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();
}
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();
}
