inputAction.php 39 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234
  1. <?php
  2. class inputAction extends Action
  3. {
  4. public $mid = 0;
  5. public $flow;
  6. public $rs = array();
  7. public $gongsiarr,$actclss,$fieldarrall,$inputobj,$subfielsa,$checkobj,$mdb;
  8. public function initAction()
  9. {
  10. /*
  11. $aid = (int)$this->get('adminid');
  12. $token = $this->get('token');
  13. $uid = m('login')->autologin($aid, $token);
  14. $this->getlogin();
  15. $this->loginnot();*/
  16. }
  17. private $fieldarr = array();
  18. private $ismobile = 0;
  19. protected $moders = array();
  20. //保存前处理,主要用于判断是否可以保存
  21. protected function savebefore($table,$arr, $id, $addbo){}
  22. //保存后处理,主要用于判断是否可以保存
  23. protected function saveafter($table,$arr, $id, $addbo){}
  24. //生成列表页,数据读取前处理
  25. protected function storebefore($table){}
  26. //生成列表页,数据读取后处理
  27. protected function storeafter($table, $rows){}
  28. //过滤html代码
  29. private function xxsstolt($uaarr)
  30. {
  31. foreach($uaarr as $k=>$v){
  32. $vss = strtolower($v);
  33. if(contain($vss, '<script')){
  34. $uaarr[$k] = str_replace(array('<','>'),array('&lt;','&gt;'), $v);
  35. }
  36. }
  37. return $uaarr;
  38. }
  39. /**
  40. * 录入的保存
  41. */
  42. public function saveAjax()
  43. {
  44. $id = (int)$this->request('id');
  45. $modenum = $this->request('sysmodenum');
  46. $uid = $this->adminid;
  47. $this->flow = m('flow')->initflow($modenum);
  48. $this->moders = $this->flow->moders;
  49. $modeid = $this->moders['id'];
  50. $isflow = (int)$this->moders['isflow'];
  51. $flownum = $this->moders['num'];
  52. $table = $this->moders['table'];
  53. $sysisturn = (int)$this->post('istrun','1');
  54. $this->checkobj = c('check');
  55. if($this->isempt($table))$this->backmsg('模块未设置表名');
  56. $fieldsarr = array();
  57. $fiexar = $this->flow->flowfieldarr($this->flow->fieldsarra, 2);
  58. foreach($fiexar as $k2=>$rs2)if($rs2['islu']==1)$fieldsarr[]=$rs2;
  59. if(!$fieldsarr)$this->backmsg('没有录入元素');
  60. $db = m($table);$subna = '提交';$addbo = false;$where = "`id`='$id'"; $oldrs = false;
  61. $this->mdb = $db;
  62. if($id==0){
  63. $where = '';
  64. $addbo = true;
  65. $isadd = m('view')->isadd($modeid, $uid);
  66. if(!$isadd)$this->backmsg('无权添加['.$this->moders['name'].']的数据1;');
  67. }else{
  68. $oldrs = $db->getone($id);
  69. if(!$oldrs)$this->backmsg('记录不存在');
  70. $this->flow->loaddata($id);
  71. if(!$this->flow->iseditqx())
  72. $this->backmsg('无权编辑['.$this->moders['name'].']的数据;');
  73. if($isflow>0){
  74. if($oldrs['uid']==$uid || $oldrs['optid']==$uid || $this->flow->floweditother){
  75. }else{
  76. //$this->backmsg('不是你提交/申请的单据,不允许编辑');
  77. }
  78. if($oldrs['status']==1)$this->backmsg('单据已审核完成,不允许编辑');
  79. }
  80. $subna = '编辑';
  81. }
  82. if($oldrs)$this->rs = $oldrs;
  83. $uaarr = $farrs = array();
  84. $lvls = array('text','textarea','ditumap');
  85. foreach($fieldsarr as $k=>$rs){
  86. $fid = $rs['fields'];
  87. $fi1 = substr($fid, 0, 5);
  88. if($fi1=='temp_' || $fi1=='base_')continue;
  89. $val = $this->post($fid);
  90. if($rs['isbt']==1 && isempt($val))$this->backmsg(''.$rs['name'].'不能为空');
  91. $msy = $this->attrcheck($val, arrvalue($rs, 'attr'), $this->checkobj);
  92. if($msy)$this->backmsg(''.$rs['name'].''.$msy.'');
  93. if(in_array($rs['fieldstype'], $lvls))$val = htmlspecialchars($val);
  94. $uaarr[$fid] = $val;
  95. $farrs[$fid] = array('name' => $rs['name']);
  96. }
  97. //人员选择保存的
  98. foreach($fieldsarr as $k=>$rs){
  99. if(substr($rs['fieldstype'],0,6)=='change'){
  100. if(!$this->isempt($rs['data'])){
  101. $fid = $rs['data'];
  102. if(isset($uaarr[$fid]))continue;
  103. $val = $this->post($fid);
  104. if($rs['isbt']==1&&$this->isempt($val))$this->backmsg(''.$rs['name'].'id不能为空');
  105. $uaarr[$fid] = $val;
  106. $farrs[$fid] = array('name' => $rs['name'].'id');
  107. }
  108. }
  109. if($rs['fieldstype']=='num'){
  110. $fid = $rs['fields'];
  111. if($this->flow->rows("`$fid`='{$uaarr[$fid]}' and `id`<>$id")>0)$uaarr[$fid]=$this->flow->createbianhao($rs['data'], $fid);
  112. }
  113. if($rs['fieldstype']=='uploadfile'){
  114. $_val= arrvalue($uaarr, $rs['fields']);
  115. if(!isempt($_val))$this->otherfileid.=','.$_val.'';
  116. }
  117. if($rs['fieldstype']=='graph'){
  118. $_val= arrvalue($uaarr, $rs['fields']);
  119. if($_val)$uaarr[$rs['fields']] = c('input')->createqianming($_val);
  120. }
  121. }
  122. //默认字段保存
  123. $allfields = $this->db->getallfields('[Q]'.$table.'');
  124. if(in_array('optdt', $allfields))$uaarr['optdt'] = $this->now;
  125. if(in_array('optid', $allfields))$uaarr['optid'] = $this->adminid;
  126. if(in_array('optname', $allfields))$uaarr['optname'] = $this->adminname;
  127. if(in_array('uid', $allfields) && $addbo){
  128. $uaarr['uid'] = $this->post('uid', $this->adminid);
  129. }
  130. if(isset($uaarr['uid'])){
  131. $urs = $this->flow->adminmodel->getone($uaarr['uid']);
  132. in_array('applyname', $allfields) and $uaarr['applyname'] = $urs['name'];
  133. in_array('applydeptname', $allfields) and $uaarr['applydeptname'] = $urs['deptname'];
  134. }
  135. if(in_array('applydt', $allfields) && $id==0)
  136. $uaarr['applydt'] = $this->post('applydt', $this->date);
  137. if($addbo){
  138. if(in_array('createdt', $allfields))$uaarr['createdt'] = $this->now;
  139. if(in_array('adddt', $allfields))$uaarr['adddt'] = $this->now;
  140. if(in_array('createid', $allfields))$uaarr['createid'] = $this->adminid;
  141. if(in_array('createname', $allfields))$uaarr['createname'] = $this->adminname;
  142. }
  143. //保存公司的
  144. if(in_array('comid', $allfields)){
  145. if($addbo)$uaarr['comid'] = m('admin')->getcompanyid();
  146. if(arrvalue($oldrs,'comid')=='0')$uaarr['comid'] = m('admin')->getcompanyid();
  147. }
  148. if($isflow>0){
  149. $uaarr['status']= '0';
  150. if($sysisturn==0){
  151. $uaarr['isturn']= '0';
  152. $subna = '保存';
  153. }
  154. }else{
  155. if(in_array('status', $allfields))$uaarr['status'] = (int)$this->post('status', '1');
  156. if(in_array('isturn', $allfields))$uaarr['isturn'] = (int)$this->post('isturn', '1');
  157. }
  158. //保存条件的判断
  159. foreach($fieldsarr as $k=>$rs){
  160. $ss = '';
  161. if(isset($uaarr[$rs['fields']]))$ss = $this->flow->savedatastr($uaarr[$rs['fields']], $rs, $uaarr);
  162. if($ss!='')$this->backmsg($ss);
  163. }
  164. //判断保存前的
  165. $ss = '';
  166. $befa = $this->savebefore($table, $this->getsavenarr($uaarr, $oldrs), $id, $addbo);
  167. $notsave= array();//不保存的字段
  168. if(is_string($befa)){
  169. $ss = $befa;
  170. }else{
  171. if(isset($befa['msg']))$ss=$befa['msg'];
  172. if(isset($befa['rows'])){
  173. if(is_array($befa['rows']))foreach($befa['rows'] as $bk=>$bv)$uaarr[$bk]=$bv;
  174. }
  175. if(isset($befa['notsave'])){
  176. $notsave=$befa['notsave'];
  177. if(is_string($notsave))$notsave = explode(',', $notsave);
  178. }
  179. }
  180. if(!$this->isempt($ss))$this->backmsg($ss);
  181. //不保存字段过滤掉
  182. if(is_array($notsave))foreach($notsave as $nofild)if(isset($uaarr[$nofild]))unset($uaarr[$nofild]);
  183. $uaarr = $this->xxsstolt($uaarr);//过滤特殊文字
  184. foreach($uaarr as $kf=>$kv){
  185. if(!in_array($kf, $allfields)){
  186. $this->backmsg('模块主表['.$this->flow->mtable.']上字段['.$kf.']不存在');
  187. }
  188. }
  189. //isonly唯一值的判断
  190. foreach($fieldsarr as $k=>$rs){
  191. $fiesd = $rs['fields'];
  192. if($rs['isonly']=='1' && isset($uaarr[$fiesd])){
  193. $dval = $uaarr[$fiesd];
  194. if(!isempt($dval)){
  195. if($db->rows("`id`<>'$id' and `$fiesd`='$dval'")>0)$this->backmsg(''.$rs['name'].'['.$dval.']已存在了');
  196. }
  197. }
  198. }
  199. //判断子表的
  200. $tabless = $this->moders['tables'];
  201. $tablessa = array();
  202. if(!isempt($tabless))$tablessa = explode(',', $tabless);
  203. if($tablessa)foreach($tablessa as $zbx=>$zbtab){
  204. if($zbtab){
  205. $this->getsubtabledata($zbx);
  206. if($this->subtabledata_msg)$this->backmsg($this->subtabledata_msg);
  207. }
  208. }
  209. $bo = $db->record($uaarr, $where);;
  210. if(!$bo)$this->backmsg($this->db->lasterror());
  211. if($id==0)$id = $this->db->insert_id();
  212. $fobj = m('file');
  213. $fobj->addfile($this->post('fileid'), $table, $id, $modenum);
  214. if($this->otherfileid!=''){
  215. $ofid1 = substr($this->otherfileid,1);
  216. $fobj->addxuan($ofid1,$this->post('sxuanfileid'),''.$modenum.'|'.$id.'');
  217. $fobj->addfile($ofid1, '', $id, $modenum);
  218. }
  219. $newrs = $db->getone($id);
  220. $this->companyid = isset($newrs['companyid']) ? (int)$newrs['companyid'] : (int)arrvalue($newrs, 'comid', '0');
  221. if($this->companyid==0)$this->companyid = m('admin')->getcompanyid();
  222. //保存多行子表
  223. if($tablessa)foreach($tablessa as $zbx=>$zbtab){
  224. if($zbtab)$this->savesubtable($zbtab, $id, $zbx, $addbo);
  225. }
  226. //保存后处理
  227. $this->saveafter($table,$this->getsavenarr($uaarr, $oldrs), $id, $addbo);
  228. if($addbo)c('cache')->del('tempdata_'.$modenum.'_'.$this->adminid.'');//删除暂存
  229. //保存修改记录
  230. $editcont = '';
  231. if($oldrs){
  232. $newrs = $db->getone($id);
  233. $editcont = m('edit')->recordsave($farrs, $table, $id, $oldrs, $newrs);
  234. }
  235. $msg = '';
  236. $this->flow->editcont = $editcont;
  237. $this->flow->loaddata($id, false);
  238. $this->flow->submit($subna);
  239. $this->backmsg('', $subna, $id);
  240. }
  241. //格式的判断
  242. private function attrcheck($val, $attr, $checkobj)
  243. {
  244. if(!isempt($val) && !isempt($attr)){
  245. if(contain($attr, 'email') && !$checkobj->isemail($val))return '必须是邮箱格式';
  246. if(contain($attr, 'mobile') && !$checkobj->iscnmobile($val))return '必须是11位手机号';
  247. if(contain($attr, 'onlyen') && $checkobj->isincn($val))return '不能有中文';
  248. if(contain($attr, 'onlycn') && !$checkobj->isincn($val))return '必须包含中文';
  249. if(contain($attr, 'number') && !$checkobj->isnumber($val))return '必须是数字';
  250. if(contain($attr, 'date') && !$checkobj->isdate($val))return '必须是日期格式如2020-02-02';
  251. }
  252. return '';
  253. }
  254. private function getsavenarr($nsrr, $bos=false)
  255. {
  256. if(!is_array($bos))$bos = array();
  257. if($nsrr)foreach($nsrr as $k=>$v)$bos[$k]=$v;
  258. return $bos;
  259. }
  260. private $subtabledata = array();
  261. private $subtabledata_msg = '';
  262. private $otherfileid = '';
  263. public function getsubtabledata($xu)
  264. {
  265. $this->subtabledata_msg = '';
  266. if(isset($this->subtabledata[$xu]))return $this->subtabledata[$xu];
  267. $arr = array();
  268. $oi = (int)$this->post('sub_totals'.$xu.'');
  269. if($oi<=0)return $arr;
  270. $modeid = $this->moders['id'];
  271. $iszb = $xu+1;
  272. $farr = m('flow_element')->getrows("`mid`='$modeid' and `islu`=1 and `iszb`=$iszb",'`name`,`fields`,`isbt`,`fieldstype`,`savewhere`,`dev`,`data`,`attr`','`sort`');
  273. $sort = 0;
  274. $zlen = count($farr);
  275. for($i=0; $i<$oi; $i++){
  276. $sid = (int)$this->post('sid'.$xu.'_'.$i.'');
  277. $bos = true;
  278. $uaarr['id'] = $sid;
  279. $wkz = 0;
  280. foreach($farr as $k=>$rs){
  281. $fid= $rs['fields'];
  282. $flx= $rs['fieldstype'];
  283. $na = ''.$fid.''.$xu.'_'.$i.'';
  284. //if(!isset($_POST[$na]))$bos=false;
  285. $val= $this->post($na);
  286. if(isempt($val))$wkz++;//空字段
  287. if(substr($fid,0,5)=='temp_')continue;
  288. if($bos){
  289. if($rs['isbt']==1 && isempt($val))$bos=false;
  290. }
  291. if($bos){
  292. $msy = $this->attrcheck($val,$rs['attr'], $this->checkobj);
  293. if($msy){
  294. $msy='第'.$iszb.'子表行'.($sort+1).'的'.$rs['name'].''.$msy.'';
  295. $this->subtabledata_msg = $msy;
  296. return $arr;
  297. }
  298. $uaarr[$fid] = $val;
  299. if(substr($flx,0,6)=='change' && !isempt($rs['data'])){
  300. $na = ''.$rs['data'].''.$xu.'_'.$i.'';
  301. $val= $this->post($na);
  302. $uaarr[$rs['data']] = $val;
  303. }
  304. if($flx=='uploadfile'){
  305. if($val)$this->otherfileid.=','.$val.'';
  306. }
  307. }
  308. if(!$bos)break;
  309. }
  310. if(!$bos)continue;
  311. if($wkz==$zlen)continue;//全部都是空
  312. $uaarr['sort'] = $sort;
  313. $sort++;
  314. $arr[] = $uaarr;
  315. }
  316. $this->subtabledata[$xu] = $arr;
  317. return $arr;
  318. }
  319. //多行子表的保存
  320. private function savesubtable($tables, $mid, $xu, $addbo)
  321. {
  322. $dbs = m($tables);
  323. $data = $this->getsubtabledata($xu);
  324. $len = count($data);
  325. $idss = '0';
  326. $whes = '';
  327. $allfields = $this->db->getallfields('[Q]'.$tables.'');
  328. $oarray = array();
  329. if(in_array('optdt', $allfields))$oarray['optdt'] = $this->now;
  330. if(in_array('optid', $allfields))$oarray['optid'] = $this->adminid;
  331. if(in_array('optname', $allfields))$oarray['optname'] = $this->adminname;
  332. if(in_array('uid', $allfields) && $addbo)$oarray['uid'] = $this->post('uid', $this->adminid);
  333. if(in_array('applydt', $allfields) && $addbo)$oarray['applydt'] = $this->post('applydt', $this->date);
  334. if(in_array('status', $allfields))$oarray['status'] = 0;
  335. if(in_array('sslx', $allfields)){
  336. $oarray['sslx'] = $xu;
  337. $whes = ' and `sslx`='.$xu.'';
  338. }
  339. if(in_array('comid', $allfields))$oarray['comid'] = $this->companyid;
  340. if($data)foreach($data as $k=>$uaarr){
  341. $sid = $uaarr['id'];
  342. $where = "`id`='$sid'";
  343. $uaarr['mid'] = $mid;
  344. if($sid==0)$where = '';
  345. foreach($oarray as $k1=>$v1)$uaarr[$k1]=$v1;
  346. if($k==0){
  347. foreach($uaarr as $k2=>$v2){
  348. if(!in_array($k2, $allfields)){
  349. $this->backmsg('第'.($xu+1).'个子表['.$tables.']上字段['.$k2.']不存在');
  350. break;
  351. }
  352. }
  353. }
  354. unset($uaarr['id']);
  355. $dbs->record($uaarr, $where);
  356. if($sid==0)$sid = $this->db->insert_id();
  357. $idss.=','.$sid.'';
  358. }
  359. $delwhere = "`mid`='$mid'".$whes." and `id` not in($idss)";
  360. $dbs->delete($delwhere);
  361. }
  362. //获取数据
  363. public function getdataAjax()
  364. {
  365. $flownum = $this->request('flownum');
  366. $id = (int)$this->request('mid');
  367. $arr = m('flow')->getdataedit($flownum, $id);
  368. $this->backmsg('', '', $arr);
  369. }
  370. public function lumAction()
  371. {
  372. $ybarr = $this->option->authercheck();
  373. if(is_string($ybarr))return $ybarr;
  374. $this->ismobile = 1;
  375. $this->luactions();
  376. }
  377. public function luAction()
  378. {
  379. $this->ismobile = 0;
  380. $this->luactions();
  381. }
  382. public function lumoAction()
  383. {
  384. $ybarr = $this->option->authercheck();
  385. if(is_string($ybarr))return $ybarr;
  386. $this->ismobile = 1;
  387. $this->luactions();
  388. }
  389. public function lusAction()
  390. {
  391. $this->ismobile = 1;
  392. $menuid = (int)$this->get('menuid');
  393. $fields = m('flow_menu')->getmou('fields', $menuid);
  394. if(isempt($fields))exit('sorry;');
  395. $fields = str_replace(',',"','", $fields);
  396. $stwhe = "and `fields` in('$fields')";
  397. $this->luactions(1, $stwhe);
  398. }
  399. //高级搜索显示框
  400. public function highsouAction()
  401. {
  402. $this->displayfile = ''.P.'/flow/input/tpl_input_lus.html';
  403. $this->ismobile = 1;
  404. $this->luactions(0, '', 1);
  405. }
  406. //$lutype=1高级搜索用的
  407. private function luactions($slx=0, $stwhe='', $lutype=0)
  408. {
  409. $this->tpltype = 'html';
  410. $uid = $this->adminid;
  411. $num = $this->jm->gettoken('num');
  412. $mid = (int)$this->jm->gettoken('mid');
  413. $this->mid = $mid;
  414. $this->rs = array();
  415. $this->flow = m('flow')->initflow($num);
  416. $moders = $this->flow->moders;
  417. $modename = $moders['name'];
  418. if($moders['status']=='0')exit('模块['.$modename.']已停用了;');
  419. $apaths = ''.P.'/flow/input/mode_'.$moders['num'].'Action.php';
  420. if(!file_exists($apaths))exit('没有创建布局录入页面,无法打开,请到【流程模块→表单元素管理】下的点按钮“PC端录入页面布局”,更多查看'.c('xinhu')->helpstr('bwb3mf').'。');
  421. $isflow = (int)$moders['isflow'];
  422. $this->smartydata['moders'] = array(
  423. 'num' => $moders['num'],
  424. 'id' => $moders['id'],
  425. 'name' => $moders['name'],
  426. 'names' => $moders['names'],
  427. 'isflow'=> $isflow,
  428. 'iscs' => $moders['iscs'],
  429. 'isbxs' => $moders['isbxs'],
  430. );
  431. $this->smartydata['chao'] = $this->flow->getcsname($mid);
  432. $modeid = $moders['id'];
  433. if($mid==0 && $lutype==0){
  434. $isadd = m('view')->isadd($modeid, $uid);
  435. if(!$isadd)exit('无权添加['.$modename.']的数据,请到[流程模块→流程模块权限]下添加权限');
  436. }
  437. $content = '';
  438. $oldrs = m($moders['table'])->getone($mid);
  439. $this->rs = $oldrs;
  440. $this->gongsiarr = array();
  441. $fieldarr = m('flow_element')->getrows("`mid`='$modeid' and `iszb`=0 $stwhe",'*','`sort`');
  442. $fieldarr = $this->flow->flowfieldarr($fieldarr, $this->ismobile);
  443. $modelu = '';
  444. $fieldstypearr = array();
  445. $fmoddfarr = array();
  446. foreach($fieldarr as $k=>$rs){
  447. if($slx==1 && $oldrs){
  448. $rs['value'] = $oldrs[$rs['fields']];
  449. }
  450. if($lutype==1){
  451. $rs['isbt'] = 0;
  452. if($rs['issou']==1)$modelu.='{'.$rs['fields'].'}';
  453. }else{
  454. if($rs['islu'] || $stwhe!=''){
  455. $fmoddfarr[] = $rs;
  456. $modelu.='{'.$rs['fields'].'}'; //手机端字段布局
  457. }
  458. if(!isempt($rs['gongsi']) && contain($rs['gongsi'],'{'))$this->gongsiarr[] = array(
  459. 'iszb' => 0,
  460. 'fields' => $rs['fields'],
  461. 'gongsi' => $rs['gongsi'],
  462. );
  463. }
  464. $this->fieldarr[$rs['fields']] = $rs;
  465. if($rs['islu']==1)$fieldstypearr[] = $rs['fieldstype'];
  466. }
  467. $this->smartydata['fieldsjson'] = json_encode($fieldarr);
  468. $this->moders = $moders;
  469. $zbshu = 0;
  470. $tableas = false;
  471. if(!isempt($moders['tables'])){
  472. $tableas = explode(',', $moders['tables']);
  473. $zbshu = count($tableas);
  474. }
  475. $path = ''.P.'/flow/page/input_'.$num.'.html';
  476. if(COMPANYNUM){
  477. $path1 = ''.P.'/flow/page/input_'.$num.'_'.COMPANYNUM.'.html';
  478. if(file_exists($path1))$path = $path1;
  479. }
  480. $pclucont = '';
  481. if(file_exists($path))$pclucont = file_get_contents($path);
  482. $isupfile = 0;
  483. $nameaas = explode(',', (string)$moders['names']); //子表名
  484. //PC端
  485. if($this->ismobile==0){
  486. $content = $pclucont;
  487. }else{
  488. $content = $this->mobileautov($modelu, $fmoddfarr);
  489. if($tableas && $slx==0){
  490. foreach($tableas as $k1=>$tableass){
  491. $zbstr = m('input')->getsubtable($modeid,$k1+1,1,1, $zbzdshu);
  492. if($zbzdshu>2 && $this->flow->minwidth<300)$this->flow->minwidth = $zbzdshu*180;
  493. if($zbstr!=''){
  494. $zbnam = arrvalue($nameaas, $k1);
  495. $zbstr = str_replace('{subzbname'.$k1.'}', $zbnam, $zbstr);
  496. $content.= '<tr><td colspan="2">';
  497. //if(!getconfig('inputm_view'))$content.='<div><b>'.$zbnam.'</b></div>';
  498. if($this->flow->minwidth>300 && $this->rock->ismobile() && 1==2){
  499. $content.='<div tmp="mobilezbiao" style="width:280px;overflow:auto;"><div
  500. style="min-width:'.$this->flow->minwidth.'px">'.$zbstr.'</div></div>';
  501. }else{
  502. $content.='<div>'.$zbstr.'</div>';
  503. }
  504. $content.= '</td></tr>';
  505. }
  506. }
  507. }
  508. $isupfile = contain($pclucont, '{file_content}') ? 1 : 0;
  509. }
  510. if($content=='')exit('未设置录入页面,请到[流程模块→表单元素管理]下设置');
  511. $content = $this->flow->flowinputtpl($content, $this->ismobile);
  512. $this->actclss = $this;
  513. $pathss = ''.P.'/flow/input/mode_'.$num.'Action.php';
  514. if(file_exists($pathss)){
  515. include_once($pathss);
  516. $clsnam = 'mode_'.$num.'ClassAction';
  517. $this->actclss = new $clsnam();
  518. $this->actclss->flow = $this->flow;
  519. $this->actclss->mid = $this->mid;
  520. $this->actclss->rs = $this->rs;
  521. $this->actclss->ismobile= $this->ismobile;
  522. }
  523. //初始表单插件元素
  524. $this->fieldarrall = $this->fieldarr;
  525. $this->inputobj = c('input');
  526. $this->inputobj->ismobile = $this->ismobile;
  527. $this->inputobj->fieldarr = $this->fieldarr;
  528. $this->inputobj->flow = $this->flow;
  529. $this->inputobj->mid = $this->mid;
  530. $this->inputobj->initUser($this->adminid);
  531. $chufarr= array();
  532. if(method_exists($this->flow, 'flowxiangfields'))$chufarr = $this->flow->flowxiangfields($chufarr);
  533. $this->fieldarrall['base_sericnum'] = array('name'=>arrvalue($chufarr,'base_sericnum','单号'));
  534. $this->fieldarrall['base_name'] = array('name'=>arrvalue($chufarr,'base_name','申请人'));
  535. $this->fieldarrall['base_deptname'] = array('name'=>arrvalue($chufarr,'base_deptname','申请人部门'));
  536. $this->fieldarrall['file_content'] = array('name'=>arrvalue($chufarr,'file_content','相关文件'));
  537. preg_match_all('/\{(.*?)\}/', $content, $list);
  538. foreach($list[1] as $k=>$nrs){
  539. $str = $this->inputobj->getfieldcont($nrs, $this->actclss);
  540. $content = str_replace('{'.$nrs.'}', $str, $content);
  541. }
  542. $this->subfielsa = array();
  543. $content = $this->pisubduolie($content, $modeid, $nameaas);//多列子表匹配的是[]
  544. $content = str_replace('*','<font color=red>*</font>', $content);
  545. //替换字段名^^
  546. preg_match_all('/\^(.*?)\^/', $content, $list);
  547. foreach($list[1] as $k=>$nrs){
  548. $fzdrs = arrvalue($this->fieldarrall, $nrs);
  549. if($fzdrs)$content = str_replace('^'.$nrs.'^', $fzdrs['name'], $content);
  550. }
  551. $course = array();
  552. $nowcourseid = 0;
  553. if($isflow>0 && $lutype==0){
  554. $course[]= array('name'=>'提交','id'=>0);
  555. $courses = $this->flow->getflowpipei($this->adminid);
  556. if($mid>0){
  557. $nowcourseid = $this->flow->billmodel->getmou('nowcourseid',"`table`='".$this->flow->mtable."' and `mid`='$mid'");
  558. }
  559. foreach($courses as $k=>$rs1){
  560. $na = $rs1['name'];
  561. //if(!$this->isempt($rs1['explain']))$na.= '<br><span style="font-size:12px">('.$rs1['explain'].')</span>';
  562. $rs1['name'] = $na;
  563. $rs1['k'] = $k;
  564. $rs1['isnow']= $rs1['id']==$nowcourseid;
  565. if(arrvalue($moders,'isflowlx')=='1'){
  566. $rs1['isnow'] = $k==0; //如果走重头审批第一步就是第一步的
  567. }
  568. //读取上次选择的2019-03-06 23:10:00添加
  569. $cuid = $name = '';
  570. if($rs1['isnow'] && $rs1['checktype']=='change' && $mid>0){
  571. $cheorws= $this->flow->checksmodel->getall("`table`='".$this->flow->mtable."' and `mid`='$mid' and `courseid`=".$rs1['id']."",'checkid,checkname');
  572. if($cheorws){
  573. foreach($cheorws as $k3=>$rs3){
  574. $cuid.=','.$rs3['checkid'].'';
  575. $name.=','.$rs3['checkname'].'';
  576. }
  577. if($cuid != ''){
  578. $cuid = substr($cuid, 1);
  579. $name = substr($name, 1);
  580. }
  581. }
  582. }
  583. $rs1['sysnextoptid']= $cuid;
  584. $rs1['sysnextopt'] = $name;
  585. $course[]=$rs1;
  586. }
  587. $course[]= array('name'=>'结束','id'=>-1);
  588. }
  589. $this->title = $this->flow->inputtitle();//录入页面的标题
  590. $this->smartydata['content'] = $content;
  591. $this->smartydata['gongsiarr'] = $this->gongsiarr;
  592. $this->smartydata['subfielsa'] = $this->subfielsa;
  593. $this->smartydata['mid'] = $mid;
  594. $this->smartydata['isflow'] = $isflow;
  595. $this->smartydata['showtype'] = $this->get('showtype');
  596. $this->smartydata['zbnamearr'] = $nameaas;
  597. $this->smartydata['zbshu'] = $zbshu;//子表数
  598. $this->smartydata['isupfile'] = $isupfile;//是否有上传
  599. $this->assign('inputobj', c('input'));
  600. $this->smartydata['course'] = $course;
  601. $inpwhere = $this->flow->inputwidth;
  602. if($inpwhere<200)$inpwhere = $this->option->getval('inputwidth', 750);
  603. $this->smartydata['inputwidth'] = $inpwhere;
  604. $this->assign('fieldstypearr', $fieldstypearr);
  605. $otherfile = 'webmain/flow/input/tpl_input_luother_'.$this->ismobile.'.html';
  606. if(!file_exists($otherfile))$otherfile = '';
  607. $this->assign('otherfile', $otherfile);
  608. $tempdata = ($mid==0) ? c('cache')->get('tempdata_'.$num.'_'.$this->adminid.'') : '';
  609. $this->assign('tempdata', $tempdata);
  610. }
  611. //2022-06-15添加分组显示
  612. private function mobileautov($str, $farr)
  613. {
  614. if(!$farr)return $str;
  615. $fzuar = array();
  616. foreach($farr as $k=>$rs){
  617. $ftype = arrvalue($rs, 'ftype');
  618. if(isempt($ftype))$ftype = 'defv';
  619. if(!isset($fzuar[$ftype]))$fzuar[$ftype] = '';
  620. $fzuar[$ftype].= '{'.$rs['fields'].'}';
  621. }
  622. $str = '';
  623. foreach($fzuar as $fl=>$fstr){
  624. if($fl!='defv')$str.='<tr><td colspan="2" style="line-height:35px;color:#888888;font-size:12px;padding-left:10px">'.$fl.'</td></tr>';
  625. $str.=$fstr;
  626. }
  627. return $str;
  628. }
  629. //多行子表内替换
  630. private function pisubduolie($content, $modeid, $nameaas)
  631. {
  632. $fieldarr = m('flow_element')->getrows("`mid`='$modeid' and `iszb`>0",'*','`sort`');
  633. if(!$fieldarr)return $content;
  634. $this->fieldarr = array();
  635. foreach($fieldarr as $k=>$rs){
  636. $oi = $rs['iszb']-1;
  637. $this->fieldarr['xuhao'.$oi.''] = array(
  638. 'fields' => 'xuhao'.$oi.'',
  639. 'fieldstype'=> 'xuhao',
  640. 'data' => '',
  641. 'attr' => ' readonly temp="xuhao"',
  642. 'dev' => '1',
  643. 'isbt' => '0',
  644. 'fieldss' => 'sid'.$oi.''
  645. );
  646. $this->fieldarr[$rs['fields'].''.$oi.''] = $rs;
  647. if(!isempt($rs['gongsi']))$this->gongsiarr[] = array(
  648. 'iszb' => $rs['iszb'],
  649. 'fields' => $rs['fields'],
  650. 'gongsi' => $rs['gongsi'],
  651. );
  652. if($rs['isbt']=='1'){
  653. $this->subfielsa[] = array(
  654. 'name' => $rs['name'],
  655. 'fields' => $rs['fields'],
  656. 'type' => $rs['fieldstype'],
  657. 'isbt' => $rs['isbt'],
  658. 'iszb' => (int)$rs['iszb'],
  659. 'zbname'=> arrvalue($nameaas, $oi)
  660. );
  661. }
  662. }
  663. $this->inputobj->fieldarr = $this->fieldarr;
  664. preg_match_all('/\[(.*?)\]/', $content, $list);
  665. foreach($list[1] as $k=>$nrs){
  666. if(!$this->isempt($nrs)){
  667. $fida= explode(',', $nrs);$xu0='0';
  668. if(isset($fida[1]))$xu0=$fida[1];
  669. $iszb = floatval(substr($fida[0],-1))+1;//第几个子表如果超过第10个子表就麻烦了
  670. $str = $this->inputobj->getfieldcont($fida[0], $this->actclss,'_'.$xu0.'', $iszb);
  671. $content = str_replace('['.$nrs.']', $str, $content);
  672. }
  673. }
  674. return $content;
  675. }
  676. public function getselectdataAjax()
  677. {
  678. $rows = array();
  679. $act = $this->get('act');
  680. $modenum= $this->get('sysmodenum');
  681. $actstr = $this->get('actstr');
  682. if(isempt($act)){
  683. if($actstr){
  684. $actstr1 = $this->jm->base64decode($actstr);
  685. $rows = c('input')->sqlstore($actstr1);
  686. }
  687. return $rows;
  688. }
  689. //用:读取model上的数据
  690. if(!isempt($act) && contain($act,':')){
  691. $acta = explode(':', $act);
  692. $objs = m($acta[0]);
  693. $tacs = $acta[1];
  694. if(method_exists($objs, $tacs)){
  695. $rows = $objs->$tacs();
  696. }
  697. }
  698. if(!$rows && !isempt($act) && method_exists($this, $act)){
  699. $rows = $this->$act();
  700. }
  701. //从Model上读取
  702. if(!$rows && !isempt($modenum)){
  703. $this->flow = m('flow')->initflow($modenum);
  704. if(method_exists($this->flow, $act)){
  705. $rows = $this->flow->$act();
  706. }
  707. }
  708. //从数据选项读取
  709. if(!$rows && $actstr){
  710. $acta = explode(',', $this->jm->base64decode($actstr));
  711. if(count($acta)<=3){
  712. $sarr = m('option')->getmnum($acta[0]);
  713. if($sarr){
  714. $vas = arrvalue($acta,2, 'value');
  715. foreach($sarr as $k=>$rs){
  716. $rows[] = array(
  717. 'name' => $rs['name'],
  718. 'value' => $rs[$vas],
  719. );
  720. }
  721. }
  722. }
  723. }
  724. return $rows;
  725. }
  726. /**
  727. * 公共读取数据之前处理
  728. */
  729. public $atypearr;
  730. public $modeid;
  731. public function storebeforeshow($table)
  732. {
  733. $this->atypearr = false;
  734. $this->modeid = (int)arrvalue($this->flow->moders, 'id', $this->get('modeid','0'));
  735. $pnum = $this->get('pnum');
  736. if($this->post('atype')=='grant'){
  737. $this->atypearr = array();
  738. $this->atypearr[] = array(
  739. 'id' => 0,
  740. 'num' => 'grant',
  741. 'name' => ''.$this->flow->modename.''.lang('授权查看').'',
  742. );
  743. }else if($this->loadci==1 && $this->adminid>0){
  744. $this->atypearr = m('where')->getmywhere($this->modeid, $this->adminid, $pnum);
  745. if(LANG!='zh-CN' && $this->atypearr)foreach($this->atypearr as $k1=>$rs1)$this->atypearr[$k1]['name'] = $this->flow->lang($rs1['name']);
  746. if(isempt($pnum)){
  747. $mors = $this->flow->moders;
  748. if((int)arrvalue($mors,'iscs','0')>0)$this->atypearr[] = array(
  749. 'id' => 0,
  750. 'num' => 'chaos',
  751. 'name' => ''.$mors['name'].''.lang('抄送给我').'',
  752. );
  753. if($mors['isflow']>0){
  754. $this->atypearr[] = array(
  755. 'id' => 0,
  756. 'num' => 'mychuli',
  757. 'name' => ''.$mors['name'].''.lang('经我处理').'',
  758. );
  759. }
  760. }
  761. }
  762. return $this->storebefore($table);
  763. }
  764. /**
  765. * 公共读取数据之后处理,展示列数
  766. */
  767. public function storeaftershow($table, $rows)
  768. {
  769. $barr['rows'] = $rows;
  770. $barr['atypearr'] = $this->atypearr;
  771. if($this->loadci==1){
  772. $vobj = m('view');
  773. $barr['isadd'] = $vobj->isadd($this->modeid, $this->adminid); //判断是否可添加
  774. $barr['isdaoru'] = $vobj->isdaoru($this->modeid, $this->adminid); //判断是否可导入
  775. $barr['isdaochu'] = $vobj->isdaochu($this->modeid, $this->adminid); //判断是否可导入
  776. $barr['listinfo'] = m('mode')->createlistpage($this->flow->moders,0,1,$this);
  777. }
  778. $barr['souarr'] = $this->flow->flowsearchfields();
  779. $rows = $this->flow->viewjinfields($rows);//禁看字段处理
  780. $farrl = array();
  781. foreach($this->flow->fieldsarra as $k2=>$rs2){
  782. if($rs2['fieldstype']=='uploadimg')$farrl[$rs2['fields']]=$rs2['fieldstype'];
  783. }
  784. if($rows)foreach($rows as $k1=>$rs1){
  785. foreach($farrl as $fid=>$flx){
  786. if(isset($rs1[$fid])){
  787. $val = $rs1[$fid];
  788. if($flx=='uploadimg'){
  789. $val = $this->rock->gethttppath($val);
  790. $rows[$k1][$fid] = $val;
  791. //if($this->flow->modeid>92)$val='<img src="'.$val.'" height="60">';
  792. }
  793. }
  794. }
  795. }
  796. $barr['modeid'] = $this->modeid;
  797. $barr['loadci'] = $this->loadci;
  798. $barr['rows'] = $rows;
  799. $scarr = $this->storeafter($table, $rows, $barr);
  800. if(is_array($scarr))foreach($scarr as $k=>$v)$barr[$k]=$v;
  801. return $barr;
  802. }
  803. //获取可搜索列表
  804. public function getcolumnsAjax()
  805. {
  806. $modeid = (int)$this->get('modeid');
  807. $modenum = $this->get('modenum');
  808. $flow = m('flow')->initflow($modenum);
  809. $souarr = array();
  810. $this->input= c('input');
  811. $this->flow = $flow;
  812. $this->input->flow = $flow;
  813. foreach($flow->fieldsarra as $k=>$rs){
  814. if($rs['issou']==1){
  815. $rs['store'] = $this->input->getdatastore($rs['fieldstype'], $this, $rs['data']);
  816. $souarr[] = $rs;
  817. }
  818. }
  819. $this->returnjson($souarr);
  820. }
  821. //初始化导入
  822. public function initdaoruAjax()
  823. {
  824. $modenum = $this->get('modenum');
  825. $flow = m('flow')->initflow($modenum);
  826. $rows = m('flow_element')->getall('mid='.$flow->modeid.' and `isdr`=1 and `iszb`=0','name,isbt,fields','`sort`,`id`');
  827. return $rows;
  828. }
  829. //确定导入数据
  830. public function daorudataAjax()
  831. {
  832. $modenum = $this->post('modenum');
  833. $flow = m('flow')->initflow($modenum);
  834. $rows = m('flow_element')->getall('mid='.$flow->modeid.' and `isdr`=1 and `iszb`=0','name,isbt,fields,isonly','`sort`,`id`');
  835. $fields = $fieldss = '';
  836. if(!$rows)return returnerror('没有导入的字段');
  837. $onlyfield = array();
  838. foreach($rows as $k=>$rs){
  839. $fields.=','.$rs['fields'].'';
  840. if($rs['isbt']=='1')$fieldss.=','.$rs['fields'].'';
  841. if($rs['isonly']=='1')$onlyfield[] = $rs['fields']; //唯一字段
  842. }
  843. $fields = substr($fields, 1);
  844. if($fieldss!='')$fieldss = substr($fieldss,1);
  845. $hobj = c('html');
  846. $data = $hobj->importdata($fields, $fieldss,'', 1); //获取提交过来要导入的数据库
  847. $errdata= $hobj->importerrda();
  848. if(!$data)return returnerror('没有可导入的数据,注意*是必填的哦',201, array('errdata'=>$errdata));
  849. //保存前判断
  850. if(method_exists($flow,'flowdaorubefore')){
  851. $data = $flow->flowdaorubefore($data, $errdata);
  852. if(is_string($data))return returnerror($data, 201, array('errdata'=>$errdata));
  853. }
  854. //判断是否有重复
  855. $ldata = array();
  856. if($onlyfield){
  857. foreach($data as $k=>$rs){
  858. $bos = true;
  859. foreach($onlyfield as $onid){
  860. $val = arrvalue($rs, $onid);
  861. if(!isempt($val)){
  862. $tos = $flow->rows("`$onid`='$val'");
  863. if($tos>0){
  864. $bos = false;
  865. $errdata[$rs['drxu']] = '字段('.$onid.':'.$val.')存在重复';
  866. break;
  867. }
  868. }
  869. }
  870. if($bos)$ldata[] = $rs;
  871. }
  872. }else{
  873. $ldata = $data;
  874. }
  875. if(!$ldata)return returnerror('没有可导入的数据',201, array('errdata'=>$errdata));
  876. $allfields = $this->db->getallfields('[Q]'.$flow->mtable.'');
  877. $oi = 0;
  878. $dorudat= array();
  879. foreach($ldata as $k=>$rs){
  880. $drerr = '';
  881. $drxu = $rs['drxu'];
  882. if(isset($rs['drerr'])){
  883. $drerr = $rs['drerr'];
  884. if($drerr){
  885. $errdata[$drxu] = $drerr;
  886. continue;
  887. }
  888. }
  889. unset($rs['drxu']);
  890. unset($rs['drerr']);
  891. $id = (int)arrvalue($rs,'id','0');
  892. $where = '';
  893. if($id>0){
  894. if($flow->rows($id)>0){
  895. $where='`id`='.$id.'';
  896. }else{
  897. $id = 0;
  898. }
  899. }
  900. if($id==0){
  901. if(!isset($rs['createid']) && in_array('createid', $allfields))$rs['createid'] = $this->adminid;
  902. if(!isset($rs['createname']) && in_array('createname', $allfields))$rs['createname'] = $this->adminname;
  903. if(!isset($rs['adddt']) && in_array('adddt', $allfields))$rs['adddt'] = $this->now;
  904. if(!isset($rs['createdt']) && in_array('createdt', $allfields))$rs['createdt'] = $this->now;
  905. if(!isset($rs['comid']) && in_array('comid', $allfields))$rs['comid'] = m('admin')->getcompanyid();
  906. }
  907. if(!isset($rs['uid']) && in_array('uid', $allfields))$rs['uid'] = $this->adminid;
  908. if(!isset($rs['optid']) && in_array('optid', $allfields))$rs['optid'] = $this->adminid;
  909. if(!isset($rs['optname']) && in_array('optname', $allfields))$rs['optname'] = $this->adminname;
  910. if(!isset($rs['optdt']) && in_array('optdt', $allfields))$rs['optdt'] = $this->now;
  911. if(!isset($rs['applydt']) && in_array('applydt', $allfields))$rs['applydt'] = $this->date;
  912. if($id==0){
  913. $bo = $flow->insert($rs);
  914. }else{
  915. $bo = $id;
  916. $flow->update($rs, $where);
  917. }
  918. if($bo){
  919. $rs['id'] = $bo;
  920. $dorudat[]= $rs;
  921. $oi++;
  922. //有流程的模块就要提交操作
  923. $status = arrvalue($rs,'status','0'); //状态
  924. $isturn = arrvalue($rs,'isturn','1'); //默认是提交的
  925. if($flow->isflow>0 && $status=='0'){
  926. $flow->loaddata($rs['id'], false);
  927. $na = ($isturn=='1') ? '提交' : '保存';
  928. $flow->submit($na);
  929. }
  930. $errdata[$drxu] = 'ok';
  931. }else{
  932. $errdata[$drxu] = '数据库错误:'.$this->db->error().'';
  933. }
  934. }
  935. if($oi==0)return returnerror('导入数据为0条', 201, array('errdata'=>$errdata));
  936. //保存后判断
  937. if(method_exists($flow,'flowdaoruafter')){
  938. $flow->flowdaoruafter($dorudat);
  939. }
  940. $bcarr = returnsuccess('成功导入'.$oi.'条数据');
  941. $bcarr['errdata'] = $errdata;
  942. return $bcarr;
  943. }
  944. //读取导入的excel数据
  945. public function readxlsAjax()
  946. {
  947. $fileid = (int)$this->get('fileid','0');
  948. $fpath = m('file')->getmou('filepath', $fileid);
  949. if(isempt($fpath))return returnerror('文件不存在了');
  950. $phpexcel = c('PHPExcelReader');
  951. $rows = $phpexcel->reader($fpath);
  952. if(is_string($rows))return returnerror('无法读取Excel文件('.$rows.')');
  953. $modenum= $this->get('modenum');
  954. $flow = m('flow')->initflow($modenum);
  955. $dtarr = array();//日期读取需要判断
  956. $xuha = -1;
  957. foreach($flow->fieldsarra as $k2=>$rs2){
  958. if($rs2['isdr']=='1' && $rs2['iszb']=='0'){
  959. $xuha++;
  960. if(in_array($rs2['fieldstype'], array('date','datetime'))){
  961. $dtarr[$phpexcel->A[$xuha]] = $rs2['fieldstype'];
  962. }
  963. }
  964. }
  965. $str = '';
  966. foreach($rows as $k=>$rs){
  967. $str1 = '';
  968. $xi = 0;
  969. foreach($rs as $k1=>$v1){
  970. if($xi>0)$str1.=' ';
  971. if(isset($dtarr[$k1]) && is_numeric($v1)){
  972. $v1 = $phpexcel->ExcelToDate($dtarr[$k1], $v1);
  973. }
  974. $v1 = str_replace("\n", '[XINHUBR]', $v1); //有\n转
  975. $str1.=''.$v1.'';
  976. $xi++;
  977. }
  978. if($k>0)$str.="\n";
  979. $str.=$str1;
  980. }
  981. return returnsuccess($str);
  982. }
  983. //下载导入的模版
  984. public function daoruexcelAction()
  985. {
  986. $this->display = false;
  987. $modenum = $this->get('modenum');
  988. $flow = m('flow')->initflow($modenum);
  989. $rows = m('flow_element')->getall('mid='.$flow->modeid.' and `isdr`=1 and `iszb`=0','name,isbt,fields','`sort`,`id`');
  990. if(!$rows)return '对应模块没有设置导入字段';
  991. $testdata = $texdata = array();
  992. if(method_exists($flow,'flowdaorutestdata')){
  993. $testdata = $flow->flowdaorutestdata();
  994. }
  995. m('file')->fileheader(''.$modenum.'import.xls');
  996. $str1 = '';
  997. $str2 = '';
  998. $col = 0;
  999. $headArr = array();
  1000. foreach($rows as $k=>$rs){
  1001. $col++;
  1002. $xi = $rs['isbt']=='1'? '<font color=red>*</font>' : '';
  1003. $x1 = $rs['isbt']=='1'? '*' : '';
  1004. $str1.='<td style="border:.5pt #000000 solid; background:#cdf79e" height="30" align="center">'.$xi.'<b>'.$rs['name'].'('.$rs['fields'].')</b></td>';
  1005. $headArr[$rs['fields']] = ''.$x1.''.$rs['name'].'('.$rs['fields'].')';
  1006. }
  1007. if($testdata){
  1008. $texdata = $testdata;
  1009. if(!isset($testdata[0]))$texdata = array($testdata);
  1010. foreach($texdata as $j=>$jrs){
  1011. $str2.='<tr>';
  1012. foreach($rows as $k=>$rs){
  1013. $val = arrvalue($jrs, $rs['fields']);
  1014. $str2.='<td style="border:.5pt #000000 solid;" height="30" align="center">'.$val.'</td>';
  1015. }
  1016. $str2.='</tr>';
  1017. }
  1018. }
  1019. $str = '<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
  1020. <table style="border-spacing: 0;border-collapse: collapse;"><tr bgcolor="#f1f1f1">'.$str1.'</tr>'.$str2.'';
  1021. for($i=1;$i<=100;$i++){
  1022. $str.='<tr>';
  1023. for($j=1;$j<=$col; $j++){
  1024. $str.='<td style="border:.5pt #000000 solid" height="30" align="center"></td>';
  1025. }
  1026. $str.='</tr>';
  1027. }
  1028. $str.= '</table>';
  1029. $pexecl = c('PHPExcel');
  1030. if($pexecl->isBool()){
  1031. $pexecl->title = ''.$modenum.'_import';
  1032. $pexecl->titlebool = false;
  1033. $pexecl->borderbool = false;
  1034. $pexecl->headArr = $headArr;
  1035. $pexecl->rows = $texdata;
  1036. $pexecl->display('xls', 'down');
  1037. }else{
  1038. return $str;
  1039. }
  1040. }
  1041. public function getuinfoAjax()
  1042. {
  1043. $uid = $this->post('uid', $this->adminid);
  1044. $rs = m('admin')->getone($uid,'id,name,deptname,deptid,deptallname,ranking,workdate,pingyin');
  1045. $unrs= m('userinfo')->getone($uid, 'syenddt,positivedt');
  1046. if($unrs)foreach($unrs as $k=>$v)$rs[$k] =$v;
  1047. return $rs;
  1048. }
  1049. public function upimagepathAjax()
  1050. {
  1051. $fileid = (int)$this->get('fileid');
  1052. $fid = $this->get('fid');
  1053. $frs = m('file')->getone($fileid);
  1054. $path = '';
  1055. if(!isempt($frs['thumbplat'])){
  1056. $path = str_replace('_s.','.',$frs['thumbplat']);
  1057. }
  1058. $filepathout = arrvalue($frs,'filepathout');
  1059. if($filepathout)$path = $filepathout;
  1060. return returnsuccess(array(
  1061. 'path' => $path,
  1062. 'fid' => $fid,
  1063. ));
  1064. }
  1065. public function saveoptionAction()
  1066. {
  1067. $num = $this->post('num');
  1068. $name = $this->post('name');
  1069. if($name && $num){
  1070. $pid = $this->option->getpids($num);
  1071. if($pid>0){
  1072. $this->option->insert(array(
  1073. 'pid' => $pid,
  1074. 'name' => $name,
  1075. 'optdt' => $this->now,
  1076. 'optid' => $this->adminid,
  1077. ));
  1078. }
  1079. }
  1080. return 'ok';
  1081. }
  1082. /**
  1083. * 暂存7天
  1084. */
  1085. public function savezhanAjax()
  1086. {
  1087. $flownum = $this->post('flownum');
  1088. $contstr = $this->post('contstr');
  1089. $key = 'tempdata_'.$flownum.'_'.$this->adminid.'';
  1090. if($contstr){
  1091. c('cache')->set($key, $contstr, 3600*24*7);
  1092. }else{
  1093. c('cache')->del($key);
  1094. }
  1095. return returnsuccess();
  1096. }
  1097. public function flow5importAjax()
  1098. {
  1099. $modeid = (int)$this->get('modeid');
  1100. $msg = '没有找到相应记录';
  1101. $onrs = m('flowbill')->getone('`modeid`='.$modeid.' and `uid`='.$this->adminid.' and ifnull(flow5str,\'\')<>\'\'','*','id desc');
  1102. $flow5str= '';
  1103. if($onrs){
  1104. $flow5str = $onrs['flow5str'];
  1105. $msg = '引入成功';
  1106. }
  1107. $barr = returnsuccess($flow5str);
  1108. $barr['msg'] = $msg;
  1109. return $barr;
  1110. }
  1111. }
  1112. class inputClassAction extends inputAction{}
粤ICP备19079148号