gistfile1.txt

##############
# MAIN QUERY #
##############
$g->select_command = "SELECT * FROM tbl_unit 					  
					  LEFT JOIN tbl_job ON job_id = fk_job_id
					  LEFT JOIN tbl_customer ON customer_id = fk_customer
					  LEFT JOIN tbl_users ON fk_unit_proj_id = user_id
					  WHERE unit_prod_show = '1' AND unit_status = 'ACTIVE' AND unit_closed = 'O' AND job_status <> 'ARCHIVED' 
					  "; 

###################################
# REMOVE BUTTONS FROM GRID HEADER #					  
###################################				  
$g->navgrid["param"]["del"] = false;	// remove delete from top menu

#################
# MAIN DATABAES #
#################
$g->table = "tbl_unit";

####################################
# SETUP COLUMNS TO DISPLAY IN GRID #
####################################
  /////////////
 // UNIT ID //
/////////////
$col = array();
$col["title"] = "Uint ID";
$col["name"] = "unit_id";
$col["width"] = "40";
$col["hidden"] = true;
$col["export"] = false;
$cols[] = $col;

  ////////////
 // JOB ID //
////////////
$col = array();
$col["title"] = "Job ID";
$col["name"] = "job_id";
$col["width"] = "40";
$col["hidden"] = true;
$col["export"] = false;
$cols[] = $col;

  ////////////////
 // JOB NUMBER //
////////////////
$col = array();
$col["title"] = "Job";
$col["name"] = "job_number";
$col["width"] = "30";
$col["hidden"] = false;
$col["editable"] = false;
$col["link"] = "unit_list.php?job={job_id}";
$col["export"] = true;
//$col["editoptions"] = array("defaultValue"=>"{job_number}","readonly"=>"readonly", "style"=>"border:0");
$cols[] = $col;

  /////////////////
 // UNIT NUMBER //
/////////////////
$col = array();
$col["title"] = "Unit";
$col["name"] = "unit_number";
$col["width"] = "30";
$col["hidden"] = false;
$col["editable"] = false;
$col["export"] = true;
//$col["editoptions"] = array("defaultValue"=>"{unit_number}","readonly"=>"readonly", "style"=>"border:0");
$col["search"] = true;
$cols[] = $col;

  //////////////////////
 // UNIT DESCRIPTION //
//////////////////////
$col = array();
$col["title"] = "Unit Description";
$col["name"] = "unit_description";
$col["width"] = "100";
$col["hidden"] = false;
$col["editable"] = false;
$col["export"] = true;
$cols[] = $col;

  /////////////////////
 // PROJECT MANAGER // 
/////////////////////
$col = array();
$col["title"] = "PM";
$col["name"] = "name_abbr";
$col["width"] = "30";
$col["hidden"] = false;
$col["editable"] = false;
$col["export"] = true;
$col["editoptions"] = array("defaultValue"=>"{unit_number}","readonly"=>"readonly", "style"=>"border:0");
$cols[] = $col;	

  //////////////////
 // COMPANY NAME //
//////////////////
$col = array();
$col["title"] = "Customer";
$col["name"] = "company_name";
$col["width"] = "100";
$col["hidden"] = false;
$col["editable"] = false;
$col["export"] = true;
$cols[] = $col;	

  /////////////////////
 // JOB DESCRIPTION //
/////////////////////
$col = array();
$col["title"] = "Job Description";
$col["name"] = "job_description";
$col["width"] = "100";
$col["hidden"] = true;
$col["editable"] = false;
$col["export"] = false;
$cols[] = $col;	

  ///////////////
 // JOB NOTES //
///////////////
$col = array();
$col["title"] = "Job Notes";
$col["name"] = "unit_notes";
$col["edittype"] = "textarea";
$col["editoptions"] = array("rows"=>10, "cols"=>100);
$col["width"] = "100";
$col["hidden"] = false;
$col["editable"] = true;
$col["export"] = true;
$col["search"] = false;
$cols[] = $col;	

  ///////////////////
 // INVOICES PAID //
