get_table()." b WHERE a.shipment_id=b.id AND a.item_id='$item_id' ORDER BY $order"; return(Database::ado_execute_query($sel, 'ShipmentsAdmin::get_item_shipments')); } function set_RS($designer_id='', $start_date='0000-00-00', $end_date='9999-12-31') { if($end_date == '') { $end_date = '9999-12-31'; } $where = "WHERE receive_date BETWEEN '$start_date' AND '$end_date'"; if(strlen($designer_id) > 0) { $where .= " AND designer_id='$designer_id'"; } $order = "ORDER BY receive_date DESC"; parent::set_RS($where, $order); } function shipments_html($rs, $selForm=false, $openAll=false) { $shipments_table = ''; if($selForm) { $shipments_table .= '

'; } $shipments_table .= ' '; if($selForm) { $shipments_table .= ''; } $shipments_table .= ' '; $i = 0; $total_amount = 0; while($row = $rs->FetchRow()) { ++$i; $ShipmentAdmin = new ShipmentAdmin($this->get_table(), $row['id']); if($invoice_id = $ShipmentAdmin->get_invoice_id() > 0) { $InvoiceAdmin = new InvoiceAdmin(Config::$db_tables['invoices'], $invoice_id); } $bgcolor = ($i%2) ? "#EEEEEE" : "#FFFFFF"; $open_table = $ShipmentAdmin->get_items_html(); // sets items_amount $total_amount += $ShipmentAdmin->get_items_amount(); $shipments_table .= ' '; if($selForm) { $shipments_table .= ''; } // invoice data $invoice_number = (isset($InvoiceAdmin)) ? $InvoiceAdmin->get_data('invoice_number') : ' '; $invoice_due_date = (isset($InvoiceAdmin)) ? $InvoiceAdmin->get_data('due_date') : ' '; $invoice_paid_date = (isset($InvoiceAdmin)) ? $InvoiceAdmin->get_data('paid_date') : ' '; $open_link = $_SERVER['PHP_SELF'].'?open='.$ShipmentAdmin->get_data('id'); if(isset($_GET['designer_id'])) { $open_link .= '&designer_id='.$ShipmentAdmin->get_data('designer_id'); } $shipments_table .= ' '; if( (isset($_GET['open']) && $_GET['open'] == $row['id']) || $openAll) { $openColspan = ($selForm) ? 6 : 5; $shipments_table .= ' '; } $shipments_table .= ' '; unset($InvoiceAdmin); } if($selForm) { $shipments_table .= ''; } $shipments_table .= '

	Date Received	Designer	Packing Slip #	Invoice #	Due	Paid	Items Amount
	'.$ShipmentAdmin->get_data('receive_date'); if(!$openAll) { $shipments_table .= ' +'; } $shipments_table .= '	'.$ShipmentAdmin->get_designer_name().'	'.$ShipmentAdmin->get_data('packing_slip_number').'	'.$invoice_number.'	'.$invoice_due_date.'	'.$invoice_paid_date.'	$'.number_format($ShipmentAdmin->get_items_amount(),2).'
	'.$open_table.'

'; if($selForm) { $shipments_table .= '

'; } return($shipments_table); } } ?>