//管理员头像
$uRow = D('sub_user')->find(1);
$data['info']['head_pic'] = '/data/image_c/' . $uRow['head_pic'];
$data['info']['tid'] = (int) $_POST['tid'];
$data['info']['content'] = str_inmysql($_POST['content']);
$data['info']['name'] = '云姐';
$res = $replyTable->add($data);
if ($res) {
echo json_encode($res);
}
exit;
}
//数据删除
if ($_GET['action'] == 'del') {
$id = (int) $_GET['id'];
$res = $replyTable->del($id);
echo json_encode($res);
exit;
}
//根据ID查询帖子信息
$id = (int) $_GET['id'];
$vo = $postTable->find($_GET['id']);
//回复列表
$filter['where'] = " tid=" . $id;
$filter['order'] = " id desc ";
$data = $replyTable->paginate($filter, '*', $_GET['p'], 5);
//分页信息
$smarty->assign('page', $replyTable->pager($data['pager']));
$smarty->assign('vo', $vo);
$smarty->assign('replyArr', $data['data']);
$smarty->setTpl('task/templates/bbs_manage.html')->display();
include_once "../../includes/config.inc.php";
check_login();
//验证是否登录
$model = new Model_Subtable('sub_out');
//数据保存
if ($_REQUEST['a'] == 'add') {
if (method_is('post')) {
$data = $_POST;
$res = $model->add($data);
echo json_encode($res);
die;
} else {
$id = (int) $_GET['id'];
if ($id) {
$smarty->assign('vo', $model->find($id));
}
$smarty->setTpl('tx/templates/add.html')->display();
die;
}
}
//更改支付状态
if ($_REQUEST['a'] == 'kf') {
$data['info'][is_pay] = (int) $_GET['is_pay'];
$data['info'][id] = (int) $_GET['id'];
$res = $model->add($data);
echo $res;
die;
}
//数据删除
if ($_REQUEST['a'] == 'del') {
$locationRow = $locationModel->where("fromuser='******'fromuser'] . "'")->dataRow();
$data['info'][latitude] = $locationRow['latitude'];
$data['info'][longitude] = $locationRow['longitude'];
$res = $model->add($data);
$res ? die('suc') : die('err');
} else {
//苏州市下的区
$dmodel = new Model_Subtable('s_district');
$smarty->assign('darr', $dmodel->where("CityID=78")->order("DistrictId asc")->dataArr());
//一天24小时的数组
for ($i = 0; $i < 25; $i++) {
$i < 10 ? $hourArr[] = '0' . $i . ':00' : ($hourArr[] = $i . ':00');
}
$smarty->assign('hourArr', $hourArr);
if ($_GET['id']) {
$smarty->assign('vo', $model->find($_GET['id']));
}
$smarty->setLayout('')->setTpl('mobile/templates/task_add.html')->display();
die;
}
}
if ($_REQUEST['a'] == 'detail') {
$vo = $model->find($_GET['id']);
//浏览量+1
$seeData['info']['id'] = $_GET['id'];
$seeData['info']['see_num'] = $vo['see_num'] + 1;
$model->add($seeData);
//发布时间
$current_time = time();
//当前时间戳
$lc_time = strtotime(date('Y-m-d', $current_time) . " 00:00:00");
<?php
include_once "../../includes/config.inc.php";
$configModel = new Model_CustomerConfig();
$userModel = new Model_Subtable('sub_user');
//微信通道
if (method_is('post')) {
$dailyModel = new Model_Subtable('sub_daily');
$id = $_POST['content'];
$row = $dailyModel->find($id);
$content = $row['title'] . $row['content'] . "<a href='" . $row['a_link'] . "'>" . $row['a_title'] . "</a>";
$configModel->sendCustomerMsg($content, $_POST['fromuser']);
} else {
$dailyModel = new Model_Subtable('sub_daily');
$id = $_GET['id'];
$row = $dailyModel->find($id);
$content = $row['title'] . $row['content'] . "<a href='" . $row['a_link'] . "'>" . $row['a_title'] . "</a>";
$smarty->assign('content', $content);
$smarty->assign('id', $id);
$listArr = $userModel->field('fromuser')->where("username in ('15631183141','18013085978','13814812590','18351519983')")->dataArr();
$smarty->assign('list', $listArr);
$smarty->assign('listcount', count($listArr));
$smarty->setTpl('msg/templates/send_kf.html')->display();
die;
}
include_once "../../includes/config.inc.php";
check_login();
//验证是否登录
if ($_REQUEST['typenum'] == 1) {
$model = new Model_Subtable('sub_reply');
} else {
$model = new Model_Subtable('sub_pic_reply');
}
//数据保存
if ($_REQUEST['a'] == 'reply') {
if (method_is('post')) {
//管理员头像
$uRow = D('sub_user')->find('1');
$data['info']['head_pic'] = '/data/image_c/' . $uRow['head_pic'];
$id = $_POST['id'];
$talkRow = $model->find($id);
$data['info']['name'] = '云姐';
$data['info']['tomanname'] = $talkRow['name'];
$data['info']['content'] = $_POST['content'];
if ($_POST['typenum'] == '2') {
$data['info']['pid'] = $talkRow['pid'];
$data['info']['fromuser'] = 1;
$data['info']['tomanfromuser'] = $talkRow['fromuser'];
} else {
$data['info']['tid'] = $talkRow['tid'];
$data['info']['uid'] = 1;
$data['info']['tomanid'] = $talkRow['uid'];
}
$res = $model->add($data);
if ($res) {
echo json_encode($res);
$model = new Model_Subtable('sub_task');
$userModel = new Model_Subtable('sub_user');
if ($_REQUEST['a'] == 'send') {
if (!$_GET['tid'] || !$_GET['fromuser']) {
die;
}
$tid = $_GET['tid'];
$taskRow = $model->find($tid);
//发布方公司名
if ($taskRow['company_name']) {
$cname = $taskRow['company_name'];
} else {
if ($taskRow['uid'] == 1) {
$cname = '云客驿站';
} else {
$userRow = $userModel->find($taskRow['uid']);
$cname = $userRow['nickname'];
}
}
$configModel = new Model_CustomerConfig();
$configModel->sendCustomerMsg($cname . '发布了一个新职位：' . $taskRow['title'] . "，<a href='http://www.yunfanke.com/mobile/index.php?m=task&a=detail&id=" . $tid . "'>点击查看</a>", $_GET['fromuser']);
die;
}
if ($_REQUEST['a'] == 'send_msg_confirm') {
set_time_limit(0);
$configModel = new Model_CustomerConfig();
$tid = $_GET['tid'];
//职位信息
$taskModel = D('sub_task');
$taskRow = $taskModel->find($tid);
//确认过的报名人员
//数据修改
if ($_REQUEST['a'] == 'add') {
if (method_is('post')) {
$data = $_POST;
$data['info']['work_time'] = $data['work_date'] . ' ' . $data['work_hour'] . '-' . $data['work_hour_end'];
$data['info']['jihe_time'] = $data['jihe_date'] . ' ' . $data['jihe_hour'];
//截止时间戳
$data['info']['jiezhi_time'] = strtotime($data['str']['start_time'] . ' ' . $data['str']['start_hour'] . ':00');
$res = $model->add($data);
echo json_encode($res);
die;
} else {
$id = (int) $_GET['id'];
$vo = $model->find($id);
//发布方公司名
$userRow = $userModel->find($vo['uid']);
$vo['uname'] = $userRow['nickname'];
//苏州市下的区
$dmodel = new Model_Subtable('s_district');
$smarty->assign('darr', $dmodel->where("CityID=78")->order("DistrictId asc")->dataArr());
//一天24小时的数组
for ($i = 0; $i < 25; $i++) {
$i < 10 ? $hourArr[] = '0' . $i . ':00' : ($hourArr[] = $i . ':00');
}
$smarty->assign('hourArr', $hourArr);
if ($vo['work_time']) {
$work_time_row = explode(' ', $vo['work_time']);
}
if ($work_time_row[1]) {
$work_time_row2 = explode('-', $work_time_row[1]);
}
<?php
include_once "../includes/config.inc.php";
//判断登录
if (empty($_SESSION['tyuser'])) {
header("Location:./login.php");
die;
}
//当前登录用户信息
$userModel = new Model_Subtable('sub_user');
$userRow = $userModel->find($_SESSION['tyuser']['id']);
if ($userRow['type'] == 2) {
header("Location:index.php?m=user&a=user_index");
die;
} else {
header("Location:index.php?m=task&a=index");
die;
}
$data['info'][latitude] = $locationRow['latitude'];
$data['info'][longitude] = $locationRow['longitude'];
}
$res = $model->add($data);
$res ? die('suc') : die('err');
} else {
//苏州市下的区
$dmodel = new Model_Subtable('s_district');
$smarty->assign('darr', $dmodel->where("CityID=78")->order("DistrictId asc")->dataArr());
//一天24小时的数组
for ($i = 0; $i < 25; $i++) {
$i < 10 ? $hourArr[] = '0' . $i . ':00' : ($hourArr[] = $i . ':00');
}
$smarty->assign('hourArr', $hourArr);
if ($_GET['id']) {
$vo = $model->find($_GET['id']);
if ($vo['work_time']) {
$work_time_row = explode(' ', $vo['work_time']);
}
if ($work_time_row[1]) {
$work_time_row2 = explode('-', $work_time_row[1]);
}
$vo['work_date'] = $work_time_row[0];
$vo['work_hour'] = $work_time_row2[0];
$vo['work_hour_end'] = $work_time_row2[1];
if ($vo['jihe_time']) {
$jihe_time_row = explode(' ', $vo['jihe_time']);
}
$vo['jihe_date'] = $jihe_time_row[0];
$vo['jihe_hour'] = $jihe_time_row[1];
$smarty->assign('vo', $vo);
//ajax是否正常发放
if ($_REQUEST['a'] == 'refuse_js') {
$signModel = new Model_Subtable('sub_sign');
$data1['info']['id'] = $_POST['id'];
$data1['info']['is_js'] = $_POST['is_js'];
$signModel->add($data1);
die('suc');
}
//报名管理中间页
if ($_REQUEST['a'] == 'sign_mid') {
$signModel = new Model_Subtable('sub_sign');
//是否已结算
if (!$_GET['tid']) {
die('参数丢失');
}
$taskRow = $model->find($_GET['tid']);
if ($taskRow['is_js'] == 1) {
$listArr = $signModel->where("tid=" . $_GET['tid'])->dataArr();
if ($listArr) {
foreach ($listArr as $key => $value) {
$uRow = $userModel->find($value['uid']);
$listArr[$key]['nickname'] = $uRow['nickname'];
$uRow['sex'] == 1 ? $listArr[$key]['sex'] = '男' : ($listArr[$key]['sex'] = '女');
}
}
$smarty->assign('list', $listArr);
$smarty->assign('pay_type', $taskRow['pay_type']);
$smarty->setLayout('')->setTpl('mobile/templates/sign_index_js.html')->display();
die;
} elseif ($taskRow['jingli_queren'] == 1) {
$smarty->assign('info', '财务结算中...');
<?php
$model = new Model_Subtable('sub_job');
if ($_REQUEST['a'] == 'detail') {
$jobsignModel = new Model_Subtable('sub_jobsign');
$id = (int) $_GET['id'];
$vo = $model->find($id);
$smarty->assign('vo', $vo);
$row = $jobsignModel->where("jid='" . $id . "' and uid='" . $_SESSION['tyuser']['id'] . "'")->dataRow();
if ($row) {
//任务若已领取，去填表单
$smarty->setLayout('')->setTpl('mobile/templates/job_form.html')->display();
die;
} else {
//否则，去查看详情
$smarty->setLayout('')->setTpl('mobile/templates/job_detail.html')->display();
die;
}
}
//领取任务
if ($_REQUEST['a'] == 'lq') {
$jobsignModel = new Model_Subtable('sub_jobsign');
$data = array();
$data['info']['jid'] = (int) $_REQUEST['jid'];
$data['info']['uid'] = $_SESSION['tyuser']['id'];
$jobRow = $model->find($data['info']['jid']);
$row = $jobsignModel->where("jid='" . $data['info']['jid'] . "' and uid='" . $data['info']['uid'] . "'")->dataRow();
//已领取
if ($row) {
die('err');
} else {
if (method_is('post')) {
$id = $_POST['id'];
$userModel = new Model_Subtable('sub_user');
$userRow = $userModel->find($id);
$configModel = new Model_CustomerConfig();
$configModel->sendCustomerMsg($_POST['content'], $userRow['fromuser']);
}
die;
}
//生成大礼包优惠码
if ($_REQUEST['a'] == 'produce_code') {
if (method_is('post')) {
$data = array();
$id = $_POST['id'];
$userModel = new Model_Subtable('sub_user');
$userRow = $userModel->find($id);
$data['info']['id'] = $id;
$data['info']['code'] = substr(md5($userRow['username']), -6);
$userModel->add($data);
}
die;
}
//生成代理商编号
if ($_REQUEST['a'] == 'num_change') {
if (method_is('post')) {
if ($_POST['num'] != '') {
$r = $model->where("agent_num='" . $_POST['num'] . "'")->dataRow();
if ($r) {
die('cf');
}
}
$data1['info'][score] = $tjrScore + $uRow['score'];
$data1['info'][score_all] = $tjrScore + $uRow['score_all'];
$model->add($data1);
}
}
$res = $model->add($data);
echo $res;
die;
} else {
//苏州市下的区
$dmodel = new Model_Subtable('s_district');
$smarty->assign('darr', $dmodel->where("CityID=78")->order("DistrictId asc")->dataArr());
//微信头像
$memberModel = new Model_Member();
$smarty->assign('headPic', $memberModel->getPic($userRow['fromuser']));
$smarty->assign('vo', $model->find($userRow['id']));
$smarty->setLayout('')->setTpl('mobile/templates/user_add_personal.html')->display();
die;
}
}
//企业信息完善
if ($_REQUEST['a'] == 'user_add_company') {
if (method_is('post')) {
$data = $_POST;
$res = $model->add($data);
$res ? die('suc') : die('err');
} else {
//苏州市下的区
$dmodel = new Model_Subtable('s_district');
$smarty->assign('darr', $dmodel->where("CityID=78")->order("DistrictId asc")->dataArr());
//微信头像
<?php
include_once "../../includes/config.inc.php";
check_login();
//验证是否登录
$model = new Model_Subtable('sub_shop_goods');
$cateModel = new Model_Subtable('sub_shop_cate');
//数据保存
if ($_REQUEST['a'] == 'add') {
if (method_is('post')) {
$data = $_POST;
//删除原图
if ($data['num'][id]) {
$vo = $model->find($data['num'][id]);
if ($vo['pic'] != $data['info'][pic]) {
@unlink("../../data/image_c/" . $vo['pic']);
}
}
$res = $model->add($data);
echo json_encode($res);
die;
} else {
$id = (int) $_GET['id'];
if ($id) {
$smarty->assign('vo', $model->find($id));
}
//获取商品类别
$smarty->assign('cateList', $cateModel->dataArr());
$smarty->setTpl('shop/templates/goods_add.html')->display();
die;
}
$assignRow1 = $assignModel->where("tid='" . $value['id'] . "' and isnull(final_pic)")->dataRow();
if ($assignRow && empty($assignRow1)) {
$listArr[$key]['is_dudao'] = 1;
}
}
$smarty->assign('list', $listArr);
$smarty->assign('date', $date);
$smarty->setLayout('')->setTpl('mobile/templates/assign_task_index.html')->display();
die;
}
//任务分拨界面
if ($_REQUEST['a'] == 'main') {
$userModel = D('sub_user');
$tid = (int) $_GET['tid'];
//任务id
$vo = $model->find($tid);
$vo['title'] = cut_str($vo['title'], 15);
$smarty->assign('vo', $vo);
//工作日可出勤的督导
//$dudao_list=D('sub_user_ext')->where("group_id=2")->dataArr();
$dudao_list = D('sub_attend')->where("attend_date='" . substr($vo['work_time'], 0, 10) . "'")->dataArr();
foreach ($dudao_list as $k => $v) {
$row = $userModel->field('id,nickname,username')->where("id='" . $v['uid'] . "'")->dataRow();
$dudao_list[$k]['nickname'] = $row['nickname'];
}
$smarty->assign('dudao_list', $dudao_list);
//可指定的人员
$zhiding_list = D('sub_sign')->where("tid='{$tid}' and is_valid != 2")->dataArr();
foreach ($zhiding_list as $k => $v) {
$row = $userModel->field('id,nickname,username')->where("id='" . $v['uid'] . "'")->dataRow();
$zhiding_list[$k]['nickname'] = $row['nickname'];
if (method_is('post')) {
$data = $_POST;
$data['info'][uid] = $userRow['id'];
//获取该任务发布时的经纬度（手机端）
$locationModel = new Model_Subtable('member_location');
$locationRow = $locationModel->where("fromuser='******'fromuser'] . "'")->dataRow();
$data['info'][latitude] = $locationRow['latitude'];
$data['info'][longitude] = $locationRow['longitude'];
$res = $model->add($data);
$res ? die('suc') : die('err');
} else {
//省
$pmodel = new Model_Subtable('s_province');
$smarty->assign('parr', $pmodel->dataArr());
if ($_GET['id']) {
$smarty->assign('vo', $model->find($_GET['id']));
}
$smarty->setLayout('')->setTpl('mobile/templates/task_add.html')->display();
die;
}
}
if ($_REQUEST['a'] == 'detail') {
$vo = $model->find($_GET['id']);
$smarty->assign('vo', $vo);
//公司名称简介
$smarty->assign('uRow', $userModel->field('nickname,introduce')->where("id=" . $vo['uid'])->dataRow());
//已报名人数
$signModel = new Model_Subtable('sub_sign');
$signRow = $signModel->field('count(*) as countnum')->where("tid=" . $_GET['id'])->dataRow();
$smarty->assign('signNum', $signRow['countnum']);
//评论列表
if ($_REQUEST['a'] == 'add') {
$data = $_POST;
$res = $model->add($data);
echo json_encode($res);
die;
}
//详情
if ($_REQUEST['a'] == 'detail') {
$m = new Model_Subtable('sub_shop_odetail');
$id = (int) $_GET['id'];
$vo = $model->find($id);
//收货人信息
$pmodel = new Model_Subtable('s_province');
$cmodel = new Model_Subtable('s_city');
$dmodel = new Model_Subtable('s_district');
$shipRow = $shipModel->find($vo['shipid']);
$prow = $pmodel->where("ProvinceID=" . $shipRow['pid'])->dataRow();
$shipRow['pname'] = $prow['ProvinceName'];
$crow = $cmodel->where("CityID=" . $shipRow['cid'])->dataRow();
$shipRow['cname'] = $crow['CityName'];
$drow = $dmodel->where("DistrictID=" . $shipRow['did'])->dataRow();
$shipRow['dname'] = $drow['DistrictName'];
$smarty->assign('shipRow', $shipRow);
if ($id) {
$smarty->assign('vo', $vo);
$detailList = $m->where(" oid={$id} ")->dataArr();
foreach ($detailList as $key => $value) {
$detailList[$key] = unserialize($value['goods_row']);
$detailList[$key]['oid'] = $value['oid'];
$detailList[$key]['num'] = $value['num'];
$detailList[$key]['money'] = $value['money'];
$objPHPExcel->getActiveSheet()->getStyle('B2')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('C2')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('D2')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('E2')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('F2')->getFont()->setBold(true);
//数据库操作
include_once "../../includes/config.inc.php";
$submitModel = new Model_Subtable('sub_job_submit');
$id = (int) $_GET['id'];
$listArr = $submitModel->where(" jid='{$id}' ")->order('id desc')->dataArr();
if (!$listArr) {
die('无数据');
}
$userModel = new Model_Subtable('sub_user');
foreach ($listArr as $key => $value) {
$userRow = $userModel->find($value['uid']);
$listArr[$key]['uname'] = $userRow['nickname'];
$listArr[$key]['uphone'] = $userRow['username'];
$userRow['sex'] == 1 ? $listArr[$key]['usex'] = '男' : ($listArr[$key]['usex'] = '女');
}
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('A1', '提报列表' . date('Y-m-d H:i:s'));
foreach ($listArr as $lk => $lv) {
$lj = $lk + 3;
$objPHPExcel->getActiveSheet()->setCellValue('A' . $lj, $lv['uname'] . '/' . $lv['usex'] . '/' . $lv['uphone'])->setCellValue('B' . $lj, $lv['name'])->setCellValue('C' . $lj, $lv['carnum'] . ' ')->setCellValue('D' . $lj, $lv['phone'])->setCellValue('E' . $lj, $lv['license'])->setCellValue('F' . $lj, substr($lv['addtime'], 0, 10));
}
// Rename worksheet
$objPHPExcel->getActiveSheet()->setTitle('提报列表');
// Set active sheet index to the first sheet, so Excel opens this as the first sheet
$objPHPExcel->setActiveSheetIndex(0);
// Redirect output to a client’s web browser (Excel5)
header('Content-Type: application/vnd.ms-excel');
//管理员回复
if ($_GET['at']) {
$atArr = explode('___', $_GET['at']);
$data['str']['tomanfromuser'] = $atArr[0];
$data['str']['tomanname'] = $atArr[1];
}
if ($userRow['id'] == 1) {
$data['info']['name'] = '云姐';
$data['info']['head_pic'] = '/data/image_c/' . $userRow['head_pic'];
}
$res = $replyModel->add($data);
$res ? die('suc') : die('err');
}
}
if ($_REQUEST['a'] == 'detail') {
$vo = $model->find($_GET['id']);
//拉取个人注册信息里的昵称
if ($vo['fromuser']) {
$userModel = D('sub_user');
$userRow = $userModel->where("fromuser='******'fromuser'] . "'")->dataRow();
if ($userRow['nicheng']) {
$vo['name'] = $userRow['nicheng'];
}
}
$smarty->assign('vo', $vo);
//评论列表
$replyModel = new Model_Subtable('sub_pic_reply');
$replyList = $replyModel->where("pid=" . $_GET['id'])->order('id desc')->limit('5')->dataArr();
$smarty->assign('replyList', $replyList);
$smarty->setLayout('')->setTpl('mobile/templates/pic_detail.html')->display();
die;
