phpGrid-Select2

<?php
/**
 * PHP Grid Component
 *
 * @author Abu Ghufran <gridphp@gmail.com> - http://www.phpgrid.org
 * @version 2.0.0
 * @license: see license.txt included in package
 */

include_once("config.php");
include_once("crm_get_operator_name_from_ip.php");


include(PHPGRID_LIBPATH."inc/jqgrid_dist.php");

// Database config file to be passed in phpgrid constructor
$db_conf = array(
					"type" 		=> PHPGRID_DBTYPE,
					"server" 	=> PHPGRID_DBHOST,
					"user" 		=> PHPGRID_DBUSER,
					"password" 	=> PHPGRID_DBPASS,
					"database" 	=> PHPGRID_DBNAME
				);


// master Grid 01
$g = new jqgrid($db_conf);

// following params will enable subgrid -- by default first column (PK) of parent is passed as param 'id'
$optg1["detail_grid_id"] = "list2,list3";
$optg1["height"] = "200";
$optg1["width"] = "1220";

$g->set_options($optg1);

// you can provide custom SQL query to display data

$g->select_command = " SELECT m.cie_id, m.cie_name, m.phone, m.town, m.postcode,
 s.status_name as status_id, m.address, c.local_name as country_id, m.contact_name, m.email, m.website, m.source, m.frtmap_code, m.created_by, g.group_name as group_id,
  color.color_desc as color_id, main_countries_from
 FROM crm_main m
  INNER JOIN crm_country c ON c.country_id = m.country_id
   INNER JOIN crm_group g ON g.group_id = m.group_id
    INNER JOIN crm_status s ON s.status_id = m.status_id
     INNER JOIN crm_color color ON color.color_id = m.color_id
 ";



$grid["caption"] = "CUSTOMER PROSPECT RELATION MANAGEMENT SYSTEM  [$operator_name] [$ip]";
$grid["rownumbers"] = true;
$grid["rownumWidth"] = 30;
$grid["resizable"] = false; // defaults to false
$grid["autoresize"] = false; // defaults to false

$grid["loadtext"] = "Loading your customer list ...";

$grid["toolbar"] = "both";
$grid["multiselect"] = false;
$grid["altRows"] = true;

// Date will be sorted desc, and ID asc.
$grid["sortname"] = "cie_name ASC,cie_id";
$grid["sortorder"] = "ASC";

$grid["scroll"] = false; ///// SCROLL INSTEAD OF PAGE SELECTION
$grid["cellEdit"] = false;  /// Editing like Excel
$grid["toppager"] = true;

// export XLS file
// export to excel parameters
$grid["export"] = array("format"=>"pdf", "filename"=>"my-file", "sheetname"=>"test");

$grid["add_options"] = array("recreateForm" => true, "closeAfterEdit"=>true, 'width'=>'450', 'top'=>'200', 'left'=>'400');
$grid["edit_options"] = array("recreateForm" => true, "closeAfterEdit"=>true, 'width'=>'450', 'top'=>'200', 'left'=>'400');
$grid["view_options"] = array("recreateForm" => true, "closeAfterEdit"=>true, 'width'=>'450', 'top'=>'200', 'left'=>'400');


$grid["add_options"]["editData"]["created_by"] = $operator_name;
$grid["add_options"]["editData"]["created_date"] = date("Y-m-d");

$grid["edit_options"]["editData"]["updated_by"] = $operator_name;
$grid["edit_options"]["editData"]["updated_date"] = date("Y-m-d");

$g->set_options($grid);


$eg1["js_on_load_complete"] = "grid_onloadGrid01";
$g->set_events($eg1);



/////////////////////////////////
////////////////////////////////

$g->set_actions(array(
						"add"=>true, // allow/disallow add
						"edit"=>true, // allow/disallow edit
						"delete"=>true, // allow/disallow delete
						"rowactions"=>false, // show/hide row wise edit/del/save option
						"export"=>true, // show/hide export to excel option
						"autofilter" => true, // show/hide autofilter for search
						"search" => "advance", // show single/multi field search condition (e.g. simple or advance)
            "showhidecolumns" => true
					)
				);

/////////////////////////////////
/////////////////////////////////

$col = array();
$col["title"] = "ID"; // caption of column
$col["name"] = "cie_id"; // grid column name, must be exactly same as returned column-name from sql (tablefield or field-alias)
$col["width"] = "10";
$col["hidden"] = true; // HIDE this column
//$col["editrules"] = array("edithidden"=>true);
$col["align"] = "center"; // this column is not editable
$col["editable"] = false; // this column is not editable
$col["search"] = false; // this column is not searchable
$cols[] = $col;


////////////////
////////////////

# Custom made column to show link, must have default value as it's not db driven
$col = array();
$col["title"] = "Details";
$col["name"] = "more_options";
$col["width"] = "30";
$col["align"] = "center";
$col["search"] = false;
$col["sortable"] = false;
# no new line in this html, only space. otherwise it may break ui of grid
$buttons_html = "<input type='button' value='Edit' onclick='open_edit(this)'>";
$col["default"] = $buttons_html;
$cols[] = $col;


