/** * Generate tag table for user * * @param $request * @return array */ public function generatetagTable($request) { $tagModel = new tagModel(); $datatables = new DataTables(); $viewHelper = new ViewGenerateHelper(); $columns = array(array('db' => 'tags.id', 'dt' => 0), array('db' => 'tags.name', 'dt' => 1), array('db' => 'tags.status', 'dt' => 2), array('db' => 'tags.created', 'dt' => 3), array('db' => 'tags.updated', 'dt' => 4)); $return = $tagModel->generateTagTable($request, $columns); $optionStatus = [KACANA_TAG_STATUS_ACTIVE, KACANA_TAG_STATUS_INACTIVE]; if (count($return['data'])) { foreach ($return['data'] as &$res) { $res->status = $viewHelper->dropdownView('tags', $res->id, $res->status, 'status', $optionStatus); } } $return['data'] = $datatables::data_output($columns, $return['data']); return $return; }
/** * @param $request * @return array */ public function reportDetailTableUser($request) { $userModel = new User(); $datatables = new DataTables(); $viewHelper = new ViewGenerateHelper(); $columns = array(array('db' => 'users.id', 'dt' => 0), array('db' => 'users.name', 'dt' => 1), array('db' => 'users.email', 'dt' => 2), array('db' => 'users.phone', 'dt' => 3), array('db' => 'users.role', 'dt' => 4), array('db' => 'users.status', 'dt' => 5), array('db' => 'users.created', 'dt' => 6), array('db' => 'users.updated_at', 'dt' => 7)); $return = $userModel->reportDetailTableUser($request, $columns); if (count($return['data'])) { $optionStatus = [KACANA_TAG_STATUS_ACTIVE, KACANA_USER_STATUS_INACTIVE, KACANA_USER_STATUS_BLOCK, KACANA_USER_STATUS_CREATE_BY_SYSTEM]; $optionRole = [KACANA_USER_ROLE_ADMIN, KACANA_USER_ROLE_BUYER]; foreach ($return['data'] as &$res) { $res->status = $viewHelper->dropdownView('users', $res->id, $res->status, 'status', $optionStatus); $res->role = $viewHelper->dropdownView('users', $res->id, $res->role, 'role', $optionRole); } } $return['data'] = $datatables::data_output($columns, $return['data']); return $return; }
/** * @param $request * @return array */ public function generateProductTagTable($request) { $productModel = new productModel(); $datatables = new DataTables(); $tagService = new tagService(); $viewHelper = new ViewGenerateHelper(); $columns = array(array('db' => 'products.id', 'dt' => 0), array('db' => 'products.name', 'dt' => 1), array('db' => 'products.price', 'dt' => 2), array('db' => 'products.sell_price', 'dt' => 3), array('db' => 'products.status', 'dt' => 4), array('db' => 'products.created', 'dt' => 5), array('db' => 'products.updated', 'dt' => 6)); $subTag = $tagService->getAllChildTag($request['tagId']); $return = $productModel->generateProductTagTable($subTag, $request, $columns); $statusOptions = [KACANA_PRODUCT_STATUS_ACTIVE, KACANA_PRODUCT_STATUS_INACTIVE]; if (count($return['data'])) { foreach ($return['data'] as &$res) { $res->status = $viewHelper->dropdownView('products', $res->id, $res->status, 'status', $statusOptions); } } $return['data'] = $datatables::data_output($columns, $return['data']); return $return; }
public function reportDetailTableOrder($request) { $orderModel = new orderModel(); $datatables = new DataTables(); $viewHelper = new ViewGenerateHelper(); $columns = array(array('db' => 'orders.id', 'dt' => 0), array('db' => 'users.name', 'dt' => 1), array('db' => 'users.phone', 'dt' => 2), array('db' => 'orders.total', 'dt' => 3), array('db' => 'orders.quantity', 'dt' => 4), array('db' => 'orders.status', 'dt' => 5), array('db' => 'orders.created', 'dt' => 6), array('db' => 'orders.updated', 'dt' => 7)); $return = $orderModel->reportDetailTableOrder($request, $columns); if (count($return['data'])) { $optionStatus = [KACANA_ORDER_STATUS_NEW, KACANA_ORDER_STATUS_PROCESSING, KACANA_ORDER_STATUS_CANCEL, KACANA_ORDER_STATUS_COMPLETE]; foreach ($return['data'] as &$res) { $res->status = $viewHelper->dropdownView('orders', $res->id, $res->status, 'status', $optionStatus); $res->total = formatMoney($res->total); } } $return['data'] = $datatables::data_output($columns, $return['data']); return $return; }