/** * List all orders and */ public function actionList() { $this->layout = "column2"; $model = new Orders(); $model->unsetAttributes(); $listDataProvider = null; if (isset($_POST['Orders'])) { $model->attributes = $_POST['Orders']; } if (isset($_POST['searchWhat'])) { $criteria = new CDbCriteria(); if ($_POST['searchWhat'] === 'name') { $criteria->compare("concat(tbl_customer.title,' ',tbl_customer.firstname,' ',tbl_customer.lastname)", $_POST['searchName'], true, "OR"); $criteria->join = "left join tbl_customer on tbl_customer.id = t.customer_id"; $criteria->order = "t.order_date DESC"; // $criteria->compare } else { if ($_POST['searchWhat'] === 'order_date') { $dateFormatted = date("Y-m-d", strtotime($_POST['searchOrderDate'])); $criteria->addCondition("date(order_date) = '" . $dateFormatted . "'"); $criteria->order = "t.order_date DESC"; } } $listDataProvider = new CActiveDataProvider('Orders', array('criteria' => $criteria, 'pagination' => false)); // print_r($listDataProvider->criteria); // print_r($listDataProvider->data); // die(); } else { $listDataProvider = $model->search(); } $this->render('list', array('model' => $model, 'listDataProvider' => $listDataProvider)); }
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 actionExport() { $model = new Orders(); $model->unsetAttributes(); // clear any default values if (isset($_POST['Orders'])) { $model->attributes = $_POST['Orders']; } $exportType = $_POST['fileType']; $this->widget('ext.heart.export.EHeartExport', array('title' => 'List of Orders', 'dataProvider' => $model->search(), 'filter' => $model, 'grid_mode' => 'export', 'exportType' => $exportType, 'columns' => array('order_id', 'expense_id', 'just_id', 'type', 'count', 'table_id'))); }