///////////////////////
///////////////////////

$col = array();
$col["title"] = "Prospect";
$col["name"] = "cie_name";
$col["width"] = "30";
$col["editable"] = true; // this column is not editable
$col["align"] = "center"; // this column is not editable
$col["search"] = true; // this column is not searchable
$col["editoptions"] = array("size"=>50);
$col["editrules"] = array("required"=>true); // and is required
$cols[] = $col;

//////////
/////////

$col = array();
$col["title"] = "Town";
$col["name"] = "town";
$col["width"] = "30";
$col["sortable"] = true; // this column is not sortable
$col["search"] = true; // this column is not searchable
$col["editable"] = true;
$col["editoptions"] = array("size"=>50);
$col["editrules"] = array("required"=>true); // and is required
$cols[] = $col;

//////////
/////////

$col = array();
$col["title"] = "Postcode";
$col["name"] = "postcode";
$col["width"] = "25";
$col["align"] = "center"; // this column is not editable
$col["sortable"] = false; // this column is not sortable
$col["search"] = true; // this column is not searchable
$col["editable"] = true;
$col["editoptions"] = array("size"=>12);
$col["hidden"] = true; // HIDE this column
$col["editrules"] = array("edithidden"=>true);
$cols[] = $col;

//////////
/////////

$col = array();
$col["title"] = "Country";
$col["name"] = "country_id";
$col["width"] = "50";
$col["align"] = "center"; // this column is not editable
$col["sortable"] = true; // this column is not sortable
$col["search"] = true; // this column is not searchable

$col["dbname"] = "c.country_id"; // this is required as we need to search in name field, not id
$col["editable"] = true;

# fetch data from database, with alias k for key, v for value
$str = $g->get_dropdown_values("select distinct country_id as k, local_name as v from crm_country where type = 'CO' ORDER BY local_name");

$col["edittype"] = "select"; // render as select
$col["editoptions"] = array("value"=>$str, "defaultValue" => "United Kingdom");
$col["editoptions"]["dataInit"] = "function(){ setTimeout(function(){ link_select2('{$col["name"]}'); },200); }";

$col["stype"] = "select"; // render as select
$col["searchoptions"] = array("value"=>$str);
$col["searchoptions"]["dataInit"] = "function(){ setTimeout(function(){ link_select2('gs_{$col["name"]}'); },200); }";

$col["editrules"] = array("required"=>true); // and is required

$cols[] = $col;

//////////
/////////

$col = array();
$col["title"] = "Address";
$col["name"] = "address";
$col["width"] = "60";
$col["sortable"] = false; // this column is not sortable
$col["search"] = false; // this column is not searchable
$col["editable"] = true;
$col["edittype"] = "textarea"; // render as textarea on edit
$col["editoptions"] = array("rows"=>4, "cols"=>51); // with these attributes
$col["hidden"] = true; // HIDE this column
$col["editrules"] = array("edithidden"=>true);
$cols[] = $col;

//////////
/////////

$col = array();
$col["title"] = "Contact Name";
$col["name"] = "contact_name";
$col["width"] = "50";
$col["editable"] = true; // this column is not editable
$col["align"] = "center"; // this column is not editable
$col["search"] = true; // this column is not searchable
$cols[] = $col;

//////////


$col = array();
$col["title"] = "Phone";
$col["name"] = "phone";
$col["width"] = "35";
$col["align"] = "center"; // this column is not editable
$col["sortable"] = false; // this column is not sortable
$col["search"] = true; // this column is not searchable
$col["editable"] = true;
$col["editoptions"] = array("size"=>20); // with default display of textbox with size 20
$cols[] = $col;


//////////
/////////

$col = array();
$col["title"] = "Email";
$col["name"] = "email";
$col["width"] = "50";
$col["align"] = "center"; // this column is not editable
$col["sortable"] = false; // this column is not sortable
$col["search"] = true; // this column is not searchable
$col["editable"] = true;
$col["editoptions"] = array("size"=>50); // with default display of textbox with size 20
$col["formatter"] = "function(cellval,options,rowdata){ return '<a href=\"mailto:'+cellval+'\">'+cellval+'</a>'; }";
$col["unformat"] = "function(cellval,options,cell){ return $('a', cell).attr('href').replace('mailto:',''); }";
$cols[] = $col;


//////////
/////////

$col = array();
$col["title"] = "Website";
$col["name"] = "website";
$col["width"] = "50";
$col["align"] = "center"; // this column is not editable
$col["sortable"] = false; // this column is not sortable
$col["search"] = true; // this column is not searchable
$col["editable"] = true;
$col["editoptions"] = array("size"=>50); // with default display of textbox with size 20
$col["formatter"] = "function(cellval,options,rowdata){ return '<a target=\"_blank\" href=\"http://'+cellval+'\">'+cellval+'</a>'; }";
$col["unformat"] = "function(cellval,options,cell){ return $('a', cell).attr('href').replace('http://',''); }";
$cols[] = $col;


//////////
/////////

