/** * 默认方法 * @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'];