{
$where1 = ' AND is_deleted = 1';
$where2 = ' where is_deleted = 1';
}
else
{
$where1 = ' AND is_deleted = 0';
$where2 = ' where is_deleted = 0';
}
$columns = array(
array( 'db' => 'prequistionno', 'dt' => 0 ,'field' => 'prequistionno'),
array( 'db' => 'reg_date', 'dt' => 1 ,'field' => 'reg_date'),
array( 'db' => 'branch_id', 'dt' => 2,'field' => 'branch_id','formatter' => function( $d, $row ) {
return SSP::get_branchname($d);
} ),
array( 'db' => 'customername', 'dt' =>3 ,'field' => 'customername'),
array( 'db' => 'phone', 'dt' => 4 ,'field' => 'phone'),
array( 'db' => 'email', 'dt' => 5 ,'field' => 'email'),
array( 'db' => 'id', 'dt' => 6 ,'field' => 'id','formatter' => function ( $d, $row) {
$val = SSP::get_prequistions_details($d);
if($val[0]['po_generate_type'] == 'Auotmatic'){$cn = '<span class="label label-danger">'.$val[0]['ref_no'].' </span>';}
elseif($val[0]['po_generate_type'] == 'Manual'){$cn = '<span class="label label-success">'.$val[0]['ref_no'].' </span>';}
else{$cn = '<span class="label label-warning">'.$val[0]['ref_no'].' </span>';}
if(!empty($val[0]['ref_no'])) return $cn;
} ),
array( 'db' => 'id', 'dt' => 7,'field' => 'id' ,'formatter' => function ( $d, $row) {