$col = array();
$col["title"] = "Group";
$col["name"] = "group_id";
$col["width"] = "50";
$col["align"] = "center"; // this column is not editable
$col["sortable"] = true; // this column is not sortable
$col["search"] = true; // this column is not searchable

$col["dbname"] = "g.group_id"; // this is required as we need to search in name field, not id
$col["editable"] = true;

# fetch data from database, with alias k for key, v for value
$str = $g->get_dropdown_values("select distinct group_id as k, group_name as v from crm_group ORDER BY group_name");

$col["edittype"] = "select"; // render as select
$col["editoptions"] = array("value"=>$str, "defaultValue" => "Default Group");
$col["editoptions"]["dataInit"] = "function(){ setTimeout(function(){ link_select2('{$col["name"]}'); },200); }";

$col["stype"] = "select"; // render as select
$col["searchoptions"] = array("value"=>$str);
$col["searchoptions"]["dataInit"] = "function(){ setTimeout(function(){ link_select2('gs_{$col["name"]}'); },200); }";

$cols[] = $col;

////////////////////////
////////////////////////



$col = array();
$col["title"] = "Source";
$col["name"] = "source";
$col["width"] = "30";
$col["align"] = "center"; // this column is not editable
$col["sortable"] = false; // this column is not sortable
$col["search"] = true; // this column is not searchable
$col["editable"] = true;
$col["editoptions"] = array("size"=>30); // with default display of textbox with size 20
$col["hidden"] = true; // HIDE this column
$col["editrules"] = array("edithidden"=>true);
$cols[] = $col;


//////////
/////////

$col = array();
$col["title"] = "FRTMAP";
$col["name"] = "frtmap_code";
$col["width"] = "25";
$col["align"] = "center"; // this column is not editable
$col["sortable"] = false; // this column is not sortable
$col["search"] = true; // this column is not searchable
$col["editable"] = true;
$col["editoptions"] = array("size"=>10); // with default display of textbox with size 20
$col["hidden"] = true; // HIDE this column
$col["editrules"] = array("edithidden"=>true);
$cols[] = $col;


////////////////////////
////////////////////////

$col = array();
$col["title"] = "By";
$col["name"] = "created_by";
$col["width"] = "20";
$col["align"] = "center";
$col["sortable"] = true; // this column is not sortable
$col["search"] = true; // this column is not searchable
$col["editable"] = false;
$col["hidden"] = true; // HIDE this column
//$col["editrules"] = array("edithidden"=>true);
$cols[] = $col;


////////////////////////
////////////////////////


$col = array();
$col["title"] = "Color";
$col["name"] = "color_id";
$col["width"] = "25";
$col["align"] = "center"; // this column is not editable
$col["sortable"] = true; // this column is not sortable
$col["search"] = true; // this column is not searchable

$col["dbname"] = "color.color_id"; // this is required as we need to search in name field, not id
$col["editable"] = true;

# fetch data from database, with alias k for key, v for value
$str = $g->get_dropdown_values("select distinct color_id as k, color_desc as v from crm_color ORDER BY color_desc");

$col["edittype"] = "select"; // render as select
$col["editoptions"] = array("value"=>$str, "defaultValue" => "White");
$col["editoptions"]["dataInit"] = "function(){ setTimeout(function(){ link_select2('{$col["name"]}'); },200); }";

$col["stype"] = "select"; // render as select
$col["searchoptions"] = array("value"=>$str);
$col["searchoptions"]["dataInit"] = "function(){ setTimeout(function(){ link_select2('gs_{$col["name"]}'); },200); }";

$cols[] = $col;


//////////
/////////


$col = array();
$col["title"] = "From";
$col["name"] = "main_countries_from";
$col["width"] = "50";
$col["align"] = "center"; // this column is not editable
$col["sortable"] = true; // this column is not sortable
$col["search"] = true; // this column is not searchable

$col["dbname"] = "main_countries_from"; // this is required as we need to search in name field, not id
$col["editable"] = true;

# fetch data from database, with alias k for key, v for value
$str = $g->get_dropdown_values("select distinct country_id as k, local_name as v from crm_country where type = 'CO' ORDER BY local_name");

$col["edittype"] = "select"; // render as select
$col["editoptions"] = array("value"=>$str, "defaultValue" => "United Kingdom");
$col["editoptions"]["dataInit"] = "function(){ setTimeout(function(){ link_select2('{$col["name"]}'); },200); }";

$col["stype"] = "select"; // render as select
$col["searchoptions"] = array("value"=>$str);
$col["searchoptions"]["dataInit"] = "function(){ setTimeout(function(){ link_select2('gs_{$col["name"]}'); },200); }";

// to enable multiselect option
$col["editoptions"]["multiple"] = true;

$col["stype"] = "select"; // render as select
$col["searchoptions"] = array("value"=>$str);
$col["searchoptions"]["dataInit"] = "function(){ setTimeout(function(){ link_select2('gs_{$col["name"]}'); },200); }";

$cols[] = $col;

///////////////////////////
///////////////////////////


$col = array();
$col["title"] = "Status";
$col["name"] = "status_id";
$col["width"] = "20";
$col["align"] = "center"; // this column is not editable
$col["sortable"] = true; // this column is not sortable
$col["search"] = true; // this column is not searchable

