50 lines
2.5 KiB
PHP
50 lines
2.5 KiB
PHP
|
<?php
|
||
|
|
error_reporting(E_ERROR | E_PARSE);
|
||
|
|
include('includes/config/config.php');
|
||
|
|
include('includes/functions.php');
|
||
|
|
|
||
|
|
$user_id=$_SESSION['user_id'];
|
||
|
|
error_log('xxxxxxxxx'.$user_id);
|
||
|
|
|
||
|
|
$contractor_id=getTableFieldValue('tbl_users','vendor_id','user_id',$user_id);
|
||
|
|
|
||
|
|
|
||
|
|
$sql_requisition_items="SELECT a.indent_id,a.item_id,a.indent_qty,a.dispatch_qty,a.vendor_rate,a.batch,a.expiry ,b.item_rate,b.unit,a.vendor_id FROM indent_items a left join item_rate b on a.item_id=b.item_id where indent_id='" . $_REQUEST['indent_id'] . "' and item_po_no='" . $_REQUEST['po_no'] . "' and a.indent_qty!=a.dispatch_qty and a.vendor_id='".$contractor_id."' and (a.status='APPROVED' or a.status='REJECTED' or a.status='PENDING_DISPATCH' or a.status='DRAFT_DISPATCH' or a.status='GRN_APPROVED' or a.status='COMPLETED' )" ;
|
||
|
|
|
||
|
|
error_log("get indent query:".$sql_requisition_items);
|
||
|
|
if (!$result_requisition_items = @mysqli_query($conn,$sql_requisition_items)) {
|
||
|
|
exit(mysqli_error($conn));
|
||
|
|
}
|
||
|
|
$data = array();
|
||
|
|
if(mysqli_num_rows($result_requisition_items) > 0) {
|
||
|
|
while ($row_requisition_items = mysqli_fetch_assoc($result_requisition_items)) {
|
||
|
|
//extract($row);
|
||
|
|
$row_requisition_items['item_name']=getItemWithFormName($row_requisition_items['item_id']);
|
||
|
|
if($row_requisition_items['unit']==0 || $row_requisition_items['unit']==null || $row_requisition_items['unit']=='' ){
|
||
|
|
$ratePerUnit=0;
|
||
|
|
}
|
||
|
|
else{ $ratePerUnit=($row_requisition_items['item_rate']/$row_requisition_items['unit']);}
|
||
|
|
$row_requisition_items['vendor_price']=$row_requisition_items['vendor_rate'];
|
||
|
|
$row_requisition_items['vendor_rate']=($row_requisition_items['vendor_rate']/$row_requisition_items['indent_qty']);
|
||
|
|
|
||
|
|
$row_requisition_items['ratePerUnit']=round($ratePerUnit,2);
|
||
|
|
|
||
|
|
$row_requisition_items['indent_qty']=$row_requisition_items['indent_qty']." ".getTableFieldValue('unit_master', 'UPPER (`unit_name`)', 'unit_id',getTableFieldValue('tbl_items', 'unit_id', 'item_id', $row_requisition_items['item_id']));
|
||
|
|
|
||
|
|
$row_requisition_items['price']=round(($ratePerUnit),2)*$row_requisition_items['indent_qty'];
|
||
|
|
|
||
|
|
$row_requisition_items['in_qty']=($row_requisition_items['indent_qty']-$row_requisition_items['dispatch_qty']);
|
||
|
|
$row_requisition_items['dispatch_qty']=($row_requisition_items['indent_qty']-$row_requisition_items['dispatch_qty']);
|
||
|
|
|
||
|
|
// error_log("data:".print_r($row_requisition_items,true));
|
||
|
|
$data[] = $row_requisition_items;
|
||
|
|
|
||
|
|
}
|
||
|
|
}
|
||
|
|
else
|
||
|
|
{
|
||
|
|
$data['status'] = 200;
|
||
|
|
$data['message'] = "Data not found!";
|
||
|
|
}
|
||
|
|
error_log("data:".print_r($data,true));
|
||
|
|
echo json_encode($data);
|