<?php
// $Id$


/**
 * @file
 * 
 * The pavi module.
 */

/**
 * Implements hook_help().
 */
function pavi_help($path, $arg) {
  $output = '';
  switch ($path) {
    case "admin/help#pavi":
      $output = '<p>' . t("Displays the products") . '</p>';
      break;
  }
  return $output;
}

/**
 * Implements hook_perm().
 */
 
 /*


function pavi_perm() {
  return array(
    'access pavi',
    'edit pavi',
    'administer pavi',
    'add to pavi',
  );
}


*/



function pavi_menu(){
$items = array();
$items['pavi'] = array(
		'title' => t('PRODUCTS'),
		'page callback' => 'pavi_page',
		'access arguments' => array('access pavi'),
		'type' => MENU_NORMAL_ITEM,
	);
	




return $items;
	}
	




function pavi_page(){
 return drupal_get_form('pavi_form');
 }



function pavi_form($form_state){
 $form = array();
 

 $form['productcode']=array(
		'#title'=>'',
		'#type'=>'textfield',
		'#prefix'=>'<table class="formtable"><tr><td class="labeltext">PRODUCT CODE</td><td class="textbox">',
		'#suffix'=>'</td></tr>',
  );


$form['productname']=array(
	'#type'=>'textfield',
	'#title'=>'',
	'#prefix'=>'<tr><td class="labeltext">PRODUCT NAME</td><td class="textbox">',
    '#suffix'=>'</td></tr>',
		
   );
$form['productdesc']=array(
		'#title'=>'',
		'#type'=>'textfield',
		'#prefix'=>'<tr><td class="labeltext">DESCRIPTION</td><td class="textbox">',
        '#suffix'=>'</td></tr>',
		   
);
$form['baseuom']=array(
		'#title'=>'',
		'#type'=>'textfield',
		'#prefix'=>'<tr><td class="labeltext">BASEUoM</td><td class="textbox">',
        '#suffix'=>'</td></tr>',
		
  );
$form['producttype']=array(
	'#type'=>'textfield',
	'#title'=>'',
	'#prefix'=>'<tr><td class="labeltext">PRODUCT TYPE</td><td class="textbox">',
    '#suffix'=>'</td></tr>',
		
);
$form['productgroup']=array(
	'#type'=>'textfield',
	'#title'=>'',
	'#prefix'=>'<tr><td class="labeltext">PRODUCT GROUP</td><td class="textbox">',
    '#suffix'=>'</td></tr>',
		
);

$form['plantcode']=array(
	'#type'=>'textfield',
	'#title'=>'',
	'#prefix'=>'<tr><td class="labeltext">PLANT CODE</td><td class="textbox">',
    '#suffix'=>'</td></tr>',
		
);
$form['blocked']=array(
	'#type'=>'textfield',
	'#title'=>'',
	'#prefix'=>'<tr><td class="labeltext">BLOCKED</td><td class="textbox">',
    '#suffix'=>'</td></tr>',
		
);
$form['updatedby']=array(
	'#type'=>'textfield',
	'#title'=>'',
    '#prefix'=>'<tr><td class="labeltext">UPDATED BY</td><td class="textbox">',
    '#suffix'=>'</td></tr>',
		
);
$form['status']=array(
	'#type'=>'textfield',
	'#title'=>'',
	'#prefix'=>'<tr><td class="labeltext">STATUS</td><td class="textbox">',
    '#suffix'=>'</td></tr>',
		
);
$form['comment']=array(
	'#type'=>'textarea',
	'#title'=>'',
	'#prefix'=>'<tr><td class="labeltext">COMMENT</td><td class="textbox">',
    '#suffix'=>'</td></tr>',
		
);
$form['enteredfrom']=array(
	'#type'=>'textfield',
	'#title'=>'',
	'#prefix'=>'<tr><td class="labeltext">ENTERED FROM</td><td class="textbox">',
    '#suffix'=>'</td></tr></table>',
		
);


$form['characteristicshead']=array(
	'#type'=>'hidden',
	'#title'=>'',
	'#prefix'=>'<table class="table2"><tr><th class="table2head">CHARACTERISTICS',
    '#suffix'=>'</th>',
		
);
$form['descriptionhead']=array(
	'#type'=>'hidden',
	'#title'=>'',
	'#prefix'=>'<th class="table2head">DESCRIPTION',
       '#suffix'=>'</th>',

		
);
$form['minimumhead']=array(
	'#type'=>'hidden',
	'#title'=>'',
	'#prefix'=>'<th class="table2head">MINIMUM</th>',
        '#suffix'=>'</th>',

		
);
$form['maximumhead']=array(
	'#type'=>'hidden',
	'#title'=>'',
	'#prefix'=>'<th class="table2head">MAXIMUM',
    '#suffix'=>'</th></tr>',
		
);

$form['characteristics']=array(
'#type' => 'textfield',
'#size'=> 20,
'#prefix'=>'<tr ><td class="table2row">',
'#suffix'=>'</td>',
);

$form['description']=array(
'#type' => 'textfield',
'#size'=> 20,
'#prefix'=>'<td class="table2row">',
'#suffix'=>'</td>',
);
$form['minimum']=array(
'#type' => 'textfield',
'#size'=> 20,
'#prefix'=>'<td class="table2row">',
'#suffix'=>'</td>',
);
$form['maximum']=array(
'#type' => 'textfield',
'#size'=> 20,
'#prefix'=>'<td class="table2row">',
'#suffix'=>'</td></tr></table>',
);


$form['add']=array(
'#type' => 'button',
'#value' => t('ADD CHARACTERISTICS'),
'#prefix'=>'<table><tr><td>',
'#suffix'=>'</td></tr></table>',
);


/*   adds to datatbase*/



$form['submit'] = array(
  '#type' => 'submit',
  
  '#value' => t('ADD TO TABLE')
 
 );


return $form;
}





function pavi_form_validate($form,&$form_state){
	$code=$form_state['values']['productcode'];
	$name=$form_state['values']['productname'];
	$desc=$form_state['values']['productdesc'];
	$baseuom=$form_state['values']['baseuom'];
	$type=$form_state['values']['producttype'];
	$group=$form_state['values']['productgroup'];
	$plantcode=$form_state['values']['plantcode'];
	$blocked=$form_state['values']['blocked'];
	$updatedby=$form_state['values']['updatedby'];
	$status=$form_state['values']['status'];
	$comment=$form_state['values']['comment'];
	$enteredfrom=$form_state['values']['enteredfrom'];
	
	if($code=='' || $name=='' || $type==''|| $desc=='' || $baseuom=='' || $group=='' || $plantcode=='' || $blocked==''|| $updatedby==''|| $status==''|| $comment==''|| $enteredfrom=='')
		{
			form_set_error('pavi',t('PLEASE FILL ALL FIELDS'));
			
		}
	}
	
	



function pavi_form_submit($form,&$form_state){

	//$code=$form_state['values']['productcode'];
	//$name=$form_state['values']['productname'];
	//$type=$form_state['values']['producttype'];

 db_query("INSERT INTO {pavi} VALUES ('%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s')",
			$form_state['values']['productcode'],$form_state['values']['productname'],$form_state['values']['productdesc'],
			$form_state['values']['baseuom'],$form_state['values']['producttype'],
			$form_state['values']['productgroup'],$form_state['values']['plantcode'],
			$form_state['values']['blocked'],$form_state['values']['updatedby'],
			$form_state['values']['status'],$form_state['values']['comment'],$form_state['values']['enteredfrom']);
 }
 


	
	