$col["dbname"] = "s.status_id"; // this is required as we need to search in name field, not id
$col["editable"] = true;

# fetch data from database, with alias k for key, v for value
$str = $g->get_dropdown_values("select distinct status_id as k, status_name as v from crm_status ORDER BY status_id");


//echo "</br>**** $str ***";

$col["edittype"] = "select"; // render as select
$col["editoptions"] = array("value"=>$str, "defaultValue" => "Live");
$col["editoptions"]["dataInit"] = "function(){ setTimeout(function(){ link_select2('{$col["name"]}'); },200); }";

$col["stype"] = "select"; // render as select
$col["searchoptions"] = array("value"=>$str);
$col["searchoptions"]["dataInit"] = "function(){ setTimeout(function(){ link_select2('gs_{$col["name"]}'); },200); }";

$cols[] = $col;




/////////
/////////
// pass the cooked columns to grid
$g->set_columns($cols);

/////////////////////////////////
/////////////////////////////////





// conditional css formatting of rows
//$f = array();
//$f["column"] = "color_id"; // exact column name, as defined above in set_columns or sql field name
//$f["op"] = "cn"; // cn - contains, eq - equals
//$f["value"] = "Yellow";
//$f["css"] = "'background-color':'#FFFF00', 'color':'black', 'font-weight':''"; // must use (single quote ') with css attr and value
//$f_conditions[] = $f;

//$f = array();
//$f["column"] = "color_id"; // exact column name, as defined above in set_columns or sql field name
//$f["op"] = "cn"; // cn - contains, eq - equals
//$f["value"] = "Green";
//$f["css"] = "'background-color':'#33FF00', 'color':'black', 'font-weight':''"; // must use (single quote ') with css attr and value
//$f_conditions[] = $f;

//$f = array();
//$f["column"] = "color_id"; // exact column name, as defined above in set_columns or sql field name
//$f["op"] = "cn"; // cn - contains, eq - equals
//$f["value"] = "Red";
//$f["css"] = "'background-color':'#FF0000', 'color':'black', 'font-weight':''"; // must use (single quote ') with css attr and value
//$f_conditions[] = $f;


//$g->set_conditional_css($f_conditions);




///////////////////////////////////
///////////////////////////////////



$g->table = "crm_main";
$out_master = $g->render("list1");





////////////////////////////////////////////////////////////////
////////////////////////////////////////////////////////////////
// Grid 02
$g2 = new jqgrid($db_conf);



$optg2 = array();
$optg2["sortname"] = 'note_id'; // by default sort grid by this field
$optg2["sortorder"] = "desc"; // ASC or DESC
$optg2["height"] = "300";
$optg2["width"] = "500";
$optg2["caption"] = "Company Notes / Quotes"; // caption of grid
$optg2["multiselect"] = false; // allow you to multi-select through checkboxes
$optg2["toolbar"] = top;
$optg2["rownumbers"] = true;
$optg2["rownumWidth"] = 30;
$optg2["resizable"] = false;
$optg2["autoresize"] = false;
$optg2["scroll"] = true;
$optg2["loadtext"] = "Loading Notes / Quotes ...";
//$optg2["cellEdit"] = true;
$optg2["reloadedit"] = false;

$optg2["add_options"] = array("recreateForm" => true, "closeAfterEdit"=>true, 'width'=>'600', 'top'=>'200', 'left'=>'200');
$optg2["edit_options"] = array("recreateForm" => true, "closeAfterEdit"=>true, 'width'=>'600', 'top'=>'200', 'left'=>'200');
$optg2["view_options"] = array("recreateForm" => true, "closeAfterEdit"=>true, 'width'=>'600', 'top'=>'200', 'left'=>'200');

$optg2["add_options"]["editData"]["created_by"] = $operator_name;
$optg2["add_options"]["editData"]["created_date"] = date("Y-m-d");

$optg2["edit_options"]["editData"]["updated_by"] = $operator_name;
$optg2["edit_options"]["editData"]["updated_date"] = date("Y-m-d");

$g2->set_options($optg2);

$cols = array();


$g2->set_actions(array(
						"add"=>true, // allow/disallow add
						"edit"=>true, // allow/disallow edit
						"delete"=>true, // allow/disallow delete
						"rowactions"=>false, // show/hide row wise edit/del/save option
						"export"=>true, // show/hide export to excel option
						"autofilter" => true, // show/hide autofilter for search
						"search" => "simple", // show single/multi field search condition (e.g. simple or advance)
            "showhidecolumns" => true
					)
				);

// receive id, selected row of parent grid
$id = intval($_GET["rowid"]);
// and use in sql for filteration
$g2->select_command = "SELECT note_id, note, cie_id, created_by, created_date, updated_by, updated_date FROM crm_notes WHERE cie_id='$id'";





$eg2["on_insert"] = array("add_noteGrid02", null, true);
//$eg2["on_update"] = array("update_note_Grid02", null, true);
//$eg2["on_after_insert"] = array("after_insert_note_Grid02", null, true);

$g2->set_events($eg2);


