"; // } $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; 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++; if($row2['status'] == 'REJECTED' || $row2['status'] == 'SUP_REJECTED_RATE')$rej++; } error_log("indent sql".$st); $fit=""; 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 = "APPROVED QUOTATION /Pending Dispatch "; } if($rej>0){ $fit = "REJECTED"; } } if($row1['status'] == 'APPROVED' && $rej==0){$task='E';} else $task='R'; if($hasExecuteAccess) { //echo "shubham"; $edit_link=""; } $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['indent_date']),"d-M-Y "),$indent_ref_no,$row1['remarks'],$status) ); } $data['rows'][] = array( 'id' => $row['filterkey'], 'cell' => array('', "", "", '', '','', '', '', '', '', '', '', '','', '', '','', '', '','') ); echo json_encode($data);