/**
* 默认方法
* @return {[type]} [description]
*/
public function indexAction()
{
die("Fas");
$ca = "额。。。";
// 测试
$str = <<<THEEND
<html>我爱你</html>{$ca}
<p>fasfas><fann_test_data
fdsf>f
THEEND;
echo deletehtml($str) . "<br />";
die("fa");
}
$condition[] = " cid=" . common_pg('cid') . " ";
}
if ($condition) {
$filter['where'] = implode('and', $condition);
}
//排序
$filter['order'] = " id desc ";
if ($_GET['order'] == 1) {
$filter['order'] = " outnum desc ";
}
if ($_GET['order'] == 2) {
$filter['order'] = " outnum asc ";
}
if ($_GET['order'] == 3) {
$filter['order'] = " clicknum desc ";
}
if ($_GET['order'] == 4) {
$filter['order'] = " clicknum asc ";
}
$data = $model->paginate($filter, '*', common_pg('p'), 10);
$listArr = $data['data'];
foreach ($listArr as $key => $value) {
$listArr[$key]['s_name'] = cut_str(deletehtml($value['name']), 15);
$cate_row = $cateModel->find($value['cid']);
$listArr[$key]['cname'] = $cate_row['name'];
}
//获取商品类别
$smarty->assign('cateList', $cateModel->findAll(" id>0 "));
$smarty->assign('list', $listArr);
$smarty->assign('page', $model->existPages($data['pager']));
$smarty->setTpl('app/hptshop/templates/goods_index.html')->display();
$pmodel = new Model_Subtable('s_province');
$smarty->assign('parr', $pmodel->dataArr());
$pageSize = 1;
//页大小
$p = (int) $_GET['p'] < 1 ? 1 : (int) $_GET['p'];
//当前页数
$limitStr = ($p - 1) * $pageSize . ',' . $pageSize;
//搜索条件
if ($_GET['did'] && $_GET['did'] != 'clear') {
$didWhere = " and did=" . $_GET['did'];
} else {
$didWhere = "";
}
$listArr = $model->where("sh_status=1 {$didWhere}")->order('id desc')->limit($limitStr)->dataArr();
foreach ($listArr as $key => $value) {
$listArr[$key]['title'] = cut_str(deletehtml($value['title']), 5);
//所在市 区
/* $cmodel=new Model_Subtable('s_city');
$crow=$cmodel->where("CityId=".$value['cid'])->dataRow(); */
$dmodel = new Model_Subtable('s_district');
$drow = $dmodel->where("DistrictId=" . $value['did'])->dataRow();
$listArr[$key]['addr'] = $drow['DistrictName'];
//所属公司
$urow = $userModel->find($value['uid']);
$listArr[$key]['nickname'] = $urow['nickname'];
}
if ($_GET['p']) {
if ($listArr) {
echo json_encode($listArr);
die;
} else {
function deletearticle($aids, $istrash = true)
{
global $_G;
if (empty($aids)) {
return false;
}
$trasharr = $article = $bids = $dels = $attachment = $attachaid = $catids = $pushs = array();
$query = C::t('portal_article_title')->fetch_all($aids);
foreach ($query as $value) {
$catids[] = intval($value['catid']);
$dels[$value['aid']] = $value['aid'];
$article[] = $value;
if (!empty($value['idtype'])) {
$pushs[$value['idtype']][] = $value['id'];
}
}
if ($dels) {
foreach ($article as $key => $value) {
if ($istrash) {
$trasharr[] = array('aid' => $value['aid'], 'content' => serialize($value));
} elseif ($value['pic']) {
pic_delete($value['pic'], 'portal', $value['thumb'], $value['remote']);
$attachaid[] = $value['aid'];
if ($value['madehtml'] && $value['htmldir'] && $value['htmlname']) {
deletehtml(DISCUZ_ROOT . '/' . $value['htmldir'] . $value['htmlname'], $value['contents']);
}
}
}
if ($istrash && $trasharr) {
C::t('portal_article_trash')->insert_batch($trasharr);
} else {
deletearticlepush($pushs);
deletearticlerelated($dels);
}
C::t('portal_article_title')->delete($dels);
C::t('common_moderate')->delete($dels, 'aid');
$catids = array_unique($catids);
if ($catids) {
foreach ($catids as $catid) {
$cnt = C::t('portal_article_title')->fetch_count_for_cat($catid);
C::t('portal_category')->update($catid, array('articles' => dintval($cnt)));
}
}
}
return $article;
}
function br_or_b($str)
{
$str = deletehtml($str);
$str = nl2br($str);
return str_replace(array("[b]", '[/b]', '||', '\\t\\n'), array("<b>", '</b>', '<br>', '<br>'), $str);
}
//删除原图
if ($res) {
@unlink("../../data/image_c/" . $vo['pic']);
}
echo json_encode($res);
die;
}
//评论列表
if ($_REQUEST['a'] == 'detail') {
$vo = $model->find($_GET['id']);
$smarty->assign('vo', $vo);
$replyModel = new Model_Subtable('sub_pic_reply');
$replyList = $replyModel->order('id desc')->limit('10')->dataArr();
$smarty->assign('replyList', $replyList);
$smarty->setLayout('')->setTpl('mobile/templates/pic_detail.html')->display();
die;
}
//数据列表
$filter['order'] = " is_up desc,up_time desc,id desc ";
$data = $model->paginate($filter, '*', common_pg('p'), 10);
$listArr = $data['data'];
$userModel = D('sub_user');
foreach ($listArr as $key => $value) {
$listArr[$key]['introduce'] = cut_str(deletehtml($value['introduce']), 20);
//发布人
$userRow = $userModel->where("fromuser='******'fromuser'] . "'")->dataRow();
$listArr[$key]['faburen'] = $userRow['nickname'] . '-' . $userRow['nicheng'] . '-' . $userRow['username'];
}
$smarty->assign('list', $listArr);
$smarty->assign('page', $model->pager($data['pager']));
$smarty->setTpl('pic/templates/pic_index.html')->display();
public function daochu()
{
ini_set('display_errors', FALSE);
date_default_timezone_set('Europe/London');
if (PHP_SAPI == 'cli') {
die('This example should only be run from a Web Browser');
}
require_once '../home/task/Classes/PHPExcel.php';
$objPHPExcel = new PHPExcel();
$objPHPExcel->getProperties()->setCreator("Maarten Balliauw")->setLastModifiedBy("Maarten Balliauw")->setTitle("Office 2007 XLSX Test Document")->setSubject("Office 2007 XLSX Test Document")->setDescription("Test document for Office 2007 XLSX, generated using PHP classes.")->setKeywords("office 2007 openxml php")->setCategory("Test result file");
// Add some data
$objPHPExcel->getActiveSheet()->getColumnDimension('B')->setWidth(20);
$objPHPExcel->getActiveSheet()->getColumnDimension('C')->setWidth(30);
$objPHPExcel->getActiveSheet()->getColumnDimension('E')->setWidth(30);
I('get.type') ? $lie_title = '职位' : ($lie_title = '类别');
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('A2', '姓名')->setCellValue('B2', '手机号')->setCellValue('C2', $lie_title)->setCellValue('D2', '金额(元)')->setCellValue('E2', '时间');
$objPHPExcel->getActiveSheet()->getStyle('A1')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('A2')->getFont()->setBold(true);
$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);
//数据库操作
$model = D($this->moduleName);
$userModel = M('SubUser');
$taskModel = M('SubTask');
if (I('get.type') == 'zzrj') {
$type_str = "type in (0,3) and ";
} else {
if (I('get.type') == 'zfsqf') {
$type_str = "type=4 and ";
} else {
if (I('get.type') == 'thsqf') {
$type_str = "type=5 and ";
}
}
}
$where_str = $type_str . "(addtime > '" . I('get.start_date') . " 00:00:00' and addtime < '" . I('get.end_date') . " 23:59:59')";
$title = I('get.start_date') . '至' . I('get.end_date') . '总额';
$listArr = $model->where($where_str)->order('id desc')->select();
$sum_row = $model->field("sum(money) as sum_money")->where($where_str)->find();
if (empty($listArr)) {
die('无数据');
}
$title .= $sum_row['sum_money'] . '元';
if (!I('get.type')) {
$title = I('get.start_date') . '至' . I('get.end_date');
}
foreach ($listArr as $key => $value) {
if ($value['money'] < 0) {
$listArr[$key]['money'] = 0 - $value['money'];
}
$uRow = $userModel->find($value['uid']);
$listArr[$key]['username'] = $uRow['username'];
$listArr[$key]['nickname'] = $uRow['nickname'];
//职位
$taskRow = $taskModel->field('id,title,addtime')->find($value['desc']);
if ($taskRow) {
$listArr[$key]['title'] = cut_str(deletehtml($taskRow['title']), 15) . '-' . substr($taskRow['addtime'], 0, 10);
}
if (!I('get.type')) {
//金额变动方式
$typeArr = get_money_type();
$listArr[$key]['title'] = $typeArr[$value['type']];
}
}
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('A1', $title);
foreach ($listArr as $lk => $lv) {
$lj = $lk + 3;
$objPHPExcel->getActiveSheet()->setCellValue('A' . $lj, $lv['nickname'])->setCellValue('B' . $lj, $lv['username'])->setCellValue('C' . $lj, $lv['title'])->setCellValue('D' . $lj, $lv['money'])->setCellValue('E' . $lj, $lv['addtime']);
}
// 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 (I('get.type') == 'zzrj') {
$file_name = '转账日结';
} else {
if (I('get.type') == 'zfsqf') {
$file_name = '支付申请费';
} else {
if (I('get.type') == 'thsqf') {
$file_name = '退还申请费';
}
}
}
header('Content-Disposition: attachment;filename="' . $title . $file_name . '.xls"');
header('Cache-Control: max-age=0');
// If you're serving to IE 9, then the following may be needed
header('Cache-Control: max-age=1');
// If you're serving to IE over SSL, then the following may be needed
header('Expires: Mon, 26 Jul 1997 05:00:00 GMT');
// Date in the past
header('Last-Modified: ' . gmdate('D, d M Y H:i:s') . ' GMT');
// always modified
header('Cache-Control: cache, must-revalidate');
// HTTP/1.1
header('Pragma: public');
// HTTP/1.0
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
$objWriter->save('php://output');
exit;
}
$existsCount = $_GET['existsCount'];
$dataCount = $_GET['dataCount'];
foreach ($linksList['link'] as $k => $v) {
if (in_array(getextension($v), $configIgnoreExt)) {
continue;
} else {
$link =& $v;
$sqlSearch = 'SELECT id ';
$sqlSearch .= 'FROM ' . TB_LINKS . ' ';
$sqlSearch .= 'WHERE url = \'' . $link . '\' ';
$sqlSearch .= 'Limit 1';
$rs = $db->query($sqlSearch);
if (!$rs->next_record()) {
++$dataCount;
$dataFids['id'] = '';
$dataFids['title'] = deletehtml(addslashes($linksList['title'][$k]));
$dataFids['url'] = addslashes(str_replace('&', '&', $link));
$dataFids['rules'] = $_GET['ID'];
$dataFids['date'] = strtotime(date('Y-m-d H:i:s'));
$sql = $NBS->add($dataFids);
$db->update($sql);
continue;
} else {
++$existsCount;
continue;
}
continue;
}
}
$finishBaseURL = '?module=collectionLink&action=finish&ID=' . $_GET['ID'];
$nextAlertTitle = '继续采集...';
$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'];
$detailList[$key]['name'] = cut_str(deletehtml($detailList[$key]['name']), 10);
}
$smarty->assign('detailList', $detailList);
}
$smarty->setTpl('shop/templates/order_add.html')->display();
die;
}
//数据列表
$condition = array();
$filter = array();
if ($_GET['keywords']) {
$condition[] = " id=" . common_pg('keywords') . " ";
}
if ($condition) {
$filter['where'] = implode('and', $condition);
}
//购物车列表
if ($_REQUEST['a'] == 'index') {
$listArr = array();
$totalNum = 0;
//商品数量
$totalMoney = 0;
//总价
$numArr = $_SESSION['trolley'];
$goodsModel = new Model_ApplistHptShopGoods();
if ($numArr) {
foreach ($numArr as $key => $value) {
$listArr[$key]['id'] = $key;
$listArr[$key]['num'] = $value['num'];
//获取商品信息
$vo = $goodsModel->find($key);
$listArr[$key]['name'] = cut_str(deletehtml($vo['name']), 10);
$listArr[$key]['pic'] = $vo['pic'];
$listArr[$key]['fact_price'] = round($vo['fact_price'] * $discount, 2);
$listArr[$key]['money'] = $listArr[$key]['fact_price'] * $value['num'];
$totalNum++;
//商品数量
$totalMoney += $listArr[$key]['money'];
//总价
}
} else {
$smarty->assign('info', '您尚未购买商品');
$smarty->setLayout('')->setTpl('mobile/templates/no_data.html')->display();
die;
}
$smarty->assign('list', $listArr);
$smarty->assign('totalNum', $totalNum);
public function getSingle()
{
$infocommonModel = new Model_InfoCommon();
$filter['where'] = " id='{$this->info_id}' and customer_id='{$this->customer_id}' and state='1' ";
$sql = $infocommonModel->select($filter);
$inforesult = $infocommonModel->fetchRow($sql);
$sql = "update info_common set push_num=push_num+1 where id='{$this->info_id}' and customer_id='{$this->customer_id}' limit 1";
$infocommonModel->query($sql);
$data['msgtype'] = 'news';
$data['title'] = $inforesult['info_title'];
$data['info_intro'] = $inforesult['info_intro'];
$data['description'] = $inforesult['info_desc'] != '' ? $inforesult['info_desc'] : cut_str(deletehtml($data['info_intro']), 80, $start = 0, $code = 'UTF-8');
$data['picurl'] = 'http://' . $_SERVER['HTTP_HOST'] . "/data/image_c/" . $inforesult['info_pic'];
$data['url'] = $inforesult['info_url'];
if (!$data['url']) {
$data['url'] = 'http://' . $_SERVER['HTTP_HOST'] . "/mobile/info.php?t=single&id=" . $inforesult['id'];
} else {
//关键词有外链时
if (strstr($data['url'], "?")) {
$data['url'] = $data['url'] . "&fromuser="******"&sign=" . $this->timesign;
} else {
$data['url'] = $data['url'] . "?fromuser="******"&sign=" . $this->timesign;
}
return $data;
}
}
if ($_GET['clicknum']) {
$order = " clicknum desc ";
}
if ($_GET['outnum']) {
$order = " outnum desc ";
}
//分页
$pageSize = 10;
//页大小
$p = (int) $_GET['p'] < 1 ? 1 : (int) $_GET['p'];
//当前页数
$limitStr = ($p - 1) * $pageSize . ',' . $pageSize;
$listArr = $model->where($where)->order($order)->limit($limitStr)->dataArr();
foreach ($listArr as $key => $value) {
$listArr[$key]['name'] = cut_str(deletehtml($value['name']), 10);
$listArr[$key]['content'] = cut_str(deletehtml($value['content']), 25);
$listArr[$key]['fact_price'] = round($value['fact_price'] * $discount, 2);
}
if ($_GET['p']) {
if ($listArr) {
echo json_encode($listArr);
die;
} else {
echo json_encode('err');
die;
}
} else {
//购物车数量
$numArr = $_SESSION['trolley'];
if ($numArr) {
foreach ($numArr as $key => $value) {
$rs->get('multi_intro') == 2 ? $areaMulti['intro'] = 1 : ($areaMulti['intro'] = 2);
$rs->get('enter_title') == 0 ? $areaFormat['title'] = 1 : ($areaFormat['title'] = 2);
$rs->get('enter_body') == 0 ? $areaFormat['body'] = 1 : ($areaFormat['body'] = 2);
$rs->get('enter_body_page') == 0 ? $areaFormat['body_page'] = 1 : ($areaFormat['body_page'] = 2);
$rs->get('enter_body_page_link') == 0 ? $areaFormat['body_page_link'] = 1 : ($areaFormat['body_page_link'] = 2);
$rs->get('enter_author') == 0 ? $areaFormat['author'] = 1 : ($areaFormat['author'] = 2);
$rs->get('enter_from') == 0 ? $areaFormat['from'] = 1 : ($areaFormat['from'] = 2);
$rs->get('enter_intro') == 0 ? $areaFormat['intro'] = 1 : ($areaFormat['intro'] = 2);
$bodyPageType = $rs->get('body_page_type');
$method = 'GET';
$param['cookie'] = $rs->get('cookies');
//
$referer = $rs->get('referer');
$useragent = $rs->get('useragent');
$replaceRNT = $rs->get('replaceRNT');
$NC = new NEAT_COLLECTOR();
$NIA = new NEAT_IMPORT_ARTICLE($NC);
$articleData = $NIA->getArticle($fullURL, $tag, $area, $areaMulti, $areaFormat, $method, $param, $bodyPageType, $referer, $useragent, $replaceRNT);
$tp->set_templatefile('templates/import_view.html');
$tp->assign('title', deletehtml($articleData['title']));
$tp->assign('date', date('Y年m月d日'));
$tp->assign('body', $articleData['body']);
$tp->assign('author', $articleData['author']);
$tp->assign('from', $articleData['from']);
$tp->assign('intro', $articleData['intro']);
$tp->assign('url', $shortURL);
$tp->assign('fullURL', $fullURL);
$moduleTemplate = $tp->result();
$moduleTitle = $articleData['title'];
}
}
$tag['title'] = '[标题]';
$area['links'] = $rs->get('area_link');
$rs->get('multi_link') == 1 ? $areaMulti = 1 : ($areaMulti = 2);
$rs->get('enter_link') == 0 ? $areaFormat = 1 : ($areaFormat = 2);
$linksList = $NIA->getLinks($fullURL, $tag, $area, $areaMulti, $areaFormat, $method, $param, $rs->get('link_replace'), $referer, $useragent, $replaceRNT);
$i = 0;
$report['none']['title'] = 0;
$report['have']['title'] = 0;
$report['none']['link'] = 0;
$report['have']['link'] = 0;
if (!empty($linksList['link'])) {
foreach ($linksList['link'] as $k => $v) {
if (in_array(getextension($v), $configIgnoreExt)) {
continue;
} else {
$title = deletehtml($linksList['title'][$k]);
if (60 < strlen($title)) {
$title = m_substr($title, 0, 60) . chr(0) . '...';
}
$list['list'][$i]['title'] = $title;
if (60 < strlen($v)) {
$list['list'][$i]['link'] = c_substr($v, 0, 60) . '...';
} else {
$list['list'][$i]['link'] = str_replace('&', '&', $v);
}
$list['list'][$i]['fulllink'] = $v;
$list['list'][$i]['getLink'] = rawurlencode(str_replace('&', '&', $v));
$list['list'][$i]['rules'] = $_GET['ID'];
++$i;
if ($linksList['title'][$k] == '') {
++$report['none']['title'];
if ($feRow) {
die('err');
} else {
$data['info'][type] = 2;
$data['info'][pid] = $pid;
$data['info'][fromuser] = $_SESSION['picuser']['fromuser'];
$feModel->add($data);
//鸡蛋数+1
$model->query("update sub_pic set `enum`=`enum`+1 where id={$pid}");
die('suc');
}
}
if ($_REQUEST['a'] == 'index') {
$list = $model->order('is_up desc,up_time desc,id desc')->dataArr();
foreach ($list as $key => $value) {
$list[$key]['introduce'] = cut_str(deletehtml($value['introduce']), 15);
}
$smarty->assign('list', $list);
$smarty->setLayout('')->setTpl('mobile/templates/pic_index.html')->display();
die;
}
//评论
if ($_REQUEST['a'] == 'reply') {
$replyModel = new Model_Subtable('sub_pic_reply');
if ($_GET['pid'] && $_GET['content']) {
$memberModel = new Model_Member();
$data['num']['pid'] = $_GET['pid'];
$data['info']['fromuser'] = $_SESSION['picuser']['fromuser'];
$data['info']['name'] = $_SESSION['picuser']['nickname'];
$data['info']['head_pic'] = $_SESSION['picuser']['headimgurl'];
$data['str']['content'] = $_GET['content'];