function add_noteGrid02($data)
{
    $id = intval($_GET["rowid"]);
    $data["params"]["cie_id"] = $id;
}







/////////////////////////////////
/////////////////////////////////

$col = array();
$col["title"] = "ID"; // caption of column
$col["name"] = "note_id"; // grid column name, must be exactly same as returned column-name from sql (tablefield or field-alias)
$col["width"] = "5";
$col["hidden"] = true; // HIDE this column
//$col["editrules"] = array("edithidden"=>true);
$col["align"] = "center"; // this column is not editable
$col["editable"] = false; // this column is not editable
$col["search"] = false; // this column is not searchable
$cols[] = $col;


///////////////////////
///////////////////////

//# Custom made column to show link, must have default value as it's not db driven
$col = array();
$col["title"] = "Details";
$col["name"] = "more_options";
$col["width"] = "25";
$col["align"] = "center";
$col["search"] = false;
$col["sortable"] = false;
# no new line in this html, only space. otherwise it may break ui of grid
$buttons_htmlGrid2 = "<input type='button' value='Edit' onclick='open_editGrid2(this)'>";
$col["default"] = $buttons_htmlGrid2;
$cols[] = $col;


///////////////////////
///////////////////////

$col = array();
$col["title"] = "Cie ID";
$col["name"] = "cie_id";
$col["width"] = "5";
$col["editable"] = false; // this column is not editable
$col["align"] = "center"; // this column is not editable
$col["search"] = false; // this column is not searchable
$col["hidden"] = true; // HIDE this column
$cols[] = $col;


//////////
/////////


$col = array();
$col["title"] = "Date";
$col["name"] = "created_date";
$col["width"] = "30";
$col["align"] = "center";
$col["editable"] = false; // this column is editable
$col["search"] = false; // this column is not searchable
$col["editrules"] = array("required"=>true); // and is required

$col["formatter"] = "date";
# opts array can have these options: http://api.jqueryui.com/datepicker/
$col["formatoptions"] = array("srcformat"=>'Y-m-d',"newformat"=>'d.m.y', "opts" => array("changeYear" => true, "dateFormat"=>'yy-mm-dd', "minDate"=>"16-04-01"));

// to perfor contains search, uncomment following - will disable datepicker
// $col["searchoptions"]["sopt"] = array("cn");
// search date in format Jan 23, 2008
// $col["dbname"] = "date_format(invdate,'%b %d, %Y')";

$col["hidden"] = false; // HIDE this column

$cols[] = $col;

////////////////////////
////////////////////////


$col = array();
$col["title"] = "Note / Quote";
$col["name"] = "note";
$col["width"] = "150";
$col["sortable"] = false; // this column is not sortable
$col["search"] = true; // this column is not searchable
$col["editable"] = true;
$col["edittype"] = "textarea"; // render as textarea on edit
$col["editoptions"] = array("rows"=>6, "cols"=>90); // with these attributes
$col["hidden"] = false; // HIDE this column
$col["editrules"] = array("edithidden"=>true);
$col["editrules"] = array("required"=>true); // and is required

$cols[] = $col;


//////////
/////////

$col = array();
$col["title"] = "By";
$col["name"] = "created_by";
$col["width"] = "40";
$col["align"] = "center"; // this column is not editable
$col["sortable"] = true; // this column is not sortable
$col["search"] = true; // this column is not searchable
$col["editable"] = false;
$col["hidden"] = true; // HIDE this column
//$col["editrules"] = array("edithidden"=>true);
$cols[] = $col;




////////////////////////
////////////////////////

$col = array();
$col["title"] = "UPD By";
$col["name"] = "updated_by";
$col["width"] = "50";
$col["align"] = "center"; // this column is not editable
$col["sortable"] = true; // this column is not sortable
$col["search"] = true; // this column is not searchable
$col["editable"] = false;
$col["hidden"] = true; // HIDE this column
//$col["editrules"] = array("edithidden"=>true);
$cols[] = $col;


//////////
/////////

$col = array();
$col["title"] = "UPD Date";
$col["name"] = "updated_date";
$col["width"] = "50";
$col["align"] = "center";
$col["editable"] = false; // this column is editable
$col["search"] = true; // this column is not searchable
$col["hidden"] = true; // HIDE this column
//$col["editrules"] = array("required"=>true); // and is required

$col["formatter"] = "date";
# opts array can have these options: http://api.jqueryui.com/datepicker/
$col["formatoptions"] = array("srcformat"=>'Y-m-d',"newformat"=>'d.m.y', "opts" => array("changeYear" => true, "dateFormat"=>'yy-mm-dd', "minDate"=>"16-04-01"));

// to perfor contains search, uncomment following - will disable datepicker
// $col["searchoptions"]["sopt"] = array("cn");
// search date in format Jan 23, 2008
// $col["dbname"] = "date_format(invdate,'%b %d, %Y')";



$cols[] = $col;


//////////
/////////



/////////

// pass the cooked columns to grid
$g2->set_columns($cols);

// generate grid output, with unique grid name as 'list1'
$g2->table = "crm_notes";
$out_list2 = $g2->render("list2");




