47 lines
2.6 KiB
PHP
47 lines
2.6 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();
|
|
|
|
$sql = "SELECT * FROM quotation_list where indent_id='" . $_POST['indent_id'] . "' and FIND_IN_SET($contractor_id,vendor_id) and (status='' or status='PENDING_RATE' or status=null or status='REJECTED' or status='RFQ_RETURNED' or status='DRAFT_VENDOR_RATE' or status='SUP_REJECTED_RATE') and rfq_no='" . $_POST['rfq_no'] . "' ";
|
|
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['specifications']= getFieldFromTable('specifications','tbl_items','item_id',$row_requisition_items['item_id']);
|
|
$row_requisition_items['make']= getFieldFromTable('make','tbl_items','item_id',$row_requisition_items['item_id']);
|
|
$row_requisition_items['item_unit']=getTableFieldValue('unit_master', 'unit_name', 'unit_id',getTableFieldValue('tbl_items', 'unit_id', 'item_id', $row_requisition_items['item_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']);}
|
|
|
|
// 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); |