project.lock(); DelSchQuery = database.cursor("select delivery_schedule.delivery_schedule, delivery_schedule.quantity, MONTH(delivery_schedule.promise_date) AS prom_month, DAY(delivery_schedule.promise_date) AS prom_day, YEAR(delivery_schedule.promise_date) AS prom_year, MONTH(delivery_schedule.request_date) AS req_month, DAY(delivery_schedule.request_date) AS req_day, YEAR(delivery_schedule.request_date) AS req_year from delivery_schedule where delivery_schedule.order_no = '" + request.OrderNumber + "' and delivery_schedule.line_no = '" + request.LineNo + "'") ShpFlrQuery = database.cursor("select shop_floor.operation_sequence, shop_floor.qty_ordered, shop_floor.qty_complete, MONTH(shop_floor.start_date) as sf_start_month, DAY(shop_floor.start_date) as sf_start_day, YEAR(shop_floor.start_date) as sf_start_year, MONTH(shop_floor.due_date) as sf_due_month, DAY(shop_floor.due_date) as sf_due_day, YEAR(shop_floor.due_date) as sf_due_year, order_line.shop_order_no from shop_floor, order_line where order_line.order_no = '" + request.OrderNumber + "' and order_line.line_no = '" + request.LineNo + "' and shop_floor.shop_order_no = order_line.shop_order_no order by operation_sequence") write(""); write("" + "" + ""); write(""); write("" + "" + "" + "" + "" + "" + "" + ""); write("
Query Selections
Order Number:" + request.OrderNumber + "Line Number:" + request.LineNo + "
"); write(""); write(""); write("" + ""+ ""+ ""+ ""+ ""); var no_data = "Y"; while(DelSchQuery.next()){ no_data = "N"; write(""); write(""); write(""); write(""); write(""); write(""); } write("
Delivery Schedule Detail
Delivery ScheduleQuantityPromise DateRequest Date
" + DelSchQuery.delivery_schedule + "
" + DelSchQuery.quantity + "
" + DelSchQuery.prom_month + "/" + DelSchQuery.prom_day + "/" + DelSchQuery.prom_year + "
" + DelSchQuery.req_month + "/" + DelSchQuery.req_day + "/" + DelSchQuery.req_year + "
"); if(no_data == "Y") write("No Data Matches Your Selections"); write(""); write(""); write("" + ""+ ""+ ""+ ""+ ""+ ""+ ""); no_data = "Y"; while(ShpFlrQuery.next()){ no_data = "N"; write(""); write(""); write(""); write(""); write(""); write(""); write("");; write(""); } write("
Shop Floor Detail
Shop Floor NoOperation SequenceQuantity OrderedQuantity CompleteStart DateDue Date
" + ShpFlrQuery.shop_order_no + "
" + ShpFlrQuery.operation_sequence + "
" + ShpFlrQuery.qty_ordered + "
" + ShpFlrQuery.qty_complete + "
" + ShpFlrQuery.sf_start_month + "/" + ShpFlrQuery.sf_start_day + "/" + ShpFlrQuery.sf_start_year + "
" + ShpFlrQuery.sf_due_month + "/" + ShpFlrQuery.sf_due_day + "/" + ShpFlrQuery.sf_due_year + "
"); if(no_data == "Y") write("No Data Matches Your Selections"); project.unlock();