////// END Detail Grid 02
////////////////////////////////////////////////////////////////
////////////////////////////////////////////////////////////////






////////////////////////////////////////////////////////////////
////////////////////////////////////////////////////////////////
// Grid 03 - PHONE LOG TABLE
$g3 = new jqgrid($db_conf);



$optg3 = array();
$optg3["sortname"] = 'log_id'; // by default sort grid by this field
$optg3["sortorder"] = "desc"; // ASC or DESC
$optg3["height"] = "300";
$optg3["width"] = "710";
$optg3["caption"] = "Company Phone Log"; // caption of grid
$optg3["multiselect"] = false; // allow you to multi-select through checkboxes
$optg3["toolbar"] = top;
$optg3["rownumbers"] = true;
$optg3["rownumWidth"] = 30;
$optg3["resizable"] = false;
$optg3["autoresize"] = false;
$optg3["scroll"] = true;
$optg3["loadtext"] = "Loading Phone Log ...";
//$optg3["cellEdit"] = true;
$optg3["reloadedit"] = false;

$optg3["add_options"] = array("recreateForm" => true, "closeAfterEdit"=>true, 'width'=>'600', 'top'=>'200', 'left'=>'400');
$optg3["edit_options"] = array("recreateForm" => true, "closeAfterEdit"=>true, 'width'=>'600', 'top'=>'200', 'left'=>'400');
$optg3["view_options"] = array("recreateForm" => true, "closeAfterEdit"=>true, 'width'=>'600', 'top'=>'200', 'left'=>'400');

$optg3["add_options"]["editData"]["created_by"] = $operator_name;
$optg3["add_options"]["editData"]["log_date"] = date("Y-m-d");

$optg3["edit_options"]["editData"]["updated_by"] = $operator_name;
$optg3["edit_options"]["editData"]["updated_date"] = date("Y-m-d");

$g3->set_options($optg3);

$cols = array();


$g3->set_actions(array(
						"add"=>true, // allow/disallow add
						"edit"=>true, // allow/disallow edit
						"delete"=>true, // allow/disallow delete
						"rowactions"=>false, // show/hide row wise edit/del/save option
						"export"=>true, // show/hide export to excel option
						"autofilter" => true, // show/hide autofilter for search
						"search" => "simple", // show single/multi field search condition (e.g. simple or advance)
            "showhidecolumns" => true
					)
				);

// receive id, selected row of parent grid
$id = intval($_GET["rowid"]);
// and use in sql for filteration
$g3->select_command = "SELECT log.log_id, log.cie_id, log.log_date, log.log_notes, log.follow_up_date, log.updated_by, log.updated_date, log.created_by, log.checked,
 ops.operator_name as follow_up_operator  FROM crm_log log INNER JOIN crm_operators ops ON ops.operator_id = log.follow_up_operator  WHERE log.cie_id='$id'";



$eg3["on_insert"] = array("add_logGrid03", null, true);
$eg3["on_update"] = array("update_log_Grid03", null, true);

$g3->set_events($eg3);


function add_logGrid03($data)
{
    $id = intval($_GET["rowid"]);
    $data["params"]["cie_id"] = $id;
}



/////////////////////////////////
/////////////////////////////////

$col = array();
$col["title"] = "ID"; // caption of column
$col["name"] = "log_id"; // grid column name, must be exactly same as returned column-name from sql (tablefield or field-alias)
$col["width"] = "5";
$col["hidden"] = true; // HIDE this column
//$col["editrules"] = array("edithidden"=>true);
$col["align"] = "center"; // this column is not editable
$col["editable"] = false; // this column is not editable
$col["search"] = false; // this column is not searchable
$cols[] = $col;


////////////////
////////////////

//# Custom made column to show link, must have default value as it's not db driven
$col = array();
$col["title"] = "Details";
$col["name"] = "more_options";
$col["width"] = "25";
$col["align"] = "center";
$col["search"] = false;
$col["sortable"] = false;
# no new line in this html, only space. otherwise it may break ui of grid
$buttons_htmlGrid3 = "<input type='button' value='Edit' onclick='open_editGrid3(this)'>";
$col["default"] = $buttons_htmlGrid3;
$cols[] = $col;


///////////////////////
///////////////////////

$col = array();
$col["title"] = "Cie ID";
$col["name"] = "cie_id";
$col["width"] = "5";
$col["editable"] = false; // this column is not editable
$col["align"] = "center"; // this column is not editable
$col["search"] = false; // this column is not searchable
$col["hidden"] = true; // HIDE this column
$cols[] = $col;


//////////
/////////

$col = array();
$col["title"] = "Date";
$col["name"] = "log_date";
$col["width"] = "20";
$col["align"] = "center";
$col["editable"] = false; // this column is editable
$col["search"] = false; // this column is not searchable
$col["editrules"] = array("required"=>true); // and is required

$col["formatter"] = "date";
# opts array can have these options: http://api.jqueryui.com/datepicker/
$col["formatoptions"] = array("srcformat"=>'Y-m-d',"newformat"=>'d.m.y', "opts" => array("changeYear" => true, "dateFormat"=>'yy-mm-dd', "minDate"=>"16-04-01"));

