67 lines
3.8 KiB
PHP
67 lines
3.8 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);
|
|
$item_arr=array();
|
|
$qt_filter='';
|
|
if($_REQUEST['qt_no']!='all'){
|
|
$qt_filter= " and a.quotation_no='" . $_REQUEST['qt_no'] . "' and a.status='".$_REQUEST['status']."'";
|
|
}
|
|
$sql = "SELECT a.quotation_id,a.indent_id,a.item_id,a.indent_qty,a.vendor_rate,a.rfq_qty,a.rfq_no,a.vendor_id,a.quotation_no ,b.item_rate,b.unit,c.make,c.specifications,c.item_form_id,a.per_unit_rate as qt_rate,a.rfq_qty FROM quotation_list a left join item_rate b on a.item_id=b.item_id left join tbl_items c on c.item_id=a.item_id where a.indent_id='" . $_REQUEST['indent_id'] . "' $qt_filter order by quotation_no asc";
|
|
error_log('qq'.$sql);
|
|
$result = mysqli_query($conn, $sql);
|
|
$num_rows = @mysqli_num_rows($result);
|
|
//$row=@mysql_fetch_array($result);
|
|
|
|
$i = 0;
|
|
if(mysqli_num_rows($result) > 0) {
|
|
while ($row_requisition_items = @mysqli_fetch_array($result)) {
|
|
array_push($item_arr,$row_requisition_items['item_id']);
|
|
$row_requisition_items['item_rate']=getTableFieldValue('item_rate','item_rate','item_id',$row_requisition_items['item_id']);
|
|
$row_requisition_items['item_name']=getItemWithFormName($row_requisition_items['item_id']);
|
|
$row_requisition_items['make']=$row_requisition_items['make'];
|
|
$row_requisition_items['specifications']=$row_requisition_items['specifications'];
|
|
$row_requisition_items['item_unit']=getTableFieldValue('unit_master', 'unit_name', 'unit_id',getTableFieldValue('tbl_items', 'unit_id', 'item_id', $row_requisition_items['item_id']));
|
|
$row_requisition_items['vendor_name']=getTableFieldValue('employer_contractor','employer_contractor_name','id',$row_requisition_items['vendor_id']);
|
|
if($row_requisition_items['mrp']=='' || $row_requisition_items['mrp']==null){$row_requisition_items['mrp']=getTableFieldValue('item_rate','mrp','item_id',$row_requisition_items['item_id']);}
|
|
if($row_requisition_items['gst']=='' || $row_requisition_items['gst']==null){$row_requisition_items['gst']=getTableFieldValue('item_rate','gst','item_id',$row_requisition_items['item_id']);}
|
|
if($row_requisition_items['discount']=='' || $row_requisition_items['discount']==null){$row_requisition_items['discount']=getTableFieldValue('discount','item_rate','item_id',$row_requisition_items['item_id']);}
|
|
if($row_requisition_items['unit']=='' || $row_requisition_items['unit']==null){$row_requisition_items['unit']=getTableFieldValue('item_rate','unit','item_id',$row_requisition_items['item_id']);}
|
|
|
|
|
|
|
|
if($row_requisition_items['unit']==0 || $row_requisition_items['unit']==null || $row_requisition_items['unit']=='' ){
|
|
$row_requisition_items['ratePerUnit']=0;
|
|
}
|
|
else{ $row_requisition_items['ratePerUnit']=($row_requisition_items['item_rate']/$row_requisition_items['unit']);}
|
|
$row_requisition_items['ratePerUnit']=round($row_requisition_items['ratePerUnit'],2);
|
|
|
|
$row_requisition_items['vendorRatePerUnit']=round($row_requisition_items['qt_rate'],2);
|
|
|
|
$row_requisition_items['price']=round($row_requisition_items['ratePerUnit'],2)*$row_requisition_items['rfq_qty'];
|
|
$row_requisition_items['price']=round($row_requisition_items['price'],2);
|
|
|
|
$row_requisition_items['old_rate']=round($row_requisition_items['ratePerUnit'],2)*$row_requisition_items['rfq_qty'];
|
|
$row_requisition_items['old_rate']=round($row_requisition_items['old_rate'],2);
|
|
|
|
$row_requisition_items['vendor_rate']=round($row_requisition_items['vendor_rate'],2);
|
|
// error_log("data:".print_r($row_requisition_items,true));
|
|
|
|
$data[] = $row_requisition_items;
|
|
|
|
}
|
|
}
|
|
else
|
|
{
|
|
$data['status'] = 200;
|
|
$data['message'] = "Data not found!";
|
|
}
|
|
$data['count']=$num_rows;
|
|
$data['item_arr']=$item_arr;
|
|
error_log("data:".print_r($data,true));
|
|
echo json_encode($data); |