예제 #1
0
 public function indexAction()
 {
     $columns = array(array('title' => 'Id', 'db' => 'id', 'dt' => 0, 'search' => false, 'type' => 'number'), array('title' => 'Name', 'db' => 'name', 'dt' => 1, 'search' => false, 'type' => 'number'), array('title' => 'Value', 'db' => 'value', 'dt' => 2, 'search' => false, 'type' => 'number'), array('title' => 'Type', 'db' => 'type', 'dt' => 3, 'search' => false, 'type' => 'number'));
     /////end column for table
     $table = new AjaxTable($columns, array(), 'admin/surtax');
     $table->setTablePrefix('ts');
     $table->setAjaxCall('/admin/surtax');
     $this->tableAjaxRequest($table, $columns, $this->modelSurTax);
     //end config table
     return new ViewModel(array('table' => $table, 'title' => $this->translator->translate('Manage Surtax')));
 }
예제 #2
0
 public function indexAction()
 {
     $columns = array(array('title' => 'Id', 'db' => 'id', 'dt' => 0, 'prefix' => 'h', 'select' => 'id', 'search' => false, 'type' => 'number'), array('title' => 'User', 'db' => 'userName', 'prefix' => 'u', 'select' => 'userName', 'dt' => 1, 'search' => true, 'type' => 'text'), array('title' => 'Action', 'db' => 'action', 'prefix' => 'h', 'select' => 'action', 'dt' => 2, 'search' => false, 'type' => 'number'), array('title' => 'Time', 'db' => 'time', 'prefix' => 'h', 'select' => 'time', 'dt' => 3, 'search' => false, 'type' => 'number', 'formatter' => function ($d, $row) {
         return date('d-m-Y h:i:s', $d);
     }));
     /////end column for table
     $table = new AjaxTable($columns, array(), 'admin/history');
     $table->setTablePrefix('h');
     $table->setExtendJoin(array(array('Admin\\Entity\\User', 'u', 'with', 'h.userId = u.id')));
     $table->setAjaxCall('/admin/history');
     $this->tableAjaxRequest($table, $columns, $this->modelHistory);
     //end config table
     return new ViewModel(array('table' => $table, 'title' => $this->translator->translate('Manage User History')));
 }