// to perfor contains search, uncomment following - will disable datepicker
// $col["searchoptions"]["sopt"] = array("cn");
// search date in format Jan 23, 2008
// $col["dbname"] = "date_format(invdate,'%b %d, %Y')";

$col["hidden"] = false; // HIDE this column

$cols[] = $col;

//////////
/////////


$col = array();
$col["title"] = "Call Log";
$col["name"] = "log_notes";
$col["width"] = "110";
$col["sortable"] = false; // this column is not sortable
$col["search"] = true; // this column is not searchable
$col["editable"] = true;
$col["edittype"] = "textarea"; // render as textarea on edit
$col["editoptions"] = array("rows"=>6, "cols"=>90); // with these attributes
$col["hidden"] = false; // HIDE this column
$col["editrules"] = array("edithidden"=>true);
$col["editrules"] = array("required"=>true); // and is required
$cols[] = $col;


//////////
/////////


$col = array();
$col["title"] = "FWUP";
$col["name"] = "follow_up_date";
$col["width"] = "20";
$col["align"] = "center";
$col["editable"] = true; // this column is editable
$col["editoptions"] = array("size"=>20); // with default display of textbox with size 20
$col["editrules"] = array("required"=>false, "edithidden"=>true); // and is required
# format as date
$col["formatter"] = "date";
# opts array can have these options: http://api.jqueryui.com/datepicker/
$col["formatoptions"] = array("srcformat"=>'Y-m-d',"newformat"=>'d.m.y', "opts" => array("changeYear" => true, "dateFormat"=>'yy-mm-dd', "minDate"=>"16-04-01"));

// to perfor contains search, uncomment following - will disable datepicker
// $col["searchoptions"]["sopt"] = array("cn");
// search date in format Jan 23, 2008
// $col["dbname"] = "date_format(invdate,'%b %d, %Y')";

$cols[] = $col;

////////////////////////
////////////////////////

$col = array();
$col["title"] = "UPD By";
$col["name"] = "updated_by";
$col["width"] = "30";
$col["align"] = "center"; // this column is not editable
$col["sortable"] = true; // this column is not sortable
$col["search"] = true; // this column is not searchable
$col["editable"] = false;
$col["hidden"] = true; // HIDE this column
//$col["editrules"] = array("edithidden"=>true);
$cols[] = $col;


//////////
/////////

$col = array();
$col["title"] = "UPD Date";
$col["name"] = "updated_date";
$col["width"] = "40";
$col["align"] = "center"; // this column is not editable
$col["sortable"] = true; // this column is not sortable
$col["search"] = true; // this column is not searchable
$col["editable"] = false;
$col["hidden"] = true; // HIDE this column
//$col["editrules"] = array("edithidden"=>true);
$col["formatter"] = "date";
# opts array can have these options: http://api.jqueryui.com/datepicker/
$col["formatoptions"] = array("srcformat"=>'Y-m-d',"newformat"=>'d.m.y', "opts" => array("changeYear" => true, "dateFormat"=>'yy-mm-dd', "minDate"=>"16-04-01"));

// to perfor contains search, uncomment following - will disable datepicker
// $col["searchoptions"]["sopt"] = array("cn");
// search date in format Jan 23, 2008
// $col["dbname"] = "date_format(invdate,'%b %d, %Y')";

$cols[] = $col;

//////////
/////////

$col = array();
$col["title"] = "CRT By";
$col["name"] = "created_by";
$col["width"] = "30";
$col["align"] = "center";
$col["sortable"] = true; // this column is not sortable
$col["search"] = true; // this column is not searchable
$col["editable"] = false;
$col["hidden"] = true; // HIDE this column
//$col["editrules"] = array("edithidden"=>true);
$cols[] = $col;

////////////////////////
////////////////////////

$col = array();
$col["title"] = "FWUP OP";
$col["name"] = "follow_up_operator";
$col["width"] = "50";
$col["align"] = "center"; // this column is not editable
$col["sortable"] = true; // this column is not sortable
$col["search"] = true; // this column is not searchable

$col["dbname"] = "ops.operator_id"; // this is required as we need to search in name field, not id
$col["editable"] = true;

# fetch data from database, with alias k for key, v for value
$str = $g->get_dropdown_values("select distinct operator_id as k, operator_name as v from crm_operators ORDER BY operator_name");

$col["edittype"] = "select"; // render as select
$col["editoptions"] = array("value"=>$str, "defaultValue" => "Select");
$col["editoptions"]["dataInit"] = "function(){ setTimeout(function(){ link_select2('{$col["name"]}'); },200); }";

$col["stype"] = "select"; // render as select
$col["searchoptions"] = array("value"=>$str);
$col["searchoptions"]["dataInit"] = "function(){ setTimeout(function(){ link_select2('gs_{$col["name"]}'); },200); }";

$cols[] = $col;


//////////
/////////

$col = array();
$col["title"] = "Checked";
$col["name"] = "checked";
$col["width"] = "25";
$col["align"] = "center"; // this column is not editable
$col["sortable"] = true; // this column is not sortable
$col["search"] = true; // this column is not searchable

