/**
* @brief 异步IO任务调度
* 主要是为了资源的安全释放和更快速的回收
* @param \Aha\Coroutine\Task $task
*/
public function asyncIoSchedule(\Aha\Coroutine\Task $task)
{
$this->schedule($task);
//这种情况下 如果只有一个任务 需要自己调度自己
if ($this->_taskQueue->count() === 1) {
$this->run();
}
}
/**
* Crea la paginacion de la pagina con respecto a la cantidad de registros
* @param type $query
* @return objeto json
*/
public function crearPaginacion($query)
{
try {
$count = $query->count();
} catch (ParseException $ex) {
return json_encode([pag => 'Error en la Base de datos', error => $ex->getMessage()]);
}
$paguinacion = $count / 10;
return json_encode([pag => $paguinacion]);
}
/**
* 获取商品分页数据
* @param type $dtparser datatable类库
*/
public function goods_page_data($dtparser)
{
$cols = $this->_goods_page_cols();
$sort_cols = array('0' => '`gift`.`ctime`', '4' => '`gift`.`store_num`');
$filter_cols = array();
//查询主表
$dtparser->select($cols, $sort_cols, $filter_cols, FALSE);
$dtparser->from($this->_goods_tb);
$dtparser->join('`gift_management`.`gift_brand`', 'gift_brand.id=gift.brand_id', 'left');
$dtparser->join('`gift_management`.`gift_classify`', 'gift_classify.id=gift.classify_id', 'left');
$dtparser->join('`gift_management`.`gift_supply`', 'gift_supply.id=gift.supply_id', 'left');
//条件
$cwhere = $this->get_goods_page_where();
$d['code'] = 0;
$d['iTotal'] = 0;
$d['iFilteredTotal'] = 0;
$d['aaData'] = array();
if ($d['code'] == 0) {
$d['iTotal'] = $dtparser->count($cwhere);
$d['iFilteredTotal'] = $d['iTotal'];
$query = $dtparser->get($cwhere);
$arr = $query->result_array();
$this->ajax_goods_list_table_data($arr);
$d['aaData'] = $arr;
}
return $d;
}
/**
* 礼品卡开卡列表
* @param type $dtparser
* @return type
*/
public function giftcard_order_list_page_data($dtparser)
{
$cols = array('`card_order`.`id`', '`card_order`.`trade_date`', '`user`.`nick_name` as `sales`', '`customer`.`name` as `customer`', '`card_order`.`contact_person`', '`card_order`.`order_name`', '`card_order`.`price`', '`card_order`.`pay_status`', '`card_order`.`pay_remark`', '`card_order`.`remark`', '`card_order`.`trade_date`', '`card_order`.`wechat_id`', '`card_order`.`custom_id`', '`card_order`.`sales_id`', '`card_order`.`end_user`', '`card_order`.`modify_user`');
$sort_cols = array('6' => '`price`');
$filter_cols = array();
//查询主表
$dtparser->select($cols, $sort_cols, $filter_cols, FALSE);
$dtparser->from($this->_card_order_tb);
$dtparser->join('`gift_management`.`user`', 'user.id=card_order.sales_id', 'left');
$dtparser->join('`gift_management`.`customer`', 'customer.id=card_order.custom_id', 'left');
//条件
$cwhere = $this->get_giftcard_order_page_where();
$d['code'] = 0;
$d['iTotal'] = 0;
$d['iFilteredTotal'] = 0;
$d['aaData'] = array();
if ($d['code'] == 0) {
$d['iTotal'] = $dtparser->count($cwhere);
$d['iFilteredTotal'] = $d['iTotal'];
$query = $dtparser->get($cwhere);
$arr = $query->result_array();
$this->ajax_list_table_data($arr);
$d['aaData'] = $arr;
}
return $d;
}
/**
* 获取客户分页数据
* @param type $dtparser datatable类库
*/
public function wechat_page_data($dtparser)
{
$cols = array('`wechat`.`id`', '`wechat`.`name`', '`wechat`.`style`', '`wechat`.`status`', '`wechat`.`vedio_id`', '`wechat`.`pic_id`', '`wechat`.`audio_id`', '`wechat`.`sender`', '`wechat`.`reciver`', '`wechat`.`remark`', '`wechat`.`copywriter`');
$sort_cols = array('4' => '`wechat`.`status`');
$filter_cols = array();
//查询主表
$dtparser->select($cols, $sort_cols, $filter_cols, FALSE);
$dtparser->from($this->_wechat_tb);
//条件
$cwhere = $this->get_wechat_page_where();
$d['code'] = 0;
$d['iTotal'] = 0;
$d['iFilteredTotal'] = 0;
$d['aaData'] = array();
if ($d['code'] == 0) {
$d['iTotal'] = $dtparser->count($cwhere);
$d['iFilteredTotal'] = $d['iTotal'];
$query = $dtparser->get($cwhere);
$arr = $query->result_array();
$this->ajax_list_table_data($arr);
$d['aaData'] = $arr;
}
return $d;
}
/**
* 获取客户分页数据
* @param type $dtparser datatable类库
*/
public function website_page_data($dtparser)
{
$cols = array('`website`.`id`', '`website`.`name`', '`website`.`status`', '`website`.`type`', '`website`.`hotline`', '`website`.`qq`', '`website`.`expire_date`', '`website`.`domain`');
$sort_cols = array('4' => '`website`.`status`');
$filter_cols = array();
//查询主表
$dtparser->select($cols, $sort_cols, $filter_cols, FALSE);
$dtparser->from($this->_website_tb);
//条件
$cwhere = $this->get_website_page_where();
$d['code'] = 0;
$d['iTotal'] = 0;
$d['iFilteredTotal'] = 0;
$d['aaData'] = array();
if ($d['code'] == 0) {
$d['iTotal'] = $dtparser->count($cwhere);
$d['iFilteredTotal'] = $d['iTotal'];
$query = $dtparser->get($cwhere);
$arr = $query->result_array();
$this->ajax_list_table_data($arr);
$d['aaData'] = $arr;
}
return $d;
}
/**
* 获取客户分页数据
* @param type $dtparser datatable类库
*/
public function customer_page_data($dtparser)
{
$cols = array('`customer`.`id`', '`customer`.`name`', '`customer`.`status`', '`customer`.`type`', '`customer`.`contact_person`', '`customer`.`phone`', '`customer`.`address`', '`customer`.`status`');
$sort_cols = array('4' => '`customer`.`status`');
$filter_cols = array();
//查询主表
$dtparser->select($cols, $sort_cols, $filter_cols, FALSE);
$dtparser->from($this->_customer_tb);
//条件
$cwhere = $this->get_customer_page_where();
$d['code'] = 0;
$d['iTotal'] = 0;
$d['iFilteredTotal'] = 0;
$d['aaData'] = array();
if ($d['code'] == 0) {
$d['iTotal'] = $dtparser->count($cwhere);
$d['iFilteredTotal'] = $d['iTotal'];
$query = $dtparser->get($cwhere);
$arr = $query->result_array();
$this->ajax_list_table_data($arr);
$d['aaData'] = $arr;
}
return $d;
}
