project.lock(); if(request.CustNumber != "ALL"){ CustQuery = database.cursor("select order_header.customer_no, order_header.customer_po, order_header.order_no, MONTH(order_header.order_date) AS ord_mon, DAY(order_header.order_date) AS ord_day, YEAR(order_header.order_date) AS ord_year, order_line.line_no, order_line.item_no, order_line.qty_ordered, order_line.qty_shipped, order_line.price, item_master.description from order_header, order_line, item_master where order_header.order_no = order_line.order_no and order_header.customer_no = '" + request.CustNumber + "' and order_header.order_date >= '" + request.StartDate + "' and order_header.order_date <= '" + request.EndDate + "' and order_line.item_no = item_master.part_no order by customer_no, order_no ") } else{ CustQuery = database.cursor("select order_header.customer_no, order_header.customer_po, order_header.order_no, MONTH(order_header.order_date) AS ord_mon, DAY(order_header.order_date) AS ord_day, YEAR(order_header.order_date) AS ord_year, order_line.line_no, order_line.item_no, order_line.qty_ordered, order_line.qty_shipped, order_line.price, item_master.description from order_header, order_line, item_master where order_header.order_no = order_line.order_no and order_header.order_date >= '" + request.StartDate + "' and order_header.order_date <= '" + request.EndDate + "' and order_line.item_no = item_master.part_no order by customer_no, order_no ") } SelectionQuery = database.cursor("select customer.customer_name from customer where customer.customer_no = '" + request.CustNumber + "'") write(""); SelectionQuery.next(); if(request.CustNumber == "ALL"){ SelectionQuery.customer_name = "ALL"; } write("" + ""); write(""); write("" + "" + "" + "" + "" + "" + "" + "" + "" + "" + "" + ""); write("" + "" + "" + "" + "" + "" + "" + "" + "" + "" + "" + ""); write("
Query Selections" + "
Customer Number:" + request.CustNumber + "Start Date:" + request.StartDate + "
Name:" + SelectionQuery.customer_name + "End Date:" + request.EndDate + "Print:" + request.OrdType + "
"); write(""); write(""); write("" + ""+ ""+ ""+ "" + "" + "" + "" + "" + "" + ""+ ""+ ""+ ""); var no_data = "Y"; var bo_qty = 0; var bo_amt = 0; while(CustQuery.next()){ //this code calls the truncation function. //the following two write statements need to be commented out //when compiling for netscape 2.XX write('' ) //the following two write statements need to be commented out //when compiling for netscape 2.XX. Also replace rndPrc and //rndCst with cursor.price and cursor.cost if((request.OrdType == "Open Order" && CustQuery.qty_shipped == '0') || (request.OrdType == "Backordered" && CustQuery.qty_shipped < CustQuery.qty_ordered && CustQuery.qty_shipped != '0') || (request.OrdType == "Complete" && CustQuery.qty_shipped == CustQuery.qty_ordered)){ no_data = "N"; if (CustQuery.qty_shipped > 0 && CustQuery.qty_shipped != CustQuery.qty_ordered){ bo_qty = OrderQuery.qty_ordered - OrderQuery.qty_shipped; bo_amt = bo_qty * OrderQuery.price; } else{ bo_qty = 0; bo_amt = 0; } write(""); write(""); write(""); write(""); write(""); write(""); write(""); write(""); write(""); write(""); write(""); write(""); write(""); } } write("
Order Status By Customer Number
Customer NoOrder NoOrder DateCust P.O.Line NoItem NoDescriptionQty OrderedQty ShippedPriceQty B.O.$ B.O.
" + CustQuery.customer_no + "
" + CustQuery.order_no + "
" + CustQuery.ord_mon + "/" + CustQuery.ord_day + "/" + CustQuery.ord_year + "
" + CustQuery.customer_po + "
" + CustQuery.line_no + "
" + CustQuery.item_no + "
" + CustQuery.description + "
" + CustQuery.qty_ordered + "
" + CustQuery.qty_shipped + "
" + bo_qty + "
" + bo_amt + "
"); if(no_data == "Y") write("No Data Matches Your Selections"); project.unlock();