$col["dbname"] = "checked"; // this is required as we need to search in name field, not id
$col["editable"] = true;

//# fetch data from database, with alias k for key, v for value
//$str = $g->get_dropdown_values("select distinct status_id as k, status_name as v from crm_status ORDER BY status_id");
$str = "Yes:Yes;No:No";

$col["edittype"] = "select"; // render as select
$col["editoptions"] = array("value"=>$str, "defaultValue" => "No");
$col["editoptions"]["dataInit"] = "function(){ setTimeout(function(){ link_select2('{$col["name"]}'); },200); }";

$col["stype"] = "select"; // render as select
$col["searchoptions"] = array("value"=>$str);
$col["searchoptions"]["dataInit"] = "function(){ setTimeout(function(){ link_select2('gs_{$col["name"]}'); },200); }";

$cols[] = $col;

//////////
/////////


// pass the cooked columns to grid
$g3->set_columns($cols);

// generate grid output, with unique grid name as 'list1'
$g3->table = "crm_log";
$out_list3 = $g3->render("list3");




////// END Detail Grid 03
////////////////////////////////////////////////////////////////
////////////////////////////////////////////////////////////////
?>


<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">
<html>
<head>
	<link rel="stylesheet" type="text/css" media="screen" href="lib/js/themes/redmond/jquery-ui.custom.css"></link>
	<link rel="stylesheet" type="text/css" media="screen" href="lib/js/jqgrid/css/ui.jqgrid.css"></link>

	<script src="lib/js/jquery.min.js" type="text/javascript"></script>
	<script src="lib/js/jqgrid/js/i18n/grid.locale-en.js" type="text/javascript"></script>
	<script src="lib/js/jqgrid/js/jquery.jqGrid.min.js" type="text/javascript"></script>
	<script src="lib/js/themes/jquery-ui.custom.min.js" type="text/javascript"></script>

    <!--link href="lib/js/integration/select2/select2.css" rel="stylesheet"/>
    <script src="lib/js/integration/select2/select2.min.js"></script-->

    <link rel="stylesheet" href="//cdn.jsdelivr.net/select2/3.5.2/select2.css">
    <script src="//cdn.jsdelivr.net/select2/3.5.2/select2.min.js"></script>

</head>
<body>
	<div style="margin:10px">


	<?php echo $out_master ?>
	<br>

	<div style="float:left">
	<?php echo $out_list2?>
	</div>

  <div style="float:left; margin-left:10px">
    <?php echo $out_list3?>
    </div>

	</div>


    <script>
    function grid_onloadGrid01(ids)
    {
    // get row ids from grid (with id: list1)
    var ids = $("#list1").jqGrid('getDataIDs');
    setTimeout( function(){ jQuery("#list1").jqGrid('setSelection', ids[0], true); },2200);

    var grid = $("#list1");
    var ids = grid.jqGrid('getDataIDs');
    for (var i=0;i<ids.length;i++)
    {
        var id=ids[i];
        if (grid.jqGrid('getCell',id,'color_id') == 'Red')
        {
            grid.jqGrid('setCell',id,'cie_name','',{'background-color':'rgba(255,0,0, 0.2)'});
            grid.jqGrid('setCell',id,'color_id','',{'background-color':'rgba(255,0,0, 0.2)'});
        }

        if (grid.jqGrid('getCell',id,'color_id') == 'Green')
        {
            grid.jqGrid('setCell',id,'cie_name','',{'background-color':'rgba(0,255,0, 0.2)'});
            grid.jqGrid('setCell',id,'color_id','',{'background-color':'rgba(0,255,0, 0.2)'});
        }

        if (grid.jqGrid('getCell',id,'color_id') == 'Yellow')
        {
            grid.jqGrid('setCell',id,'cie_name','',{'background-color':'rgba(247,255,40, 0.5)'});
            grid.jqGrid('setCell',id,'color_id','',{'background-color':'rgba(247,255,40, 0.5)'});

        }

    }


    }
    </script>


	<script>
	function open_edit(o)
	{
		var rowid = jQuery(o).closest('tr').attr('id');
		jQuery("#list1").jqGrid().setSelection(rowid);
		jQuery("#edit_list1").click();
	}
	</script>


	<script>
	function open_editGrid2(o)
	{
		var rowid = jQuery(o).closest('tr').attr('id');
		jQuery("#list2").jqGrid().setSelection(rowid);
		jQuery("#edit_list2").click();
	}
	</script>


	<script>
	function open_editGrid3(o)
	{
		var rowid = jQuery(o).closest('tr').attr('id');
		jQuery("#list3").jqGrid().setSelection(rowid);
		jQuery("#edit_list3").click();
	}
	</script>


      <script>
    function link_select2(id)
    {
        $('select[name='+id+'].editable, select[id='+id+']').select2({width:'95%', dropdownCssClass: 'ui-widget ui-jqdialog', onSelect: function(){ jQuery(this).trigger('change'); }});
        $(document).unbind('keypress').unbind('keydown');
    }
    </script>



</body>
</html>