/**
* 权限检测
* @author allen caowenpeng1990@126.com
*/
protected function check_acl()
{
$controller = $this->uri->rsegment(1) ? $this->uri->rsegment(1) : getgpc("mod");
$action = $this->uri->rsegment(2) ? $this->uri->rsegment(2) : getgpc("act");
$node_str = $controller . '/' . $action;
$query_node = $this->db->get_where('admin_node', array('node' => $node_str, 'status' => 1));
$node = $query_node->row_array();
//查出被权限的节点
$admin_utype = $this->session->userdata('admin_utype');
if ($admin_utype == 'sysadmin') {
//全站放行
return;
}
if (is_array($node) && count($node) > 0) {
$admin_id = $this->session->userdata('admin_id');
$query_acl = $this->db->select('admin_group.acl')->from('admin_group')->join('admin_user', 'admin_user.groupid = admin_group.id')->where(array('admin_user.id' => $admin_id))->get();
$acl = unserialize($query_acl->row_array()['acl']);
if (!in_array($node['id'], $acl)) {
if ($this->input->is_ajax_request()) {
$data['status'] = false;
$data['msg'] = '您没有权限进行此操作!';
ajaxReturn($data);
} else {
header("Content-type:text/html;charset=utf-8");
alert("您没有权限进行此操作！");
}
}
}
}
/** markdown格式接口 */
public function develop_public()
{
$gData = checkData($_GET);
$int_opt = $gData['int_opt'];
if (!$int_opt) {
ajaxReturn('非法操作[缺少必须参数]', 300);
}
//样式
echo '<style>
.markdown-here-wrapper h1{ font-size: 20px; font-weight:bold; margin-top: 10px;}
.markdown-here-wrapper h2{ font-size: 18px; font-weight:bold; margin-top: 10px;}
.markdown-here-wrapper h3{ font-size: 16px; font-weight:bold; margin-top: 10px;}
.markdown-here-wrapper table{ border-collapse: collapse; border: 1px solid yellowgreen;}
.markdown-here-wrapper th { vertical-align: baseline; border: 1px solid yellowgreen; font-weight:bold; font-size: 18px;}
.markdown-here-wrapper td { vertical-align: middle; border: 1px solid yellowgreen; font-size: 18px;}
.markdown-here-wrapper tr { border: 1px solid yellowgreen;}
.markdown-here-wrapper p a{font-size: 16px;}
</style>';
$output = $text = file_get_contents(MODULE_PATH . 'develop_info/' . $int_opt . '.md');
$parser = new MarkdownExtra();
$my_html = $parser->transform($output);
$this->s->assign('my_html', $my_html);
$this->s->display('interface_admin/interface_list.html');
}
public function city()
{
$id = I('get.provinceid', '', 'intval');
$cval = M('cities')->field('id,city,provinceid,cityid')->where('provinceid=' . $id)->select();
if ($cval === false) {
ajaxReturn(101, '请求失败', '');
} else {
ajaxReturn(0, '', $cval);
}
}
public function actorssearch()
{
$condition = I('get.condition');
$data['name|achievement'] = array('like', '%' . $condition . '%');
$data['status'] = array(array('eq', 1), array('eq', 2), 'or');
$actors = M('actors');
$actorsval = $actors->where($data)->select();
if ($actorsval === false) {
ajaxReturn(101, '请求失败', '');
} else {
ajaxReturn(0, '', $actorsval);
}
}
public function get_menu_c()
{
$pData = checkData($_POST);
$pid = intval($pData['pid']);
if (!$pid) {
$list = "<option value='0'>请选择一个项目</option>";
} else {
$list = "<option value='0'>--请选择栏目--</option>";
$data = $this->getCache('sys_menu');
foreach ($data[$pid]['list'] as $v) {
$list .= "<option value='" . $v['id'] . "'>" . $v['name'] . "(" . $v['action'] . ")</option>";
}
}
ajaxReturn($list, 200);
}
public static function handleException($e)
{
$err_code = $e->getCode();
$err_message = $e->getMessage();
$err_file = $e->getFile();
$err_line = $e->getLine();
if (IS_DEBUG) {
self::$_errors[] = '==== handleException ====';
self::$_errors[] = array('code' => $err_code, 'message' => $err_message, 'file' => $err_file, 'line' => $err_line, 'trace' => $e->getTrace());
// Exception 终止运行，故在此输出错误信息
self::showErrors();
} else {
IS_CLI ? print $err_message : (isAjax() ? ajaxReturn(0, '服务器端错误') : redirect(SITE_URI . '/error.html'));
}
// 转换为相对路径，降低log 长度=。=！
$err_file = str_replace(APPLICATION_PATH, '', $err_file);
Core_Log::getInstance()->error("{$err_message} CODE:{$err_code} FILE:{$err_file} LINE:{$err_line}");
}
public function uppasswd()
{
$oldp = I('post.oldp', '', 'md5');
$data['passwd'] = I('post.newp', '', 'md5');
$admin = M('admin');
$where = array('name' => session('name'), 'passwd' => $oldp);
$adminval = $admin->where($where)->find();
if ($adminval) {
$sign = $admin->where('id=' . $adminval['id'])->save($data);
if ($sign) {
ajaxReturn(0, '修改成功', '');
} else {
ajaxReturn(1, '未修改成功', $admin->getlastsql());
}
} else {
ajaxReturn(102, '旧密码不正确', '');
}
}
/**
*更新bid
*/
public function deleteBid()
{
$pData = checkData($_REQUEST);
$id = $pData['id'];
if (!$id) {
ajaxReturn('不能为空', 300);
}
$delete_sql = "DELETE FROM waplog.`wap_bid_list` where id={$id}";
if ($this->db->query($delete_sql)) {
ajaxReturn('删除成功', 200);
} else {
ajaxReturn('删除失败', 300);
}
/*
$id = $gData['id'];
$sql = "select * from waplog.`wap_bid_list` WHERE id={$id}";
$data = $this->db->get($sql);
$this->s->assign('result', $data);*/
}
public function recommendstar()
{
$actors = M('actors');
$where['status'] = array(array('neq', 0), array('neq', 3));
$where['recommend'] = 1;
$count = $actors->where($where)->count();
// 查询满足要求的总记录数
$Page = new \Think\Page($count, 8);
// 实例化分页类 传入总记录数和每页显示的记录数(25)
$show = $Page->show();
// 分页显示输出
// 进行分页数据查询注意limit方法的参数要使用Page类的属性
$list = $actors->field('id,img,name')->where($where)->order('instime desc')->limit($Page->firstRow . ',' . $Page->listRows)->select();
$data['page'] = ceil($count / 8);
$data['data'] = $list;
if ($list === false) {
ajaxReturn(101, '请求失败', '');
} else {
ajaxReturn(0, '', $data);
}
}
/** 系统缓存设置 */
public function system_options_cache()
{
if ($this->system_options(1, 1)) {
ajaxReturn('缓存系统设置成功', 200);
}
}
function errReturn($errCode, $msg)
{
ajaxReturn($errCode, $msg);
}
/** 修改帐号密码 */
public function chang_user_pass()
{
$pData = checkData($_POST);
$AdminUserTable = $this->OperateTable['AdminUserTable'];
$user_name = $_SESSION['user_id']['user_name'];
$user_id = $_SESSION['user_id']['user_id'];
if ($user_name == 'weedong91admin' || $user_id == 1) {
ajaxReturn('不能修改超级管理员帐号密码', 300);
}
$info_sql = "SELECT user_id,user_pass,user_name FROM {$AdminUserTable} WHERE user_id={$user_id} LIMIT 1";
$infoData = $this->db->get($info_sql);
$uData['user_id'] = $infoData['user_id'];
$uData['user_name'] = $infoData['user_name'];
$uData['user_pass'] = $infoData['user_pass'];
if ($user_name != $uData['user_name'] || $user_id != $uData['user_id']) {
ajaxReturn('非法操作[！！！]', 300);
}
if ($pData) {
/*$old_pass = MD5(MD5($pData['old_pass']));
$user_pass = MD5(MD5($pData['user_pass']));
$auth_pass = MD5(MD5($pData['auth_pass']));*/
$old_pass = MD5($pData['old_pass']);
$user_pass = MD5($pData['user_pass']);
$auth_pass = MD5($pData['auth_pass']);
if ($user_pass != $auth_pass) {
ajaxReturn('两次密码输入不同,请重新输入', 300);
}
if ($old_pass != $uData['user_pass']) {
ajaxReturn('您的旧密码错误,请重新输入', 300);
}
$sql = "UPDATE {$AdminUserTable} SET user_pass='******' WHERE user_id=" . $uData['user_id'] . " AND user_pass='******'user_pass'] . "' LIMIT 1";
if ($this->db->query($sql)) {
$this->setLog('修改用户密码{' . $user_name . '}成功！');
$back_json = '{
"statusCode":"200",
"message":"修改用户密码{' . $user_name . '}成功！",
"callbackType":"closeCurrent"
}';
echo $back_json;
exit;
} else {
$this->setLog('修改用户密码{' . $user_name . '}失败！');
ajaxReturn('修改用户密码{' . $user_name . '}失败！', 300);
}
}
$this->s->assign('uData', $uData);
$this->s->display('admin/chang_user_pass.html');
}
$rack_combo_options[0] = '';
foreach ($racks as $rack) {
$rack_combo_options[$rack['bin_racks_id']] = 'Rack ' . $class_bins->formatRackNumber($rack['no']) . ' (' . $class_bins->rack_flag_options[$rack['rack_flag']] . ')';
}
echo utf8_encode('<select>' . loadComboListFromArray($rack_combo_options) . '</select>');
exit;
} elseif ($_POST['me_action'] == 'LOADBIN') {
$segment_id = tep_db_prepare_input($_POST['segment_id']);
$rack_id = tep_db_prepare_input($_POST['rack_id']);
$bin = $class_bins->getBinUsable($segment_id, null, $rack_id);
if (is_null($bin)) {
$bin = array('error' => '1');
} else {
$bin['error'] = '0';
}
ajaxReturn($bin);
exit;
} elseif ($_POST['me_action'] == "TRANSFERBIN") {
$bin_id_old = tep_db_prepare_input($_POST['bin_id_old']);
$bin_id_new = tep_db_prepare_input($_POST['bin_id_new']);
echo utf8_encode($class_bins->transferBin($bin_id_old, $bin_id_new) ? 'OK' : 'FAILED');
exit;
}
}
$_SESSION[$session_page]['last_scan'] = '';
$_SESSION[$session_page]['last_scan_count'] = 0;
$box_style = 'style="text-align:center;width:500px;padding:20px;"';
$content .= '<div class="red" style="margin-bottom:10px;">* <strong>Bin In</strong> and <strong>Pick and Pack</strong> Process must be closed before starting this process</div>';
//STEP 1
$content .= '<div id="step-1-window" class="box ui-corner-all" ' . $box_style . '>';
$content .= '<h2 style="margin-bottom:20px;" class="notice">Step 1: Choose Original Bin Location</h2>';
$ids = $_POST['ids'];
list($notifications_id, $not_class) = split('-', $ids);
$notifications->delete($notifications_id);
$result = array();
$result['notifications_id'] = $notifications_id;
$result['not_class'] = $not_class;
ajaxReturn($result);
exit;
} elseif ($_POST['me_action'] == 'CLOSEFEEDBACK') {
$ids = $_POST['ids'];
list($notifications_id, $not_class) = split('-', $ids);
$notifications->closeOpenFeedback($notifications_id);
$result = array();
$result['ids'] = $ids;
$result['notifications_id'] = $notifications_id;
ajaxReturn($result);
exit;
} elseif ($_POST['me_action'] == 'REFRESHFILTERS') {
$sender = tep_db_prepare_input($_POST['sender']);
$filter = isset($_POST['sender']) && $_POST['sender'] != '' ? "AND posted_by = '{$sender}'" : "";
}
}
$date_oldest = date('Y-m-d', strtotime("-14 day"));
$date_today = date('j M Y');
$date_yesterday = date('j M Y', strtotime("-1 day"));
$n_lists = $notifications->retrieveListGeneralQuery("muhn.user_id={$session_userinfo['id']} AND (muhn.status=0 OR muhn.need_feedback=1 OR muhn.posted_date>='{$date_oldest}') {$filter}", 'muhn.posted_date DESC, muhn.posted_by');
$notifications_new = array();
$printed_date = '';
$previous_date = '';
//$dbposted = tep_db_query("SELECT DISTINCT posted_by FROM minierp_users_has_notifications WHERE user_id = '$session_userinfo[id]'");
//while($r=tep_db_fetch_array($dbposted))$postedusers[$r['posted_by']] = $r['posted_by'];
$page = $_POST['page'];
$pageSize = $_POST['rows'];
$sort = $_POST['sord'];
$order = $_POST['sidx'];
$offset = ($page - 1) * $pageSize;
//分页起始条数
$sql = "select * from employee order by {$order} {$sort} limit {$offset}, {$pageSize}";
$result = $conn->query($sql);
$rows = [];
if ($result) {
$nums = $result->num_rows;
while ($row = $result->fetch_assoc()) {
$rows[] = $row;
}
}
if ($nums > 0) {
$total_pages = ceil($nums / $pageSize);
} else {
$total_pages = 0;
}
$arr_json = array('page' => $page, 'total' => $total_pages, 'records' => $nums, 'rows' => $rows);
ajaxReturn($arr_json);
/**
*
* @param array $data
*/
function ajaxReturn(array $data)
{
header('content-type:application/json;charset=utf8');
exit(json_encode($data, JSON_UNESCAPED_UNICODE));
}
if (empty($session)) {
ajaxReturn('', 'token error', 403);
}
//得到ppfeature、start，end对应的upload_url
$key = "{$_GET['start']}_{$_GET['end']}";
$ranges = api_cache($_GET['ppfeature'], $key);
if (empty($ranges)) {
ajaxReturn('', '传参start、end不对', 502);
}
//先存本地
$target = UPLOAD_DIR . "/{$_GET['ppfeature']}";
@mkdir($target);
$target .= "/{$key}";
$input = fopen("php://input", "r");
@file_put_contents($target, $input);
//文件大小校验
if ($_GET['end'] - $_GET['start'] != filesize($target)) {
ajaxReturn('', '文件不完整', 502);
}
//传swift
$uploadId = send_put_file($ranges['upload_url'], $target);
if (!$uploadId) {
ajaxReturn('', '传文件至公有云出错', 500);
}
//通知已完成
$md5 = strtoupper($uploadId);
$url = API_CLOUDPLAY . "/2/file/{$_GET['fid']}/action/uploaded?fromcp=private_cloud&range_md5={$md5}&bid={$ranges['bid']}&uploadid={$uploadId}";
$arr = json_decode(send_json_post($url, ''), 1);
$arr['data'] = array('nextUrl' => "{$URL_PREFIX}/getRange.php");
ajaxReturn($arr['data'], 'success', 0);
public function error($message = '', $ajax_data = null)
{
isAjax() ? ajaxReturn(false, $message, $ajax_data) : $this->_jump(false, $message, $ajax_data);
}
function postProcess($post_vars)
{
global $session_userinfo;
$result = array();
if ($post_vars['me_action'] == 'SEARCH') {
$type = $post_vars['type'];
$jng_sp_id = $post_vars['jng_sp_id'];
//another strange case, in live datepicker filter is always given as \'datevalue\' instead of 'datevalue'
//still cant find the root cause (and it's ok in local dev), so for quickwin workaround we simple replace
//the \' value into ' with below update (sahat 11.02.2014)
//$post_filters = explode("|", $post_vars['post_filters']);
$post_filters = explode("|", str_replace('\\\'', "'", $post_vars['post_filters']));
$filters = array();
foreach ($post_filters as $f) {
$f_temp = explode('-', $f);
$field = $f_temp[0];
unset($f_temp[0]);
$value = implode('-', $f_temp);
//explode to array for input on field $multivalue_fields which allowed multivalue separated by $multivalue_separator
if (in_array($field, $this->multivalue_fields)) {
$mv_temp = explode(current($this->multivalue_separator), $value);
if (is_array($mv_temp) && $mv_temp > 0) {
foreach ($mv_temp as $mv) {
$mv = trim($mv);
if (!isset($filters[$field]) || !in_array($mv, $filters[$field])) {
$filters[$field][] = $mv;
}
}
} else {
$filters[$field][] = $value;
}
} else {
$filters[$field][] = $value;
}
}
$query = $this->constructQuery($jng_sp_id, $filters);
$dbq = tep_db_query($query);
$result = '';
$total = 0;
$elements_ids = '';
//$display_spot = '';
while ($r = tep_db_fetch_array($dbq)) {
$total++;
if ($total > 1) {
$elements_ids .= ',';
}
$elements_ids .= $r['elements_id'];
// $display_spot .= '<div id="'.$r['elements_id'].'" class="lists-elements"></div>';
}
$result['type'] = $type;
$result['total'] = $total;
$result['elements_ids'] = $elements_ids;
// $result['display_spot'] = $display_spot;
ajaxReturn($result);
} elseif ($post_vars['me_action'] == 'DISPLAY') {
$type = $post_vars['type'];
$elements_id = $post_vars['elements_id'];
$query = "SELECT e.elements_id, e.elements_code, e.elements_name, e.elements_image, e.elements_price, e.add_date, IFNULL(e.elements_weight,'-') elements_weight, e.stars, e.elements_description";
$query .= ", IFNULL(esup.suppliers_name,'-') suppliers_name";
$query .= ", el.used_in_products, IFNULL(el.weekly_sold, '-') weekly_sold, IFNULL(el.weekly_sold_products, '-') weekly_sold_products, IFNULL(el.sold_monthly_1, '-') last_month_sold";
$query .= ", (IFNULL(els.sold_{$this->last_year}_sp, 0) + IFNULL(els.sold_{$this->last_year}_jg, 0)) sold_{$this->last_year}";
$query .= ", (IFNULL(els.sold_products_{$this->last_year}_sp, 0) + IFNULL(els.sold_products_{$this->last_year}_jg, 0)) sold_products_{$this->last_year}";
$query .= ", ec.name AS cat_name, pm.material_name AS mat_name, cpd.name AS color_name, ei.name AS size_name, eh.name AS holesize_name";
$query .= ", es.name AS shape_name, es.shape_image, eu.name AS surface_name, eu.surface_image, et.name AS cut_name, et.cuts_image AS cut_image";
$query .= ", ehe.name AS height_name, ew.name AS width_name, eth.name AS thickness_name, est.stock";
$query .= ", DATEDIFF(NOW(), e.add_date) AS elements_age";
$query .= " FROM element e";
$query .= " LEFT JOIN elements_log el ON el.elements_id=e.elements_id";
$query .= " LEFT JOIN elements_log_static els ON els.elements_id=e.elements_id";
$query .= " LEFT JOIN elements_to_elements_suppliers etes ON etes.elements_id = e.elements_id AND is_default = 1";
$query .= " LEFT JOIN elements_suppliers esup ON esup.elements_suppliers_id = etes.elements_suppliers_id";
$query .= " LEFT JOIN elements_stock est ON est.elements_id = e.elements_id AND est.jng_warehouses_id = " . WAREHOUSE_ID_ELEMENTS;
$query .= " LEFT JOIN element_category ec ON ec.element_category_id=e.attribute_category_id";
$query .= " LEFT JOIN products_materials pm ON pm.products_materials_id=e.attribute_material_id";
$query .= " LEFT JOIN color_pattern cp ON cp.color_pattern_id=e.attribute_color_id";
$query .= " LEFT JOIN color_pattern_description cpd ON cpd.color_pattern_id=e.attribute_color_id AND languages_id=1";
$query .= " LEFT JOIN element_size ei ON ei.element_size_id=e.attribute_size_id";
$query .= " LEFT JOIN element_holesize eh ON eh.element_holesize_id=e.attribute_holesize_id";
$query .= " LEFT JOIN element_shape es ON es.element_shape_id=e.attribute_shape_id";
$query .= " LEFT JOIN element_surface eu ON eu.element_surface_id=e.attribute_surface_id";
$query .= " LEFT JOIN element_cut et ON et.element_cut_id=e.attribute_cut_id";
$query .= " LEFT JOIN element_height ehe ON ehe.element_height_id=e.attribute_height_id";
$query .= " LEFT JOIN element_width ew ON ew.element_width_id=e.attribute_width_id";
$query .= " LEFT JOIN element_thickness eth ON eth.element_thickness_id=e.attribute_thickness_id";
$query .= " WHERE e.elements_id = '{$elements_id}'";
$dbq = tep_db_query($query);
$res = tep_db_fetch_array($dbq);
$elements_image = webImageWithDetailLink($res['elements_image'], IMAGE_SIZE_THUMBNAIL_1, IMAGE_SIZE_THUMBNAIL_1, 'Element ' . $res['elements_id'], 'img-border');
$elements_created = date('d-M-Y', strtotime($res['add_date']));
$elements_price = $res['elements_price'] < ELEMENTS_LOWER_PRICE ? displayCurrency('EUR', $res['elements_price'], true, 5) : displayCurrency('EUR', $res['elements_price']);
$resultsdt = array();
//0-4
$resultsdt[] = $elements_id;
$resultsdt[] = $elements_image;
//$resultsdt[] = $res['elements_name'];
$resultsdt[] = $res['elements_description'];
$resultsdt[] = $elements_created;
$resultsdt[] = $elements_price;
//5-9
$resultsdt[] = $res['suppliers_name'];
$resultsdt[] = $res['weekly_sold'];
$resultsdt[] = $res['weekly_sold_products'];
$resultsdt[] = $res['sold_' . $this->last_year];
$resultsdt[] = $res['sold_products_' . $this->last_year];
//10-14'd
$resultsdt[] = $res['elements_weight'];
$resultsdt[] = $res['last_month_sold'];
$resultsdt[] = $res['stock'];
$resultsdt[] = drawStars($res['stars']);
$resultsdt[] = $res['elements_age'];
$result['type'] = $type;
$result['result'] = implode($this->result_separator, $resultsdt);
ajaxReturn($result);
} elseif ($post_vars['me_action'] == 'KILLELEMENT') {
use_class('element');
$elid = tep_db_prepare_input($_POST['elid']);
$element = new element($elid);
$is_deleted = $element->delete($session_userinfo['username']);
$result = array();
$result['target_id'] = $elid;
$result['is_deleted'] = $is_deleted;
ajaxReturn($result);
}
}
public function dept_del()
{
$gData = checkData($_GET);
$id = $gData['id'];
if ($id <= 0) {
ajaxReturn('参数错误', 300);
}
$sql = "delete from system_dept where id={$id} or dept={$id}";
if ($this->db->query($sql)) {
ajaxReturn('删除成功', 200);
} else {
ajaxReturn('删除失败', 300);
}
}
function acl_config()
{
$gid = $this->input->get('gid');
$query_group = $this->db->query("select * from web_admin_group where id = '{$gid}'");
$group = $query_group->row_array();
$acl = unserialize($group['acl']);
$query_nodes = $this->db->get('admin_node');
$nodes = $query_nodes->result_array();
foreach ($nodes as $key => $value) {
foreach ($acl as $v) {
if ($v == $value['id']) {
$nodes[$key]['checked'] = true;
}
}
}
$nodes_format = get_menu(tree($nodes));
if ($this->input->isPost()) {
$post = $this->input->posts();
$gid = $post['gid'];
$data = array('acl' => serialize($post['acl_id']), 'utime' => date('Y-m-d H:i:s'));
$ck = $this->db->where('id', $gid)->update('admin_group', $data);
$response['status'] = $ck;
if ($ck) {
$response['msg'] = '配置成功！';
} else {
$response['msg'] = '配置失败！';
}
ajaxReturn($response);
}
$this->load->view('admin/acl_config', array('group' => $group, 'nodes' => $nodes_format));
}
/**
* 错误信息
* @param info 要显示的消息
* @author Colin <*****@*****.**>
*/
public function error($info = null)
{
$this->info = $info;
switch ($this->type) {
case 'showMessage':
showMessage($this->info);
break;
case 'ajaxReturn':
ajaxReturn(array('info' => $this->info, 'url' => null, 'status' => 0));
break;
default:
$this->type($this->info);
break;
}
}
public function greegroup()
{
$sex = I('get.sex');
$actors = M('actors');
if ($sex) {
$where['sex'] = $sex;
}
$where['groupid'] = 3;
$where['status'] = 1;
$actorsval = $actors->where($where)->order('votes desc')->select();
foreach ($actorsval as $key => $val) {
$actorsval[$key]['lifting'] = $val['oldrank'] - $val['rank'];
}
if ($actorsval === false) {
ajaxReturn(1, '系统错误', '');
} else {
ajaxReturn(0, '', $actorsval);
}
}
public function vial()
{
$type = intval(trim(I('get.type')));
$vedio = M('vedio');
$condition = I('get.condition');
if ($condition == 'hot') {
$order = 'hot desc,instime desc';
} else {
$order = 'instime desc,hot desc';
}
//视频汇
$data['type'] = $type;
$data['status'] = 1;
//$tvvideo = $vedio->where($data)->order('instime desc,hot desc')->limit(0,15)->select();
$count = $vedio->where($data)->count();
// 查询满足要求的总记录数
$Page = new \Think\Page($count, 15);
// 实例化分页类 传入总记录数和每页显示的记录数(25)
$show = $Page->show();
// 分页显示输出
// 进行分页数据查询 注意limit方法的参数要使用Page类的属性
$list = $vedio->field('id,instime,bigimg,title')->where($data)->order($order)->limit($Page->firstRow . ',' . $Page->listRows)->select();
$dump['page'] = ceil($count / 15);
$dump['data'] = $list;
if ($list === false) {
ajaxReturn(101, '请求失败', '');
} else {
if (!$dump['data']) {
$dump['data'] = array();
}
foreach ($list as $key => $val) {
$dump['data'][$key]['instime'] = date('m-d', $val['instime']);
$dump['data'][$key]['title'] = mb_strlen($val['title'], 'utf8') > 12 ? mb_substr($val['title'], 0, 12, 'utf8') . '...' : $val['title'];
}
ajaxReturn(0, '', $dump);
}
}
$design_name = '';
$design_description = '';
$design_priority = 1;
$design_qty = 0;
$design_link = '';
$use_exit = false;
break;
case 'CREATE':
$design_name = '';
$design_description = '';
$design_priority = '';
$design_qty = '';
$design_link = '';
//$name, $description, $link, $priority, $qty,createby
$newdesign = $class_ppn->addNewDesign($design_name, $design_description, $design_link, $filename, $design_priority, $design_qty, $session_userinfo['username']);
ajaxReturn($newdesign);
//
break;
case 'NEWDESIGNSORT':
$sort_string = $class_pp->getNewDesignSort($sort_id);
$sp_orders .= $class_pp->getNewDesign('1', $sort_id, $sort_string);
echo utf8_encode($sp_orders);
break;
case 'TODOSORT':
$sort_string = $class_pp->getNewDesignSort($sort_id);
$sp_orders .= $class_pp->getNewDesign('11', $sort_id, $sort_string);
echo utf8_encode($sp_orders);
break;
case 'NEWDESIGNSORTQUESTION1':
$sort_string = $class_pp->getNewDesignSort($sort_id);
$sp_orders = $class_pp->getOpenQuestion1($sort_id, $sort_string);
$r = tep_db_query($query);
$products = array();
while ($row = tep_db_fetch_array($r)) {
$products[$row['products_id']] = $row;
}
if (count($products) > 0) {
$ajaxResult['products_id'] = implode(',', array_reverse(array_keys($products)));
foreach ($products as $pid => $row) {
$obj_product = new Product($pid);
$product_image = $obj_product->displayImage(IMAGE_SIZE_THUMBNAIL_2, IMAGE_SIZE_THUMBNAIL_2, '', false, '', Product::IMAGE_LINKTO_PRODUCT_DETAIL);
$ajaxResult['img-' . $pid] = '<div id="rb-pid-' . $pid . '" style="float:left;margin:0 5px 20px 4px;">' . $product_image . '</div>';
}
} else {
$ajaxResult['products_id'] = 'none';
}
echo ajaxReturn($ajaxResult);
exit;
}
/*
if($_POST['me_action']=='TODOSUSERCOUNTER') {
use_class('minierp_users');
$class_mu = new minierp_users();
$userlist = $class_mu->retrieveList('status="1"','username ASC');
$todos_counter = $class_td->userTodosCounter($userlist);
$result = array();
foreach($todos_counter as $userid=>$counter) $result[] = "$userid,$counter";
ajaxReturn($result);
exit;
} else
*/
}
public function useraddactive()
{
$a = $this->checklogin();
//验证登陆
if (!$a) {
ajaxReturn(104, '未登录', '');
}
$active = M('active');
// $upload = new \Think\Upload();// 实例化上传类
// $upload->maxSize = 3145728 ;// 设置附件上传大小
// $upload->exts = array('jpg', 'png', 'jpeg');
// // 设置附件上传类型
// $upload->savePath = '/active/'; // 设置附件上传目录 // 上传文件
// $info = $upload->upload();
// if(!$info) {// 上传错误提示错误信息
// $this->error($upload->getError());
// }else{
// $data['img'] = $info['mypic']['savepath'].$info['mypic']['savename'];
// }
$data['img'] = substr(stripslashes(I('post.img')), 9);
$data['title'] = I('post.title');
$data['content'] = I('post.content');
$data['phone'] = I('post.phone');
$data['begin_time'] = strtotime(I('post.begin_time'));
$data['last_time'] = strtotime(I('post.last_time'));
$data['instime'] = time();
$span = $data['last_time'] - $data['begin_time'];
if ($span < 0) {
ajaxReturn(103, '活动结束日期不可比开始日期早', '');
//$this->error('活动结束日期不可比开始日期早');
}
$data['info'] = I('post.info');
$a = $this->checkDump($data);
if (!$a) {
ajaxReturn(102, '活动主体信息不可为空', '');
//$this->error('');
}
$data['linetype'] = I('post.line_type');
if ($data['linetype'] == 0) {
$data['line_address'] = I('post.line_address');
}
$data['week'] = $this->isWeek($data['begin_time'], $data['last_time']);
$data['sponsor_name'] = I('post.sponsor_name');
$data['sponsor_phone'] = I('post.sponsor_phone');
$data['sponsor_address'] = I('post.sponsor_address');
$data['sponsor_email'] = I('post.sponsor_email');
$data['order'] = I('post.order');
$data['status'] = 2;
$data['mast'] = session('username');
$data['userid'] = session('userid');
$sign = $active->add($data);
if ($sign) {
ajaxReturn(0, '活动发起成功,静待审核通过', '');
} else {
ajaxReturn(101, '发起失败', '');
}
}
/**
* Handle POST/GET Action that related to products_articles
*/
function processAction()
{
if (isset($_POST['me_action']) && $_POST['me_action'] == 'PRODUCTSARTICLES') {
switch ($_POST['act']) {
case 'ADDEANTOPRODUCT':
$products_id = tep_db_prepare_input($_POST['products_id']);
use_class('products_ean');
$class_ean = new products_ean();
$result = $class_ean->attachToProduct($products_id);
break;
case 'ADDEANTOARTICLE':
$article_id = tep_db_prepare_input($_POST['article_id']);
use_class('products_ean');
$class_ean = new products_ean();
$ean_no = $class_ean->attactToArticle($article_id);
$result = "{$article_id},{$ean_no}";
break;
case 'ADD':
$products_id = tep_db_prepare_input($_POST['products_id']);
$price = tep_db_prepare_input($_POST['new_price']);
$price_old = tep_db_prepare_input($_POST['new_price_old']);
$length = tep_db_prepare_input($_POST['new_length']);
$options = array();
$options['length'] = $length;
$prepared = true;
$products_articles_id = $this->add($products_id, $price, $price_old, $options, $prepared);
if ($products_articles_id == 0) {
$result .= '0';
} else {
//$result = '<tr><td>Other Length <sup class="red">new</sup></td><td>'.$length.'cm = '.$price.' EUR</td>';
$result .= '<tr>';
$result .= '<td class="green">New</td>';
$result .= '<td class="notice">Unset</td>';
$result .= '<td>' . $length . '</td>';
//$result .= '<td>'.$price.'</td>';
//$result .= '<td>'.$price_old.'</td>';
$result .= '<td colspan="2"><a href="">Refresh Page</a> for action links</td>';
$result .= '</tr>';
}
break;
case 'UPDATE':
$options = array();
$options['length'] = $_POST['new_length'];
$result = $this->update($_POST['products_articles_id'], $_POST['new_price'], $_POST['new_price_old'], $options);
break;
case 'REMOVE':
$result = $this->remove($_POST['products_articles_id']);
break;
case 'ARTICLEACTIVATION':
$paid = tep_db_prepare_input($_POST['paid']);
$status = tep_db_prepare_input($_POST['status']);
$this->setActiveStatus($paid, $status);
$result = array();
$result['paid'] = $paid;
$result['status'] = $status;
$result['success'] = '1';
ajaxReturn($result);
exit;
break;
}
echo utf8_encode($result);
exit;
}
}
public static function processPostAction()
{
global $session_userinfo;
if (isset($_POST['me_action'])) {
if ($_POST['me_action'] == 'WALLPOSTADD') {
$user_id = tep_db_prepare_input($_POST['user_id']);
$team = tep_db_prepare_input($_POST['team']);
$message = htmlspecialchars(tep_db_prepare_input($_POST['message'], true));
$wp = new wall_post();
$wp->create($user_id, $team, $session_userinfo['id'], date('Y-m-d H:i:s'), $message);
$ajaxResult = array();
$ajaxResult['user_id'] = $wp->user_id;
$ajaxResult['newpost'] = $wp->draw(true, true);
ajaxReturn($ajaxResult);
exit;
} elseif ($_POST['me_action'] == 'WALLPOSTREM') {
$wpid = tep_db_prepare_input($_POST['wpid']);
$wp = new wall_post($wpid);
$wp->delete();
echo utf8_encode($wpid);
exit;
}
objectSocialLinePostAction('wall_post');
}
}
/**
* 返回给前端页面json
* @param string|array $data
* @param string $errcode
* @param bool $helper 是否helper调用，如果true,则不返回json
*/
protected function R($data = "", $errcode = '', $helper = false, $jumpUrl = '')
{
if (!empty($errcode)) {
$this->errcode = $errcode;
}
if ($this->errcode == 0) {
$errmsg = '请求成功！';
$isImportant = 0;
} else {
if (empty(self::$errMap)) {
$errMap = (require __ROOT__ . '/errorCode.php');
self::$errMap = $errMap;
}
if (is_array(self::$errMap[$this->errcode])) {
$errmsg = self::$errMap[$this->errcode][0];
$isImportant = self::$errMap[$this->errcode][1];
$defaultUrl = empty(self::$errMap[$this->errcode][2]) ? 0 : self::$errMap[$this->errcode][2];
$jumpUrl = empty($jumpUrl) ? $defaultUrl : $jumpUrl;
} else {
$errmsg = self::$errMap[$this->errcode];
$isImportant = 0;
$jumpUrl = '';
}
}
$returnData = ["errcode" => $this->errcode, "errmsg" => $errmsg, 'data' => $data, 'isImportant' => $isImportant, 'jumpUrl' => $jumpUrl];
$isView = Router::$isView;
$isViewMuti = Router::$isViewMuti;
if (!$helper && $isView === false) {
ajaxReturn($returnData, "JSON", JSON_UNESCAPED_UNICODE);
} elseif (!$helper && $isView === true) {
//错误跳转
if ($returnData['errcode'] != 0 && $returnData['isImportant'] == 1) {
redirect(getHost() . $jumpUrl);
}
if ($isViewMuti) {
self::$viewDataTemp[self::$functionName] = $returnData;
} else {
self::$viewDataTemp = $returnData;
}
return;
}
return $returnData;
}
/**
*评论分页显示数据调用
*@param id 页面id。type 类型
*@author witner
*@version 2015年11月9日15:37:37
*@return
*/
public function commentlist()
{
//评论显示
$comment = M('comment');
$data['status'] = 1;
$type = trim(I('get.type'));
$id = trim(I('get.id'));
if (empty($type) || empty($id)) {
ajaxReturn(102, '参数错误', '');
}
$data['typeid'] = $type;
$data['pageid'] = $id;
//$commentlist = $comment->field('id,name,namehead,content,instime,')->where($data)->select();
$count = $comment->where($data)->count();
// 查询满足要求的总记录数
$Page = new \Think\Page($count, 5);
// 实例化分页类 传入总记录数和每页显示的记录数(25)
$show = $Page->show();
//分页显示输出
// 进行分页数据查询注意limit方法的参数要使用Page类的属性
$list = $comment->field('id,name,namehead,content,instime')->where($data)->order('instime desc')->limit($Page->firstRow . ',' . $Page->listRows)->select();
//$this->assign('lists',$list); //赋值数据集
// $this->assign('page',$show); //赋值分页输出
$page = ceil($count / 5);
if (false === $list) {
ajaxReturn(101, '请求失败，重新请求', '');
} else {
if (!$list) {
$list = array();
} else {
foreach ($list as $key => $value) {
$list[$key]['instime'] = date('Y/m/d H:i:s', $value['instime']);
}
}
$data = array('data' => $list, 'page' => $page);
ajaxReturn(0, '', $data);
}
}