///////////////////
$col = array();
$col["title"] = "Invoices Paid";
$col["name"] = "prod_unit_inv_paid";
$col["edittype"] = "textarea";
$col["editoptions"] = array("rows"=>10, "cols"=>100);
$col["width"] = "100";
$col["hidden"] = false;
$col["editable"] = true;
$col["export"] = true;
$col["search"] = false;
$cols[] = $col;	

  ///////////////////
 // INVOICES OPEN //
///////////////////
$col = array();
$col["title"] = "Invoices Open";
$col["name"] = "prod_unit_inv_open";
$col["edittype"] = "textarea";
$col["editoptions"] = array("rows"=>10, "cols"=>100);
$col["width"] = "100";
$col["hidden"] = false;
$col["editable"] = true;
$col["export"] = true;
$col["search"] = false;
$cols[] = $col;	
 
$col = array();
$col["title"] = "CWP";
$col["name"] = "ck_prod_cop";
$col["editable"] = true;
$col["edittype"] = "checkbox";
$col["formatter"] = "checkbox";
$col["editoptions"] = array("value"=>"1:0");
$col["hidden"] = false;
$col["width"] = "35";
$col["export"] = false;
$col["search"] = false;
$col["formatter"] = "function(cellvalue, options, rowObject){ return cboxFormatter(cellvalue, options, rowObject); }";
$col["unformat"] = "function(cellvalue, options, cell){ return cboxUnFormat(cellvalue, options, cell);}";
$cols[] = $col;	
 
  //////////////////////
 // PERCENT COMPLETE //
//////////////////////
$col = array();
$col["title"] = "PCT<br>CMPLT";
$col["name"] = "unit_percent_comp";
$col["width"] = "40";
$col["hidden"] = false;
$col["editable"] = true;
$col["export"] = true;
$col["search"] = false;
$cols[] = $col;	

  ///////////////
 // PO NUMBER //
///////////////
$col = array();
$col["title"] = "PO Number";
$col["name"] = "unit_po";
$col["width"] = "80";
$col["hidden"] = false;
$col["editable"] = false;
$col["export"] = true;
$cols[] = $col;	

  ////////////////
 // JOB STATUS //
////////////////
if ($utype > 300) {
$col = array();
$col["title"] = "Status"; 			
$col["name"] = "unit_closed"; 				
$col["width"] = "30";
$col["editable"] = true;
$col["edittype"] = "select";
$str = "O:O;C:C";
$col["editoptions"] = array("value"=>$str);
$col["export"] = false;
$col["search"] = false;
$cols[] = $col;
}

  ////////////////////////
 // ADD COOKED COLUMNS //
////////////////////////
$g->set_columns($cols);

##########
# EVENTS #
##########
$e["on_insert"] = array("add_edit_caps", null, true);
$e["on_update"] = array("add_edit_caps", null, true);
$g->set_events($e);

##########################
# CALLED EVENT FUNCTIONS #
##########################
function add_edit_caps($data)
{
		  /////////////////////////////////////
		 // SET COLUMN TO UPPER CASE ON ADD //
		/////////////////////////////////////	
			
		  /////////////////////////////////////////////////////////////
		 // UNSET ALL COLUMNS THAT DONOT BELONG TO DEFAULT DATABASE //
		/////////////////////////////////////////////////////////////
		unset($data["params"]["job_number"]);																//UNSET JOB NUMBER
		unset($data["params"]["full_name"]);																//UNSET PEROJECT MANAGER		


		
}

#######################
# RENDER GRID (list1) #
#######################	
$out = $g->render("list1");
?>

	
<?php
		
	################
	# INCLUDE MENU #
	################
	include("assets/menu.php");

	################
	# DISPLAY GRID #
	################
	echo $out
?>