public function index()
{
$news = Mynews::instance();
$per_page = controller_tool::per_page();
$orderby_arr = array(0 => array('id' => 'DESC'), 1 => array('id' => 'ASC'), 2 => array('order' => 'ASC'), 3 => array('order' => 'DESC'));
$orderby = controller_tool::orderby($orderby_arr);
$query_struct = array('where' => array(), 'orderby' => $orderby, 'limit' => array('per_page' => $per_page, 'offset' => 0));
$total = $news->count_site_news();
$this->pagination = new Pagination(array('base_url' => url::current(), 'uri_segment' => 'page', 'total_items' => $total, 'items_per_page' => $per_page, 'style' => 'digg'));
$query_struct['limit']['offset'] = $this->pagination->sql_offset;
$news = Mynews::instance()->lists($query_struct);
$categorys = array();
foreach ($news as $row) {
$categorys[$row['classid']] = $row['classid'];
}
foreach ($categorys as $v) {
$str = '';
$aa = array('where' => array('id' => $v), 'like' => array(), 'limit' => array());
$categories = Mynews_category::instance()->list_news_categories($aa);
if (count($categories)) {
$str = $categories[0]['category_name'];
if ($categories[0]['parent_id'] > 0) {
$aa = array('where' => array('id' => $categories[0]['parent_id']), 'like' => array(), 'limit' => array());
$cate = Mynews_category::instance()->list_news_categories($aa);
$str = $cate[0]['category_name'] . ' > ' . $str;
}
}
$categorys[$v] = $str;
}
$this->template->content = new View("site/news_list");
$this->template->content->data = $news;
$this->template->content->categorys = $categorys;
$this->template->content->title = "site news list";
}
public function index($status = NULL)
{
//权限检查 得到所有可管理站点ID列表
role::check('contact_us');
$this->template->content = new View("user/contact_us_list");
//搜索功能
$search_arr = array('id', 'email', 'name', 'message', 'ip');
$where = array();
$where_view = array();
if ($search_arr) {
foreach ($search_arr as $search_value) {
if ($this->input->get('search_type') == $search_value && strlen($this->input->get('search_value'))) {
$where[$search_value] = $this->input->get('search_value');
if ($search_value == 'ip') {
$where[$search_value] = tool::myip2long($this->input->get('search_value'));
}
}
}
$where_view['search_type'] = $this->input->get('search_type');
$where_view['search_value'] = $this->input->get('search_value');
}
//列表排序
$orderby_arr = array(0 => array('id' => 'DESC'), 1 => array('id' => 'ASC'), 2 => array('id' => 'ASC'), 3 => array('id' => 'DESC'), 4 => array('email' => 'ASC'), 5 => array('email' => 'DESC'), 6 => array('name' => 'ASC'), 7 => array('name' => 'DESC'), 8 => array('message' => 'ASC'), 9 => array('message' => 'DESC'), 10 => array('date_add' => 'ASC'), 11 => array('date_add' => 'DESC'), 12 => array('ip' => 'ASC'), 13 => array('ip' => 'DESC'));
$orderby = controller_tool::orderby($orderby_arr);
//每页显示条数
$per_page = controller_tool::per_page();
//调用分页
if (isset($status) && $status == 'active') {
$where['active'] = 1;
}
$this->pagination = new Pagination(array('total_items' => Mycontact_us::instance()->count($where), 'items_per_page' => $per_page));
//调用列表
$this->template->content->contact_us_list = Mycontact_us::instance()->contact_uses($where, $orderby, $per_page, $this->pagination->sql_offset);
$this->template->content->where = $where_view;
}
/**
* 数据列表
*/
public function index()
{
role::check('product_attribute');
$return_struct = array('status' => 0, 'code' => 501, 'msg' => 'Not Implemented', 'content' => array());
try {
//$profiler = new Profiler;
//* 初始化返回数据 */
$return_data = array();
//* 收集请求数据 ==根据业务逻辑定制== */
$request_data = $this->input->get();
// 执行业务逻辑
//* 初始化默认查询结构体 */
$query_struct_default = array('where' => array('apply' => self::ATTRIBUTE_TYPE), 'orderby' => array('id' => 'DESC'), 'limit' => array('per_page' => 20, 'page' => 1));
//* 初始化当前查询结构体 */
$query_struct_current = array();
//* 设置合并默认查询条件到当前查询结构体 */
$query_struct_current = array_merge($query_struct_current, $query_struct_default);
//列表排序
$orderby_arr = array(0 => array('id' => 'DESC'), 1 => array('id' => 'ASC'), 2 => array('name' => 'ASC'), 3 => array('name' => 'DESC'), 4 => array('order' => 'ASC'), 5 => array('order' => 'DESC'));
$orderby = controller_tool::orderby($orderby_arr);
// 排序处理
if (isset($request_data['orderby']) && is_numeric($request_data['orderby'])) {
$query_struct_current['orderby'] = $orderby;
}
// 每页条目数
controller_tool::request_per_page($query_struct_current, $request_data);
//调用服务执行查询
$attribute_service = AttributeService::get_instance();
$count = $attribute_service->count($query_struct_current);
// 模板输出 分页
$this->pagination = new Pagination(array('total_items' => $count, 'items_per_page' => $query_struct_current['limit']['per_page']));
$query_struct_current['limit']['page'] = $this->pagination->current_page;
$return_data['list'] = $attribute_service->get_attribute_options($query_struct_current);
//* 补充&修改返回结构体 */
$return_struct['status'] = 1;
$return_struct['code'] = 200;
$return_struct['msg'] = '';
$return_struct['content'] = $return_data;
//* 请求类型 */
if ($this->is_ajax_request()) {
// ajax 请求
// json 输出
$this->template->content = $return_struct;
} else {
// html 输出
//* 模板输出 */
$content = new View('product/' . $this->class_name . '/' . __FUNCTION__);
//* 变量绑定 */
$this->template->title = '规格管理';
$this->template->content = $content;
//* 请求结构数据绑定 */
$this->template->content->request_data = $request_data;
//* 返回结构体绑定 */
$this->template->content->return_struct = $return_struct;
}
// end of request type determine
} catch (MyRuntimeException $ex) {
$this->_ex($ex, $request_data, $return_struct);
}
}
/**
* 数据列表
*/
public function index()
{
role::check('product_rush');
$return_struct = array('status' => 0, 'code' => 501, 'msg' => 'Not Implemented', 'content' => array());
try {
//* 初始化返回数据 */
$return_data = $rid = array();
//* 收集请求数据 ==根据业务逻辑定制== */
$request_data = $this->input->get();
// 执行业务逻辑
//* 初始化默认查询结构体 */
$query_struct_current = array('where' => array(), 'like' => array(), 'orderby' => array('id' => 'DESC'), 'limit' => array('per_page' => 20, 'page' => 1));
//列表排序
$orderby_arr = array(0 => array('id' => 'DESC'), 1 => array('id' => 'ASC'), 2 => array('title' => 'ASC'), 3 => array('title' => 'DESC'), 4 => array('start_time' => 'ASC'), 5 => array('end_time' => 'DESC'), 6 => array('position' => 'DESC'), 7 => array('position' => 'ASC'));
$orderby = controller_tool::orderby($orderby_arr);
// 排序处理
if (isset($request_data['orderby']) && is_numeric($request_data['orderby'])) {
$query_struct_current['orderby'] = $orderby;
}
// 每页条目数
controller_tool::request_per_page($query_struct_current, $request_data);
//调用服务执行查询
$product_rush_service = Product_rushService::get_instance();
$count = $product_rush_service->count($query_struct_current);
// 模板输出 分页
$this->pagination = new Pagination(array('total_items' => $count, 'items_per_page' => $query_struct_current['limit']['per_page']));
$query_struct_current['limit']['page'] = $this->pagination->current_page;
$return_data['list'] = $product_rush_service->index($query_struct_current);
foreach ($return_data['list'] as $pd) {
$rid[$pd['product_id']] = true;
}
//* 补充&修改返回结构体 */
$return_struct['status'] = 1;
$return_struct['code'] = 200;
$return_struct['msg'] = '';
$return_struct['content'] = $return_data;
//* 请求类型 */
if ($this->is_ajax_request()) {
// ajax 请求
// json 输出
$this->template->content = $return_struct;
} else {
// html 输出
//* 模板输出 */
$content = new View('product/' . $this->class_name . '/' . __FUNCTION__, array('rid' => $rid));
//* 变量绑定 */
$this->template->title = '抢购商品管理';
$this->template->content = $content;
//* 请求结构数据绑定 */
$this->template->content->request_data = $request_data;
//* 返回结构体绑定 */
$this->template->content->return_struct = $return_struct;
}
// end of request type determine
} catch (MyRuntimeException $ex) {
$this->_ex($ex, $return_struct, $request_data);
}
}
public function index()
{
$user_query_struct = array('where' => array(), 'like' => array(), 'orderby' => array(), 'limit' => array('per_page' => 20, 'offset' => 0));
/* 搜索功能 */
$search_arr = array('id', 'email', 'firstname', 'lastname', 'ip', 'mobile', 'real_name');
$search_value = $this->input->get('search_value');
$search_type = $this->input->get('search_type');
$where_view = array();
if ($search_arr) {
foreach ($search_arr as $value) {
if ($search_type == $value && strlen($search_value) > 0) {
$user_query_struct['like'][$value] = $search_value;
//$user_query_struct['where'][$value] = $search_value;
if ($value == 'ip') {
$user_query_struct['like'][$value] = tool::myip2long($search_value);
//$user_query_struct['where'][$value] = tool::myip2long($search_value);
}
}
}
$where_view['search_type'] = $search_type;
$where_view['search_value'] = $search_value;
}
/* 列表排序 */
$orderby_arr = array(0 => array('id' => 'DESC'), 1 => array('id' => 'ASC'), 4 => array('email' => 'ASC'), 5 => array('email' => 'DESC'), 6 => array('firstname' => 'ASC'), 7 => array('firstname' => 'DESC'), 8 => array('lastname' => 'ASC'), 9 => array('lastname' => 'DESC'), 10 => array('date_add' => 'ASC'), 11 => array('date_add' => 'DESC'), 12 => array('ip' => 'ASC'), 13 => array('ip' => 'DESC'), 14 => array('active' => 'ASC'), 15 => array('active' => 'DESC'), 16 => array('register_mail_active' => 'ASC'), 17 => array('register_mail_active' => 'DESC'));
$orderby = controller_tool::orderby($orderby_arr);
$user_query_struct['orderby'] = $orderby;
/* 每页显示条数 */
$per_page = controller_tool::per_page();
$user_query_struct['limit']['per_page'] = $per_page;
/* 调用分页 */
$this->pagination = new Pagination(array('total_items' => Myuser::instance()->query_count($user_query_struct), 'items_per_page' => $per_page));
$user_query_struct['limit']['offset'] = $this->pagination->sql_offset;
$user_list = Myuser::instance()->query_assoc($user_query_struct);
//找出所有的站点的用户等级信息
$user_levelservice = User_levelService::get_instance();
$query_struct = array('where' => array('active' => 1));
$user_levels = $user_levelservice->index($query_struct);
$tmp = array();
foreach ($user_levels as $user_level) {
if ($user_level['is_default']) {
$tmp['default'] = $user_level;
}
$tmp[$user_level['id']] = $user_level;
}
$user_levels = $tmp;
foreach ($user_list as $key => $value) {
$users[$key]['level'] = '';
if (!empty($user_levels[$value['level_id']])) {
$users[$key]['level'] = $user_levels[$value['level_id']]['name_manage'];
} else {
//$users[$key]['level'] = $user_levels['default']['name_manage'];
}
}
$this->template->content = new View("superplaner/agent_select_list");
$this->template->content->where = $where_view;
$this->template->content->user_list = $user_list;
}
/**
* 页面分类列表
*/
public function index()
{
$list_columns = array(array('name' => '名称', 'column' => 'category_name', 'class_num' => '200'));
$orderby_arr = array(0 => array('id' => 'ASC'), 1 => array('id' => 'DESC'), 2 => array('p_order' => 'ASC'), 3 => array('p_order' => 'DESC'));
$orderby = controller_tool::orderby($orderby_arr);
$query_struct = array('where' => array('parent_id' => 0), 'like' => array(), 'orderby' => $orderby, 'limit' => array('per_page' => controller_tool::per_page(), 'offset' => 0));
$categories = Mydoc_category::instance()->list_doc_categories($query_struct);
$this->template->content = new View("site/doc_category_list");
$this->template->content->list_columns = $list_columns;
$this->template->content->categories = $categories;
}
public function index()
{
role::check('card_system_manage');
$query_condition = array();
$query_condition['beginNum'] = null;
$query_condition['endNum'] = null;
$query_condition['selectKey'] = null;
$query_condition['selectValue'] = null;
$per_page = controller_tool::per_page();
$orderby_arr = array(0 => array('id' => 'ASC'), 1 => array('id' => 'DESC'), 2 => array('order' => 'ASC'), 3 => array('order' => 'DESC'));
$orderby = controller_tool::orderby($orderby_arr);
$query_struct = array('where' => array(), 'orderby' => $orderby, 'limit' => array('per_page' => $per_page, 'offset' => 0));
if ($_GET) {
if (!empty($_GET['beginNum']) && !empty($_GET['endNum'])) {
$query_condition['beginNum'] = $_GET['beginNum'];
$query_condition['endNum'] = $_GET['endNum'];
$query_struct['where']['mgrnum >='] = $_GET['beginNum'];
$query_struct['where']['mgrnum <='] = $_GET['endNum'];
}
if (isset($_GET['selectValue']) && !empty($_GET['selectValue'])) {
$query_condition['selectKey'] = $_GET['selectKey'];
$query_condition['selectValue'] = $_GET['selectValue'];
if ($query_condition['selectKey'] == 'mgrNum') {
$query_struct['where']['mgrnum'] = $_GET['selectValue'];
} else {
if ($query_condition['selectKey'] == 'serialCode') {
$query_struct['where']['cardserialcode'] = $_GET['selectValue'];
} else {
if ($query_condition['selectKey'] == 'issueId') {
$query_struct['where']['issueid'] = $_GET['selectValue'];
} else {
if ($query_condition['selectKey'] == 'openId') {
$query_struct['where']['openid'] = $_GET['selectValue'];
} else {
if ($query_condition['selectKey'] == 'flag') {
$query_struct['where']['flag'] = $_GET['selectValue'];
}
}
}
}
}
}
}
$total = $this->cardDao->count_items_with_condition($query_struct['where']);
$this->pagination = new Pagination(array('base_url' => url::current(), 'uri_segment' => 'page', 'total_items' => $total, 'items_per_page' => $per_page, 'style' => 'digg'));
$query_struct['limit']['offset'] = $this->pagination->sql_offset;
$cardList = $this->cardDao->lists($query_struct);
$this->template->content = new View("card/card_list");
$this->template->content->data = $cardList;
$this->template->content->query_condition = $query_condition;
$this->template->content->selectMap = $this->selectMap;
}
public function index()
{
$orderby_arr = array(0 => array('id' => 'DESC'), 1 => array('id' => 'ASC'), 2 => array('order' => 'ASC'), 3 => array('order' => 'DESC'));
$orderby = controller_tool::orderby($orderby_arr);
// 初始化默认查询条件
$query_struct = array('where' => array(), 'orderby' => $orderby);
$link = Mysite_link::instance();
$links = $link->lists($query_struct);
$total = $link->count($query_struct);
$this->template->content = new View("site/link_list");
$this->template->content->data = $links;
$this->template->content->total = $total;
}
public function index()
{
$agentDao = Superplaner::instance();
$per_page = controller_tool::per_page();
$orderby_arr = array(0 => array('id' => 'DESC'), 1 => array('id' => 'ASC'), 2 => array('order' => 'ASC'), 3 => array('order' => 'DESC'));
$orderby = controller_tool::orderby($orderby_arr);
$query_struct = array('where' => array(), 'orderby' => $orderby, 'limit' => array('per_page' => $per_page, 'offset' => 0));
$total = $agentDao->count_agents();
$this->pagination = new Pagination(array('base_url' => url::current(), 'uri_segment' => 'page', 'total_items' => $total, 'items_per_page' => $per_page, 'style' => 'digg'));
$query_struct['limit']['offset'] = $this->pagination->sql_offset;
$agentList = $agentDao->lists($query_struct);
$this->template->content = new View("superplaner/agent_list");
$this->template->content->data = $agentList;
}
public function index()
{
role::check('card_system_manage');
$per_page = controller_tool::per_page();
$orderby_arr = array(0 => array('id' => 'DESC'), 1 => array('id' => 'ASC'), 2 => array('order' => 'ASC'), 3 => array('order' => 'DESC'));
$orderby = controller_tool::orderby($orderby_arr);
$query_struct = array('where' => array(), 'orderby' => $orderby, 'limit' => array('per_page' => $per_page, 'offset' => 0));
$total = $this->moneyExchangeDao->count_items_with_condition($query_struct['where']);
$this->pagination = new Pagination(array('base_url' => url::current(), 'uri_segment' => 'page', 'total_items' => $total, 'items_per_page' => $per_page, 'style' => 'digg'));
$query_struct['limit']['offset'] = $this->pagination->sql_offset;
$moneyExchangeList = $this->moneyExchangeDao->lists($query_struct);
$this->template->content = new View("card/money_exchange_list");
$this->template->content->data = $moneyExchangeList;
}
public function index()
{
$settlerealtimerptDao = Superplaner_settlerealtimerpt::instance();
$agent_type = Kohana::config('settle.agent_type');
$isbeidan = Kohana::config('settle.isbeidan');
$per_page = controller_tool::per_page();
$orderby_arr = array(0 => array('id' => 'DESC'), 1 => array('id' => 'ASC'), 2 => array('order' => 'ASC'), 3 => array('order' => 'DESC'));
$orderby = controller_tool::orderby($orderby_arr);
$query_struct = array('where' => array(), 'orderby' => $orderby, 'limit' => array('per_page' => $per_page, 'offset' => 0));
/**
* 搜索
*/
$search_arr = array('type', 'agent_type', 'isbeidan', 'date_begin', 'date_end', 'user_id', 'lastname');
foreach ($this->input->get() as $key => $value) {
if (in_array($key, $search_arr)) {
if ($key == 'date_begin') {
$query_struct['where']["settletime >"] = $value . ' 00:00:00';
} elseif ($key == 'date_end') {
$query_struct['where']["settletime <"] = $value . ' 24:00:00';
} elseif ($key == 'isbeidan' && !empty($value)) {
$query_struct['where']["type"] = $value - 1;
} elseif ($key == 'agent_type' && !empty($value)) {
$query_struct['where']["agent_type"] = $value - 1;
} elseif (!empty($value)) {
$query_struct['where'][$key] = $value;
}
}
}
$total = $settlerealtimerptDao->count_itmes();
$this->pagination = new Pagination(array('base_url' => url::current(), 'uri_segment' => 'page', 'total_items' => $total, 'items_per_page' => $per_page, 'style' => 'digg'));
$query_struct['limit']['offset'] = $this->pagination->sql_offset;
// $dataList = Superplaner_settlerealtimerpt::instance()->lists($query_struct);
$dataList = Superplaner_settlerealtimerpt::instance()->mylists($query_struct);
foreach ($dataList as $key => $value) {
$dataList[$key]['agent_type'] = $agent_type[$value['agent_type']];
$dataList[$key]['type'] = $isbeidan[$value['type']];
foreach ($value as $k => $v) {
if (!is_numeric($v) && empty($v)) {
$dataList[$key][$k] = '无';
}
}
}
$this->template->content = new View("superplaner/settle_realtime_rpt");
$this->template->content->data = $dataList;
$this->template->content->agent_type = $agent_type;
$this->template->content->isbeidan = $isbeidan;
$this->template->content->today = date("Y-m-d", time());
$this->template->content->yesterday = date("Y-m-d", time() - 24 * 3600);
}
public function index()
{
$settlemonthrptdtlDao = Mysettlemonthrptdtl::instance();
$ticket_type = Kohana::config('ticket_type.type');
$per_page = controller_tool::per_page();
$orderby_arr = array(0 => array('id' => 'DESC'), 1 => array('id' => 'ASC'), 2 => array('order' => 'ASC'), 3 => array('order' => 'DESC'));
$orderby = controller_tool::orderby($orderby_arr);
$query_struct = array('where' => array(), 'orderby' => $orderby, 'limit' => array('per_page' => $per_page, 'offset' => 0));
/**
* 搜索
*/
$search_arr = array('ticket_type', 'date_begin', 'date_end', 'agentid', 'user_id', 'agentlastname', 'masterid');
foreach ($this->input->get() as $key => $value) {
if (in_array($key, $search_arr)) {
if ($key == 'date_begin') {
$query_struct['where']["settletime >"] = $value . ' 00:00:00';
} elseif ($key == 'date_end') {
$query_struct['where']["settletime <"] = $value . ' 24:00:00';
} elseif ($key == 'agentlastname' && !empty($value)) {
$query_struct['where']["agent.lastname ="] = $value;
} elseif (!empty($value)) {
$query_struct['where'][$key] = $value;
}
}
}
$total = $settlemonthrptdtlDao->count_itmes();
$this->pagination = new Pagination(array('base_url' => url::current(), 'uri_segment' => 'page', 'total_items' => $total, 'items_per_page' => $per_page, 'style' => 'digg'));
$query_struct['limit']['offset'] = $this->pagination->sql_offset;
// $dataList = Mysettlemonthrptdtl::instance()->lists($query_struct);
$dataList = Mysettlemonthrptdtl::instance()->mylists($query_struct);
foreach ($dataList as $key => $value) {
$dataList[$key]['urlbase'] = $this->getUrlBaseByTicketType($dataList[$key]['ticket_type']);
if ($value['ticket_type'] != 0 && $value['ticket_type'] != 99) {
$dataList[$key]['ticket_type'] = $ticket_type[$value['ticket_type']];
} else {
$dataList[$key]['ticket_type'] = '';
}
foreach ($value as $k => $v) {
if (!is_numeric($v) && empty($v)) {
$dataList[$key][$k] = '无';
}
}
}
$this->template->content = new View("distribution/settle_month_dtl_rpt");
$this->template->content->data = $dataList;
$this->template->content->ticket_type = $ticket_type;
$this->template->content->today = date("Y-m-d", time());
$this->template->content->yesterday = date("Y-m-d", time() - 24 * 3600);
}
public function index()
{
/* 初始化默认查询条件 */
$newsletter_query_struct = array('where' => array('user_id' => 0), 'like' => array(), 'orderby' => array(), 'limit' => array('per_page' => 20, 'offset' => 0));
/* 权限检查 得到所有可管理站点ID列表 */
$site_id_list = role::check('newsletter');
/* Newsletter列表模板 */
$this->template->content = new View("user/newsletter");
/* 搜索功能 */
$search_arr = array('email', 'ip');
$search_value = $this->input->get('search_value');
$search_type = $this->input->get('search_type');
$where_view = array();
if ($search_arr) {
foreach ($search_arr as $value) {
if ($search_type == $value && strlen($search_value) > 0) {
$newsletter_query_struct['where'][$value] = $search_value;
if ($value == 'ip') {
$newsletter_query_struct['where'][$value] = tool::myip2long($search_value);
}
}
}
$where_view['search_type'] = $search_type;
$where_view['search_value'] = $search_value;
}
//当前切入的站点查询条件
$site_in = site::current_query_site_ids();
$where_view['site_id'] = '';
$newsletter_query_struct['where']['site_id'] = $site_in;
/* 列表排序 */
$orderby_arr = array(0 => array('id' => 'DESC'), 1 => array('id' => 'ASC'), 2 => array('site_id' => 'ASC'), 3 => array('site_id' => 'DESC'), 4 => array('email' => 'ASC'), 5 => array('email' => 'DESC'), 6 => array('date_add' => 'ASC'), 7 => array('date_add' => 'DESC'), 8 => array('ip' => 'ASC'), 9 => array('ip' => 'DESC'), 10 => array('active' => 'ASC'), 11 => array('active' => 'DESC'));
$orderby = controller_tool::orderby($orderby_arr);
$newsletter_query_struct['orderby'] = $orderby;
/* 每页显示条数 */
$per_page = controller_tool::per_page();
$newsletter_query_struct['limit']['per_page'] = $per_page;
/* 调用分页 */
$this->pagination = new Pagination(array('total_items' => Mynewsletter::instance()->query_count($newsletter_query_struct), 'items_per_page' => $per_page));
$newsletter_query_struct['limit']['offset'] = $this->pagination->sql_offset;
$newsletters = Mynewsletter::instance()->query_assoc($newsletter_query_struct);
foreach ($newsletters as $key => $value) {
$site = Mysite::instance($value['site_id'])->get();
$newsletters[$key]['site'] = $site;
}
/* 调用列表 */
$this->template->content->newsletter_list = $newsletters;
/* 搜索信息保存 */
$this->template->content->where = $where_view;
}
public function index()
{
$per_page = controller_tool::per_page();
//列表排序
$orderby_arr = array(0 => array('id' => 'DESC'), 1 => array('id' => 'ASC'), 2 => array('order' => 'ASC'), 3 => array('order' => 'DESC'));
$orderby = controller_tool::orderby($orderby_arr);
// 初始化默认查询条件
$query_struct = array('where' => array(), 'like' => array(), 'orderby' => $orderby, 'limit' => array('per_page' => $per_page, 'offset' => 0));
$faq = Myfaq::instance();
$total = $faq->count($query_struct);
$this->pagination = new Pagination(array('base_url' => url::current(), 'uri_segment' => 'page', 'total_items' => $total, 'items_per_page' => $per_page, 'style' => 'digg'));
$faqs = $faq->lists($query_struct);
$this->template->content = new View("site/faq_list");
$this->template->content->data = $faqs;
$this->template->content->title = "site faq list";
}
public function index()
{
// 初始化默认查询条件
$orderby_arr = array(0 => array('id' => 'DESC'), 1 => array('id' => 'ASC'), 2 => array('order' => 'ASC'), 3 => array('order' => 'DESC'), 4 => array('parent_id' => 'ASC'), 5 => array('parent_id' => 'DESC'), 6 => array('memo' => 'ASC'), 7 => array('memo' => 'DESC'));
$orderby = controller_tool::orderby($orderby_arr);
$query_struct = array('where' => array(), 'orderby' => $orderby);
$site_menu = Mysite_menu::instance();
$total = $site_menu->count($query_struct);
$site_menus = $site_menu->lists($query_struct);
$data = $site_menus;
foreach ($site_menus as $key => $val) {
$data[$key]['parent_name'] = Mysite_menu::instance($val['parent_id'])->get('name');
}
$this->template->content = new View("site/site_menu_list");
$this->template->content->data = $data;
$this->template->content->total = $total;
}
/**
* 菜单列表
*/
public function index()
{
$orderby_arr = array(0 => array('order' => 'DESC'), 1 => array('order' => 'ASC'));
$orderby = controller_tool::orderby($orderby_arr);
$this->template->content = new View("manage/menu_list");
$menus = Mymenu::instance()->menus(0, $orderby);
foreach ($menus as $key => $value) {
$menus[$key]['action_name'] = Myaction::instance($value['action_id'])->get('name');
}
foreach ($menus as $key => $value) {
foreach ($value as $k => $v) {
if (!is_numeric($v) && empty($v)) {
$menus[$key][$k] = 'NULL';
}
}
}
$this->template->content->menus = $menus;
}
public function index()
{
$settlemonthrptDao = Mysettlelog::instance();
$settlecls = Kohana::config('settle.settlecls');
$per_page = controller_tool::per_page();
$orderby_arr = array(0 => array('id' => 'DESC'), 1 => array('id' => 'ASC'), 2 => array('order' => 'ASC'), 3 => array('order' => 'DESC'));
$orderby = controller_tool::orderby($orderby_arr);
$query_struct = array('where' => array(), 'orderby' => $orderby, 'limit' => array('per_page' => $per_page, 'offset' => 0));
/**
* 搜索
*/
$search_arr = array('settlecls', 'date_begin', 'date_end');
foreach ($this->input->get() as $key => $value) {
if (in_array($key, $search_arr)) {
if ($key == 'date_begin') {
$query_struct['where']["date_add >"] = $value . ' 00:00:00';
} elseif ($key == 'date_end') {
$query_struct['where']["date_add <"] = $value . ' 24:00:00';
} elseif ($key == 'settlecls' && !empty($value)) {
$query_struct['like']["actname"] = $value;
} elseif (!empty($value)) {
$query_struct['where'][$key] = $value;
}
}
}
$total = $settlemonthrptDao->count_itmes();
$this->pagination = new Pagination(array('base_url' => url::current(), 'uri_segment' => 'page', 'total_items' => $total, 'items_per_page' => $per_page, 'style' => 'digg'));
$query_struct['limit']['offset'] = $this->pagination->sql_offset;
$dataList = Mysettlelog::instance()->lists($query_struct);
foreach ($dataList as $key => $value) {
$dataList[$key]['actname'] = $settlecls[$value['actname']];
foreach ($value as $k => $v) {
if (!is_numeric($v) && empty($v)) {
$dataList[$key][$k] = '无';
}
}
}
$this->template->content = new View("distribution/settle_log");
$this->template->content->data = $dataList;
$this->template->content->settlecls = $settlecls;
$this->template->content->today = date("Y-m-d", time());
$this->template->content->yesterday = date("Y-m-d", time() - 24 * 3600);
}
public function index()
{
//权限验证
role::check('manage_payment_type');
$this->template->content = new View("manage/payment_type_list");
//搜索功能
$search_arr = array('id');
$where = array();
$where_view = array();
//列表排序
$orderby_arr = array(0 => array('id' => 'DESC'), 1 => array('id' => 'ASC'), 2 => array('name' => 'ASC'), 3 => array('name' => 'DESC'), 4 => array('image_url' => 'ASC'), 5 => array('image_url' => 'DESC'), 6 => array('driver' => 'ASC'), 7 => array('driver' => 'DESC'), 8 => array('submit_url' => 'ASC'), 9 => array('submit_url' => 'DESC'));
$orderby = controller_tool::orderby($orderby_arr);
//每页显示条数
$per_page = 100;
//调用分页
$this->pagination = new Pagination(array('total_items' => 100, 'items_per_page' => $per_page));
//调用列表
$this->template->content->payment_type_list = Mypayment_type::instance()->payment_types($where, $orderby, $per_page, $this->pagination->sql_offset);
}
public function index($userId)
{
//权限验证
role::check('distribution_system_manage');
if (!$userId) {
remind::set(Kohana::lang('o_global.bad_request'), request::referrer(), 'error');
}
$aUser = $this->userDao->get_by_id($userId);
$aAgent = $this->agentDao->get_by_user_id($userId);
if ($aAgent == null) {
remind::set(Kohana::lang('o_agent.agent_not_exists'), request::referrer(), 'error');
return;
}
//排序
$per_page = controller_tool::per_page();
$orderby_arr = array(0 => array('id' => 'DESC'), 1 => array('id' => 'ASC'), 2 => array('order' => 'ASC'), 3 => array('order' => 'DESC'));
$orderby = controller_tool::orderby($orderby_arr);
$query_struct = array('where' => array(), 'orderby' => $orderby, 'limit' => array('per_page' => $per_page, 'offset' => 0));
$query_struct['where']['agentid'] = $aAgent['user_id'];
//搜索
$search_arr = array('users.lastname', 'users.real_name', 'users.email', 'users.mobile', 'users.ip');
$searchBox = array('search_key' => null, 'search_value' => null);
$searchBox['search_key'] = $this->input->get('search_key');
$searchBox['search_value'] = $this->input->get('search_value');
if (in_array($searchBox['search_key'], $search_arr)) {
if ($searchBox['search_key'] == 'ip') {
$query_struct['like'][$value] = tool::myip2long($value);
} elseif (!empty($searchBox['search_value'])) {
// $query_struct['where'][$key] = $value;
$query_struct['like'][$searchBox['search_key']] = $searchBox['search_value'];
}
}
$total = $this->relationDao->count_agent_client($aAgent['user_id']);
$this->pagination = new Pagination(array('base_url' => url::current(), 'uri_segment' => 'page', 'total_items' => $total, 'items_per_page' => $per_page, 'style' => 'digg'));
$query_struct['limit']['offset'] = $this->pagination->sql_offset;
$dataList = $this->relationDao->mylists($query_struct);
$this->template->content = new View("distribution/agent_client_list");
$this->template->content->theUser = $aUser;
$this->template->content->theAgent = $aAgent;
$this->template->content->searchBox = $searchBox;
$this->template->content->dataList = $dataList;
}
public function index()
{
//权限验证
role::check('manage_payment');
$this->template->content = new View("manage/payment_list");
//搜索功能
$search_arr = array('id');
$where = array();
$where_view = array();
$where['manager_id'] = role::root_manager_id();
//列表排序
$orderby_arr = array(0 => array('id' => 'DESC'), 1 => array('id' => 'ASC'), 2 => array('payment_type_id' => 'ASC'), 3 => array('payment_type_id' => 'DESC'), 4 => array('account' => 'ASC'), 5 => array('account' => 'DESC'), 6 => array('position' => 'ASC'), 7 => array('position' => 'DESC'), 8 => array('active' => 'ASC'), 9 => array('active' => 'DESC'));
$orderby = controller_tool::orderby($orderby_arr);
//每页显示条数
$per_page = controller_tool::per_page();
//调用分页
$this->pagination = new Pagination(array('total_items' => Mypayment::instance()->count($where), 'items_per_page' => $per_page));
//调用列表
$this->template->content->payment_list = Mypayment::instance()->payments($where, $orderby, $per_page, $this->pagination->sql_offset);
}
public function index()
{
$per_page = controller_tool::per_page();
$orderby_arr = array(0 => array('id' => 'DESC'), 1 => array('id' => 'ASC'), 2 => array('order' => 'ASC'), 3 => array('order' => 'DESC'));
$orderby = controller_tool::orderby($orderby_arr);
$query_struct = array('where' => array(), 'orderby' => $orderby, 'limit' => array('per_page' => $per_page, 'offset' => 0));
$total = $this->agentDao->count_agents();
$this->pagination = new Pagination(array('base_url' => url::current(), 'uri_segment' => 'page', 'total_items' => $total, 'items_per_page' => $per_page, 'style' => 'digg'));
$query_struct['limit']['offset'] = $this->pagination->sql_offset;
$agentList = $this->agentDao->lists($query_struct);
foreach ($agentList as $index => $aAgent) {
if ($aAgent['agent_type'] == 12) {
$relationQuery = array('user_id' => $aAgent['user_id']);
$theRelationList = $this->relationDao->lists($relationQuery);
$agentList[$index]['relation'] = $theRelationList[0];
}
}
$this->template->content = new View("distribution/agent_list");
$this->template->content->data = $agentList;
}
public function index()
{
// 初始化国家结构体
$country_query_struct = array('where' => array(), 'orderby' => array('id' => 'DESC'));
$this->template->content = new View("site/country_manage_list");
//列表排序
$orderby_arr = array(0 => array('id' => 'DESC'), 1 => array('id' => 'ASC'), 2 => array('iso_code' => 'ASC'), 3 => array('iso_code' => 'DESC'), 4 => array('name' => 'ASC'), 5 => array('name' => 'DESC'), 6 => array('name_manage' => 'ASC'), 7 => array('name_manage' => 'DESC'), 8 => array('position' => 'ASC'), 9 => array('position' => 'DESC'));
$orderby = controller_tool::orderby($orderby_arr);
if (isset($orderby) && !empty($orderby)) {
$country_query_struct['orderby'] = $orderby;
}
//每页显示条数
$per_page = controller_tool::per_page();
$country_query_struct['limit']['per_page'] = $per_page;
//调用分页
$this->pagination = new Pagination(array('total_items' => Mycountry::instance()->query_count($country_query_struct), 'items_per_page' => $per_page));
$country_query_struct['limit']['offset'] = $this->pagination->sql_offset;
//调用列表
$this->template->content->country_list = Mycountry::instance()->query_assoc($country_query_struct);
}
/**
* 商户留言列表
*/
public function index()
{
$request_data = $this->input->get();
$message_service = MessageService::get_instance();
$true = FALSE;
//判断用户的角色是不是管理员
if ($this->manager_is_admin == 1) {
$true = TRUE;
}
//初始化请求结构体
$query_struct = array('where' => array(), 'like' => array(), 'orderby' => array('id' => 'DESC'), 'limit' => array('per_page' => 20, 'offset' => 0));
if ($true != TRUE) {
$query_struct['where']['manager_id'] = $this->manager_id;
}
//列表排序
$orderby_arr = array(0 => array('id' => 'DESC'), 1 => array('id' => 'ASC'), 2 => array('manager_id' => 'ASC'), 3 => array('manager_id' => 'DESC'), 4 => array('status' => 'ASC'), 5 => array('status' => 'DESC'), 6 => array('title' => 'ASC'), 7 => array('title' => 'DESC'), 8 => array('email' => 'ASC'), 9 => array('email' => 'DESC'), 10 => array('create_timestamp' => 'ASC'), 11 => array('create_timestamp' => 'DESC'), 12 => array('ip' => 'ASC'), 13 => array('ip' => 'DESC'), 14 => array('is_reply' => 'ASC'), 15 => array('is_reply' => 'DESC'));
// 排序处理
$orderby = controller_tool::orderby($orderby_arr);
if (isset($orderby) && !empty($orderby)) {
$query_struct['orderby'] = $orderby;
}
// 每页条目数
controller_tool::request_per_page($query_struct, $request_data);
$count = $message_service->query_count($query_struct);
// 模板输出 分页
$this->pagination = new Pagination(array('total_items' => $count, 'items_per_page' => $query_struct['limit']['per_page']));
$query_struct['limit']['offset'] = $this->pagination->sql_offset;
$query_struct['limit']['page'] = $this->pagination->current_page;
if ($true === TRUE) {
$messages = $message_service->messages($query_struct);
$this->template->content = new View("manage/message_manage_list");
$this->template->content->messages = $messages;
$this->template->content->count = $count;
} else {
$messages = $message_service->get_message_reply_by_site_manage_role($query_struct);
$this->template->content = new View("manage/message_list");
$this->template->content->messages = $messages;
$this->template->content->count = $count;
}
}
public function user_handsel_list($id = '')
{
$per_page = controller_tool::per_page();
//列表排序
$orderby_arr = array(0 => array('id' => 'DESC'), 1 => array('id' => 'ASC'), 2 => array('order' => 'ASC'), 3 => array('order' => 'DESC'));
$orderby = controller_tool::orderby($orderby_arr);
/* 初始化默认查询条件 */
if (empty($id)) {
$user_query_struct = array('where' => array('check_status' => 2), 'orderby' => $orderby, 'limit' => array('per_page' => $per_page, 'offset' => 0));
} else {
$user_query_struct = array('where' => array('check_status' => 3), 'orderby' => $orderby, 'limit' => array('per_page' => $per_page, 'offset' => 0));
}
$user_handsel_list = Myuser::instance();
$total = $user_handsel_list->count($user_query_struct);
$this->pagination = new Pagination(array('base_url' => url::current(), 'uri_segment' => 'page', 'total_items' => $total, 'items_per_page' => $per_page, 'style' => 'digg'));
$user_query_struct['limit']['offset'] = $this->pagination->sql_offset;
$user_handsel_list = Myuser::instance();
$user_list = $user_handsel_list->lists($user_query_struct);
$this->template->content = new View("handsel/user_handsel_list");
$this->template->content->user_list = $user_list;
$this->template->content->total = $total;
$this->template->content->title = "site news list";
}
public function index()
{
$request_data = $this->input->get();
$delivery_service = DeliveryService::get_instance();
//初始化请求结构体
$query_struct = array('where' => array(), 'like' => array(), 'orderby' => array('id' => 'DESC'), 'limit' => array('per_page' => 20, 'offset' => 0));
//列表排序
$orderby_arr = array(0 => array('id' => 'DESC'), 1 => array('id' => 'ASC'), 2 => array('url' => 'ASC'), 3 => array('url' => 'DESC'), 4 => array('name' => 'ASC'), 5 => array('name' => 'DESC'), 6 => array('position' => 'ASC'), 7 => array('position' => 'DESC'), 8 => array('delay' => 'ASC'), 9 => array('delay' => 'DESC'), 10 => array('active' => 'ASC'), 11 => array('active' => 'DESC'), 12 => array('type' => 'ASC'), 13 => array('type' => 'DESC'), 14 => array('is_default' => 'ASC'), 15 => array('is_default' => 'DESC'));
$orderby = controller_tool::orderby($orderby_arr);
if (isset($orderby) && !empty($orderby)) {
$query_struct['orderby'] = $orderby;
}
// 每页条目数
controller_tool::request_per_page($query_struct, $request_data);
$count = $delivery_service->query_count($query_struct);
// 模板输出 分页
$this->pagination = new Pagination(array('total_items' => $count, 'items_per_page' => $query_struct['limit']['per_page']));
$query_struct['limit']['offset'] = $this->pagination->sql_offset;
$query_struct['limit']['page'] = $this->pagination->current_page;
//调用列表
$deliveries = $delivery_service->query_assoc($query_struct);
$this->template->content = new View("site/delivery_cn_list");
$this->template->content->deliveries = $deliveries;
}
/**
* 数据列表
*/
public function index()
{
$return_struct = array('status' => 0, 'code' => 501, 'msg' => 'Not Implemented', 'content' => array());
$return_data = array();
$request_data = $this->input->get();
/* 初始化默认查询结构体 */
$query_struct_default = array('like' => array(), 'orderby' => array('id' => 'DESC'), 'limit' => array('per_page' => 20, 'page' => 1));
/* 初始化当前查询结构体 */
$query_struct_current = array();
//* 设置合并默认查询条件到当前查询结构体 */
$query_struct_current = array_merge($query_struct_current, $query_struct_default);
//列表排序
$orderby_arr = array(0 => array('id' => 'DESC'), 1 => array('id' => 'ASC'), 2 => array('type' => 'ASC'), 3 => array('type' => 'DESC'), 4 => array('version' => 'ASC'), 5 => array('version' => 'DESC'), 6 => array('agent_detail' => 'ASC'), 7 => array('agent_detail' => 'DESC'), 8 => array('ip' => 'ASC'), 9 => array('ip' => 'DESC'), 10 => array('date_add' => 'ASC'), 11 => array('date_add' => 'DESC'), 12 => array('date_upd' => 'ASC'), 13 => array('date_upd' => 'DESC'), 14 => array('quantity' => 'ASC'), 15 => array('quantity' => 'DESC'));
$orderby = controller_tool::orderby($orderby_arr);
// 排序处理
if (isset($request_data['orderby']) && is_numeric($request_data['orderby'])) {
$query_struct_current['orderby'] = $orderby;
}
// 每页条目数
controller_tool::request_per_page($query_struct_current, $request_data);
//调用服务执行查询
$kc_browser_stat = Mykc_browser_stat::instance();
$count = $kc_browser_stat->count($query_struct_current);
// 模板输出 分页
$this->pagination = new Pagination(array('total_items' => $count, 'items_per_page' => $query_struct_current['limit']['per_page']));
$query_struct_current['limit']['page'] = $this->pagination->current_page;
$return_data['list'] = Mykc_browser_stat::instance()->lists($query_struct_current);
$return_struct['content'] = $return_data;
$content = new View($this->class_name . '_' . __FUNCTION__);
/* 变量绑定 */
$this->template->title = '浏览器详细信息';
$this->template->content = $content;
$this->template->content->request_data = $request_data;
/* 返回结构体绑定 */
$this->template->content->return_struct = $return_struct;
}
/**
* 订单列表
*/
public function index($status = NULL)
{
$time_expired = 60 * 60 * 2;
//将要过期时间
$time_delay = 5 * 60;
//过期延迟显示时间
//$mklasttime = mktime(date("H"), date("i"), date("s"), date("m"), date("d")-5, date("Y"));
//$last_time = date('Y-m-d H:i:s', $mklasttime);
//初始化默认查询结构体
$query_struct_default = array('where' => array(), 'orderby' => array('id' => 'DESC'), 'limit' => array('per_page' => 10, 'page' => 1));
if (!empty($status)) {
switch ($status) {
case 'hasbuy':
$query_struct_default['where']['status'] = 0;
break;
case 'noprint':
$query_struct_default['where']['status'] = 1;
break;
case 'beexpired':
$query_struct_default['where']['date_end <'] = date("Y-m-d H:i:s", time() + $time_expired);
//当离方案截止时间小于2小时时为将要到期
$query_struct_default['where']['date_end >'] = tool::get_date();
break;
case 'hasexpired':
$query_struct_default['where']['date_end <'] = date("Y-m-d H:i:s", time() + $time_delay);
$query_struct_default['where']['status'] = array(0);
break;
case 'hasprint':
$query_struct_default['where']['status'] = 2;
break;
case 'nobonus':
$query_struct_default['where']['status'] = 3;
break;
case 'hasbonus':
$query_struct_default['where']['status'] = 4;
break;
case 'givehonus':
$query_struct_default['where']['status'] = 5;
break;
case 'cancel':
$query_struct_default['where']['status'] = 6;
break;
default:
}
}
//d($query_struct_default);
/* 搜索功能 */
$search_arr = array('id', 'order_num', 'username');
$search_value = $this->input->get('search_value');
$search_type = $this->input->get('search_type');
$where_view = array();
//$query_struct_default['where']['date_end >='] = tool::get_date();
if (strlen($this->input->get('start_time')) > 0) {
$query_struct_default['where']['date_add >='] = $this->input->get('start_time') . ' 00:00:00';
$where_view['start_time'] = $this->input->get('start_time');
}
if (strlen($this->input->get('end_time')) > 0) {
$query_struct_default['where']['date_add <='] = $this->input->get('end_time') . ' 00:00:00';
$where_view['end_time'] = $this->input->get('end_time');
}
if ($search_arr) {
foreach ($search_arr as $value) {
if ($search_type == $value && strlen($search_value) > 0) {
if ($value == 'lastname') {
$userobj = user::get_instance();
$userinfo = $userobj->get_search($search_value);
$userid = $userinfo['id'];
$query_struct_default['where']['start_user_id'] = $userid;
$query_struct_default['where']['user_id'] = $userid;
} else {
$query_struct_default['like'][$value] = $search_value;
}
}
}
$where_view['search_type'] = $search_type;
$where_view['search_value'] = $search_value;
}
$request_data = $this->input->get();
//初始化当前查询结构体
$query_struct_current = array();
//设置合并默认查询条件到当前查询结构体
$query_struct_current = array_merge($query_struct_current, $query_struct_default);
//列表排序
$orderby_arr = array(0 => array('id' => 'DESC'), 1 => array('id' => 'ASC'));
$orderby = controller_tool::orderby($orderby_arr);
// 排序处理
if (isset($request_data['orderby']) && is_numeric($request_data['orderby'])) {
$query_struct_current['orderby'] = $orderby;
}
$query_struct_current['orderby'] = $orderby;
//每页条目数
controller_tool::request_per_page($query_struct_current, $request_data);
//调用服务执行查询
$return_data['count'] = $this->order_basic_obj->count($query_struct_current);
//统计数量
/* 调用分页 */
$this->pagination = new Pagination(array('total_items' => $return_data['count'], 'items_per_page' => $query_struct_current['limit']['per_page']));
$query_struct_current['limit']['page'] = $this->pagination->current_page;
$return_data['list'] = $this->order_basic_obj->query_assoc($query_struct_current);
//$return_data['ticket_type'] = Kohana::config('ticket_type');
/* $planobj = plan::get_instance();
$i = 0;
foreach ($return_data['list'] as $rowlist)
{
$planobj->get_result($return_data['list'][$i]);
if(empty($return_data['list'][$i]['detail'])) {
unset($return_data['list'][$i]);
}
$i++;
}
//d($return_data['list']);
$return_data['status'] = $status;
$return_data['time_expired'] = $time_expired;
//d($return_data['list']);
$return_data['site_config'] = Kohana::config('site_config.site');
$host = $_SERVER['HTTP_HOST'];
$dis_site_config = Kohana::config('distribution_site_config');
if (array_key_exists($host, $dis_site_config) == true && isset($dis_site_config[$host])) {
$return_data['site_config']['site_title'] = $dis_site_config[$host]['site_name'];
$return_data['site_config']['keywords'] = $dis_site_config[$host]['keywords'];
$return_data['site_config']['description'] = $dis_site_config[$host]['description'];
}
*/
$this->template->content = new View("order/order_index", $return_data);
$this->template->content->where = $where_view;
}
/**
* 评论列表
*/
public function index()
{
$return_struct = array('status' => 0, 'code' => 501, 'msg' => 'Not Implemented', 'content' => array());
try {
//$profiler = new Profiler;
//* 初始化返回数据 */
$return_data = array('assoc' => NULL, 'count' => 0);
//* 收集请求数据 ==根据业务逻辑定制== */
$request_data = $this->input->get();
//* 初始化默认查询结构体 ==根据业务逻辑定制== */
$request_struct_default = array('type' => NULL, 'keyword' => NULL);
//* 初始化请求结构体 */
$request_struct_current = array();
//* 设置合并默认请求结构数据到当前请求结构体 */
$request_struct_current = array_merge($request_struct_current, $request_struct_default);
//* 初始化默认查询结构体 ==根据业务逻辑定制== */
$query_struct_default = array('where' => array(), 'like' => array(), 'orderby' => array('id' => 'DESC'), 'limit' => array('per_page' => Kohana::config('my.items_per_page'), 'page' => 1));
//* 初始化当前查询结构体 */
$query_struct_current = array();
$product_all_ids = array();
$product_get_ids = array();
$product_id = 0;
//* 设置合并默认查询条件到当前查询结构体 */
$query_struct_current = array_merge($query_struct_current, $query_struct_default);
$data = ProductcommentService::get_instance()->index($query_struct_current);
//d($query_struct_current,1);d($data);
foreach ($data as $key => $val) {
if (isset($product_all_ids[$val['product_id']])) {
unset($data[$key]);
} else {
$product_all_ids[$val['product_id']] = $val['product_id'];
}
}
if (isset($request_data['status']) and in_array(trim($request_data['status']), array(ProductcommentService::COMMENT_EXAMINE_FALSE, ProductcommentService::COMMENT_EXAMINE_TRUE, ProductcommentService::COMMENT_NOT_EXAMINE))) {
$query_struct_current['where']['status'] = trim($request_data['status']);
}
//* 当前支持的查询业务逻辑 ==根据业务逻辑定制== */
if (isset($request_data['type']) && isset($request_data['keyword']) && !empty($request_data['keyword'])) {
switch ($request_data['type']) {
case 'sku':
$products = ProductService::get_instance()->query_assoc(array('like' => array('sku' => trim($request_data['keyword']))));
if (empty($products)) {
$product_id = 0;
} else {
foreach ($products as $val) {
if (in_array($val['id'], $product_all_ids)) {
$product_get_ids[$val['id']] = $val['id'];
}
}
}
if (is_array($product_get_ids) && count($product_get_ids) > 0) {
$query_struct_current['where']['product_id'] = $product_get_ids;
} else {
$query_struct_current['where']['product_id'] = $product_id;
}
$request_struct_current['keyword'] = trim($request_data['keyword']);
break;
case 'mail':
$query_struct_current['like'][$request_data['type']] = trim($request_data['keyword']);
$request_struct_current['keyword'] = $query_struct_current['like'][$request_data['type']];
/*
$query_struct_current['where'][$request_data['type']] = trim($request_data['keyword']);
$request_struct_current['keyword'] = $query_struct_current['where'][$request_data['type']];
*/
break;
}
$request_struct_current['type'] = $request_data['type'];
}
//列表排序
$orderby_arr = array(0 => array('id' => 'DESC'), 1 => array('id' => 'ASC'), 4 => array('status' => 'ASC'), 5 => array('status' => 'DESC'), 6 => array('product_id' => 'ASC'), 7 => array('product_id' => 'DESC'), 8 => array('user_id' => 'ASC'), 9 => array('user_id' => 'DESC'), 10 => array('mail' => 'ASC'), 11 => array('mail' => 'DESC'), 12 => array('grade' => 'ASC'), 13 => array('grade' => 'DESC'), 14 => array('create_timestamp' => 'ASC'), 15 => array('create_timestamp' => 'DESC'), 16 => array('ip' => 'ASC'), 17 => array('ip' => 'DESC'));
$orderby = controller_tool::orderby($orderby_arr);
// 排序处理
if (isset($request_data['orderby']) && is_numeric($request_data['orderby'])) {
$query_struct_current['orderby'] = $orderby;
}
//设定默认分页
$preset_perpages = Kohana::config('my.items_per_pages');
if (isset($request_data['per_page']) && !empty($request_data['per_page'])) {
$query_struct_current['limit']['per_page'] = $request_data['per_page'];
}
$request_struct_current['per_page'] = $query_struct_current['limit']['per_page'];
if (isset($request_data['page']) && !empty($request_data['page']) && is_numeric($request_data['page']) && $request_data['page'] > 0) {
$query_struct_current['limit']['page'] = $request_data['page'];
}
$request_struct_current['page'] = $query_struct_current['limit']['page'];
try {
//* 调用后端服务获取数据 */
$comment_service = ProductcommentService::get_instance();
//查询
$return_data['assoc'] = $comment_service->index($query_struct_current);
$return_data['count'] = $comment_service->count($query_struct_current);
$product_ids = array();
$user_ids = array();
foreach ($return_data['assoc'] as $comment) {
if (!empty($comment['user_id'])) {
$user_ids[$comment['user_id']] = TRUE;
}
if (!empty($comment['product_id'])) {
$product_ids[$comment['product_id']] = TRUE;
}
}
$products = array();
$users = array();
if (!empty($product_ids)) {
foreach (ProductService::get_instance()->query_assoc(array('where' => array('id' => array_keys($product_ids)))) as $product) {
$products[$product['id']] = $product;
}
}
if (!empty($user_ids)) {
foreach (ORM::factory('user')->in('id', array_keys($user_ids))->find_all() as $user) {
$user = $user->as_array();
$users[$user['id']] = $user;
}
}
// 模板输出 分页
$this->pagination = new Pagination(array('total_items' => $return_data['count'], 'items_per_page' => $query_struct_current['limit']['per_page']));
} catch (MyRuntimeException $ex) {
//* ==根据业务逻辑定制== */
//FIXME 根据service层的异常做一些对应处理并抛出用户友好的异常Message
throw $ex;
}
//* 如果是ajax请求缩减返回的字段 ==根据业务逻辑定制== */
if ($this->is_ajax_request()) {
$requestkeys = array('id', 'category_id', 'title', 'uri_name', 'store', 'on_sale', 'goods_price', 'sku');
array_walk($return_data['assoc'], 'util::simplify_return_array', $requestkeys);
}
//* 补充&修改返回结构体 */
$return_struct['status'] = 1;
$return_struct['code'] = 200;
$return_struct['msg'] = '';
$return_struct['content'] = $return_data;
//exit("<div id=\"do_debug\" style=\"clear:both;display:;\"><pre>\n".var_export($return_struct,TRUE)."\n</pre></div>");
//* 请求类型 */
if ($this->is_ajax_request()) {
// ajax 请求
// json 输出
$this->template->content = $return_struct;
} else {
//* html 输出 ==根据业务逻辑定制== */
//* 模板输出 */
$this->template->return_struct = $return_struct;
$content = new View($this->package_name . '/' . $this->class_name . '/' . __FUNCTION__);
//* 变量绑定 */
$this->template->title = Kohana::config('site.name');
$this->template->content = $content;
//* 请求结构数据绑定 */
$this->template->content->request_data = $request_data;
$this->template->content->request_struct = $request_struct_current;
//* 返回结构体绑定 */
$this->template->content->return_struct = $return_struct;
//:: 当前应用专用数据
$this->template->content->title = Kohana::config('site.name');
$this->template->content->products = $products;
$this->template->content->users = $users;
}
} catch (MyRuntimeException $ex) {
$return_struct['status'] = 0;
$return_struct['code'] = $ex->getCode();
$return_struct['msg'] = $ex->getMessage();
//TODO 异常处理
//throw $ex;
if ($this->is_ajax_request()) {
$this->template->content = $return_struct;
} else {
$this->template->return_struct = $return_struct;
$content = new View('info');
$this->template->content = $content;
//* 请求结构数据绑定 */
$this->template->content->request_data = $request_data;
//* 返回结构体绑定 */
$this->template->content->return_struct = $return_struct;
}
}
}
/**
* 数据列表
*/
public function index()
{
role::check('product_filter');
$return_struct = array('status' => 0, 'code' => 501, 'msg' => 'Not Implemented', 'content' => array());
try {
//* 初始化返回数据 */
$return_data = array();
//* 收集请求数据 ==根据业务逻辑定制== */
$request_data = $this->input->get();
// 执行业务逻辑
//* 初始化默认查询结构体 */
$query_struct_default = array('where' => array(), 'like' => array(), 'orderby' => array('id' => 'DESC'), 'limit' => array());
//* 初始化当前查询结构体 */
$query_struct_current = array();
//* 设置合并默认查询条件到当前查询结构体 */
$query_struct_current = array_merge($query_struct_current, $query_struct_default);
//列表排序
$orderby_arr = array(0 => array('id' => 'DESC'), 1 => array('id' => 'ASC'), 2 => array('title' => 'ASC'), 3 => array('title' => 'DESC'), 4 => array('uri_name' => 'ASC'), 5 => array('uri_name' => 'DESC'), 6 => array('update_timestamp' => 'ASC'), 7 => array('update_timestamp' => 'DESC'), 8 => array('order' => 'ASC'), 9 => array('order' => 'DESC'));
$orderby = controller_tool::orderby($orderby_arr);
// 排序处理
if (isset($request_data['orderby']) && is_numeric($request_data['orderby'])) {
$query_struct_current['orderby'] = $orderby;
}
// 每页条目数
//controller_tool::request_per_page($query_struct_current, $request_data);
//调用服务执行查询
$aliasfilter_service = Alias_filterService::get_instance();
$return_data['total'] = $aliasfilter_service->count($query_struct_current);
// 模板输出 分页
/*
$this->pagination = new Pagination(array (
'total_items' => $count,
'items_per_page' => $query_struct_current['limit']['per_page']
));*/
//$query_struct_current['limit']['page'] = $this->pagination->current_page;
$result = $aliasfilter_service->index($query_struct_current);
$return_data['list'] = array();
if (!empty($result)) {
foreach ($result as $key => $val) {
$val['create_timestamp'] = date('Y-m-d H:i:s', $val['create_timestamp']);
$val['update_timestamp'] = date('Y-m-d H:i:s', $val['update_timestamp']);
$return_data['list'][$val['id']] = $val;
}
}
//* 补充&修改返回结构体 */
$return_struct['status'] = 1;
$return_struct['code'] = 200;
$return_struct['msg'] = '';
$return_struct['content'] = $return_data;
//* 请求类型 */
if ($this->is_ajax_request()) {
// ajax 请求
// json 输出
$this->template->content = $return_struct;
} else {
// html 输出
//* 模板输出 */
$content = new View('product/' . $this->class_name . '/' . __FUNCTION__);
//* 变量绑定 */
$this->template->title = '别名过滤器管理';
$this->template->content = $content;
//* 请求结构数据绑定 */
$this->template->content->request_data = $request_data;
//* 返回结构体绑定 */
$this->template->content->return_struct = $return_struct;
}
// end of request type determine
} catch (MyRuntimeException $ex) {
$this->_ex($ex, $return_struct, $request_data);
}
}
/**
* 数据列表
*/
public function index()
{
$return_struct = array('status' => 0, 'code' => 501, 'msg' => 'Not Implemented', 'content' => array());
try {
//* 初始化返回数据 */
$return_data = array('site_list' => array(), 'list' => array());
//* 收集请求数据 ==根据业务逻辑定制== */
$request_data = $this->input->get();
//* 权限验证 */
$site_id = site::id();
if ($site_id == 0) {
throw new MyRuntimeException(Kohana::lang('o_global.select_site'), 400);
}
role::check('inquiry_subject', $site_id, 0);
// 执行业务逻辑
//* 初始化默认查询结构体 */
$query_struct_default = array('where' => array('site_id' => $site_id), 'like' => array(), 'orderby' => array('id' => 'DESC'), 'limit' => array('per_page' => 20, 'page' => 1));
//* 初始化当前查询结构体 */
$query_struct_current = array();
//* 设置合并默认查询条件到当前查询结构体 */
$query_struct_current = array_merge($query_struct_current, $query_struct_default);
//列表排序
$orderby_arr = array(0 => array('id' => 'ASC'), 1 => array('id' => 'DESC'), 2 => array('name' => 'ASC'), 3 => array('name' => 'DESC'), 4 => array('update_timestamp' => 'ASC'), 5 => array('update_timestamp' => 'DESC'), 6 => array('position' => 'ASC'), 7 => array('position' => 'DESC'));
$orderby = controller_tool::orderby($orderby_arr);
// 排序处理
if (isset($request_data['orderby']) && is_numeric($request_data['orderby'])) {
$query_struct_current['orderby'] = $orderby;
}
// 每页条目数
controller_tool::request_per_page($query_struct_current, $request_data);
//调用服务执行查询
$inquieysubject_service = InquirysubjectService::get_instance();
$count = $inquieysubject_service->count($query_struct_current);
// 模板输出 分页
$this->pagination = new Pagination(array('total_items' => $count, 'items_per_page' => $query_struct_current['limit']['per_page']));
$query_struct_current['limit']['page'] = $this->pagination->current_page;
$return_data['list'] = $inquieysubject_service->index($query_struct_current);
//* 补充&修改返回结构体 */
$return_struct['status'] = 1;
$return_struct['code'] = 200;
$return_struct['msg'] = '';
$return_struct['content'] = $return_data;
//* 请求类型 */
if ($this->is_ajax_request()) {
$this->template->content = $return_struct;
} else {
// html 输出
//* 模板输出 */
$content = new View($this->package . '/' . $this->class_name . '/' . __FUNCTION__);
//* 变量绑定 */
$this->template->title = '商品咨询主题管理';
$this->template->content = $content;
//* 请求结构数据绑定 */
$this->template->content->request_data = $request_data;
//* 返回结构体绑定 */
$this->template->content->return_struct = $return_struct;
//:: 当前应用专用数据
$this->template->content->site_id = $site_id;
}
// end of request type determine
} catch (MyRuntimeException $ex) {
$return_struct['status'] = 0;
$return_struct['code'] = $ex->getCode();
$return_struct['msg'] = $ex->getMessage();
//TODO 异常处理
//throw $ex;
if ($this->is_ajax_request()) {
$this->template->content = $return_struct;
} else {
$this->template->return_struct = $return_struct;
$content = new View('info');
$this->template->content = $content;
//* 请求结构数据绑定 */
$this->template->content->request_data = $request_data;
//* 返回结构体绑定 */
$this->template->content->return_struct = $return_struct;
}
}
}
