public function postIndex()
 {
     $this->fields = Config::get('jex.default_courier_fields');
     $db = Config::get('jayon.main_db');
     $this->def_order_by = 'ordertime';
     $this->def_order_dir = 'desc';
     $this->place_action = 'first';
     $this->show_select = true;
     $this->sql_key = 'delivery_id';
     $this->sql_table_name = Config::get('jayon.incoming_delivery_table');
     $this->sql_connection = 'mysql';
     return parent::SQLtableResponder();
 }
 public function postIndex()
 {
     $this->fields = array(array('ordertime', array('kind' => 'daterange', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('pickuptime', array('kind' => 'daterange', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('pickup_person', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('pickup_person', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('buyerdeliverytime', array('kind' => 'daterange', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('buyerdeliveryslot', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('buyerdeliveryzone', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('buyerdeliverycity', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('shipping_address', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('merchant_trans_id', array('kind' => 'text', 'callback' => 'dispBar', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('delivery_type', array('kind' => 'text', 'callback' => 'colorizetype', 'query' => 'like', 'pos' => 'both', 'show' => true)), array(Config::get('jayon.jayon_members_table') . '.merchantname', array('kind' => 'text', 'alias' => 'merchant_name', 'query' => 'like', 'callback' => 'merchantInfo', 'pos' => 'both', 'show' => true)), array('delivery_id', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('status', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('directions', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('delivery_id', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('delivery_cost', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('cod_cost', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('total_price', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('buyer_name', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('shipping_zip', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('phone', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('volume', array('kind' => 'numeric', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('weight', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)));
     /*
     $categoryFilter = Input::get('categoryFilter');
     if($categoryFilter != ''){
         $this->additional_query = array('shopcategoryLink'=>$categoryFilter, 'group_id'=>4);
     }
     */
     $db = Config::get('jayon.main_db');
     $this->def_order_by = 'ordertime';
     $this->def_order_dir = 'desc';
     $this->place_action = 'first';
     $this->show_select = true;
     $this->sql_key = 'delivery_id';
     $this->sql_table_name = Config::get('jayon.incoming_delivery_table');
     $this->sql_connection = 'mysql';
     return parent::SQLtableResponder();
 }
 public function postIndex()
 {
     $this->fields = Config::get('jex.default_incoming_fields');
     /*
     $categoryFilter = Input::get('categoryFilter');
     if($categoryFilter != ''){
         $this->additional_query = array('shopcategoryLink'=>$categoryFilter, 'group_id'=>4);
     }
     */
     $db = Config::get('jayon.main_db');
     $this->def_order_by = 'ordertime';
     $this->def_order_dir = 'desc';
     $this->place_action = 'first';
     $this->show_select = true;
     $this->sql_key = 'delivery_id';
     $this->sql_table_name = Config::get('jayon.incoming_delivery_table');
     $this->sql_connection = 'mysql';
     return parent::SQLtableResponder();
 }
Beispiel #4
0
 public function postIndex()
 {
     $this->fields = array(array('identifier', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('devname', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('descriptor', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('key', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('mobile', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('district', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('city', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('color', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('is_on', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)));
     /*
     $categoryFilter = Input::get('categoryFilter');
     if($categoryFilter != ''){
         $this->additional_query = array('shopcategoryLink'=>$categoryFilter, 'group_id'=>4);
     }
     */
     $db = Config::get('jayon.main_db');
     $this->def_order_by = 'identifier';
     $this->def_order_dir = 'desc';
     $this->place_action = 'first';
     $this->show_select = true;
     $this->sql_key = 'identifier';
     $this->sql_table_name = Config::get('jayon.jayon_devices_table');
     $this->sql_connection = 'mysql';
     return parent::SQLtableResponder();
 }
 public function postIndex()
 {
     $this->fields = array(array('PERIOD', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('TRANS_DATETIME', array('kind' => 'daterange', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('VCHR_NUM', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('ACCNT_CODE', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('j10_acnt.DESCR', array('kind' => 'text', 'alias' => 'ACC_DESCR', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('TREFERENCE', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('CONV_CODE', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('OTHER_AMT', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('BASE_RATE', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('AMOUNT', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('DESCRIPTN', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)));
     /*
     $categoryFilter = Input::get('categoryFilter');
     if($categoryFilter != ''){
         $this->additional_query = array('shopcategoryLink'=>$categoryFilter, 'group_id'=>4);
     }
     */
     $db = Config::get('lundin.main_db');
     $company = Input::get('acc-company');
     $company = strtolower($company);
     if (Schema::hasTable($db . '.' . $company . '_a_salfldg')) {
         $company = Config::get('lundin.default_company');
     }
     $company = strtolower($company);
     $this->def_order_by = 'TRANS_DATETIME';
     $this->def_order_dir = 'DESC';
     $this->place_action = 'none';
     $this->show_select = false;
     $this->sql_key = 'TRANS_DATETIME';
     $this->sql_table_name = $company . '_a_salfldg';
     $this->sql_connection = 'mysql2';
     return parent::SQLtableResponder();
 }