/**
* 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')));
}
