65 lines
2.9 KiB
PHP
65 lines
2.9 KiB
PHP
<?php
|
|
$paramlist='';
|
|
if($qtype=='pl_no' || $qtype=='purchase_order_date' || $qtype=='purchase_order_date_between' || $qtype=='client' ||$qtype=='item_name' || $qtype=='item_desc_new'|| $qtype=='firm_code'||$qtype=='tender_no' ||$qtype=='a.tender_no' ||$qtype=='internal_ref_no'||$qtype=='purchase_order_no'||$qtype=='a.purchase_order_no'||$qtype=='po_no'||$qtype=='production_file_no'||$qtype=='pf_no'||$qtype=='delivery_date'||$qtype=='delivery_date_between'||$qtype=='call_date'||$qtype=='call_date_between'||$qtype=='inspection_date'||$qtype=='inspection_date_between'||$qtype=='certificate_date'||$qtype=='certificate_date_between' ||$qtype=='date_marked_for_dispatch'||$qtype=='date_marked_for_dispatch_between'||$qtype=='submission_date'||$qtype=='submission_date_between'||$qtype=='due_date'||$qtype=='submission_date'||$qtype=='submission_date_between'||$qtype=='due_date_between'||$qtype=='curr_date'||$qtype=='curr_date_between'||$qtype=='date_marked_for_dispatch'||$qtype=='date_marked_for_dispatch_between'||$qtype=='amendment_date'||$qtype=='amendment_date_between'||$qtype=='firm_name')
|
|
{
|
|
if($qtype=='pl_no')
|
|
{
|
|
$paramlist="PL NO : $query ";
|
|
}
|
|
else if($qtype=='client')
|
|
{
|
|
$paramlist="CLIENT : $query ";
|
|
}
|
|
else if($qtype=='firm_name')
|
|
{
|
|
$paramlist="FIRM NAME : $query ";
|
|
}
|
|
else if($qtype=='purchase_order_date'||$qtype=='call_date'||$qtype=='inspection_date'||$qtype=='certificate_date'||$qtype=='date_marked_for_dispatch'||$qtype=='submission_date'||$qtype=='due_date'||$qtype=='submission_date'||$qtype=='delivery_date'||$qtype=='curr_date'||$qtype=='date_marked_for_dispatch'||$qtype=='date_marked_for_dispatch'||$qtype=='amendment_date')
|
|
{
|
|
$paramlist="DATE : $query ";
|
|
}
|
|
else if($qtype=='purchase_order_date_between' ||$qtype=='delivery_date_between'||$qtype=='call_date_between'||$qtype=='inspection_date_between'||$qtype=='certificate_date_between'||$qtype=='date_marked_for_dispatch_between'||$qtype=='submission_date_between'||$qtype=='submission_date_between'||$qtype=='due_date_between'||$qtype=='curr_date_between' ||$qtype=='date_marked_for_dispatch_between'||$qtype=='amendment_date_between')
|
|
{
|
|
$paramlist="DATE SPREAD : '".trim($dates[0])."' and '".trim($dates[1])."' ";
|
|
}
|
|
else if($qtype=='item_name')
|
|
{
|
|
$paramlist="ITEM : $query ";
|
|
}
|
|
else if($qtype=='item_desc_new'||$qtype=='item_desc' || $qtype=='b.item_desc' || $qtype=='a.item_desc' )
|
|
{
|
|
$paramlist="ITEM DESCRIPTION is : $query ";
|
|
}
|
|
else if($qtype=='firm_code')
|
|
{
|
|
$paramlist="FIRM CODE : $query ";
|
|
}
|
|
|
|
else if($qtype=='internal_ref_no')
|
|
{
|
|
$paramlist="INTERNAL REF NO : $query ";
|
|
}
|
|
else if($qtype=='po_no'||$qtype=='purchase_order_no'|| $qtype=='a.purchase_order_no')
|
|
{
|
|
$paramlist="PURCHASE ORDER NO : $query ";
|
|
}
|
|
else if($qtype=='production_file_no'||$qtype=='pf_no')
|
|
{
|
|
$paramlist="PRODUCTION FILE NO : $query ";
|
|
}
|
|
|
|
|
|
|
|
|
|
else if($qtype=='a.tender_no' || $qtype=='tender_no')
|
|
{
|
|
$paramlist="TENDER NO : $query ";
|
|
}
|
|
else
|
|
{
|
|
$paramlist=" ";
|
|
}
|
|
|
|
}
|
|
|
|
?>
|