dispatch_qty) $searchSql $sortSql";
//echo $sql;
error_log($sql."count sql");
$result = mysqli_query($conn,$sql);
//echo $result;
$row = mysqli_fetch_array($result);
$total = $row[0];
if(!isSet($rp)){
$rp=10;
}
// Setup paging SQL
//$rp=1;
$pageStart = ($page-1)*$rp;
$limitSql = "limit $pageStart, $rp";
// Return JSON data
$data = array();
$data['page'] = $page;
$data['total'] = $total;
$data['rows'] = array();
$sql1 = "select * from po_master where po_id in (select distinct(po_id) from po_items where vendor_id='".$contractor_id."' and delivery_qty>dispatch_qty and status in ('APPROVED')) ";
error_log('qqq'.$sql1);
$sql_export = $sql1;
$sql1.=" $searchSql $sortSql $limitSql ";
$sql_export.=" $searchSql $sortSql ";
//echo $sql1;
$results = mysqli_query($conn,$sql1);
//echo $results;
//echo mysqli_error($results);
$count=($page-1)*$rp+1;
//echo $sql_ailment;
//echo $access_level;
while ($row1= mysqli_fetch_assoc($results)) {
$id=$row1['po_id'];
//echo $Department_id;
$view_link="";
$edit_link="";
$delete_link="";
$status_update_link="";
$links="";
// if($hasWriteAccess)
// {
// $edit_link="";
// }
$app_rem=$row1['approval_remarks'];
$item_desc="";
$item_qty="";
$indent_ref_no = "" . $row1['indent_ref_no'] . "";
$sql_q="select * from indent_items where vendor_id='".$contractor_id."' and indent_id='".$row1['indent_id']."' and status in ('',null,'REJECTED','DRAFT_VENDOR_RATE','SUP_REJECTED_RATE')";
$result=mysqli_query($conn,$sql_q);
$num_rows = @mysqli_num_rows( $result);
$st=0;
$rej=0;
$pending_dispatch=0;
while ($row2=mysqli_fetch_assoc($result)){
$item_desc = $item_desc.' '.getItemWithFormName($row2['item_id']).'
';
$item_unit_id=getTableFieldValue('tbl_items','unit_id','item_id',$row2['item_id']);
$item_unit =getTableFieldValue(' unit_master','unit_name','unit_id',$item_unit_id);
$item_qty=$item_qty.' '.$row2['indent_qty'].' '.$item_unit.'
';
if($row2['status'] == 'DRAFT_VENDOR_RATE')$st++;
else if($row2['status'] == 'REJECTED' || $row2['status'] == 'SUP_REJECTED_RATE')$rej++;
else if($row2['status'] == 'APPROVED')$pending_dispatch++;
}
error_log("indent sql".$pending_dispatch++);
$fit="";
if($pending_dispatch==0){$fit = "All Dispatched ";}
else if($row1['status']=='APPROVED'){$fit = "Ready For Dispatch ";}
else{
if($num_rows>0 ){
$fit = "Pending RFQ ";
}
if($st>0){
$fit = "Draft Quotation";
}
if($num_rows==0){
$fit = "Pending Dispatching ";
}
if($rej>0){
$fit = "Rejected";
}
}
if($row1['status'] == 'APPROVED' && $rej==0){$task='E';}
else $task='R';
if($hasExecuteAccess)
{
//echo "shubham";
$edit_link="";
}
$po_no = "" . $row1['po_no'] . "";
$space=" ";
$links =$edit_link.$space;
if($app_rem=='' || $app_rem==null){
$status=$fit;
}
else $status=$fit.$space."(".$app_rem.")";
$data['rows'][] = array(
'id' => $row1['indent_id'],
'cell' => array($links,$count++,date_format(date_create($row1['po_date']),"d-M-Y "),$po_no,$row1['remarks'],$status)
);
}
$data['rows'][] = array(
'id' => $row['filterkey'],
'cell' => array('', "", "", '', '','', '', '', '', '', '', '', '','', '', '','', '', '','')
);
echo json_encode($data);