public function ajaxListAction()
 {
     $fields = array('id', 'menuStoreId', 'action', 'quantity', 'unit', 'date', 'note', 'cost', 'supplier', 'store', 'orderId');
     $offset = $this->getDataTableQueryOffset();
     $limit = $this->getDataTableQueryLimit();
     $sortCol = $this->getDataTableQuerySortingColumn();
     $sortDirection = $this->getDataTableQuerySortingDirection();
     $search = $this->getDataTableQuerySearch();
     // WHERE conditions
     $dqlWhere = $this->getDataTableWhereDql('c', $fields, $search);
     // ORDERING
     $dqlOrder = $this->getDataTableOrderDql('c', $fields, $sortCol, $sortDirection);
     // DQL
     $dql = "SELECT c FROM Admin\\Entity\\Transaction c";
     // RESULTS
     $query = $this->getEntityManager()->createQuery($dql . $dqlWhere . $dqlOrder);
     if (!empty($dqlWhere)) {
         $query->setParameter(':search', '%' . $search . '%');
     }
     $results = $query->setMaxResults($limit)->setFirstResult($offset)->getResult();
     // TOTAL RESULTS COUNT
     $countDql = "SELECT COUNT(c.id) FROM Admin\\Entity\\Transaction c ";
     $count = $this->getEntityManager()->createQuery($countDql)->getSingleScalarResult();
     // map data
     $ret = array_map(function ($item) {
         $storeInfo = Utility::getMainStoreInfo($item->getMenuStoreId());
         // create link
         $linkEdit = '/admin/transaction/add/' . $item->getId();
         $linkDelete = '/admin/transaction/delete/' . $item->getId();
         $linkDetail = '/admin/transaction/detail/' . $item->getId();
         return array('id' => $item->getId(), 'menuStoreId' => $storeInfo->getName(), 'action' => $item->getAction(), 'quantity' => $item->getQuantity(), 'unit' => $item->getUnit(), 'date' => $item->getDate(), 'note' => $item->getNote(), 'cost' => $item->getCost(), 'supplier' => $item->getSupplier(), 'store' => $item->getStore(), 'orderId' => $item->getOrderId(), 'actions' => '<a href="' . $linkDetail . '" class="btn btn-info"><i class="icon-edit-sign"></i></a><a class="btn btn-primary" href="' . $linkEdit . '"><i class="icon-edit-sign"></i></a><a href="' . $linkDelete . '" class="btn btn-danger"><i class="icon-trash"></i></a>');
     }, $results);
     return $this->getDataTableJsonResponse($ret, $count, $dqlWhere);
 }
Пример #2
0
 public function convertToArray($datas, $store = SUB_STORE)
 {
     $return = array();
     foreach ($datas as $data) {
         $storeInfo = Utility::getStoreInfo($data->getMenuStoreId());
         if ($store == MAIN_STORE) {
             $storeInfo = Utility::getMainStoreInfo($data->getMenuStoreId());
         }
         $note = TransactionUtility::getStoreItemInOrder($data->getNote());
         if ($note == '') {
             $note = $data->getNote();
         }
         $supplier = Utility::getSupplierInfo($data->getSupplier());
         $array = array();
         $array['id'] = $data->getId();
         $array['menuStoreId'] = $storeInfo->getName();
         $array['action'] = $data->getAction();
         $array['quantity'] = $data->getQuantity();
         $array['unit'] = $data->getUnit();
         $array['date'] = date('d-m-Y', $data->getDate());
         $array['note'] = $note;
         $array['cost'] = $data->getCost();
         $array['supplier'] = $supplier->getCompanyName();
         $return[] = $array;
     }
     return $return;
 }
 public function managerInOutAction()
 {
     $columns = array(array('title' => 'Id', 'db' => 'id', 'dt' => 0, 'select' => 'id', 'prefix' => 'o', 'search' => false, 'type' => 'number'), array('title' => 'Store Name', 'db' => 'menuStoreId', 'dt' => 1, 'select' => 'menuStoreId', 'prefix' => 'o', 'search' => true, 'type' => 'text', 'formatter' => function ($d, $row) {
         $storeInfo = Utility::getMainStoreInfo($d);
         return $storeInfo->getName();
     }), array('title' => 'Action', 'db' => 'action', 'dt' => 2, 'select' => 'action', 'prefix' => 'o', 'search' => true, 'type' => 'text'), array('title' => 'Quantity', 'db' => 'quantity', 'dt' => 3, 'select' => 'quantity', 'prefix' => 'o', 'search' => true, 'type' => 'text'), array('title' => 'Cost', 'db' => 'cost', 'dt' => 4, 'select' => 'cost', 'prefix' => 'o', 'search' => true, 'type' => 'text'), array('title' => 'Note', 'db' => 'note', 'dt' => 5, 'select' => 'note', 'prefix' => 'o', 'search' => true, 'type' => 'text', 'formatter' => function ($d, $row) {
         $note = TransactionUtility::getStoreItemInOrder($d);
         if ($note == '') {
             $note = $d;
         }
         return $note;
     }), array('title' => 'Action', 'db' => 'orderId', 'dt' => 6, 'select' => 'id', 'prefix' => 'o', 'search' => false, 'type' => 'number', 'formatter' => function ($d, $row) {
         $actionUrl = '/admin/menustoremain';
         return '
                     <a class="btn-xs action action-detail btn btn-info btn-default" href="' . $actionUrl . '/detail/' . $d . '"><i class="icon-info-sign"></i></a>
                     <a class="btn-xs action action-detail btn btn-success btn-default" href="' . $actionUrl . '/add/' . $d . '"><i class="icon-edit"></i></a>
                     <a data-id="' . $d . '" id="' . $d . '" data-link="' . $actionUrl . '" class="btn-xs action action-detail btn btn-danger  btn-delete " href="javascript:void(0)"><i class="icon-remove"></i></a>
                 ';
     }));
     /////end column for table
     $table = new AjaxTable(array(), array(), 'admin/menustoremain/managerinout');
     $table->setTableColumns($columns);
     $table->setTablePrefix('o');
     $table->setAjaxCall('/admin/menustoremain/managerinout');
     $table->setActionDeleteAll('deleteall');
     $this->tableAjaxRequest($table, $columns, $this->transactionModel);
     return new ViewModel(array('table' => $table, 'title' => $this->translator->translate('Manage Import/Export')));
 }