public function validateAccess()
{
$objOrder = new Orders();
$objOrder->setCompany(request_var("company"));
$objOrder->setOffice(DEFAULT_ID);
$objOrder->setUserWeb(request_var("username"));
$objOrder->setPassWeb(request_var("password"));
$objOrder->setInitDate("01/01/2000");
$objOrder->setEndDate("01/01/2020");
$_response = $objOrder->search();
if (is_array($_response) && count($_response)) {
$_response = $_response["ConsultarOrdenWebSigLabResult"]["ClsOrdenes"];
$objOrder->setOffice($_response["OficinaId"]);
$objOrder->setOrderId($_response["OrdId"]);
$objOrder->setTable(TEMP_TABLE_RESULTS . $objOrder->getOrderId());
$_response = $objOrder->viewResult();
if (is_array($_response) && count($_response)) {
$objOrder->saveResult($_response);
$header = $objOrder->generateHeader();
$menu = $objOrder->generateMenu();
$resultados = $objOrder->viewResultDetail();
$printer = $objOrder->generatePrinter();
$footer = CLIENT_FOOTER . " " . date('Y') . " - Todos los Derechos Reservados.";
include "../view/lab_results.php";
} else {
echo "<b>No hay detalle a mostrar.</b>";
}
}
}
public function viewResultDetail()
{
$objOrder = new Orders();
$objOrder->setTest(request_var("info"));
$objOrder->setOrderId(request_var("ordId"));
$objOrder->setTable(TEMP_TABLE_RESULTS . $objOrder->getOrderId());
echo $objOrder->viewResultDetail();
}
function index()
{
if (!Login::verifyLogin()) {
header("Location: ../../home/login/index");
exit;
}
$user_id = "";
if (isset($_SESSION['user_id'])) {
$user_id = $_SESSION['user_id'];
if (!empty($user_id)) {
$user_data = Login::verify_login($user_id);
if (!empty($user_data)) {
// var_dump($user_data);
$this->assign('user_data', $user_data);
}
}
}
$m_order = new Orders();
$field = array('ord.id', 'ord.order_no', 'ord.created', 'ord.status', 'ord.product_id', 'ord.qty', 'ord.freight', 'pr.product_url', 'pr.title_cn', 'pr.title_th', 'pr.category_3_id', 'pr.floor_3_id', 'pr.image_url', 'pr.product_url', 'pr.shop', 'pr.shop_id', 'pr.shop_url', 'pr.product_id', 'pr.status', 'pr.category_1_id', 'pr.sales_price');
$m_order->clear();
$m_order->setField($field);
$m_order->setTable(' vcb_order as ord');
$m_order->setJoin(' vcb_product as pr ', 'ord.product_id=pr.product_id');
$count = $m_order->getRowsCount();
//var_dump($count);
$page = new Page($count, 5);
$parameter = array();
$page->setParameter($parameter);
$showPage = $page->showPage();
$showTotal = $page->showTotal();
//var_dump($showPage);
//var_dump($showTotal);
$m_order->setPage();
$page->setListRows(5);
$m_order->setWhere('ord.user_id', '=', $user_id);
$m_order->setWhere('ord.status', '!=', 60000);
$m_order->setLimit($page->listRows);
$order_data = $m_order->select();
// var_dump($order_data);
/* $product_data = array();
$m_product = new products();
for($i = 0;$i<count($order_data);$i++){
$product_data[$i] = $m_product->getproducts_id($order_data[$i]['product_id']);
} */
//var_dump($product_data);
$this->assign('order_data', $order_data);
$this->assign('showPage', $showPage);
$this->assign('showTotal', $showTotal);
//$this->assign('pro_data', $product_data);
}
