/** * 更新游戏信息 */ public function gupdateAction() { $id = reqnum('id', 0); $ispost = reqnum('ispost', 0); $m = new Psys_ResModel(); if ($ispost == 1) { $appname = reqstr('appname'); $appcol = reqstr('appcol'); $appid = reqstr('appid', ''); $appid = $appid ? $appid : $this->getmaxappidAction($appcol); $price = reqstr('price', 0); $downcount = reqstr('downcount', 0); $logourl = reqstr('logourl'); $appurl = reqstr('appurl'); $ver = reqstr('ver', 0); $vernum = reqstr('vernum'); $filesize = reqstr('filesize'); $apppackage = reqstr('package'); $apptype = reqstr('apptype'); $lang = reqstr('lang'); $iftj = reqstr('iftj'); $flag = reqstr('flag'); $adesc = reqstr('adesc'); $adetail = reqstr('adetail'); $typeinfo = reqstr('typeinfo'); $develop = reqstr('develop'); $sig = reqstr('sig'); $pptfilenames = reqstr('pptfilenames'); $pptiosnames = reqstr('pptios'); $sortid = reqnum('sortid', 0); //return array('result'=>$pptfilenames); //转ppt文件名连接成的字符串为数组 if (!empty($pptfilenames)) { $ppt = explode(';', $pptfilenames); } else { $ppt = array(); } if (!empty($pptiosnames)) { $pptios = explode(';', $pptiosnames); } else { $pptios = array(); } //$ext = strrchr($logourl,'.'); $ext = '.png'; $data = array('appname' => $appname, 'appid' => $appid, 'price' => $price, 'downcount' => $downcount, 'sortid' => $sortid, 'imgurl' => 'logo' . $ext, 'appurl' => $appurl, 'ver' => $ver, 'vernum' => $vernum, 'filesize' => $filesize, 'package' => $apppackage, 'appcol' => $appcol, 'apptype' => $apptype, 'lang' => $lang, 'iftj' => $iftj, 'flag' => $flag, 'adesc' => $adesc, 'adetail' => $adetail, 'signature' => $sig, 'ctime' => time(), 'utime' => time(), 'typeinfo' => $typeinfo, 'develop' => $develop); $result = array('result' => 'ERROR'); if ($logourl == '') { MsgInfoConst::GetMsg(1041, $result); return $result; } /* * // 判断APP是否存在 $where = array ( 'appid' => $appid ); $isexit = $m->GetOneGame ( $where ); if ($isexit || count ( $isexit ) > 0) { MsgInfoConst::GetMsg ( 1043, $result ); return $result; } */ if ($id == 0) { $m->AddGame($data); if ($apptype == 2) { $ppt = $pptios; } if (!empty($ppt)) { for ($i = 0; $i < count($ppt); $i++) { // APP对应PPT //$ext = '.png'; //$ext = strrchr($ppt[$i],'.'); $appimg = array('appid' => $appid, 'imgurl' => $ppt[$i], 'ctime' => time()); if (empty($appimg['imgurl'])) { break; } $res = $m->AddGamePPT($appimg); $m->Record($appimg, $res, 'db-rht_sync', 'appimg', 'rhs_downsync'); } } // start 写操作日志 $log = array('logtype' => 71, 'guid' => $_SESSION['Cur_X_User']['id'], 'ctime' => time(), 'cip' => real_ip()); $log['logdetail'] = $_SESSION['Cur_X_User']['username'] . "于" . date("Y-m-d H:i:s") . "[添加]APP" . $appname; $m->admin_syslog($log); $result['result'] = 'SUCCESS'; } else { $w = array('id' => $id); $data['utime'] = time(); //------------------------物理文件更新开始 //获取更新前数据信息 $oldData = $m->GetOneGame($w, 'imgurl,appurl'); if ($data['appcol'] == 1) { $dir = GAME_PATH; } else { $dir = APP_PATH; } $imgurlPath = $dir . '/' . $data['appid'] . '/' . $oldData['imgurl']; $appurlPath = $dir . '/' . $data['appid'] . '/' . $oldData['appurl']; if (file_exists($imgurlPath) && $data['imgurl'] != $oldData['imgurl']) { unlink($imgurlPath); } if (file_exists($appurlPath) && $data['appurl'] != $oldData['appurl']) { unlink($appurlPath); } //------------------------物理文件更新结束 $m->UpdateGame($data, $w); // 先删除PPT表里等于APPID的PPT $w = array('appid' => $appid); $m->DelOneGamePPT($w); for ($i = 0; $i < count($ppt); $i++) { // APP对应PPT //$ext = strrchr($ppt[$i],'.'); //$ext = '.png'; $appimg = array('appid' => $appid, 'imgurl' => $ppt[$i], 'ctime' => time()); if (empty($appimg['imgurl'])) { break; } $res = $m->AddGamePPT($appimg); $m->Record($appimg, $res, 'db-rht_sync', 'appimg', 'rhs_downsync'); } // start 写操作日志 $log = array('logtype' => 71, 'guid' => $_SESSION['Cur_X_User']['id'], 'ctime' => time(), 'cip' => real_ip()); $log['logdetail'] = $_SESSION['Cur_X_User']['username'] . "于" . date("Y-m-d H:i:s") . "[编辑]APP信息" . $appname; $m->admin_syslog($log); // end 日志 $result['result'] = 'SUCCESS'; } return $result; } }
/** * 更新广告位信息 */ public function updateAction() { $id = reqnum('id', 0); $ispost = reqnum('ispost', 0); $model = new Psys_AdsModel(); if ($ispost == 1) { //广告名 $adname = reqstr('adname'); //显示位置 $colid = reqnum('colid'); //显示系统 $adstype = reqstr('adstype', ''); //是否车站 $isstation = reqnum('isstation', 0); //状态 $flag = reqnum('flag', 0); //图片路径 $imgurl = reqstr('imgurl', ''); //访问路径 $actionurl = reqstr('actionurl', ''); //排序 $orderby = reqnum('orderby', 0); //链接ID $tjappid = reqnum('tjappid', 0); //有效期 $validity = strtotime(reqstr('validity', 0)); //广告描述 $addesc = reqstr('content', ''); //候车厅 $colstr = reqstr('colstr', ''); //根据ID获取app类型 $appmodel = new Psys_ResModel(); $where = array('id' => $tjappid); $app_data = $appmodel->GetOneGame($where); $tjapptype = $app_data ? $app_data['apptype'] : 0; //添加时间 $data = array('adname' => $adname, 'colid' => $colid, 'adstype' => $adstype, 'station' => $isstation, 'flag' => $flag, 'imgurl' => $imgurl, 'actionurl' => $actionurl, 'orderby' => $orderby, 'tjappid' => $tjappid, 'validity' => $validity, 'addesc' => $addesc, 'colstr' => $colstr, 'tjapptype' => $tjapptype, 'ctime' => time()); $result = array('result' => 'ERROR'); if ($imgurl == '') { MsgInfoConst::GetMsg(1041, $result); return $result; } if ($id == 0) { $returnid = $model->AddOne($data); $m = new Psys_ResModel(); $m->Record($data, $returnid, 'db-rht_sync', 'ads', 'rhs_downsync'); // start 写操作日志 $log = array('logtype' => 72, 'guid' => $_SESSION['Cur_X_User']['id'], 'ctime' => time(), 'cip' => real_ip()); $log['logdetail'] = $_SESSION['Cur_X_User']['username'] . "于" . date("Y-m-d H:i:s") . "[添加]广告位" . $adname; $model->admin_syslog($log); // end 日志 $result['result'] = 'SUCCESS'; } else { $w = array('id' => $id); $returnid = $model->UpdateOne($data, $w); $m = new Psys_ResModel(); $m->Record($data, $returnid, 'db-rht_sync', 'ads', 'rhs_downsync'); // start 写操作日志 $log = array('logtype' => 72, 'guid' => $_SESSION['Cur_X_User']['id'], 'ctime' => time(), 'cip' => real_ip()); $log['logdetail'] = $_SESSION['Cur_X_User']['username'] . "于" . date("Y-m-d H:i:s") . "[编辑]广告位" . $adname; $model->admin_syslog($log); // end 日志 $result['result'] = 'SUCCESS'; } if ($result['result'] == 'SUCCESS') { $file = dirname(dirname(dirname(dirname(dirname(__FILE__))))) . '/temp.txt'; $fp = fopen($file, 'w'); fwrite($fp, '1'); fclose($fp); } return $result; } }
public function importAction() { /*设置上传路径*/ define('INSTALL', str_replace('\\', '/', dirname(dirname(dirname(dirname(dirname(__FILE__))))))); $savePath = INSTALL . '/traindata_appui/imgs/video/Excel/'; $action = !empty($_GET['action']) ? trim($_GET['action']) : ''; $file = !empty($_GET['file']) ? trim($_GET['file']) : ''; if ($action == 'del') { $myfile = $savePath . $file; if (file_exists($myfile)) { if (unlink($myfile)) { echo '<script type="text/javascript">alert("删除成功;返回列表");window.location.href="/res/import";</script>'; exit; } echo '<script type="text/javascript">alert("删除失败;返回列表");window.location.href="/res/import";</script>'; exit; } else { echo '<script type="text/javascript">alert("文件不存在;返回列表");window.location.href="/res/import";</script>'; exit; } } elseif (!empty($_FILES['file_stu']['name']) or $action == 'import') { if ($action == 'import' and !empty($file)) { $file_name = $file; } elseif (!empty($_FILES['file_stu']['name'])) { $tmp_file = $_FILES['file_stu']['tmp_name']; $file_types = explode(".", $_FILES['file_stu']['name']); $file_type = $file_types[count($file_types) - 1]; /*判别是不是.xls文件,判别是不是excel文件*/ if (strtolower($file_type) != "xls") { $this->error('不是Excel文件,重新上传'); } if (!is_dir($savePath)) { mkdir($savePath, 0777, true); } /*以时间来命名上传的文件*/ $str = date('Ymdhis'); $file_name = $str . "." . $file_type; /*是否上传成功*/ if (!copy($tmp_file, $savePath . $file_name)) { $this->error('上传失败'); } } //echo $savePath . $file_name;exit; $res = $this->read($savePath . $file_name); /*对生成的数组进行数据库的写入*/ $errmsg = ''; $noimpor = ''; $okmsg = ''; $m = new Psys_ResModel(); foreach ($res as $k => $v) { if ($k > 1) { $data = array('vname' => $v['1'], 'cast' => $v['6'], 'direcotr' => $v['10'], 'runtimes' => $v['11'], 'hits' => $v['11'], 'price' => $v['14'], 'sectionnum' => $v['15'], 'vpath' => $v['2'], 'vimg' => $v['3'], 'parter' => $v['21'], 'sortid' => $v['18'], 'area' => $v['9'], 'colid' => $v['7'], 'vyear' => $v['8'], 'iftj' => $v['16'], 'flag' => $v['17'], 'vdesc' => $v['4'], 'vdetail' => $v['5'], 'ctime' => time()); echo '<pre>'; print_r($data); exit; $svl = $obj->GetOne(array('value' => $v[1]), '*', 'rhi_packvalue'); if (empty($svl)) { $result = $m->AddVideo($data); if (!$result) { $str = pring_r($data, true); $errmsg .= date('Y-m-d H:i:s') . $str . "\r\n"; } } else { $noimpor .= $v[1] . ':在数据库中已存在' . "\r\n"; } } } if ($noimpor) { $logpas = ERRLOG_PATH . 'video' . DIRECTORY_SEPARATOR . date('Ymd') . DIRECTORY_SEPARATOR; if (!is_dir($logpas)) { mkdir($logpas, 0777, true); } $log = $logpas . 'video_noimport.log'; $str = $noimpor . "\r\n"; error_log($str, 3, $log); } if ($errmsg) { $logpas = ERRLOG_PATH . 'video' . DIRECTORY_SEPARATOR . date('Ymd') . DIRECTORY_SEPARATOR; if (!is_dir($logpas)) { mkdir($logpas, 0777, true); } $log = $logpas . 'video_error.log'; $str = $errmsg . "\r\n"; error_log($str, 3, $log); } echo '<script>alert("导入成功,自动过滤从复数据!");window.location.href="/video/valuelist"</script>'; exit; } else { //开始运行 $files = $this->listDir($savePath); $this->smarty->assign('files', $files); $this->forward = "import"; } }
/** * 日期交易 */ public function dateListAction() { //var_dump($_POST);exit; global $G_X; $page = reqnum('page', 1); $pagesize = reqnum('pagesize', 10); $order = reqnum('order', 0); $ifsucc = reqnum('ifsucc', -1); //获取用户输入 $year = reqnum('year', 0); $month = reqnum('month', 0); $day = reqnum('day', 0); if (!$year || !$month || !$day) { $date = ''; } else { $date = $year . '-' . $month . '-' . $day; } if ($date == '') { $date = date('Y-m-d'); } $date = strtotime($date); //url拼接 $url = ''; $url .= '&date=' . $date; $url .= '&order=' . $order; $url .= '&ifsucc=' . $ifsucc; $model = new Psys_FinModel(); $list = $model->dateList($date, $order, $ifsucc, $page, $pagesize); //资源列表 $resModel = new Psys_ResModel(); foreach ($list['allrow'] as &$value) { $value['ctime'] = date('Y-m-d H:i:s', $value['ctime']); //下单时间格式转换 $value['cip'] = long2ip($value['cip']); //下单地址格式转换 if ($value['utime'] != '' || $value['uip'] != '') { $value['utime'] = date('Y-m-d H:i:s', $value['utime']); $value['uip'] = long2ip($value['uip']); } switch ($value['producttype']) { case 1: //视频 $value['producttype'] = $G_X['order_type']['video_type'][1]; $where = array('id' => $value['productid']); $result = $resModel->GetOneVideo($where); $value['productid'] = $result['vname']; break; case 2: //音乐 $value['producttype'] = $G_X['order_type']['music_type'][1]; $where = array('id' => $value['productid']); $result = $resModel->GetOne($where, 'mname', 'rhi_music'); $value['productid'] = $result['mname']; break; case 3: //游戏 $value['producttype'] = $G_X['order_type']['game_type'][1]; $where = array('id' => $value['productid']); $result = $resModel->GetOneGame($where); $value['productid'] = $result['appname']; break; case 4: //应用 $value['producttype'] = $G_X['order_type']['app_type'][1]; $where = array('id' => $value['productid']); $result = $resModel->GetOne($where, 'appname', 'rhi_apps'); $value['productid'] = $result['appname']; break; case 10: //美食 $value['producttype'] = $G_X['order_type']['food_type'][1]; $where = array('id' => $value['productid']); $result = $resModel->GetOne($where, 'fname', 'rhi_foodish'); $value['productid'] = $result['fname']; break; } } self::inidate($list['allnum'], $page, $pagesize, count($list['allrow'])); $this->smarty->assign('year', $year); $this->smarty->assign('month', $month); $this->smarty->assign('day', $day); $this->smarty->assign('order', $order); $this->smarty->assign('ifsucc', $ifsucc); $this->smarty->assign('url', $url); $this->smarty->assign('allnum', $list['allnum']); $this->smarty->assign('list', $list['allrow']); $this->forward = 'dateList'; }
/** * * 数据同步表写入 * @param int $id 类型ID * @param bool $isdel true 删除同步 false 更新同步 */ public function syncDb($id, $isdel) { //获取指定数据 $data = $this->GetOne(array('id' => $id), '*', 'rhi_apps'); if ($data['appcol'] == 1) { $type = 3; } else { $type = 4; } $typeid = $id; //选择数据库 $this->SetDb('db-rht_sync'); if ($isdel) { $method = 3; $data = array(); $oldData = json_encode($data); $syncData = array('type' => $type, 'typeid' => $typeid, 'method' => $method, 'dataInfo' => $oldData, 'flag' => 0, 'ctime' => time()); $num = $this->AddOne($syncData, 'rhs_sync'); if ($num) { return array('result' => 'SUCCESS'); } else { return array('result' => 'ERROR'); } } else { //更新同步 $oldData = json_encode($data); if ($data['utime']) { $method = 2; } else { $method = 1; } //数据写入 $syncData = array('type' => $type, 'typeid' => $typeid, 'method' => $method, 'dataInfo' => $oldData, 'flag' => 0, 'ctime' => time()); $num = $this->AddOne($syncData, 'rhs_sync'); if ($num) { $this->SetDb("db-rht_idc"); $model = new Psys_ResModel(); $data = array('unconfirm' => 0); $model->UpdateGame($data, array('id' => $id)); return array('result' => 'SUCCESS'); } else { return array('result' => 'ERROR'); } } }
/** * 添加 */ public function addAction() { $traintype = array('K' => '快速', 'Z' => '直达特快', '' => '其他', 'T' => '空调特快', 'D' => '动车组', 'G' => '高速动车'); $id = reqnum('id', 0); $ispost = reqnum('ispost', 0); $trainModel = new Psys_TrainModel(); $one = array(); if ($ispost == 1) { $rtn = array('result' => 'ERROR'); $one['trainno'] = reqstr('checi', ''); if ($one['trainno'] == '') { MsgInfoConst::GetMsg(2001, $rtn); return $rtn; } else { $one['trainno'] = str_ireplace("/", ",", trim($one['trainno'], ',')); $one['trainno'] = ',' . $one['trainno'] . ','; } $one['traintype'] = reqstr('leixin', ''); $one['bstation'] = reqstr('b_station', ''); $one['btime'] = str_ireplace(':', ':', reqstr('btime_station', '')); $one['estation'] = reqstr('e_station', ''); $one['etime'] = str_ireplace(':', ':', reqstr('etime_station', '')); $one['runtime'] = str_ireplace(':', ':', reqstr('runtime', '')); $one['price'] = reqstr('price', ''); $one['mileage'] = reqstr('mileage', ''); if ($id > 0) { $w = array('id' => $id); $res = $trainModel->UpdateOne($one, $w); $m = new Psys_ResModel(); $m->Record($one, $res, 'db-rht_sync', 'trainno', 'rhs_downsync'); } else { $res = $trainModel->AddOne($one); $m = new Psys_ResModel(); $m->Record($one, $res, 'db-rht_sync', 'trainno', 'rhs_downsync'); } $rtn['result'] = 'SUCCESS'; MsgInfoConst::GetMsg(2002, $rtn); return $rtn; } else { $one['trainno'] = ''; $one['traintype'] = ''; $one['bstation'] = ''; $one['btime'] = ''; $one['estation'] = ''; $one['etime'] = ''; $one['runtime'] = ''; $one['price'] = ''; $one['mileage'] = ''; } if ($id > 0) { $one = $trainModel->GetOne(array('id' => $id)); if (!$one) { $id = 0; } else { $one['trainno'] = str_ireplace(",", "/", trim($one['trainno'], ',')); } } $this->smarty->assign('one', $one); $this->smarty->assign('id', $id); $this->smarty->assign('traintype', $traintype); $this->forward = "add"; }