public function getContact($type = "")
{
if (isset($type) && $type != "") {
$extraWhere = 'type =' . $type;
} else {
$extraWhere = '';
}
$table = 'inv_contact';
$primaryKey = 'id';
$columns = array(array('db' => 'name', 'dt' => 0, 'field' => 'name', 'searchable' => 'name', 'formatter' => function ($d, $row) {
return '<a href="contact/item/' . $row['id'] . '" style="color:blue;">' . $d . '</a>';
}), array('db' => 'type', 'dt' => 1, 'field' => 'type', 'formatter' => function ($d, $row) {
$a = $d == 1 ? 'Client' : 'Supplier';
return $a;
}), array('db' => 'phone', 'dt' => 2, 'field' => 'phone', 'searchable' => 'phone'), array('db' => 'email', 'dt' => 3, 'field' => 'email', 'searchable' => 'email'), array('db' => 'country', 'dt' => 4, 'field' => 'country', 'searchable' => 'country'), array('db' => 'id', 'dt' => 5, 'field' => 'action', 'formatter' => function ($d, $row) {
return '<a href="contact/edit/' . $d . '" class="btn btn-xs show-tooltip" title="" data-original-title="Edit"><span class="fa fa-edit"></span></a>';
}));
$joinQuery = 'SELECT * FROM inv_contact $where $order $limit';
echo json_encode(SSP::simple1($_REQUEST, $this->_sql_details, $table, $primaryKey, $columns, $joinQuery, $extraWhere));
}
array( 'db' => 'sals.remarks', 'dt' => 11, 'field' => 'remarks', 'formatter' => function( $d, $row ) {
return '-';
}),
array( 'db' => 'sals.id', 'dt' => 12 , 'field' => 'id' , 'formatter' => function( $d, $row ) {
return '-';
}),
array( 'db' => 'cus.customername', 'dt' => 13, 'field' => 'customername' ),
array( 'db' => 'ccpi.name' , 'field' => 'name' , 'dt' => 14 ),
array( 'db' => 'brnch.branchname' , 'field' => 'branchname' , 'dt' => 15),
array( 'db' => 'inst.name', 'dt' => 16, 'field' => 'name' ),
array( 'db' => 'bra.brandname', 'dt' => 17, 'field' => 'brandname' ),
array( 'db' => 'des.model_no', 'dt' => 18, 'field' => 'model_no' ),
array( 'db' => 'ran.range_name', 'dt' => 19, 'field' => 'range_name' ),
array( 'db' => 'des.sales_calllocation', 'dt' => 20, 'field' => 'sales_calllocation' ),
array( 'db' => 'des.sales_calltype', 'dt' => 21, 'field' => 'sales_calltype' ),
array( 'db' => 'dept.departmentname', 'dt' => 22, 'field' => 'departmentname' ),
array( 'db' => 'des.sales_unitprice', 'dt' => 23, 'field' => 'sales_unitprice' ),
array( 'db' => 'des.title1_val', 'dt' => 24, 'field' => 'title1_val' ),
array( 'db' => 'des.title2_val', 'dt' => 25, 'field' => 'title2_val' ),
array( 'db' => 'des.title3_val', 'dt' => 26, 'field' => 'title3_val' ),
array( 'db' => 'des.title4_val', 'dt' => 27, 'field' => 'title4_val' ),
array( 'db' => 'des.title5_val', 'dt' => 28, 'field' => 'title5_val' ),
);
echo json_encode(
SSP::simple1( $_GET, $sql_details, $table, $primaryKey, $columns , $where1, $where2 ,$join)
);