예제 #3
0
 public function indexAction()
 {
     //config table
     /////column for table
     $columns = array(array('title' => 'Id', 'db' => 'id', 'dt' => 0, 'select' => 'id', 'prefix' => 'o', 'search' => false, 'type' => 'number'), array('title' => 'Table', 'db' => 'name', 'dt' => 1, 'select' => 'name', 'prefix' => 't', 'search' => true, 'type' => 'text'), array('title' => 'User Name', 'db' => 'userName', 'dt' => 2, 'select' => 'userName', 'prefix' => 'u', 'search' => true, 'type' => 'text'), array('title' => 'Create Date', 'db' => 'createDate', 'dt' => 3, 'select' => 'createDate', 'prefix' => 'o', 'search' => true, 'type' => 'text', 'formatter' => function ($d, $row) {
         return date('d-m-Y h:i:s', $d);
     }), array('title' => 'Total Cost', 'db' => 'totalCost', 'dt' => 4, 'select' => 'totalCost', 'prefix' => 'o', 'search' => true, 'type' => 'text', 'formatter' => function ($d, $row) {
         return Utility::formatCost($d);
     }), array('title' => 'Total Real Cost', 'db' => 'totalRealCost', 'select' => 'totalRealCost', 'prefix' => 'o', 'dt' => 5, 'search' => true, 'type' => 'text', 'formatter' => function ($d, $row) {
         return Utility::formatCost($d);
     }), array('title' => 'Coupon', 'db' => 'code', 'dt' => 6, 'select' => 'code', 'prefix' => 'c', 'search' => true, 'type' => 'text'), array('title' => 'Action', 'db' => 'orderId', 'dt' => 7, 'select' => 'id', 'prefix' => 'o', 'search' => false, 'type' => 'number', 'formatter' => function ($d, $row) {
         $actionUrl = '/admin/order';
         return '
                     <a class="btn-xs action action-detail btn btn-info btn-default" href="' . $actionUrl . '/detail/' . $d . '"><i class="icon-info"></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/order');
     $table->setTableColumns($columns);
     $table->setTablePrefix('o');
     $table->setExtendJoin(array(array(" Admin\\Entity\\User", "u", "WITH", "u.id = o.userId "), array(" Admin\\Entity\\Managetable", "t", "WITH", "t.id = o.tableId "), array(" Admin\\Entity\\Coupon", "c", "WITH", "c.id = o.couponId ")));
     $table->setExtendSQl(array(array('AND', 'o.isdelete', '=', '0')));
     $table->setAjaxCall('/admin/order');
     $table->setActionDeleteAll('deleteall');
     $this->tableAjaxRequest($table, $columns, $this->modelOrder);
     //end config table
     return new ViewModel(array('table' => $table, 'title' => $this->translator->translate('Manage Order')));
 }
예제 #4
0
 public function __construct()
 {
     $config = Utility::getConfig();
     $this->sumOption = array('option' => array('curency' => $config['currency'], 'currency_before' => $config['currency_before'], 'number_decimal' => $config['number_decimal']));
     $this->sumColumn = array();
     parent::__construct();
 }
예제 #5
0
 public function indexAction()
 {
     $columns = array(array('title' => 'Id', 'db' => 'id', 'dt' => 0, 'search' => false, 'type' => 'number'), array('title' => 'Title', 'db' => 'title', 'dt' => 1, 'search' => false, 'type' => 'text'), array('title' => 'Value', 'db' => 'value', 'dt' => 2, 'search' => false, 'type' => 'number'), array('title' => 'Reason', 'db' => 'reason', 'dt' => 3, 'search' => false, 'type' => 'text'), array('title' => 'Time', 'db' => 'time', 'dt' => 4, 'search' => false, 'type' => 'text'), array('title' => 'Category', 'db' => 'categoryId', 'dt' => 5, 'search' => false, 'type' => 'text'), array('title' => 'Action', 'db' => 'id', 'dt' => 6, 'search' => false, 'type' => 'text', 'formatter' => function ($d, $row) {
         $actionUrl = '/admin/payment';
         return '
                     <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($columns, array(), 'admin/payment');
     $table->setTablePrefix('ts');
     $table->setAjaxCall('/admin/payment');
     $this->tableAjaxRequest($table, $columns, $this->modelCustomer);
     //end config table
     return new ViewModel(array('table' => $table, 'title' => $this->translator->translate('Manage Payment')));
 }
 public function indexAction()
 {
     $columns = array(array('title' => 'Id', 'db' => 'id', 'dt' => 0, 'search' => false, 'type' => 'number'), array('title' => 'Name', 'db' => 'name', 'dt' => 1, 'search' => false, 'type' => 'number'), array('title' => 'Item Id', 'db' => 'supplierItemId', 'dt' => 2, 'search' => false, 'type' => 'number'), array('title' => 'Item Name', 'db' => 'supplierItemName', 'dt' => 3, 'search' => false, 'type' => 'number'), array('title' => 'Quantity', 'db' => 'quantity', 'dt' => 4, 'search' => false, 'type' => 'number'), array('title' => 'Note', 'db' => 'note', 'dt' => 5, 'search' => false, 'type' => 'number'), array('title' => 'Time', 'db' => 'time', 'dt' => 6, 'search' => false, 'type' => 'number', 'formatter' => function ($d, $row) {
         return $d;
     }), array('title' => 'Action', 'db' => 'id', 'dt' => 7, 'search' => false, 'type' => 'text', 'formatter' => function ($d, $row) {
         $actionUrl = '/admin/tracking-tore';
         return '
                     <a class="btn-xs action action-detail btn btn-success btn-default" href="' . $actionUrl . '/add/' . $d . '"><i class="icon-edit"></i></a>
                 ';
     }));
     /////end column for table
     $table = new AjaxTable($columns, array(), 'admin/tracking-tore');
     $table->setTablePrefix('ts');
     $table->setAjaxCall('/admin/tracking-tore');
     $this->tableAjaxRequest($table, $columns, $this->modelTracking);
     //end config table
     return new ViewModel(array('table' => $table, 'title' => $this->translator->translate('Manage Tracking')));
 }
예제 #7
0
 public function indexAction()
 {
     //config table
     /////column for table
     $columns = array(array('title' => 'Id', 'db' => 'id', 'dt' => 0, 'search' => false, 'type' => 'number'), array('title' => 'Name', 'db' => 'name', 'dt' => 1, 'search' => true, 'type' => 'text'), array('title' => 'Category', 'db' => 'catId', 'dt' => 2, 'search' => false, 'type' => 'number', 'dataSelect' => Utility::getCategoryForSelect()), array('title' => 'Cost', 'db' => 'cost', 'dt' => 3, 'search' => false, 'type' => 'number', 'formatter' => function ($d, $row) {
         return Utility::formatCost($d);
     }), array('title' => 'Take Away Cost', 'db' => 'taCost', 'dt' => 4, 'search' => false, 'type' => 'number', 'formatter' => function ($d, $row) {
         return Utility::formatCost($d);
     }), array('title' => 'Action', 'db' => 'id', 'dt' => 5, 'search' => false, 'type' => 'number', 'formatter' => function ($d, $row) {
         $actionUrl = '/admin/index';
         return '
                     <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($columns, array(), 'admin/index');
     $table->setTablePrefix('m');
     $table->setExtendSQl(array(array('AND', 'm.isdelete', '=', '0')));
     $table->setAjaxCall('/admin/index');
     $table->setActionDeleteAll('deleteall');
     $this->tableAjaxRequest($table, $columns, $this->modelMenu);
     //end config table
     return new ViewModel(array('table' => $table, 'title' => $this->translator->translate('Manage Menu')));
 }
예제 #8
0
 public function indexAction()
 {
     $columns = array(array('title' => 'Id', 'db' => 'id', 'dt' => 0, 'search' => false, 'type' => 'number'), array('title' => 'Name', 'db' => 'name', 'dt' => 1, 'search' => true, 'type' => 'text'), array('title' => 'Category', 'db' => 'catId', 'dt' => 2, 'search' => false, 'type' => 'number', 'dataSelect' => Utility::getCategoryForSelect()), array('title' => 'Cost', 'db' => 'cost', 'dt' => 3, 'search' => false, 'type' => 'number'), array('title' => 'Take Away cost', 'db' => 'taCost', 'dt' => 4, 'search' => false, 'type' => 'number'));
     /////end column for table
     $table = new AjaxTable($columns, array(), 'frontend/com');
     $table->setTablePrefix('m');
     $table->setExtendSQl(array(array('AND', 'm.isdelete', '=', '0'), array('AND', 'm.isCombo', '=', '1')));
     $table->setAjaxCall('/frontend/com');
     $table->setActionDeleteAll('deleteall');
     $this->tableAjaxRequest($table, $columns, $this->modelMenu);
     //end config table
     return new ViewModel(array('table' => $table, 'title' => array('title' => $this->translator->translate('Combo'))));
 }
예제 #9
0
 public function indexAction()
 {
     //config table
     /////column for table
     $menuTableColumn = $columns = array(array('title' => 'Id', 'db' => 'id', 'dt' => 0, 'search' => true, 'type' => 'number'), array('title' => 'Name', 'db' => 'userName', 'dt' => 1, 'search' => true, 'type' => 'text'), array('title' => 'Full name', 'db' => 'fullName', 'dt' => 2, 'search' => true, 'type' => 'number'), array('title' => 'User Type', 'db' => 'type', 'dt' => 3, 'search' => true, 'type' => 'number', 'dataSelect' => Utility::getUserRole()), array('title' => 'Action', 'db' => 'id', 'dt' => 4, 'search' => false, 'type' => 'number', 'formatter' => function ($d, $row) {
         $actionUrl = '/admin/users';
         return '
                     <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($menuTableColumn, 'admin/users');
     $table->setTablePrefix('u');
     $table->setExtendSQl(array(array('AND', 'u.isdelete', '=', '0')));
     $table->setAjaxCall('/admin/users');
     $table->setActionLink('admin/users');
     $table->setActionDeleteAll('deleteall');
     $this->tableAjaxRequest($table, $columns, $this->modelUsers);
     //end config table
     return new ViewModel(array('table' => $table, 'title' => $this->translator->translate('Users Manage')));
 }
 public function indexAction()
 {
     $columns = array(array('title' => 'ID', 'db' => 'id', 'dt' => 0, 'search' => false, 'type' => 'number'), array('title' => 'Value', 'db' => 'value', 'dt' => 1, 'search' => true, 'type' => 'text'), array('title' => 'Action', 'db' => 'id', 'dt' => 2, 'search' => false, 'type' => 'number', 'formatter' => function ($d, $row) {
         $actionUrl = '/admin/supplieritem';
         return '
                     <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($columns, array(), 'admin/supplieritem');
     $table->setTablePrefix('m');
     $table->setExtendSQl(array(array('AND', 'm.isdelete', '=', '0')));
     $table->setAjaxCall('/admin/supplieritem');
     $table->setActionDeleteAll('deleteall');
     $this->tableAjaxRequest($table, $columns, $this->modelSubItem);
     //end config table
     return new ViewModel(array('table' => $table, 'title' => $this->translator->translate('Raw Material')));
 }
예제 #11
0
    public function indexAction()
    {
        //config table
        /////column for table
        $columns = array(array('title' => 'Id', 'db' => 'id', 'dt' => 0, 'search' => false, 'type' => 'number'), array('title' => 'Code', 'db' => 'code', 'dt' => 1, 'search' => true, 'type' => 'text'), array('title' => 'Value', 'db' => 'value', 'dt' => 2, 'search' => true, 'type' => 'text'), array('title' => 'Type', 'db' => 'type', 'dt' => 3, 'search' => true, 'type' => 'text', 'dataSelect' => Utility::getCouponType()), array('title' => 'From Date', 'db' => 'fromdate', 'dt' => 4, 'search' => true, 'type' => 'text'), array('title' => 'To Date', 'db' => 'todate', 'dt' => 5, 'search' => true, 'type' => 'text'), array('title' => 'Action', 'db' => 'id', 'dt' => 6, 'search' => false, 'type' => 'number', 'formatter' => function ($d, $row) {
            $actionUrl = '/admin/coupon';
            return '

                        <a class="btn-xs action action-detail btn btn-success btn-default" href="' . $actionUrl . '/add/' . $d . '"><i class="icon-edit"></i></a>
                        <a class="btn-xs action action-detail btn btn-danger  " href="' . $actionUrl . '/delete/' . $d . '"><i class="icon-remove"></i></a>
                    ';
        }));
        /////end column for table
        $table = new AjaxTable($columns, array(), 'admin/coupon');
        $table->setTablePrefix('m');
        $table->setExtendSQl(array(array('AND', 'm.isdelete', '=', '0')));
        $table->setAjaxCall('/admin/coupon');
        $table->setActionDeleteAll('deleteall');
        $this->tableAjaxRequest($table, $columns, $this->modelCoupon);
        //end config table
        return new ViewModel(array('table' => $table, 'title' => $this->translator->translate('Manage Coupon')));
    }
예제 #12
0
 public function indexAction()
 {
     //config table
     /////column for table
     $columns = array(array('title' => 'Id', 'db' => 'id', 'dt' => 0, 'search' => false, 'type' => 'number'), array('title' => 'Full name', 'db' => 'fullname', 'dt' => 1, 'search' => true, 'type' => 'text'), array('title' => 'Nice name', 'db' => 'nicename', 'dt' => 2, 'search' => true, 'type' => 'text'), array('title' => 'Customer Code', 'db' => 'customerCode', 'dt' => 3, 'search' => true, 'type' => 'text'), array('title' => 'Level', 'db' => 'level', 'dt' => 4, 'search' => true, 'type' => 'number'), array('title' => 'Phone', 'db' => 'phone', 'dt' => 5, 'search' => true, 'type' => 'text'), array('title' => 'Email', 'db' => 'email', 'dt' => 6, 'search' => true, 'type' => 'text'), array('title' => 'Address', 'db' => 'address', 'dt' => 7, 'search' => true, 'type' => 'text'), array('title' => 'Birthday', 'db' => 'birthday', 'dt' => 8, 'search' => true, 'type' => 'text'), array('title' => 'Avatar', 'db' => 'avatar', 'dt' => 9, 'search' => true, 'type' => 'text', 'formatter' => function ($d, $row) {
         $image = '<img src="' . $d . '" width="50" />';
         return $image;
     }), array('title' => 'Action', 'db' => 'id', 'dt' => 10, 'search' => false, 'type' => 'number', 'formatter' => function ($d, $row) {
         $actionUrl = '/admin/customer';
         return '
                     <a class="btn-xs action action-detail btn btn-success btn-default" href="' . $actionUrl . '/add/' . $d . '"><i class="icon-edit"></i></a>
                     <a class="btn-xs action action-detail btn btn-danger  " href="' . $actionUrl . '/delete/' . $d . '"><i class="icon-remove"></i></a>
                 ';
     }));
     /////end column for table
     $table = new AjaxTable($columns, array(), 'admin/customer');
     $table->setTablePrefix('m');
     $table->setExtendSQl(array(array('AND', 'm.isdelete', '=', '0')));
     $table->setAjaxCall('/admin/customer');
     $table->setActionDeleteAll('deleteall');
     $this->tableAjaxRequest($table, $columns, $this->modelCustomer);
     //end config table
     return new ViewModel(array('table' => $table, 'title' => $this->translator->translate('Manage Customer')));
 }
예제 #13
0
    public function unitListCovertAction()
    {
        //config table
        /////column for table
        $columns = array(array('title' => 'Id', 'db' => 'id', 'dt' => 0, 'search' => true, 'type' => 'number', 'name' => 'id'), array('title' => 'Name', 'db' => 'name', 'dt' => 1, 'search' => true, 'type' => 'text', 'name' => 'name'), array('title' => 'Action', 'db' => 'id', 'dt' => 2, 'search' => true, 'type' => 'number', 'formatter' => function ($d, $row) {
            $actionUrl = '/admin/config/additemunit';
            $actionDeleteUrl = '/admin/config/deleteitemunit';
            return '

                        <a class="btn-xs action action-detail btn btn-success btn-default" href="' . $actionUrl . '/' . $d . '"><i class="icon-edit"></i></a>
                        <a data-id="' . $d . '" id="' . $d . '" data-specific-link="1" data-link="' . $actionDeleteUrl . '" 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($columns, array(), 'admin/config/unitlist');
        $table->setTablePrefix('u');
        $table->setAjaxCall('/admin/config/unitlist');
        $table->setActionDeleteAll('deleteall');
        $this->tableAjaxRequest($table, $columns, $this->modelUnit);
        //end config table
        return new ViewModel(array('table' => $table, 'title' => $this->translator->translate('Unit')));
    }
 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')));
 }
예제 #15
0
 public function managerInOutAction()
 {
     $columns = array(array('title' => 'ID', 'db' => 'id', 'dt' => 0, 'search' => false, 'type' => 'number'), array('title' => 'Name', 'db' => 'menuStoreId', 'dt' => 1, 'search' => true, 'type' => 'number', 'formatter' => function ($d, $row) {
         //$storeInfo = Utility::getStoreInfo( $d);
         return $d;
     }), array('title' => 'Quantity', 'db' => 'quantity', 'dt' => 2, 'search' => true, 'type' => 'number'), array('title' => 'Unit', 'db' => 'unit', 'dt' => 3, 'search' => false, 'type' => 'text'), array('title' => 'Cost', 'db' => 'cost', 'dt' => 4, 'search' => true, 'type' => 'number'), array('title' => 'Action', 'db' => 'action', 'dt' => 5, 'search' => false, 'type' => 'text'), array('title' => 'Time', 'db' => 'date', 'dt' => 6, 'search' => true, 'type' => 'number', 'formatter' => function ($d, $row) {
         return $d;
     }), array('title' => 'Note', 'db' => 'note', 'dt' => 7, 'search' => false, 'type' => 'text', 'formatter' => function ($d, $row) {
         return $d;
     }));
     /////end column for table
     $table = new AjaxTable($columns, array(), 'admin/menustore');
     $table->setTablePrefix('m');
     $table->setAjaxCall('/admin/menustore/managerinout');
     $table->setActionDeleteAll('deleteall');
     $this->tableAjaxRequest($table, $columns, $this->transactionModel);
     //end config table
     return new ViewModel(array('table' => $table, 'title' => $this->translator->translate('Manage Import/Export')));
 }