Domů Procházet Nápověda
Přihlásit se
caipin
/
cld
1
0
Rozštěpit 0
Soubory Úkoly 0 Pull Requesty 0 Wiki
Strom: d46753d7a1
Větve Značky
cld
/
protected
/
controller
/
ReceiptController.php

ReceiptController.php 118 KB
Historie Surový

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281128212831284128512861287128812891290129112921293129412951296129712981299130013011302130313041305130613071308130913101311131213131314131513161317131813191320132113221323132413251326132713281329133013311332133313341335133613371338133913401341134213431344134513461347134813491350135113521353135413551356135713581359136013611362136313641365136613671368136913701371137213731374137513761377137813791380138113821383138413851386138713881389139013911392139313941395139613971398139914001401140214031404140514061407140814091410141114121413141414151416141714181419142014211422142314241425142614271428142914301431143214331434143514361437143814391440144114421443144414451446144714481449145014511452145314541455145614571458145914601461146214631464146514661467146814691470147114721473147414751476147714781479148014811482148314841485148614871488148914901491149214931494149514961497149814991500150115021503150415051506150715081509151015111512151315141515151615171518151915201521152215231524152515261527152815291530153115321533153415351536153715381539154015411542154315441545154615471548154915501551155215531554155515561557155815591560156115621563156415651566156715681569157015711572157315741575157615771578157915801581158215831584158515861587158815891590159115921593159415951596159715981599160016011602160316041605160616071608160916101611161216131614161516161617161816191620162116221623162416251626162716281629163016311632163316341635163616371638163916401641164216431644164516461647164816491650165116521653165416551656165716581659166016611662166316641665166616671668166916701671167216731674167516761677167816791680168116821683168416851686168716881689169016911692169316941695169616971698169917001701170217031704170517061707170817091710171117121713171417151716171717181719172017211722172317241725172617271728172917301731173217331734173517361737173817391740174117421743174417451746174717481749175017511752175317541755175617571758175917601761176217631764176517661767176817691770177117721773177417751776177717781779178017811782178317841785178617871788178917901791179217931794179517961797179817991800180118021803180418051806180718081809181018111812181318141815181618171818181918201821182218231824182518261827182818291830183118321833183418351836183718381839184018411842184318441845184618471848184918501851185218531854185518561857185818591860186118621863186418651866186718681869187018711872187318741875187618771878187918801881188218831884188518861887188818891890189118921893189418951896189718981899190019011902190319041905190619071908190919101911191219131914191519161917191819191920192119221923192419251926192719281929193019311932193319341935193619371938193919401941194219431944194519461947194819491950195119521953195419551956195719581959196019611962196319641965196619671968196919701971197219731974197519761977197819791980198119821983198419851986198719881989199019911992199319941995199619971998199920002001200220032004200520062007200820092010201120122013201420152016201720182019202020212022202320242025202620272028202920302031203220332034203520362037203820392040204120422043204420452046204720482049205020512052205320542055205620572058205920602061206220632064206520662067206820692070207120722073207420752076207720782079208020812082208320842085208620872088208920902091209220932094209520962097209820992100210121022103210421052106210721082109211021112112211321142115211621172118211921202121212221232124212521262127212821292130213121322133213421352136213721382139214021412142214321442145214621472148214921502151215221532154215521562157215821592160216121622163216421652166216721682169217021712172217321742175217621772178217921802181218221832184218521862187218821892190219121922193219421952196219721982199220022012202220322042205220622072208220922102211221222132214221522162217221822192220222122222223222422252226222722282229223022312232223322342235223622372238223922402241224222432244224522462247224822492250225122522253225422552256225722582259226022612262226322642265226622672268226922702271227222732274227522762277227822792280228122822283228422852286228722882289229022912292229322942295229622972298229923002301230223032304230523062307230823092310231123122313231423152316231723182319232023212322232323242325232623272328232923302331233223332334233523362337233823392340234123422343234423452346234723482349235023512352235323542355235623572358235923602361236223632364236523662367236823692370237123722373237423752376237723782379238023812382238323842385238623872388238923902391239223932394239523962397239823992400240124022403240424052406240724082409241024112412241324142415241624172418241924202421242224232424242524262427242824292430243124322433243424352436243724382439244024412442244324442445244624472448244924502451245224532454245524562457245824592460246124622463246424652466246724682469247024712472247324742475247624772478247924802481248224832484248524862487248824892490249124922493249424952496249724982499250025012502250325042505250625072508250925102511251225132514251525162517251825192520252125222523252425252526252725282529253025312532253325342535253625372538253925402541254225432544254525462547254825492550255125522553255425552556255725582559256025612562256325642565256625672568256925702571257225732574257525762577257825792580258125822583258425852586258725882589259025912592259325942595259625972598259926002601260226032604260526062607260826092610261126122613261426152616261726182619262026212622262326242625262626272628262926302631263226332634263526362637263826392640264126422643264426452646264726482649265026512652265326542655265626572658265926602661266226632664266526662667266826692670267126722673267426752676267726782679268026812682268326842685268626872688268926902691269226932694269526962697269826992700270127022703270427052706270727082709271027112712271327142715271627172718271927202721272227232724272527262727272827292730273127322733273427352736273727382739274027412742274327442745274627472748274927502751275227532754275527562757275827592760276127622763276427652766276727682769277027712772277327742775277627772778277927802781278227832784278527862787278827892790279127922793279427952796279727982799280028012802280328042805280628072808280928102811281228132814281528162817281828192820282128222823282428252826282728282829283028312832283328342835283628372838283928402841284228432844284528462847284828492850285128522853285428552856285728582859286028612862286328642865286628672868286928702871287228732874287528762877287828792880288128822883288428852886288728882889289028912892289328942895289628972898289929002901290229032904290529062907290829092910291129122913291429152916291729182919292029212922292329242925292629272928292929302931293229332934293529362937293829392940294129422943294429452946294729482949295029512952295329542955295629572958295929602961296229632964296529662967296829692970297129722973297429752976297729782979298029812982298329842985298629872988298929902991299229932994299529962997299829993000300130023003300430053006300730083009301030113012301330143015301630173018301930203021302230233024302530263027302830293030303130323033303430353036303730383039304030413042304330443045304630473048304930503051305230533054305530563057305830593060306130623063306430653066306730683069307030713072307330743075307630773078307930803081308230833084308530863087308830893090309130923093309430953096309730983099310031013102310331043105310631073108310931103111311231133114311531163117311831193120312131223123312431253126312731283129313031313132313331343135313631373138313931403141314231433144314531463147314831493150315131523153315431553156315731583159316031613162316331643165316631673168316931703171 
  1. <?php
    2. 

  2. 

  3. /**
    4. 

  4.  * @author darkredz
    5. 

  5.  */
    6. 

  6. class ReceiptController extends DooController {
    7. 

  7. 	public $staff;
    8. 

  8. 	public $verifyId;
    9. 

  9. 	public static $NEW = 0;
    10. 

  10. 	
    11. 

  11. 	public $AGENCY="日常相关费用";
    12. 

  12. 	public $TRAVEL="差旅相关费用";
    13. 

  13. 	public $TRAIN="培训班费用";
    14. 

  14. 	public $OTHER="其他";
    15. 

  15. 	private $MYREVEIPTCACHEPATH="protected/cache/myReceipt/";
    16. 

  16. 	private $PERSONALCOLLECTCACHEPATH="protected/cache/personalCollect/";
    17. 

  17. 	private $CATEGORYCOLLECTPATH="protected/cache/categoryCollect/";
    18. 

  18. 	private $STAFFCOLLECTPATH="protected/cache/staffCollect/";
    19. 

  19. 	
    20. 

  20. 	private function showCache($path){
    21. 

  21. 		if(file_exists($path)){
    22. 

  22. 				echo "<!DOCTYPE html>";
    23. 

  23. 				include $path;die;
    24. 

  24. 		}
    25. 

  25. 	}
    26. 

  26. 	
    27. 

  27. 	private function cacheFile($path){
    28. 

  28. 		$content = ob_get_contents();
    29. 

  29. 		$fp = fopen($path, "w");
    30. 

  30. 		fwrite($fp, $content);
    31. 

  31. 		fclose($fp);
    32. 

  32. 	}
    33. 

  33. 	
    34. 

  34. 	private function getReceiptCount(){
    35. 

  35. 		
    36. 

  36. 		$status=2;
    37. 

  37. 		$year=date('Y');
    38. 

  38. 		
    39. 

  39. 		Doo::loadModel('receipt');
    40. 

  40. 		$receipt=new receipt();
    41. 

  41. 		Doo::loadModel('verify');
    42. 

  42. 		$verify=new verify();
    43. 

  43. 		
    44. 

  44. 		//user verify ID
    45. 

  45. 		$vidList=array();
    46. 

  46. 		$verifyDetail=$verify->find(array('where'=>'staff like "%\"'.$this->staff[0]['sid'].'\"%"','asArray'=>true));
    47. 

  47. 		foreach ($verifyDetail as $key=>$value){
    48. 

  48. 			array_push($vidList, $value['vid']);
    49. 

  49. 		}
    50. 

  50. 		$vid=implode(",", $vidList);
    51. 

  51. 		if(empty($verifyDetail))
    52. 

  52. 			$vid=0;
    53. 

  53. 		
    54. 

  54. 		$dateCondition=" and Year(date) =".$year;	
    55. 

  55. 		$approvalCondition=' and verifyStaff not like "%\"'.$this->staff[0]['sid'].'\":{%" ';
    56. 

  56. 			
    57. 

  57. 		$receiptList=$receipt->find(array('where'=>'verify in('.$vid.') and status='.$status.$dateCondition.$approvalCondition,'desc'=>'rid','asArray'=>true));
    58. 

  58. 		
    59. 

  59. 		return count($receiptList);
    60. 

  60. 	}
    61. 

  61. 	
    62. 

  62. 	private function collectHtml($receiptCollectList=array(),$itemCategory="日常相关费用",$classType="b"){
    63. 

  63. 		$collectHtml="";$sumPrice=0.00;
    64. 

  64. 		for ($i=1;$i<=12;$i++){
    65. 

  65. 			$falg=true;
    66. 

  66. 			foreach ($receiptCollectList as $key=>$value){
    67. 

  67. 				if($value['itemCategory']==$itemCategory&&$value['month']==$i){
    68. 

  68. 					$sumPrice+=$value['price'];
    69. 

  69. 					if ($classType=="b"){
    70. 

  70. 						$collectHtml.='<td class="colGreen taR">￥'.$value['price'].'</td>';$falg=false;break;
    71. 

  71. 					}else{ 
    72. 

  72. 						$collectHtml.='<td class="taR">￥'.$value['price'].'</td>';$falg=false;break;
    73. 

  73. 					}
    74. 

  74. 				}
    75. 

  75. 			}
    76. 

  76. 			if ($falg)
    77. 

  77. 				$collectHtml.='<td class="taR">-</td>';
    78. 

  78. 		}
    79. 

  79. 		$collectHtml.='<td class="taR colGreen">￥'.$sumPrice.'</td>';
    80. 

  80. 		return $collectHtml;
    81. 

  81. 	}
    82. 

  82. 	
    83. 

  83. 	function __construct() { 
    84. 

  84. 		if(isset($_COOKIE["staff"])){
    85. 

  85. 			
    86. 

  86. 			if(!empty($_COOKIE["staff"])){
    87. 

  87. 			
    88. 

  88. 				Doo::loadModel ( 'staff' );
    89. 

  89. 				Doo::loadModel('verify');
    90. 

  90. 				$verify=new verify();
    91. 

  91. 				$staff = new staff ();
    92. 

  92. 				
    93. 

  93. 				$verifyList=$verify->find(array('select'=>'staff','asArray'=>true));
    94. 

  94. 				$list=array();
    95. 

  95. 				foreach ($verifyList as $key=>$value){
    96. 

  96. 					$ver=json_decode($value['staff']);
    97. 

  97. 					foreach ($ver as $k=>$v){
    98. 

  98. 						array_push($list, $v[0]);
    99. 

  99. 					}
    100. 

  100. 				}
    101. 

  101. 				
    102. 

  102. 				$this->verifyId=$list;
    103. 

  103. 				$this->staff=$staff->getUserByIdList($_COOKIE["staff"]);
    104. 

  104. 				self::$NEW= $this->getReceiptCount();
    105. 

  105. 				return "/";
    106. 

  106. 			}
    107. 

  107. 		}
    108. 

  108. 		
    109. 

  109. 		Doo::loadCore ( 'uri/DooUriRouter' );
    110. 

  110. 		$router = new DooUriRouter ();
    111. 

  111. 		$routeRs = $router->execute ( Doo::app ()->route, Doo::conf ()->SUBFOLDER );
    112. 

  112. 			
    113. 

  113. 		if($routeRs['1']!="login"){
    114. 

  114. 			header ( 'Content-Type:text/html;charset=utf-8' );
    115. 

  115. 			@header ( "Location: /login"  );
    116. 

  116. 		}
    117. 

  117. 	}
    118. 

  118. 	
    119. 

  119. 	function myReceipt(){
    120. 

  120. 		
    121. 

  121. 		//all approval past withdraw
    122. 

  122. 		$item=isset($this->params['item'])?$this->params['item']:"";
    123. 

  123. 		if(empty($item))
    124. 

  124. 			$item=$this->get_args('item')?$this->get_args('item'):"";
    125. 

  125. 		
    126. 

  126. 		$year=$this->get_args('year')?$this->get_args('year'):date("Y");
    127. 

  127. 		$moth=$this->get_args('moth')?$this->get_args('moth'):"";
    128. 

  128. 		
    129. 

  129. 		Doo::loadModel('receipt');
    130. 

  130. 		$receipt=new receipt();
    131. 

  131. 		
    132. 

  132. 		//pre-loaded
    133. 

  133. 		if(!empty($item)&&($item=="past"||$item=="withdraw")){
    134. 

  134. 			//have cache
    135. 

  135. 			$path=SITE_PATH.$this->MYREVEIPTCACHEPATH.$item."_".$year.".htmls";
    136. 

  136. 			if(!empty($moth))//yearPage
    137. 

  137. 				$path=SITE_PATH.$this->MYREVEIPTCACHEPATH.$item."_".$year."_".$moth.".htmls";
    138. 

  138. 			
    139. 

  139. 			$this->showCache($path);		
    140. 

  140. 		}
    141. 

  141. 		
    142. 

  142. 		Doo::loadModel('L_category');
    143. 

  143. 		$Lcategory=new L_category();
    144. 

  144. 		Doo::loadModel('verify');
    145. 

  145. 		Doo::loadModel('statistics');
    146. 

  146. 		$statistics=new statistics();
    147. 

  147. 		$verify=new verify();
    148. 

  148. 		
    149. 

  149. 		$condition=" and status!=4 ";
    150. 

  150. 		if($item=="approval")
    151. 

  151. 			$condition=" and status=2 ";
    152. 

  152. 		elseif ($item=="withdraw")
    153. 

  153. 			$condition=" and status=3 ";
    154. 

  154. 		elseif ($item=="past")
    155. 

  155. 			$condition=" and status=1 ";
    156. 

  156. 

  157. 		$dateCondition=" and Year(date) =".$year;	
    158. 

  158. 		if(!empty($moth)){
    159. 

  159. 			$dateCondition=" and Year(date) =".$year." and Month(date) = ".$moth;	
    160. 

  160. 			$stList=$statistics->getOne(array('select'=>'rePrice ,agPrice','where'=>' staff='.$this->staff[0]['sid'].$dateCondition,'asArray'=>true));
    161. 

  161. 		}else
    162. 

  162. 			$stList=$statistics->statisticsByYear($year,$this->staff[0]['sid']);
    163. 

  163. 			
    164. 

  164. 		if(empty($stList))
    165. 

  165. 			$stList=array('rePrice'=>0,'agPrice'=>0);
    166. 

  166. 		$data['stList']=array('rePrice'=>$stList['rePrice'],'agPrice'=>$stList['agPrice'],'skPrice'=>($stList['rePrice']-$stList['agPrice']));
    167. 

  167. 		$receiptList=$receipt->find(array('where'=>'staff='.$this->staff[0]['sid'].$condition.$dateCondition,'desc'=>'rid','asArray'=>true));
    168. 

  168. 		foreach ($receiptList as $key=>$vlaue){
    169. 

  169. 			$receiptList[$key]['accountItem']=json_decode($vlaue['accountItem'],true);
    170. 

  170. 			$categoryDetil=$Lcategory->getOne(array('where'=>'cid='.$vlaue['cid'],'asArray'=>true));
    171. 

  171. 			$receiptList[$key]['category']=$categoryDetil['title'];
    172. 

  172. 			$verifyList=$verify->getOne(array('where'=>'vid='.$vlaue['verify'],'asArray'=>true));
    173. 

  173. 			$verifyList=json_decode($verifyList['staff']);//status opinion
    174. 

  174. 			$verifyStaff=json_decode($vlaue['verifyStaff'],true);
    175. 

  175. 			foreach ($verifyList as $k=>$v){
    176. 

  176. 				//init verifyStaff
    177. 

  177. 				$verifyList[$k]['date']="";
    178. 

  178. 				$verifyList[$k]['opinion']="";
    179. 

  179. 				$verifyList[$k]['status']="";
    180. 

  180. 				if (empty($verifyStaff)){
    181. 

  181. 					$verifyList[$k]['date']="";
    182. 

  182. 					$verifyList[$k]['opinion']="";
    183. 

  183. 					if ($v[0]==$this->staff[0]['sid'])
    184. 

  184. 						$verifyList[$k]['status']=4;
    185. 

  185. 				}else{
    186. 

  186. 					foreach ($verifyStaff as $m=>$u){
    187. 

  187. 						if ($v[0]==$m){
    188. 

  188. 							$verifyList[$k]['date']=$u['date'];
    189. 

  189. 							$verifyList[$k]['opinion']=$u['opinion'];
    190. 

  190. 							$verifyList[$k]['status']=$u['status'];
    191. 

  191. 							break;
    192. 

  192. 						}
    193. 

  193. 					}
    194. 

  194. 				}
    195. 

  195. 			}
    196. 

  196. 			$receiptList[$key]['verifyList']=$verifyList;
    197. 

  197. 		}
    198. 

  198. 		//print_r($receiptList);die;
    199. 

  199. 		$mothHtml="";
    200. 

  200. 		for($i=1;$i<=12;$i++){
    201. 

  201. 			if($moth==$i)
    202. 

  202. 				$mothHtml.='<option selected value="'.$i.'">'.$i.'月</option>';
    203. 

  203. 			else
    204. 

  204. 				$mothHtml.='<option value="'.$i.'">'.$i.'月</option>';
    205. 

  205. 		}
    206. 

  206. 		
    207. 

  207. 		$data['mothHtml']=$mothHtml;
    208. 

  208. 		$data['receiptList']=$receiptList;
    209. 

  209. 		$data['memu']="receipt";
    210. 

  210. 		$data['staff']=$this->staff;
    211. 

  211. 		$data['receiptMemu']='receipt';
    212. 

  212. 		$data['verifyId']=$this->verifyId;
    213. 

  213. 		$data['item']=$item;
    214. 

  214. 		$data['year']=$year;
    215. 

  215. 		
    216. 

  216. 		if(!empty($item)&&($item=="past"||$item=="withdraw")){
    217. 

  217. 			//sufficient condition to generate cache
    218. 

  218. 			if(empty($moth)&&($year<date("Y"))){
    219. 

  219. 				$receiptList=$receipt->find(array('where'=>'staff='.$this->staff[0]['sid'].' and (status=2 or status=4) and Year(date) ='.$year,'asArray'=>true));
    220. 

  220. 				if(empty($receiptList)){ //generated files
    221. 

  221. 					ob_start();
    222. 

  222. 					$this->render ( "/admin/saea_myList", $data );
    223. 

  223. 					$this->cacheFile($path);die;
    224. 

  224. //					$content = ob_get_contents();
    225. 

  225. //					$fp = fopen($path, "w");
    226. 

  226. //					fwrite($fp, $content);
    227. 

  227. //					fclose($fp);
    228. 

  228. 				}
    229. 

  229. 			}elseif (!empty($moth)&&($year<=date("Y"))&&($moth<date("m"))){	
    230. 

  230. 				$receiptList=$receipt->find(array('where'=>'staff='.$this->staff[0]['sid'].' and (status=2 or status=4) and Year(date) ='.$year.' and Month(date) ='.$moth,'asArray'=>true));
    231. 

  231. 				if(empty($receiptList)){ //generated files
    232. 

  232. 					ob_start();
    233. 

  233. 					$this->render ( "/admin/saea_myList", $data );
    234. 

  234. 					$this->cacheFile($path);die;
    235. 

  235. 				}
    236. 

  236. 			}
    237. 

  237. 		}
    238. 

  238. 		$this->render ( "/admin/saea_myList", $data );
    239. 

  239. 	}
    240. 

  240. 	
    241. 

  241. 	function saeaCreate(){
    242. 

  242. 		
    243. 

  243. 		Doo::loadModel('accountItem');
    244. 

  244. 		Doo::loadModel('verify');
    245. 

  245. 		Doo::loadModel('receipt');
    246. 

  246. 		Doo::loadModel('L_category');
    247. 

  247. 		$lCategory=new L_category();
    248. 

  248. 		$receipt=new receipt();
    249. 

  249. 		$verify=new verify();
    250. 

  250. 		$accountItem=new accountItem();
    251. 

  251. 		
    252. 

  252. //		$receiptDetail=$receipt->getOne(array('where'=>'staff='.$this->staff[0]['sid'].' and status=4','asArray'=>true));
    253. 

  253. //		if(!empty($receiptDetail))
    254. 

  254. //			return "/referReceipt/".$receiptDetail['rid'];
    255. 

  255. 			
    256. 

  256. 		$acItem=$accountItem->find(array('asArray'=>true));
    257. 

  257. 		$veList=$verify->find(array('asArray'=>true));
    258. 

  258. 		
    259. 

  259. 		foreach ($veList as $key=>$value){
    260. 

  260. 			$veList[$key]['staff']=json_decode($value['staff']);
    261. 

  261. 		}
    262. 

  262. 		
    263. 

  263. 		$data['category']=$lCategory->find(array('asArray'=>true));
    264. 

  264. 		$data['veList']=$veList;
    265. 

  265. 		$data['acItem']=$acItem;
    266. 

  266. 		$data['memu']="receipt";
    267. 

  267. 		$data['staff']=$this->staff;
    268. 

  268. 		
    269. 

  269. 		$data['receiptMemu']='saeaCreate';
    270. 

  270. 		$data['verifyId']=$this->verifyId;
    271. 

  271. 		
    272. 

  272. 		$this->render ( "/admin/saea_create", $data );
    273. 

  273. 	}
    274. 

  274. 	
    275. 

  275. 	function addReceipt(){
    276. 

  276. 		$agency=$this->get_args('agency');
    277. 

  277. 		$travel=$this->get_args('travel');
    278. 

  278. 		$train=$this->get_args('train');
    279. 

  279. 		$other=$this->get_args('other');
    280. 

  280. 		$verify=$this->get_args('verify')&&is_numeric($this->get_args('verify'))?$this->get_args('verify'):0;
    281. 

  281. 		$cid=$this->get_args('cid')&&is_numeric($this->get_args('cid'))?$this->get_args('cid'):0;
    282. 

  282. 		$explanation=$this->get_args('explanation')?$this->get_args('explanation'):"";
    283. 

  283. 		
    284. 

  284. 		if(!empty($verify)&&!empty($cid)&&!empty($explanation)){
    285. 

  285. 			
    286. 

  286. 			Doo::loadModel('receipt');
    287. 

  287. 			Doo::loadModel('receiptDetail');
    288. 

  288. 			Doo::loadModel('accountItem');
    289. 

  289. 			$accountItem=new accountItem();
    290. 

  290. 			$receipt=new receipt();
    291. 

  291. 			
    292. 

  292. //			$receiptDetail=$receipt->getOne(array('where'=>'staff='.$this->staff[0]['sid'].' and status=4','asArray'=>true));
    293. 

  293. //			if(!empty($receiptDetail))
    294. 

  294. //				return "/referReceipt/".$receiptDetail['rid'];
    295. 

  295. 			
    296. 

  296. 			$aItem=$accountItem->find(array('asArray'=>true));
    297. 

  297. 			$accountJson[$this->AGENCY]=$accountJson[$this->TRAVEL]=$accountJson[$this->TRAIN]=$accountJson[$this->OTHER]=array();
    298. 

  298. 			$ag=$tr=$ta=$ot=0;
    299. 

  299. 			$sum=$agencySum=$travelSum=$trainSum=$otherSum=0;
    300. 

  300. 			
    301. 

  301. 			foreach ($aItem as $key=>$value){
    302. 

  302. 				if ($value['category']==$this->AGENCY){
    303. 

  303. 					if (is_numeric($agency[$ag])&&$agency[$ag]!=0){
    304. 

  304. 						array_push($accountJson[$this->AGENCY], array('aid'=>$value['aid'],'name'=>$value['name'],'price'=>number_format($agency[$ag], 2, '.', '')));
    305. 

  305. 						$sum+=$agency[$ag];$agencySum+=$agency[$ag];
    306. 

  306. 					}
    307. 

  307. 					$ag++;
    308. 

  308. 				}
    309. 

  309. 				
    310. 

  310. 				if($value['category']==$this->TRAVEL){
    311. 

  311. 					if (is_numeric($travel[$tr])&&$travel[$tr]!=0){
    312. 

  312. 						array_push($accountJson[$this->TRAVEL], array('aid'=>$value['aid'],'name'=>$value['name'],'price'=>number_format($travel[$tr], 2, '.', '')));
    313. 

  313. 						$sum+=$travel[$tr];$travelSum+=$travel[$tr];
    314. 

  314. 					}
    315. 

  315. 					$tr++;
    316. 

  316. 				}
    317. 

  317. 				
    318. 

  318. 				if($value['category']==$this->TRAIN){
    319. 

  319. 					if (is_numeric($train[$ta])&&$train[$ta]!=0){
    320. 

  320. 						array_push($accountJson[$this->TRAIN], array('aid'=>$value['aid'],'name'=>$value['name'],'price'=>number_format($train[$ta], 2, '.', '')));
    321. 

  321. 						$sum+=$train[$ta];$trainSum+=$train[$ta];
    322. 

  322. 					}
    323. 

  323. 					$ta++;
    324. 

  324. 				}
    325. 

  325. 				
    326. 

  326. 				if($value['category']==$this->OTHER){
    327. 

  327. 					if (is_numeric($other[$ot])&&$other[$ot]!=0){
    328. 

  328. 						array_push($accountJson[$this->OTHER], array('aid'=>$value['aid'],'name'=>$value['name'],'price'=>number_format($other[$ot], 2, '.', '')));
    329. 

  329. 						$sum+=$other[$ot];$otherSum+=$other[$ot];
    330. 

  330. 					}
    331. 

  331. 					$ot++;
    332. 

  332. 				}
    333. 

  333. 			}
    334. 

  334. 			$accountJson['cSum']=array('agencySum'=>number_format($agencySum, 2, '.', ''),'travelSum'=>number_format($travelSum, 2, '.', ''),'trainSum'=>number_format($trainSum, 2, '.', ''),'otherSum'=>number_format($otherSum, 2, '.', ''));
    335. 

  335. 			
    336. 

  336. 			//报销单
    337. 

  337. 			$receipt->accountItem=json_encode($accountJson);
    338. 

  338. 			$receipt->staff=$this->staff[0]['sid'];
    339. 

  339. 			$receipt->sum=number_format($sum, 2, '.', '');
    340. 

  340. 			$receipt->date=date("Y-m-d");
    341. 

  341. 			$receipt->cid=$cid;
    342. 

  342. 			$receipt->status=4;
    343. 

  343. 			$receipt->verify=$verify;
    344. 

  344. 			$receipt->receiptOrder="#B".date("Ymd").mt_rand(1000,9999);
    345. 

  345. 			$receipt->explanation=$explanation;
    346. 

  346. 			$rid=$receipt->insert();
    347. 

  347. 			
    348. 

  348. 			//报销详情
    349. 

  349. 			foreach ($accountJson[$this->AGENCY] as $key=>$value){
    350. 

  350. 				$receiptDetail=new receiptDetail();
    351. 

  351. 				$receiptDetail->staff=$this->staff[0]['sid'];
    352. 

  352. 				$receiptDetail->item=$value['name'];
    353. 

  353. 				$receiptDetail->itemCategory=$this->AGENCY;
    354. 

  354. 				$receiptDetail->price=number_format($value['price'], 2, '.', '');
    355. 

  355. 				$receiptDetail->date=date("Y-m-d");
    356. 

  356. 				$receiptDetail->cid=$cid;
    357. 

  357. 				$receiptDetail->rid=$rid;
    358. 

  358. 				$receiptDetail->status=4;
    359. 

  359. 				$receiptDetail->insert();
    360. 

  360. 			}
    361. 

  361. 			foreach ($accountJson[$this->TRAVEL] as $key=>$value){
    362. 

  362. 				$receiptDetail=new receiptDetail();
    363. 

  363. 				$receiptDetail->staff=$this->staff[0]['sid'];
    364. 

  364. 				$receiptDetail->item=$value['name'];
    365. 

  365. 				$receiptDetail->itemCategory=$this->TRAVEL;
    366. 

  366. 				$receiptDetail->price=number_format($value['price'], 2, '.', '');
    367. 

  367. 				$receiptDetail->date=date("Y-m-d");
    368. 

  368. 				$receiptDetail->cid=$cid;
    369. 

  369. 				$receiptDetail->rid=$rid;
    370. 

  370. 				$receiptDetail->status=4;
    371. 

  371. 				$receiptDetail->insert();
    372. 

  372. 			}
    373. 

  373. 			foreach ($accountJson[$this->TRAIN] as $key=>$value){
    374. 

  374. 				$receiptDetail=new receiptDetail();
    375. 

  375. 				$receiptDetail->staff=$this->staff[0]['sid'];
    376. 

  376. 				$receiptDetail->item=$value['name'];
    377. 

  377. 				$receiptDetail->itemCategory=$this->TRAIN;
    378. 

  378. 				$receiptDetail->price=number_format($value['price'], 2, '.', '');
    379. 

  379. 				$receiptDetail->date=date("Y-m-d");
    380. 

  380. 				$receiptDetail->cid=$cid;
    381. 

  381. 				$receiptDetail->rid=$rid;
    382. 

  382. 				$receiptDetail->status=4;
    383. 

  383. 				$receiptDetail->insert();
    384. 

  384. 			}
    385. 

  385. 			foreach ($accountJson[$this->OTHER] as $key=>$value){
    386. 

  386. 				$receiptDetail=new receiptDetail();
    387. 

  387. 				$receiptDetail->staff=$this->staff[0]['sid'];
    388. 

  388. 				$receiptDetail->item=$value['name'];
    389. 

  389. 				$receiptDetail->itemCategory=$this->OTHER;
    390. 

  390. 				$receiptDetail->price=number_format($value['price'], 2, '.', '');
    391. 

  391. 				$receiptDetail->date=date("Y-m-d");
    392. 

  392. 				$receiptDetail->cid=$cid;
    393. 

  393. 				$receiptDetail->rid=$rid;
    394. 

  394. 				$receiptDetail->status=4;
    395. 

  395. 				$receiptDetail->insert();
    396. 

  396. 			}
    397. 

  397. 			
    398. 

  398. 			return "/referReceipt/".$rid;
    399. 

  399. 		}
    400. 

  400. 		return "/saeaCreate";
    401. 

  401. 	}
    402. 

  402. 	
    403. 

  403. 	function referReceipt(){
    404. 

  404. 		//$rid=isset($this->params['rid'])&&is_numeric($this->params['rid'])?$this->params['rid']:0;
    405. 

  405. 		
    406. 

  406. 			Doo::loadModel('receipt');
    407. 

  407. 			Doo::loadModel('verify');
    408. 

  408. 			$verify=new verify();
    409. 

  409. 			$receipt=new receipt();
    410. 

  410. 			Doo::loadModel('L_category');
    411. 

  411. 			$lCategory=new L_category();
    412. 

  412. 		
    413. 

  413. 			$receiptDetail=$receipt->find(array('where'=>'staff='.$this->staff[0]['sid'].' and status=4 ','asArray'=>true));
    414. 

  414. 			if(empty($receiptDetail))
    415. 

  415. 				return "/addReceipt";
    416. 

  416. 			
    417. 

  417. 			
    418. 

  418. 			foreach ($receiptDetail as $key=>$value){
    419. 

  419. 				$receiptDetail[$key]['accountItem']=json_decode($value['accountItem'],true);
    420. 

  420. 				$veList=$verify->getOne(array('where'=>'vid='.$value['verify'],'asArray'=>true));
    421. 

  421. 				$v=json_decode($veList['staff']);
    422. 

  422. 				array_push($v[0], $veList['description']);
    423. 

  423. 				$receiptDetail[$key]['staff']=$v;
    424. 

  424. 				$category=$lCategory->getOne(array('where'=>'cid='.$value['cid'],'asArray'=>true));
    425. 

  425. 				$receiptDetail[$key]['category']=$category['title'];
    426. 

  426. 			}
    427. 

  427. 			
    428. 

  428. 			$data['receiptDetail']=$receiptDetail;
    429. 

  429. 		
    430. 

  430. 		$data['memu']="receipt";
    431. 

  431. 		$data['staff']=$this->staff;
    432. 

  432. 		$data['receiptMemu']='saeaCreate';
    433. 

  433. 		$data['verifyId']=$this->verifyId;
    434. 

  434. 		
    435. 

  435. 		$this->render ( "/admin/saea_confirm", $data );
    436. 

  436. 	}
    437. 

  437. 	
    438. 

  438. 	function editReceipt(){
    439. 

  439. 		//edit status 4
    440. 

  440. 		$rid=isset($this->params['rid'])&&is_numeric($this->params['rid'])?$this->params['rid']:0;
    441. 

  441. 		//echo $rid;
    442. 

  442. 		Doo::loadModel('accountItem');
    443. 

  443. 		Doo::loadModel('verify');
    444. 

  444. 		Doo::loadModel('receipt');
    445. 

  445. 		$receipt=new receipt();
    446. 

  446. 		$verify=new verify();
    447. 

  447. 		$accountItem=new accountItem();
    448. 

  448. 		Doo::loadModel('L_category');
    449. 

  449. 		$lCategory=new L_category();
    450. 

  450. 		
    451. 

  451. 		$receiptDetail=$receipt->getOne(array('where'=>'staff='.$this->staff[0]['sid'].' and status=4 and rid='.$rid,'asArray'=>true));
    452. 

  452. 		if(empty($receiptDetail))
    453. 

  453. 			return "/saeaCreate";
    454. 

  454. 			
    455. 

  455. 		$acItem=$accountItem->find(array('asArray'=>true));
    456. 

  456. 		$veList=$verify->find(array('asArray'=>true));
    457. 

  457. 		
    458. 

  458. 		foreach ($veList as $key=>$value){
    459. 

  459. 			$veList[$key]['staff']=json_decode($value['staff']);
    460. 

  460. 		}
    461. 

  461. 		
    462. 

  462. 		//配置编辑信息
    463. 

  463. 		$accountItemList=json_decode($receiptDetail['accountItem'],true);
    464. 

  464. 		foreach ($acItem as $key=>$value){
    465. 

  465. 			foreach ($accountItemList[$this->AGENCY] as $k=>$v){
    466. 

  466. 				if($acItem[$key]['category']==$this->AGENCY&&$acItem[$key]['name']==$v['name']){
    467. 

  467. 					$acItem[$key]['price']=$v['price'];
    468. 

  468. 				}
    469. 

  469. 			}
    470. 

  470. 			foreach ($accountItemList[$this->TRAIN] as $k=>$v){
    471. 

  471. 				if($acItem[$key]['category']==$this->TRAIN&&$acItem[$key]['name']==$v['name']){
    472. 

  472. 					$acItem[$key]['price']=$v['price'];
    473. 

  473. 				}
    474. 

  474. 			}
    475. 

  475. 			foreach ($accountItemList[$this->TRAVEL] as $k=>$v){
    476. 

  476. 				if($acItem[$key]['category']==$this->TRAVEL&&$acItem[$key]['name']==$v['name']){
    477. 

  477. 					$acItem[$key]['price']=$v['price'];
    478. 

  478. 				}
    479. 

  479. 			}
    480. 

  480. 			foreach ($accountItemList[$this->OTHER] as $k=>$v){
    481. 

  481. 				if($acItem[$key]['category']==$this->OTHER&&$acItem[$key]['name']==$v['name']){
    482. 

  482. 					$acItem[$key]['price']=$v['price'];
    483. 

  483. 				}
    484. 

  484. 			}
    485. 

  485. 		}
    486. 

  486. 		
    487. 

  487. 		$data['category']=$lCategory->find(array('asArray'=>true));
    488. 

  488. 		$data['cSum']=$accountItemList['cSum'];
    489. 

  489. 		$data['sum']=$receiptDetail['sum'];
    490. 

  490. 		$data['receiptDetail']=$receiptDetail;
    491. 

  491. 		$data['veList']=$veList;
    492. 

  492. 		$data['acItem']=$acItem;
    493. 

  493. 		$data['memu']="receipt";
    494. 

  494. 		$data['staff']=$this->staff;
    495. 

  495. 		$data['receiptMemu']='saeaCreate';
    496. 

  496. 		$data['verify']=$receiptDetail['verify'];
    497. 

  497. 		$data['verifyId']=$this->verifyId;
    498. 

  498. 		$data['rid']=$rid;
    499. 

  499. 		
    500. 

  500. 		$this->render ( "/admin/saea_edit", $data );
    501. 

  501. 	}
    502. 

  502. 	
    503. 

  503. 	function updateReceipt(){
    504. 

  504. 		$agency=$this->get_args('agency');
    505. 

  505. 		$travel=$this->get_args('travel');
    506. 

  506. 		$train=$this->get_args('train');
    507. 

  507. 		$other=$this->get_args('other');
    508. 

  508. 		$verify=$this->get_args('verify')&&is_numeric($this->get_args('verify'))?$this->get_args('verify'):0;
    509. 

  509. 		$explanation=$this->get_args('explanation')?$this->get_args('explanation'):"";
    510. 

  510. 		$cid=$this->get_args('cid')&&is_numeric($this->get_args('cid'))?$this->get_args('cid'):0;
    511. 

  511. 		$rid=$this->get_args('rid')&&is_numeric($this->get_args('rid'))?$this->get_args('rid'):0;
    512. 

  512. 		
    513. 

  513. 		if(!empty($verify)&&!empty($explanation)){
    514. 

  514. 			
    515. 

  515. 			Doo::loadModel('receipt');
    516. 

  516. 			Doo::loadModel('receiptDetail');
    517. 

  517. 			Doo::loadModel('accountItem');
    518. 

  518. 			$accountItem=new accountItem();
    519. 

  519. 			$receipt=new receipt();
    520. 

  520. 			
    521. 

  521. 			$receiptDetail=$receipt->getOne(array('where'=>'staff='.$this->staff[0]['sid'].' and status=4 and rid='.$rid,'asArray'=>true));
    522. 

  522. 			if(empty($receiptDetail))
    523. 

  523. 				return "/saeaCreate";
    524. 

  524. 			
    525. 

  525. 			$aItem=$accountItem->find(array('asArray'=>true));
    526. 

  526. 			$accountJson[$this->AGENCY]=$accountJson[$this->TRAVEL]=$accountJson[$this->TRAIN]=$accountJson[$this->OTHER]=array();
    527. 

  527. 			$ag=$tr=$ta=$ot=0;
    528. 

  528. 			$sum=$agencySum=$travelSum=$trainSum=$otherSum=0;
    529. 

  529. 			
    530. 

  530. 			foreach ($aItem as $key=>$value){
    531. 

  531. 				if ($value['category']==$this->AGENCY){
    532. 

  532. 					if (is_numeric($agency[$ag])&&$agency[$ag]!=0){
    533. 

  533. 						array_push($accountJson[$this->AGENCY], array('aid'=>$value['aid'],'name'=>$value['name'],'price'=>number_format($agency[$ag], 2, '.', '')));
    534. 

  534. 						$sum+=$agency[$ag];$agencySum+=$agency[$ag];
    535. 

  535. 					}
    536. 

  536. 					$ag++;
    537. 

  537. 				}
    538. 

  538. 				
    539. 

  539. 				if($value['category']==$this->TRAVEL){
    540. 

  540. 					if (is_numeric($travel[$tr])&&$travel[$tr]!=0){
    541. 

  541. 						array_push($accountJson[$this->TRAVEL], array('aid'=>$value['aid'],'name'=>$value['name'],'price'=>number_format($travel[$tr], 2, '.', '')));
    542. 

  542. 						$sum+=$travel[$tr];$travelSum+=$travel[$tr];
    543. 

  543. 					}
    544. 

  544. 					$tr++;
    545. 

  545. 				}
    546. 

  546. 				
    547. 

  547. 			
    548. 

  548. 				if($value['category']==$this->TRAIN){
    549. 

  549. 					if (is_numeric($train[$ta])&&$train[$ta]!=0){
    550. 

  550. 						array_push($accountJson[$this->TRAIN], array('aid'=>$value['aid'],'name'=>$value['name'],'price'=>number_format($train[$ta], 2, '.', '')));
    551. 

  551. 						$sum+=$train[$ta];$trainSum+=$train[$ta];
    552. 

  552. 					}
    553. 

  553. 					$ta++;
    554. 

  554. 				}
    555. 

  555. 				
    556. 

  556. 				if($value['category']==$this->OTHER){
    557. 

  557. 					if (is_numeric($other[$ot])&&$other[$ot]!=0){
    558. 

  558. 						array_push($accountJson[$this->OTHER], array('aid'=>$value['aid'],'name'=>$value['name'],'price'=>number_format($other[$ot], 2, '.', '')));
    559. 

  559. 						$sum+=$other[$ot];$otherSum+=$other[$ot];
    560. 

  560. 					}
    561. 

  561. 					$ot++;
    562. 

  562. 				}
    563. 

  563. 			}
    564. 

  564. 			$accountJson['cSum']=array('agencySum'=>number_format($agencySum, 2, '.', ''),'travelSum'=>number_format($travelSum, 2, '.', ''),'trainSum'=>number_format($trainSum, 2, '.', ''),'otherSum'=>number_format($otherSum, 2, '.', ''));
    565. 

  565. 			
    566. 

  566. 			//报销单
    567. 

  567. 			$rid=$receipt->rid=$receiptDetail['rid'];
    568. 

  568. 			$receipt->accountItem=json_encode($accountJson);
    569. 

  569. 			$receipt->staff=$this->staff[0]['sid'];
    570. 

  570. 			$receipt->sum=number_format($sum, 2, '.', '');
    571. 

  571. 			$receipt->date=date("Y-m-d");
    572. 

  572. 			$receipt->cid=$cid;
    573. 

  573. 			$receipt->status=4;
    574. 

  574. 			$receipt->verify=$verify;
    575. 

  575. 			$receipt->explanation=$explanation;
    576. 

  576. 			$receipt->update();
    577. 

  577. 			
    578. 

  578. 			$receiptDetail=new receiptDetail();
    579. 

  579. 			$receiptDetail->delete(array('where'=>'rid='.$rid));
    580. 

  580. 			
    581. 

  581. 			//报销详情
    582. 

  582. 			foreach ($accountJson[$this->AGENCY] as $key=>$value){
    583. 

  583. 				$receiptDetail=new receiptDetail();
    584. 

  584. 				$receiptDetail->staff=$this->staff[0]['sid'];
    585. 

  585. 				$receiptDetail->item=$value['name'];
    586. 

  586. 				$receiptDetail->itemCategory=$this->AGENCY;
    587. 

  587. 				$receiptDetail->price=number_format($value['price'], 2, '.', '');
    588. 

  588. 				$receiptDetail->date=date("Y-m-d");
    589. 

  589. 				$receiptDetail->cid=$cid;
    590. 

  590. 				$receiptDetail->rid=$rid;
    591. 

  591. 				$receiptDetail->status=4;
    592. 

  592. 				$receiptDetail->insert();
    593. 

  593. 			}
    594. 

  594. 			foreach ($accountJson[$this->TRAVEL] as $key=>$value){
    595. 

  595. 				$receiptDetail=new receiptDetail();
    596. 

  596. 				$receiptDetail->staff=$this->staff[0]['sid'];
    597. 

  597. 				$receiptDetail->item=$value['name'];
    598. 

  598. 				$receiptDetail->itemCategory=$this->TRAVEL;
    599. 

  599. 				$receiptDetail->price=number_format($value['price'], 2, '.', '');
    600. 

  600. 				$receiptDetail->date=date("Y-m-d");
    601. 

  601. 				$receiptDetail->cid=$cid;
    602. 

  602. 				$receiptDetail->rid=$rid;
    603. 

  603. 				$receiptDetail->status=4;
    604. 

  604. 				$receiptDetail->insert();
    605. 

  605. 			}
    606. 

  606. 			foreach ($accountJson[$this->TRAIN] as $key=>$value){
    607. 

  607. 				$receiptDetail=new receiptDetail();
    608. 

  608. 				$receiptDetail->staff=$this->staff[0]['sid'];
    609. 

  609. 				$receiptDetail->item=$value['name'];
    610. 

  610. 				$receiptDetail->itemCategory=$this->TRAIN;
    611. 

  611. 				$receiptDetail->price=number_format($value['price'], 2, '.', '');
    612. 

  612. 				$receiptDetail->date=date("Y-m-d");
    613. 

  613. 				$receiptDetail->cid=$cid;
    614. 

  614. 				$receiptDetail->rid=$rid;
    615. 

  615. 				$receiptDetail->status=4;
    616. 

  616. 				$receiptDetail->insert();
    617. 

  617. 			}
    618. 

  618. 			foreach ($accountJson[$this->OTHER] as $key=>$value){
    619. 

  619. 				$receiptDetail=new receiptDetail();
    620. 

  620. 				$receiptDetail->staff=$this->staff[0]['sid'];
    621. 

  621. 				$receiptDetail->item=$value['name'];
    622. 

  622. 				$receiptDetail->itemCategory=$this->OTHER;
    623. 

  623. 				$receiptDetail->price=number_format($value['price'], 2, '.', '');
    624. 

  624. 				$receiptDetail->date=date("Y-m-d");
    625. 

  625. 				$receiptDetail->cid=$cid;
    626. 

  626. 				$receiptDetail->rid=$rid;
    627. 

  627. 				$receiptDetail->status=4;
    628. 

  628. 				$receiptDetail->insert();
    629. 

  629. 			}
    630. 

  630. 			
    631. 

  631. 			return "/referReceipt/".$rid;
    632. 

  632. 		}
    633. 

  633. 		return "/editReceipt/1";
    634. 

  634. 	}
    635. 

  635. 	
    636. 

  636. 	function approvedReceipt(){
    637. 

  637. 		$rid=isset($this->params['rid'])&&is_numeric($this->params['rid'])?$this->params['rid']:0;
    638. 

  638. 		
    639. 

  639. 		Doo::loadModel('receipt');
    640. 

  640. 		Doo::loadModel('receiptDetail');
    641. 

  641. 		$receipt=new receipt();
    642. 

  642. 		$receiptDetail=new receiptDetail();
    643. 

  643. 		Doo::loadModel('statistics');
    644. 

  644. 		Doo::loadModel('itemStatistics');
    645. 

  645. 		$statistics=new statistics();
    646. 

  646. 		$itemStatistics=new itemStatistics();
    647. 

  647. 		
    648. 

  648. 		$receiptDetailList=$receipt->getOne(array('where'=>'staff='.$this->staff[0]['sid'].' and status=4 and rid='.$rid,'asArray'=>true));
    649. 

  649. 		if(empty($receiptDetailList))
    650. 

  650. 			return "/saeaCreate";
    651. 

  651. 		
    652. 

  652. 		$receipt->rid=$receiptDetailList['rid'];
    653. 

  653. 		$receipt->status=2;
    654. 

  654. 		$receipt->update();
    655. 

  655. 		
    656. 

  656. 		$receiptDetail->status=2;
    657. 

  657. 		$receiptDetail->update(array('where'=>'rid='.$receiptDetailList['rid']));
    658. 

  658. 		
    659. 

  659. 		//statistics item
    660. 

  660. 		$dateArray=explode("-", $receiptDetailList['date']);
    661. 

  661. 		$dateCondition=" and Year(date) =".$dateArray[0]." and Month(date) = ".$dateArray[1];	
    662. 

  662. 		
    663. 

  663. 		$accountItem=json_decode($receiptDetailList['accountItem'],true);
    664. 

  664. 		//print_r($accountItem['cSum']['agencySum']);die;
    665. 

  665. //		foreach ($accountItem['cSum'] as $key=>$value){
    666. 

  666. //			if($key=="agencySum"){
    667. 

  667. //				$iStatistics=$itemStatistics->getOne(array('where'=>'staff='.$this->staff[0]['sid'].' and itemCategory="'.$this->AGENCY.'"'.$dateCondition,'asArray'=>true));
    668. 

  668. //				if(empty($iStatistics)){
    669. 

  669. //					$itemStatistics->cid=$this->staff[0]['cid'];
    670. 

  670. //					$itemStatistics->staff=$this->staff[0]['sid'];
    671. 

  671. //					$itemStatistics->price=$value;
    672. 

  672. //					$itemStatistics->itemCategory=$this->AGENCY;
    673. 

  673. //					$itemStatistics->date=date("Y-m-d");
    674. 

  674. //					$itemStatistics->insert();
    675. 

  675. //				}else{
    676. 

  676. //					if (!empty($value)){
    677. 

  677. //						$itemStatistics->price=$value+$iStatistics['price'];
    678. 

  678. //						$itemStatistics->update(array('where'=>'sid='.$iStatistics['sid']));
    679. 

  679. //					}
    680. 

  680. //				}
    681. 

  681. //			}elseif($key=="travelSum"){
    682. 

  682. //				$iStatistics=$itemStatistics->getOne(array('where'=>'staff='.$this->staff[0]['sid'].' and itemCategory="'.$this->TRAVEL.'"'.$dateCondition,'asArray'=>true));
    683. 

  683. //				if(empty($iStatistics)){
    684. 

  684. //					$itemStatistics->cid=$this->staff[0]['cid'];
    685. 

  685. //					$itemStatistics->staff=$this->staff[0]['sid'];
    686. 

  686. //					$itemStatistics->price=$value;
    687. 

  687. //					$itemStatistics->itemCategory=$this->TRAVEL;
    688. 

  688. //					$itemStatistics->date=date("Y-m-d");
    689. 

  689. //					$itemStatistics->insert();
    690. 

  690. //				}else{
    691. 

  691. //					if (!empty($value)){
    692. 

  692. //						$itemStatistics->price=$value+$iStatistics['price'];
    693. 

  693. //						$itemStatistics->update(array('where'=>'sid='.$iStatistics['sid']));
    694. 

  694. //					}
    695. 

  695. //				}
    696. 

  696. //			}elseif($key=="trainSum"){
    697. 

  697. //				$iStatistics=$itemStatistics->getOne(array('where'=>'staff='.$this->staff[0]['sid'].' and itemCategory="'.$this->TRAIN.'"'.$dateCondition,'asArray'=>true));
    698. 

  698. //				if(empty($iStatistics)){
    699. 

  699. //					$itemStatistics->cid=$this->staff[0]['cid'];
    700. 

  700. //					$itemStatistics->staff=$this->staff[0]['sid'];
    701. 

  701. //					$itemStatistics->price=$value;
    702. 

  702. //					$itemStatistics->itemCategory=$this->TRAIN;
    703. 

  703. //					$itemStatistics->date=date("Y-m-d");
    704. 

  704. //					$itemStatistics->insert();
    705. 

  705. //				}else{
    706. 

  706. //					if (!empty($value)){
    707. 

  707. //						$itemStatistics->price=$value+$iStatistics['price'];
    708. 

  708. //						$itemStatistics->update(array('where'=>'sid='.$iStatistics['sid']));
    709. 

  709. //					}
    710. 

  710. //				}
    711. 

  711. //			}elseif($key=="otherSum"){
    712. 

  712. //				$iStatistics=$itemStatistics->getOne(array('where'=>'staff='.$this->staff[0]['sid'].' and itemCategory="'.$this->OTHER.'"'.$dateCondition,'asArray'=>true));
    713. 

  713. //				if(empty($iStatistics)){
    714. 

  714. //					$itemStatistics->cid=$this->staff[0]['cid'];
    715. 

  715. //					$itemStatistics->staff=$this->staff[0]['sid'];
    716. 

  716. //					$itemStatistics->price=$value;
    717. 

  717. //					$itemStatistics->itemCategory=$this->OTHER;
    718. 

  718. //					$itemStatistics->date=date("Y-m-d");
    719. 

  719. //					$itemStatistics->insert();
    720. 

  720. //				}else{
    721. 

  721. //					if (!empty($value)){
    722. 

  722. //						$itemStatistics->price=$value+$iStatistics['price'];
    723. 

  723. //						$itemStatistics->update(array('where'=>'sid='.$iStatistics['sid']));
    724. 

  724. //					}
    725. 

  725. //				}
    726. 

  726. //			}
    727. 

  727. //		}
    728. 

  728. 		
    729. 

  729. 		$stat=$statistics->getOne(array('where'=>'staff='.$this->staff[0]['sid'].$dateCondition,'asArray'=>true));
    730. 

  730. 		if(empty($stat)){
    731. 

  731. 			$statistics->date=date("Y-m-d");
    732. 

  732. 			$statistics->cid=$this->staff[0]['cid'];
    733. 

  733. 			$statistics->staff=$this->staff[0]['sid'];
    734. 

  734. 			$statistics->agPrice=0;
    735. 

  735. 			$statistics->rePrice=$accountItem['cSum']['agencySum']+$accountItem['cSum']['travelSum']+$accountItem['cSum']['trainSum']+$accountItem['cSum']['otherSum'];
    736. 

  736. 			$statistics->insert();
    737. 

  737. 		}else{
    738. 

  738. 			$statistics->rePrice=$stat['rePrice']+$accountItem['cSum']['agencySum']+$accountItem['cSum']['travelSum']+$accountItem['cSum']['trainSum']+$accountItem['cSum']['otherSum'];
    739. 

  739. 			$statistics->update(array('where'=>'sid='.$stat['sid']));
    740. 

  740. 		}
    741. 

  741. 		
    742. 

  742. 		return "/myReceipt";
    743. 

  743. 	}
    744. 

  744. 	
    745. 

  745. 	
    746. 

  746. 	
    747. 

  747. 	function approval(){
    748. 

  748. 		
    749. 

  749. 		$status=isset($this->params['status'])?$this->params['status']:'';
    750. 

  750. 		$year=$this->get_args('year')?$this->get_args('year'):date('Y');
    751. 

  751. 		$month=$this->get_args('month')?$this->get_args('month'):"";
    752. 

  752. 		$cid=$this->get_args('cid')?$this->get_args('cid'):0;
    753. 

  753. 		$sid=$this->get_args('sid')?$this->get_args('sid'):0;
    754. 

  754. 		
    755. 

  755. 		if (empty($status))
    756. 

  756. 			$status=$this->get_args('status')?$this->get_args('status'):2;
    757. 

  757. 			
    758. 

  758. 		$vidList=array();
    759. 

  759. 		$button=0;
    760. 

  760. 		
    761. 

  761. 		Doo::loadModel('verify');
    762. 

  762. 		Doo::loadModel('receipt');
    763. 

  763. 		Doo::loadModel('staff');
    764. 

  764. 		$staff=new staff();
    765. 

  765. 		$receipt=new receipt();
    766. 

  766. 		$verify=new verify();
    767. 

  767. 		Doo::loadModel('L_category');
    768. 

  768. 		$Lcategory=new L_category();
    769. 

  769. 		
    770. 

  770. 		//user verify ID
    771. 

  771. 		$verifyDetail=$verify->find(array('where'=>'staff like "%\"'.$this->staff[0]['sid'].'\"%"','asArray'=>true));
    772. 

  772. 		foreach ($verifyDetail as $key=>$value){
    773. 

  773. 			array_push($vidList, $value['vid']);
    774. 

  774. 		}
    775. 

  775. 		$vid=implode(",", $vidList);
    776. 

  776. 		if(empty($verifyDetail))
    777. 

  777. 			$vid=0;
    778. 

  778. 

  779. 		$dateCondition=" and Year(date) =".$year;	
    780. 

  780. 		if(!empty($month))
    781. 

  781. 			$dateCondition=" and Year(date) =".$year." and Month(date) = ".$month;		
    782. 

  782. 			
    783. 

  783. 		$categoryList=$Lcategory->find(array('asArray'=>true));	
    784. 

  784. 		$staffList=$staff->find(array('where'=>'cid='.$cid,'asArray'=>true));
    785. 

  785. 		$cateCondition="";$staffCondition="";$approvalCondition="";
    786. 

  786. 		if (!empty($cid))
    787. 

  787. 			$cateCondition=' and cid='.$cid;
    788. 

  788. 		if(!empty($sid)){
    789. 

  789. 			$staffCondition=' and staff='.$sid;
    790. 

  790. 			$cateCondition="";
    791. 

  791. 		}
    792. 

  792. 		if($status==2)
    793. 

  793. 			$approvalCondition=' and verifyStaff not like "%\"'.$this->staff[0]['sid'].'\":{%" ';
    794. 

  794. 		$ap="";
    795. 

  795. 		if($status==4){
    796. 

  796. 			$ap=4;$status=2;
    797. 

  797. 			$approvalCondition=' and verifyStaff like "%\"'.$this->staff[0]['sid'].'\":{%" ';
    798. 

  798. 		}		
    799. 

  799. 		
    800. 

  800. 		//get Receipt By verifyID status 2
    801. 

  801. 		$receiptList=$receipt->find(array('where'=>'verify in('.$vid.') and status='.$status.$dateCondition.$cateCondition.$staffCondition.$approvalCondition,'desc'=>'rid','asArray'=>true));
    802. 

  802. 		$Locate=0;
    803. 

  803. 		if($ap==4)
    804. 

  804. 			$status=4;
    805. 

  805. 		foreach ($receiptList as $key=>$value){
    806. 

  806. 			$receiptList[$key]['Locate']=$Locate;$Locate++;
    807. 

  807. 			$receiptList[$key]['reviseDetail']=array();
    808. 

  808. 			if (!empty($value['reviseDetail']))
    809. 

  809. 				$receiptList[$key]['reviseDetail']=json_decode($value['reviseDetail'],true);
    810. 

  810. 			$receiptList[$key]['accountItem']=json_decode($value['accountItem'],true);
    811. 

  811. 			$categoryDetil=$Lcategory->getOne(array('where'=>'cid='.$value['cid'],'asArray'=>true));
    812. 

  812. 			$receiptList[$key]['category']=$categoryDetil['title'];
    813. 

  813. 			$verifyList=$verify->getOne(array('where'=>'vid='.$value['verify'],'asArray'=>true));
    814. 

  814. 			$verifyList=json_decode($verifyList['staff'],true);//status opinion
    815. 

  815. 			$verifyStaff=json_decode($value['verifyStaff'],true);
    816. 

  816. 			foreach ($verifyList as $k=>$v){
    817. 

  817. 				//init verifyStaff
    818. 

  818. 				$verifyList[$k]['date']="";
    819. 

  819. 				$verifyList[$k]['opinion']="";
    820. 

  820. 				$verifyList[$k]['status']="";
    821. 

  821. 				if (empty($verifyStaff)){
    822. 

  822. 					$verifyList[$k]['date']="";
    823. 

  823. 					$verifyList[$k]['opinion']="";
    824. 

  824. 					if ($v[0]==$this->staff[0]['sid']){
    825. 

  825. 						$verifyList[$k]['status']=4;
    826. 

  826. 						$button=4;
    827. 

  827. 					}
    828. 

  828. 				}else{
    829. 

  829. 					$flag=true;
    830. 

  830. 					foreach ($verifyStaff as $m=>$u){
    831. 

  831. 						if ($v[0]==$m){
    832. 

  832. 							$verifyList[$k]['date']=$u['date'];
    833. 

  833. 							$verifyList[$k]['opinion']=$u['opinion'];
    834. 

  834. 							$verifyList[$k]['status']=$u['status'];
    835. 

  835. 							$flag=false;
    836. 

  836. 							break;
    837. 

  837. 						}
    838. 

  838. //						elseif($v[0]==$this->staff[0]['sid']){$verifyList[$k]['status']=4;break;}
    839. 

  839. //						if ($v[0]==$this->staff[0]['sid']&&$m!=$this->staff[0]['sid']){$verifyList[$k]['status']=4;}
    840. 

  840. //						if($v[0]==$this->staff[0]['sid']&&$v[0]==$m){if ($u['status']!=1&&$u['status']!=3)$button=4;}
    841. 

  841. 					}
    842. 

  842. 					if($flag){//检测可编辑
    843. 

  843. 						if($v[0]==$this->staff[0]['sid']){
    844. 

  844. 							$verifyList[$k]['status']=4;$button=4;
    845. 

  845. 						}
    846. 

  846. 					}
    847. 

  847. 				}
    848. 

  848. 			}
    849. 

  849. 			$receiptList[$key]['verifyList']=$verifyList;
    850. 

  850. 			$receiptList[$key]['staffDetail']=$staff->getOne(array('where'=>'sid='.$value['staff'],'asArray'=>true));
    851. 

  851. 			$receiptList[$key]['button']=$button;
    852. 

  852. 		}
    853. 

  853. 		//print_r($receiptList);die;
    854. 

  854. 		//$data['verifyDetail']=$verifyDetail;
    855. 

  855. 		
    856. 

  856. 		$mothHtml="";
    857. 

  857. 		for($i=1;$i<=12;$i++){
    858. 

  858. 			if($month==$i)
    859. 

  859. 				$mothHtml.='<option selected value="'.$i.'">'.$i.'月</option>';
    860. 

  860. 			else
    861. 

  861. 				$mothHtml.='<option value="'.$i.'">'.$i.'月</option>';
    862. 

  862. 		}
    863. 

  863. 		$data['mothHtml']=$mothHtml;
    864. 

  864. 		
    865. 

  865. 		$data['receiptList']=$receiptList;
    866. 

  866. 		$data['receiptApprovalCount']=count($receiptList);
    867. 

  867. 		$data['status']=$status;
    868. 

  868. 		$data['year']=$year;
    869. 

  869. 		$data['categoryList']=$categoryList;
    870. 

  870. 		$data['staffList']=$staffList;
    871. 

  871. 		$data['cid']=$cid;
    872. 

  872. 		$data['sid']=$sid;
    873. 

  873. 		$data['ap']=$ap;
    874. 

  874. 		
    875. 

  875. 		$data['memu']="receipt";
    876. 

  876. 		$data['staff']=$this->staff;
    877. 

  877. 		$data['receiptMemu']='approval';
    878. 

  878. 		$data['verifyId']=$this->verifyId;
    879. 

  879. 		
    880. 

  880. 		$this->render ( "/admin/saea_reportList", $data );
    881. 

  881. 	}
    882. 

  882. 	
    883. 

  883. 	function remittance(){
    884. 

  884. 		$year=$this->get_args('year')?$this->get_args('year'):date('Y');
    885. 

  885. 		$month=$this->get_args('month')?$this->get_args('month'):"";
    886. 

  886. 		
    887. 

  887. 		Doo::loadModel('receipt');
    888. 

  888. 		$receipt=new receipt();
    889. 

  889. 		Doo::loadModel('staff');
    890. 

  890. 		$staff=new staff();
    891. 

  891. 		
    892. 

  892. 		$dateCondition=" and Year(pastDate) =".$year;	
    893. 

  893. 		if(!empty($month))
    894. 

  894. 			$dateCondition=" and Year(pastDate) =".$year." and Month(pastDate) = ".$month;	
    895. 

  895. 		
    896. 

  896. 		//get Receipt By verifyID status 1
    897. 

  897. 		$receiptList=$receipt->find(array('select'=>'sum(sum) as sum,staff,pastDate','where'=>' status=1'.$dateCondition,'desc'=>'pastDate','groupby'=>'staff,pastDate','asArray'=>true));
    898. 

  898. 		$dateList=$receipt->find(array('select'=>'pastDate','where'=>' status=1'.$dateCondition,'desc'=>'pastDate','groupby'=>'pastDate','asArray'=>true));
    899. 

  899. 		$dataList=array();
    900. 

  900. 		foreach ($dateList as $d=>$a){
    901. 

  901. 			$dataList[$a['pastDate']]=array();$daySum=0;
    902. 

  902. 			foreach ($receiptList as $key=>$value){
    903. 

  903. 				if($a['pastDate']==$value['pastDate']){
    904. 

  904. 					$oderList=$receipt->find(array('select'=>'receiptOrder','where'=>' status=1 and staff='.$value['staff'].' and pastDate=\''.$a['pastDate'].'\'','asArray'=>true));
    905. 

  905. 					$list=array();
    906. 

  906. 					foreach ($oderList as $v){
    907. 

  907. 						array_push($list, $v['receiptOrder']);
    908. 

  908. 					}
    909. 

  909. 					$receiptList[$key]['receiptOrder']=implode(",", $list);
    910. 

  910. 					
    911. 

  911. 					$sinfo=$staff->getOne(array('select'=>'username ','where'=>' sid='.$value['staff'],'asArray'=>true));
    912. 

  912. 					$receiptList[$key]['username']=$sinfo['username'];
    913. 

  913. 					$daySum+=$value['sum'];
    914. 

  914. 					array_push($dataList[$a['pastDate']], $receiptList[$key]);
    915. 

  915. 				}
    916. 

  916. 				$dataList[$a['pastDate']]['9999999']=number_format($daySum,2);
    917. 

  917. 			}
    918. 

  918. 		}
    919. 

  919. 		//print_r($dataList);die;
    920. 

  920. 		$data['dataList']=$dataList;
    921. 

  921. 		
    922. 

  922. 		$mothHtml="";
    923. 

  923. 		for($i=1;$i<=12;$i++){
    924. 

  924. 			if($month==$i)
    925. 

  925. 				$mothHtml.='<option selected value="'.$i.'">'.$i.'月</option>';
    926. 

  926. 			else
    927. 

  927. 				$mothHtml.='<option value="'.$i.'">'.$i.'月</option>';
    928. 

  928. 		}
    929. 

  929. 		$data['year']=$year;
    930. 

  930. 		$data['mothHtml']=$mothHtml;
    931. 

  931. 		$data['memu']="receipt";
    932. 

  932. 		$data['staff']=$this->staff;
    933. 

  933. 		$data['receiptMemu']='approval';
    934. 

  934. 		$data['verifyId']=$this->verifyId;
    935. 

  935. 		
    936. 

  936. 		$this->render ( "/admin/saeaReportListPay", $data );
    937. 

  937. 	}
    938. 

  938. 	
    939. 

  939. 	function revocationAdjustment(){
    940. 

  940. 		$sid=isset($this->params['sid'])&&is_numeric($this->params['sid'])?$this->params['sid']:0;
    941. 

  941. 		$price=isset($this->params['price'])&&is_numeric($this->params['price'])?$this->params['price']:-99999;
    942. 

  942. 		$rid=isset($this->params['rid'])&&is_numeric($this->params['rid'])?$this->params['rid']:0;
    943. 

  943. 		
    944. 

  944. 		if ((!empty($sid))&&($price!=-99999)&&(!empty($rid))){
    945. 

  945. 			Doo::loadModel('receipt');
    946. 

  946. 			$receipt=new receipt();
    947. 

  947. 			
    948. 

  948. 			$receiptDetail=$receipt->getOne(array('where'=>'rid='.$rid,'asArray'=>true));
    949. 

  949. 			if (empty($receiptDetail['reviseDetail']))
    950. 

  950. 				return "/approval";
    951. 

  951. 				
    952. 

  952. 			$reviseDetail=json_decode($receiptDetail['reviseDetail'],true);
    953. 

  953. 			$RD=array();
    954. 

  954. 			foreach ($reviseDetail as $key=>$value){
    955. 

  955. 				if ($value['price']==$price&&$value['sid']==$sid)
    956. 

  956. 					continue;
    957. 

  957. 				array_push($RD, $value);
    958. 

  958. 			}
    959. 

  959. 			
    960. 

  960. 			$reviseDetailString=json_encode($RD);
    961. 

  961. 			$receipt->reviseDetail=$reviseDetailString;
    962. 

  962. 			$receipt->sum=$receiptDetail['sum']+$price;
    963. 

  963. 			$receipt->update(array('where'=>'rid='.$rid));
    964. 

  964. 		}
    965. 

  965. 		return "/approval";
    966. 

  966. 	}
    967. 

  967. 	
    968. 

  968. 	function updateApprovalReceipt(){
    969. 

  969. 		$opinion=$this->get_args('opinion')?$this->get_args('opinion'):"";
    970. 

  970. 		$status=$this->get_args('status')&&is_numeric($this->get_args('status'))?$this->get_args('status'):0;
    971. 

  971. 		$rid=$this->get_args('rid')&&is_numeric($this->get_args('rid'))?$this->get_args('rid'):0;
    972. 

  972. 		$Locate=$this->get_args('Locate')&&is_numeric($this->get_args('Locate'))?$this->get_args('Locate'):0;
    973. 

  973. 		
    974. 

  974. 		if(!empty($rid)){
    975. 

  975. 			Doo::loadModel("receipt");
    976. 

  976. 			Doo::loadModel("verify");
    977. 

  977. 			Doo::loadModel("receiptDetail");
    978. 

  978. 			$receiptDetailObj=new receiptDetail();
    979. 

  979. 			Doo::loadModel("itemStatistics");
    980. 

  980. 			Doo::loadModel("statistics");
    981. 

  981. 			$statistics=new statistics();
    982. 

  982. 			$itemStatistics=new itemStatistics();
    983. 

  983. 			$verify=new verify();
    984. 

  984. 			$receipt=new receipt();
    985. 

  985. 			
    986. 

  986. 			$receiptDetail=$receipt->getOne(array('where'=>'rid='.$rid.' and status=2 ','asArray'=>true));
    987. 

  987. 			if (empty($receiptDetail))
    988. 

  988. 				return "/approval";
    989. 

  989. 			
    990. 

  990. 			$verifyStaff=json_decode($receiptDetail['verifyStaff'],true);	
    991. 

  991. 

  992. 			if(empty($opinion)){
    993. 

  993. 				if ($status==3)
    994. 

  994. 					$opinion="退回";
    995. 

  995. 				else 
    996. 

  996. 					$opinion="同意支付";
    997. 

  997. 			}
    998. 

  998. 			
    999. 

  999. 			if(empty($verifyStaff)){
    1000. 

  1000. 				$verifyStaff=array($this->staff[0]['sid']=>array('date'=>date('Y-m-d'),'opinion'=>$opinion,'status'=>$status));
    1001. 

  1001. 				if($status==3)
    1002. 

  1002. 					$verifyStaff=array('final'=>$status,$this->staff[0]['sid']=>array('date'=>date('Y-m-d'),'opinion'=>$opinion,'status'=>$status));
    1003. 

  1003. 				
    1004. 

  1004. 				$vStaffString=json_encode($verifyStaff);
    1005. 

  1005. 				$receipt->verifyStaff=$vStaffString;
    1006. 

  1006. 			}else{
    1007. 

  1007. 				if (!array_key_exists($this->staff[0]['sid'],$verifyStaff)){
    1008. 

  1008. 					$verifyStaff[$this->staff[0]['sid']]=array('date'=>date('Y-m-d'),'opinion'=>$opinion,'status'=>$status);
    1009. 

  1009. 					if($status==3){
    1010. 

  1010. 						$verifyStaff['final']=$status;
    1011. 

  1011. 						$verifyStaff[$this->staff[0]['sid']]=array('date'=>date('Y-m-d'),'opinion'=>$opinion,'status'=>$status);
    1012. 

  1012. 					}
    1013. 

  1013. 					$vStaffString=json_encode($verifyStaff);
    1014. 

  1014. 					$receipt->verifyStaff=$vStaffString;
    1015. 

  1015. 				}
    1016. 

  1016. 			}
    1017. 

  1017. 			
    1018. 

  1018. 			$verifyDetail=$verify->getOne(array('where'=>' vid ='.$receiptDetail['verify'],'asArray'=>true));
    1019. 

  1019. 			$verifyDetail=json_decode($verifyDetail['staff'],true);
    1020. 

  1020. 			
    1021. 

  1021. 			if (isset($verifyStaff['final'])){//rDetail
    1022. 

  1022. 				$receipt->status=3;
    1023. 

  1023. 				$receiptDetailObj->status=3;
    1024. 

  1024. 				$receiptDetailObj->update(array('where'=>'rid='.$rid));
    1025. 

  1025. 			}elseif(count($verifyStaff)==count($verifyDetail)){
    1026. 

  1026. 				$receipt->status=1;
    1027. 

  1027. 				if(!empty($receiptDetail['reviseDetail'])){//statistics item rDetail
    1028. 

  1028. 					$reviseDetail=json_decode($receiptDetail['reviseDetail'],true);
    1029. 

  1029. 					$reviseSum=0;
    1030. 

  1030. 					foreach ($reviseDetail as $key=>$value){
    1031. 

  1031. 						$receiptDetailObj=new receiptDetail();
    1032. 

  1032. 						$receiptDetailObj->staff=$receiptDetail['staff'];// $this->staff[0]['sid'];
    1033. 

  1033. 						$receiptDetailObj->item=$value['description'];
    1034. 

  1034. 						$receiptDetailObj->itemCategory="报销金额调整";
    1035. 

  1035. 						$receiptDetailObj->price=$value['price'];
    1036. 

  1036. 						$receiptDetailObj->date=$receiptDetail['date'];
    1037. 

  1037. 						$receiptDetailObj->cid=$this->staff[0]['cid'];
    1038. 

  1038. 						$receiptDetailObj->rid=$rid;
    1039. 

  1039. 						$receiptDetailObj->status=1;
    1040. 

  1040. 						$receiptDetailObj->insert();
    1041. 

  1041. 						$reviseSum+=$value['price'];
    1042. 

  1042. 					}
    1043. 

  1043. 					
    1044. 

  1044. 					$itemStatistics=new itemStatistics();
    1045. 

  1045. 					$itemStatistics->cid=$receiptDetail['cid'];//$this->staff[0]['cid'];
    1046. 

  1046. 					$itemStatistics->staff=$receiptDetail['staff'];//$this->staff[0]['sid'];
    1047. 

  1047. 					$itemStatistics->price=$reviseSum;
    1048. 

  1048. 					$itemStatistics->itemCategory="报销金额调整";
    1049. 

  1049. 					$itemStatistics->date=$receiptDetail['date'];
    1050. 

  1050. 					$itemStatistics->insert();
    1051. 

  1051. 				}
    1052. 

  1052. 				$receiptDetailObj=new receiptDetail();
    1053. 

  1053. 				$receiptDetailObj->status=1;
    1054. 

  1054. 				$receiptDetailObj->update(array('where'=>'rid='.$rid));
    1055. 

  1055. 				
    1056. 

  1056. 				$dateArray=explode("-", $receiptDetail['date']);
    1057. 

  1057. 				$dateCondition=" and Year(date) =".$dateArray[0]." and Month(date) = ".$dateArray[1];
    1058. 

  1058. 				$stat=$statistics->getOne(array('where'=>'staff='.$receiptDetail['staff'].$dateCondition,'asArray'=>true));
    1059. 

  1059. 				if(empty($stat)){
    1060. 

  1060. 					$statistics->date=$receiptDetail['date'];
    1061. 

  1061. 					$statistics->cid=$receiptDetail['cid'];//$this->staff[0]['cid'];
    1062. 

  1062. 					$statistics->staff=$receiptDetail['staff'];//$this->staff[0]['sid'];
    1063. 

  1063. 					$statistics->agPrice=$receiptDetail['sum'];
    1064. 

  1064. 					$statistics->rePrice=$reviseSum;
    1065. 

  1065. 					$statistics->insert();
    1066. 

  1066. 				}else{
    1067. 

  1067. 					$statistics->agPrice=$stat['agPrice']+$receiptDetail['sum'];
    1068. 

  1068. 					$statistics->rePrice=$stat['rePrice']+$reviseSum;
    1069. 

  1069. 					$statistics->update(array('where'=>'sid='.$stat['sid']));
    1070. 

  1070. 				}
    1071. 

  1071. 				
    1072. 

  1072. 				$dateArray=explode("-", $receiptDetail['date']);
    1073. 

  1073. 				$dateCondition=" and Year(date) =".$dateArray[0]." and Month(date) = ".$dateArray[1];	
    1074. 

  1074. 				$accountItem=json_decode($receiptDetail['accountItem'],true);
    1075. 

  1075. 				foreach ($accountItem['cSum'] as $key=>$value){
    1076. 

  1076. 				if($key=="agencySum"){
    1077. 

  1077. 					$iStatistics=$itemStatistics->getOne(array('where'=>'staff='.$receiptDetail['staff'].' and itemCategory="'.$this->AGENCY.'"'.$dateCondition,'asArray'=>true));
    1078. 

  1078. 					if(empty($iStatistics)){
    1079. 

  1079. 						$itemStatistics->cid=$receiptDetail['cid'];;
    1080. 

  1080. 						$itemStatistics->staff=$receiptDetail['staff'];
    1081. 

  1081. 						$itemStatistics->price=$value;
    1082. 

  1082. 						$itemStatistics->itemCategory=$this->AGENCY;
    1083. 

  1083. 						$itemStatistics->date=$receiptDetail['date'];
    1084. 

  1084. 						$itemStatistics->insert();
    1085. 

  1085. 					}else{
    1086. 

  1086. 						if (!empty($value)){
    1087. 

  1087. 							$itemStatistics->price=$value+$iStatistics['price'];
    1088. 

  1088. 							$itemStatistics->update(array('where'=>'sid='.$iStatistics['sid']));
    1089. 

  1089. 						}
    1090. 

  1090. 					}
    1091. 

  1091. 				}elseif($key=="travelSum"){
    1092. 

  1092. 					$iStatistics=$itemStatistics->getOne(array('where'=>'staff='.$receiptDetail['staff'].' and itemCategory="'.$this->TRAVEL.'"'.$dateCondition,'asArray'=>true));
    1093. 

  1093. 					if(empty($iStatistics)){
    1094. 

  1094. 						$itemStatistics->cid=$receiptDetail['cid'];
    1095. 

  1095. 						$itemStatistics->staff=$receiptDetail['staff'];
    1096. 

  1096. 						$itemStatistics->price=$value;
    1097. 

  1097. 						$itemStatistics->itemCategory=$this->TRAVEL;
    1098. 

  1098. 						$itemStatistics->date=$receiptDetail['date'];
    1099. 

  1099. 						$itemStatistics->insert();
    1100. 

  1100. 					}else{
    1101. 

  1101. 						if (!empty($value)){
    1102. 

  1102. 							$itemStatistics->price=$value+$iStatistics['price'];
    1103. 

  1103. 							$itemStatistics->update(array('where'=>'sid='.$iStatistics['sid']));
    1104. 

  1104. 						}
    1105. 

  1105. 					}
    1106. 

  1106. 				}elseif($key=="trainSum"){
    1107. 

  1107. 					$iStatistics=$itemStatistics->getOne(array('where'=>'staff='.$receiptDetail['staff'].' and itemCategory="'.$this->TRAIN.'"'.$dateCondition,'asArray'=>true));
    1108. 

  1108. 					if(empty($iStatistics)){
    1109. 

  1109. 						$itemStatistics->cid=$receiptDetail['cid'];
    1110. 

  1110. 						$itemStatistics->staff=$receiptDetail['staff'];
    1111. 

  1111. 						$itemStatistics->price=$value;
    1112. 

  1112. 						$itemStatistics->itemCategory=$this->TRAIN;
    1113. 

  1113. 						$itemStatistics->date=$receiptDetail['date'];
    1114. 

  1114. 						$itemStatistics->insert();
    1115. 

  1115. 					}else{
    1116. 

  1116. 						if (!empty($value)){
    1117. 

  1117. 							$itemStatistics->price=$value+$iStatistics['price'];
    1118. 

  1118. 							$itemStatistics->update(array('where'=>'sid='.$iStatistics['sid']));
    1119. 

  1119. 						}
    1120. 

  1120. 					}
    1121. 

  1121. 				}elseif($key=="otherSum"){
    1122. 

  1122. 					$iStatistics=$itemStatistics->getOne(array('where'=>'staff='.$receiptDetail['staff'].' and itemCategory="'.$this->OTHER.'"'.$dateCondition,'asArray'=>true));
    1123. 

  1123. 					if(empty($iStatistics)){
    1124. 

  1124. 						$itemStatistics->cid=$receiptDetail['cid'];
    1125. 

  1125. 						$itemStatistics->staff=$receiptDetail['staff'];
    1126. 

  1126. 						$itemStatistics->price=$value;
    1127. 

  1127. 						$itemStatistics->itemCategory=$this->OTHER;
    1128. 

  1128. 						$itemStatistics->date=$receiptDetail['date'];
    1129. 

  1129. 						$itemStatistics->insert();
    1130. 

  1130. 					}else{
    1131. 

  1131. 						if (!empty($value)){
    1132. 

  1132. 							$itemStatistics->price=$value+$iStatistics['price'];
    1133. 

  1133. 							$itemStatistics->update(array('where'=>'sid='.$iStatistics['sid']));
    1134. 

  1134. 						}
    1135. 

  1135. 					}
    1136. 

  1136. 				}
    1137. 

  1137. 			}
    1138. 

  1138. 				$receipt->pastDate=date("Y-m-d");
    1139. 

  1139. 			}
    1140. 

  1140. 			
    1141. 

  1141. 			$receipt->update(array('where'=>'rid='.$rid));
    1142. 

  1142. 			return "/approval#".$Locate;
    1143. 

  1143. 		}
    1144. 

  1144. 	}
    1145. 

  1145. 	
    1146. 

  1146. 	function revisePrice(){
    1147. 

  1147. 		$description=$this->get_args('description')?$this->get_args('description'):"";
    1148. 

  1148. 		$price=$this->get_args('price')&&is_numeric($this->get_args('price'))?$this->get_args('price'):0;
    1149. 

  1149. 		$rid=$this->get_args('rid')&&is_numeric($this->get_args('rid'))?$this->get_args('rid'):0;
    1150. 

  1150. 		
    1151. 

  1151. 		if (!empty($rid)){
    1152. 

  1152. 			Doo::loadModel("receipt");
    1153. 

  1153. 			$receipt=new receipt();
    1154. 

  1154. 			
    1155. 

  1155. 			$receiptDetail=$receipt->getOne(array('where'=>'rid='.$rid.' and status=2 ','asArray'=>true));
    1156. 

  1156. 			if (empty($receiptDetail))
    1157. 

  1157. 				return "/approval";
    1158. 

  1158. 				
    1159. 

  1159. 			$reviseDetail=array();
    1160. 

  1160. 			if (empty($receiptDetail['reviseDetail'])){
    1161. 

  1161. 				array_push($reviseDetail, array('sid'=>$this->staff[0]['sid'],'name'=>$this->staff[0]['username'],'description'=>$description,'price'=>$price));
    1162. 

  1162. 				$reviseDetailString=json_encode($reviseDetail);
    1163. 

  1163. 				$receipt->reviseDetail=$reviseDetailString;
    1164. 

  1164. 				$receipt->revisePrice=$price;
    1165. 

  1165. 				$receipt->sum=bcadd($receiptDetail['sum'],$price,2);
    1166. 

  1166. 			}else{
    1167. 

  1167. 				$reviseDetail=json_decode($receiptDetail['reviseDetail'],true);
    1168. 

  1168. 				array_push($reviseDetail,array('sid'=>$this->staff[0]['sid'],'name'=>$this->staff[0]['username'],'description'=>$description,'price'=>$price));
    1169. 

  1169. 				$reviseDetailString=json_encode($reviseDetail);
    1170. 

  1170. 				$receipt->reviseDetail=$reviseDetailString;
    1171. 

  1171. 				$receipt->revisePrice=round($price,2)+round($receiptDetail['revisePrice'],2);
    1172. 

  1172. 				$receipt->sum=bcadd($receiptDetail['sum'],$price,2);
    1173. 

  1173. 			}
    1174. 

  1174. 			$receipt->update(array('where'=>'rid='.$rid));
    1175. 

  1175. 		}
    1176. 

  1176. 		return "/approval";
    1177. 

  1177. 	}
    1178. 

  1178. 	
    1179. 

  1179. 	function personalCollect(){
    1180. 

  1180. 		$year=$this->get_args('year')?$this->get_args('year'):date("Y");
    1181. 

  1181. 		
    1182. 

  1182. 		$path=SITE_PATH.$this->PERSONALCOLLECTCACHEPATH."personalCollect_".$year.".htmls";
    1183. 

  1183. 		$this->showCache($path);		
    1184. 

  1184. 		
    1185. 

  1185. 		Doo::loadModel("receiptDetail");
    1186. 

  1186. 		Doo::loadModel("itemStatistics");
    1187. 

  1187. 		Doo::loadModel('statistics');
    1188. 

  1188. 		$statistics=new statistics();
    1189. 

  1189. 		$itemStatistics=new itemStatistics();
    1190. 

  1190. 		$receiptDetail=new receiptDetail();
    1191. 

  1191. 		
    1192. 

  1192. 		$receiptCollectList=$receiptDetail->find(array('select'=>'staff,sum(price) as price,itemCategory,Month(date) as month',
    1193. 

  1193. 		'where'=>'staff='.$this->staff[0]['sid']." and status=1 and Year(date)=".$year,'groupby'=>'itemCategory,Month(date)','asArray'=>true));
    1194. 

  1194. 		$data['itemStatisticsList']=$itemStatistics->find(array('where'=>'staff='.$this->staff[0]['sid'],'asArray'=>true));
    1195. 

  1195. 		
    1196. 

  1196. 		//create collect html
    1197. 

  1197. 		$collectArray=array('日常相关费用'=>array(),'差旅相关费用'=>array(),'培训班费用'=>array(),'其他'=>array());
    1198. 

  1198. 		$adjustment=array();
    1199. 

  1199. 		
    1200. 

  1200. 		$collectHtml=$this->collectHtml($receiptCollectList,'日常相关费用');
    1201. 

  1201. 		array_push($collectArray['日常相关费用'], $collectHtml);
    1202. 

  1202. 		
    1203. 

  1203. 		$collectHtml=$this->collectHtml($receiptCollectList,'差旅相关费用');
    1204. 

  1204. 		array_push($collectArray['差旅相关费用'], $collectHtml);
    1205. 

  1205. 		
    1206. 

  1206. 		$collectHtml=$this->collectHtml($receiptCollectList,'培训班费用');
    1207. 

  1207. 		array_push($collectArray['培训班费用'], $collectHtml);
    1208. 

  1208. 		
    1209. 

  1209. 		$collectHtml=$this->collectHtml($receiptCollectList,'其他');
    1210. 

  1210. 		array_push($collectArray['其他'], $collectHtml);
    1211. 

  1211. 		
    1212. 

  1212. 		$data['collectArray']=$collectArray;
    1213. 

  1213. 		//statistics html
    1214. 

  1214. 		$stList=$statistics->statisticsByYear($year,$this->staff[0]['sid']);
    1215. 

  1215. 		if(empty($stList))
    1216. 

  1216. 			$stList=array('rePrice'=>0,'agPrice'=>0);
    1217. 

  1217. 		$data['stList']=array('rePrice'=>$stList['rePrice'],'agPrice'=>$stList['agPrice'],'skPrice'=>($stList['rePrice']-$stList['agPrice']));
    1218. 

  1218. 		
    1219. 

  1219. 		//Adjustment price html
    1220. 

  1220. 		$collectHtml=$this->collectHtml($receiptCollectList,'报销金额调整');
    1221. 

  1221. 		array_push($adjustment, $collectHtml);
    1222. 

  1222. 		$data['adjustment']=$adjustment;
    1223. 

  1223. 		
    1224. 

  1224. 		//total price html
    1225. 

  1225. 		$collectHtml="";$total=0;
    1226. 

  1226. 		for ($i=1;$i<=12;$i++){
    1227. 

  1227. 			$sumPrice=0;
    1228. 

  1228. 			foreach ($receiptCollectList as $key=>$value){
    1229. 

  1229. 				if($value['month']==$i){
    1230. 

  1230. 					$sumPrice+=$value['price'];
    1231. 

  1231. 				}
    1232. 

  1232. 			}
    1233. 

  1233. 			if ($sumPrice==0)
    1234. 

  1234. 				$collectHtml.='<td class="taR">-</td>';
    1235. 

  1235. 			else
    1236. 

  1236. 				$collectHtml.='<td class="taR">￥'.$sumPrice.'</td>';
    1237. 

  1237. 			$total+=$sumPrice;
    1238. 

  1238. 		}
    1239. 

  1239. 		$collectHtml.='<td class="taR colGreen">￥'.$total.'</td>';
    1240. 

  1240. 		$data['totalPrice']=$collectHtml;
    1241. 

  1241. 		$data['year']=$year;
    1242. 

  1242. 		$data['totalYear']=$total;
    1243. 

  1243. 		$data['memu']="receipt";
    1244. 

  1244. 		$data['staff']=$this->staff;
    1245. 

  1245. 		$data['receiptMemu']='personalCollect';
    1246. 

  1246. 		$data['verifyId']=$this->verifyId;
    1247. 

  1247. 		
    1248. 

  1248. 		//year staff status 2,4
    1249. 

  1249. 		if($year<date("Y")){
    1250. 

  1250. 			Doo::loadModel('receipt');
    1251. 

  1251. 			$receipt=new receipt();
    1252. 

  1252. 			$receiptList=$receipt->find(array('where'=>'staff='.$this->staff[0]['sid'].' and (status=2 or status=4) and Year(date) ='.$year,'asArray'=>true));
    1253. 

  1253. 			if(empty($receiptList)){
    1254. 

  1254. 				ob_start();
    1255. 

  1255. 			$this->render ( "/admin/saea_slist_collect", $data );
    1256. 

  1256. 			$this->cacheFile($path);die;
    1257. 

  1257. 			}
    1258. 

  1258. 		}
    1259. 

  1259. 		$this->render ( "/admin/saea_slist_collect", $data );
    1260. 

  1260. 	}
    1261. 

  1261. 	
    1262. 

  1262. 	function personalCollectDetail(){
    1263. 

  1263. 		$year=$this->get_args('year')?$this->get_args('year'):date("Y");
    1264. 

  1264. 		
    1265. 

  1265. 		$path=SITE_PATH.$this->PERSONALCOLLECTCACHEPATH."personalCollectDetail_".$year.".htmls";
    1266. 

  1266. 		$this->showCache($path);	
    1267. 

  1267. 		
    1268. 

  1268. 		Doo::loadModel("receiptDetail");
    1269. 

  1269. 		Doo::loadModel("itemStatistics");
    1270. 

  1270. 		Doo::loadModel('statistics');
    1271. 

  1271. 		Doo::loadModel('accountItem');
    1272. 

  1272. 		$accountItem=new accountItem();
    1273. 

  1273. 		$statistics=new statistics();
    1274. 

  1274. 		$itemStatistics=new itemStatistics();
    1275. 

  1275. 		$receiptDetail=new receiptDetail();
    1276. 

  1276. 		
    1277. 

  1277. 		$receiptCollectList=$receiptDetail->find(array('select'=>'staff,item,sum(price) as price,itemCategory,Month(date) as month',
    1278. 

  1278. 		'where'=>'staff='.$this->staff[0]['sid']." and status=1 and Year(date)=".$year,'groupby'=>'item,Month(date)','asArray'=>true));
    1279. 

  1279. 		
    1280. 

  1280. 		$accountList=$accountItem->find(array('asArray'=>true));
    1281. 

  1281. 		
    1282. 

  1282. 		//create CollectDetail HTML
    1283. 

  1283. 		$collectHtml=array();
    1284. 

  1284. 		foreach ($accountList as $key=>$value){
    1285. 

  1285. 			$html="";$asum=0;
    1286. 

  1286. 			for ($i=1;$i<=12;$i++){
    1287. 

  1287. 				$falg=true;
    1288. 

  1288. 				foreach ($receiptCollectList as $v) {
    1289. 

  1289. 					if($value['category']==$v['itemCategory']&&$v['item']==$value['name']&&$i==$v['month']){
    1290. 

  1290. 						$asum+=$v['price'];
    1291. 

  1291. 						$html.='<td class="taR">￥'.$v['price'].'</td>';$falg=false;break;
    1292. 

  1292. 					}
    1293. 

  1293. 				}	
    1294. 

  1294. 				if($falg)
    1295. 

  1295. 					$html.='<td class="taR">-</td>';
    1296. 

  1296. 			} 
    1297. 

  1297. 			$html.='<td class="taR colGreen"><b>￥'.$asum.'</b></td>';
    1298. 

  1298. 			$collectHtml[$value['category']][$value['name']]=$html;
    1299. 

  1299. 		}
    1300. 

  1300. 		$data['collectHtml']=$collectHtml;
    1301. 

  1301. 		
    1302. 

  1302. 		//create  Adjustment price html
    1303. 

  1303. 		$receiptCollectList=$receiptDetail->find(array('select'=>'staff,sum(price) as price,itemCategory,Month(date) as month',
    1304. 

  1304. 		'where'=>'staff='.$this->staff[0]['sid']." and status=1 and Year(date)=".$year,'groupby'=>'itemCategory,Month(date)','asArray'=>true));
    1305. 

  1305. 		
    1306. 

  1306. 		$adjustment=array();$collectArray=array('日常相关费用'=>array(),'差旅相关费用'=>array(),'培训班费用'=>array(),'其他'=>array());
    1307. 

  1307. 		
    1308. 

  1308. 		$collectHtml=$this->collectHtml($receiptCollectList,'日常相关费用','b');
    1309. 

  1309. 		array_push($collectArray['日常相关费用'], $collectHtml);
    1310. 

  1310. 		
    1311. 

  1311. 		$collectHtml=$this->collectHtml($receiptCollectList,'差旅相关费用','b');
    1312. 

  1312. 		array_push($collectArray['差旅相关费用'], $collectHtml);
    1313. 

  1313. 		
    1314. 

  1314. 		$collectHtml=$this->collectHtml($receiptCollectList,'培训班费用','b');
    1315. 

  1315. 		array_push($collectArray['培训班费用'], $collectHtml);
    1316. 

  1316. 		
    1317. 

  1317. 		$collectHtml=$this->collectHtml($receiptCollectList,'其他','b');
    1318. 

  1318. 		array_push($collectArray['其他'], $collectHtml);
    1319. 

  1319. 		
    1320. 

  1320. 		$collectHtml=$this->collectHtml($receiptCollectList,'报销金额调整');
    1321. 

  1321. 		array_push($adjustment, $collectHtml);
    1322. 

  1322. 		
    1323. 

  1323. 		//total price html
    1324. 

  1324. 		$collectHtml="";$total=0;
    1325. 

  1325. 		for ($i=1;$i<=12;$i++){
    1326. 

  1326. 			$sumPrice=0;
    1327. 

  1327. 			foreach ($receiptCollectList as $key=>$value){
    1328. 

  1328. 				if($value['month']==$i){
    1329. 

  1329. 					$sumPrice+=$value['price'];
    1330. 

  1330. 				}
    1331. 

  1331. 			}
    1332. 

  1332. 			if ($sumPrice==0)
    1333. 

  1333. 				$collectHtml.='<td class="taR">-</td>';
    1334. 

  1334. 			else
    1335. 

  1335. 				$collectHtml.='<td class="taR">￥'.$sumPrice.'</td>';
    1336. 

  1336. 			$total+=$sumPrice;
    1337. 

  1337. 		}
    1338. 

  1338. 		$collectHtml.='<td class="taR colGreen">￥'.$total.'</td>';
    1339. 

  1339. 		
    1340. 

  1340. 		//statistics html
    1341. 

  1341. 		$stList=$statistics->statisticsByYear($year,$this->staff[0]['sid']);
    1342. 

  1342. 		if(empty($stList))
    1343. 

  1343. 			$stList=array('rePrice'=>0,'agPrice'=>0);
    1344. 

  1344. 		$data['stList']=array('rePrice'=>$stList['rePrice'],'agPrice'=>$stList['agPrice'],'skPrice'=>($stList['rePrice']-$stList['agPrice']));
    1345. 

  1345. 		
    1346. 

  1346. 		$data['collectArray']=$collectArray;
    1347. 

  1347. 		$data['adjustment']=$adjustment;
    1348. 

  1348. 		$data['totalPrice']=$collectHtml;
    1349. 

  1349. 		$data['totalYear']=$total;
    1350. 

  1350. 		$data['year']=$year;
    1351. 

  1351. 		
    1352. 

  1352. 		$data['memu']="receipt";
    1353. 

  1353. 		$data['staff']=$this->staff;
    1354. 

  1354. 		$data['receiptMemu']='personalCollect';
    1355. 

  1355. 		$data['verifyId']=$this->verifyId;
    1356. 

  1356. 				
    1357. 

  1357. 		//year staff status 2,4
    1358. 

  1358. 		if($year<date("Y")){
    1359. 

  1359. 			Doo::loadModel('receipt');
    1360. 

  1360. 			$receipt=new receipt();
    1361. 

  1361. 			$receiptList=$receipt->find(array('where'=>'staff='.$this->staff[0]['sid'].' and (status=2 or status=4) and Year(date) ='.$year,'asArray'=>true));
    1362. 

  1362. 			if(empty($receiptList)){
    1363. 

  1363. 				ob_start();
    1364. 

  1364. 			$this->render ( "/admin/saeaCollectArticles", $data );
    1365. 

  1365. 			$this->cacheFile($path);die;
    1366. 

  1366. 			}
    1367. 

  1367. 		}
    1368. 

  1368. 		
    1369. 

  1369. 		$this->render ( "/admin/saeaCollectArticles", $data );
    1370. 

  1370. 	}
    1371. 

  1371. 	
    1372. 

  1372. 	function companyCategoryCollect(){
    1373. 

  1373. 		
    1374. 

  1374. 		$year=$this->get_args('year')?$this->get_args('year'):date("Y");
    1375. 

  1375. 		
    1376. 

  1376. 		$path=SITE_PATH.$this->CATEGORYCOLLECTPATH."categoryCollect_".$year.".htmls";
    1377. 

  1377. 		$this->showCache($path);	
    1378. 

  1378. 		
    1379. 

  1379. 		Doo::loadModel('L_category');
    1380. 

  1380. 		Doo::loadModel('itemStatistics');
    1381. 

  1381. 		Doo::loadModel('statistics');
    1382. 

  1382. 		$statistics=new statistics();
    1383. 

  1383. 		$Lcategory=new L_category();
    1384. 

  1384. 		$itemStatistics=new itemStatistics();
    1385. 

  1385. 		
    1386. 

  1386. 		$LcategoryList=$Lcategory->find(array('asArray'=>true));//'staff='.$this->staff[0]['sid']." and
    1387. 

  1387. 		$itemStatisticsList=$itemStatistics->find(array('select'=>'cid,staff,sum(price) as price,itemCategory,Month(date) as month',
    1388. 

  1388. 		'where'=>" Year(date)=".$year,'groupby'=>'cid,Month(date)','asArray'=>true));
    1389. 

  1389. 		
    1390. 

  1390. 		//ceatre companyCollectHtml
    1391. 

  1391. 		foreach ($LcategoryList as $value){
    1392. 

  1392. 			$html="";$asum=0;
    1393. 

  1393. 			for ($i=1;$i<=12;$i++){
    1394. 

  1394. 				$falg=true;
    1395. 

  1395. 				foreach ($itemStatisticsList as $v){
    1396. 

  1396. 					if($value['cid']==$v['cid']&&$i==$v['month']){
    1397. 

  1397. 						$asum+=$v['price'];
    1398. 

  1398. 						$html.='<td class="taR">￥'.$v['price'].'</td>';$falg=false;break;
    1399. 

  1399. 					}
    1400. 

  1400. 				}
    1401. 

  1401. 				if($falg)
    1402. 

  1402. 					$html.='<td class="taR">-</td>';
    1403. 

  1403. 			}
    1404. 

  1404. 			$html.='<td class="taR colGreen"><b>￥'.$asum.'</b></td>';
    1405. 

  1405. 			$collectHtml[$value['title']]=array('html'=>$html,'cid'=>$value['cid']);
    1406. 

  1406. 		}
    1407. 

  1407. 		$data['companyHtml']=$collectHtml;
    1408. 

  1408. 		
    1409. 

  1409. 		//total price html
    1410. 

  1410. 		$collectHtml="";$total=0;
    1411. 

  1411. 		for ($i=1;$i<=12;$i++){
    1412. 

  1412. 			$sumPrice=0;
    1413. 

  1413. 			foreach ($itemStatisticsList as $key=>$value){
    1414. 

  1414. 				if($value['month']==$i){
    1415. 

  1415. 					$sumPrice+=$value['price'];
    1416. 

  1416. 				}
    1417. 

  1417. 			}
    1418. 

  1418. 			if ($sumPrice==0)
    1419. 

  1419. 				$collectHtml.='<td class="taR">-</td>';
    1420. 

  1420. 			else
    1421. 

  1421. 				$collectHtml.='<td class="taR">￥'.$sumPrice.'</td>';
    1422. 

  1422. 			$total+=$sumPrice;
    1423. 

  1423. 		}
    1424. 

  1424. 		$collectHtml.='<td class="taR colGreen">￥'.$total.'</td>';
    1425. 

  1425. 		$data['companyTotalHtml']=$collectHtml;
    1426. 

  1426. 		$data['total']=$total;
    1427. 

  1427. 		
    1428. 

  1428. 		//statistics html
    1429. 

  1429. 		$stList=$statistics->statisticsByComPanyYear($year,$this->staff[0]['sid']);
    1430. 

  1430. 		if(empty($stList))
    1431. 

  1431. 			$stList=array('rePrice'=>0,'agPrice'=>0);
    1432. 

  1432. 		$data['stList']=array('rePrice'=>$stList['rePrice'],'agPrice'=>$stList['agPrice'],'skPrice'=>($stList['rePrice']-$stList['agPrice']));
    1433. 

  1433. 		
    1434. 

  1434. 		$data['year']=$year;
    1435. 

  1435. 		
    1436. 

  1436. 		$data['memu']="receipt";
    1437. 

  1437. 		$data['staff']=$this->staff;
    1438. 

  1438. 		$data['receiptMemu']='companyCategoryCollect';
    1439. 

  1439. 		$data['verifyId']=$this->verifyId;
    1440. 

  1440. 		
    1441. 

  1441. 		//year staff status 2,4
    1442. 

  1442. 		if($year<date("Y")){
    1443. 

  1443. 			Doo::loadModel('receipt');
    1444. 

  1444. 			$receipt=new receipt();
    1445. 

  1445. 			$receiptList=$receipt->find(array('where'=>'Year(date) ='.$year.' and (status=2 or status=4)','asArray'=>true));
    1446. 

  1446. 			if(empty($receiptList)){
    1447. 

  1447. 				ob_start();
    1448. 

  1448. 			$this->render ( "/admin/saeaCompanyCollect", $data );
    1449. 

  1449. 			$this->cacheFile($path);die;
    1450. 

  1450. 			}
    1451. 

  1451. 		}
    1452. 

  1452. 		
    1453. 

  1453. 		$this->render ( "/admin/saeaCompanyCollect", $data );
    1454. 

  1454. 	}
    1455. 

  1455. 	
    1456. 

  1456. 	function categoryCollectDetail(){
    1457. 

  1457. 		$year=$this->get_args('year')?$this->get_args('year'):date("Y");
    1458. 

  1458. 		$cid=isset($this->params['cid'])&&is_numeric($this->params['cid'])?$this->params['cid']:0;
    1459. 

  1459. 		
    1460. 

  1460. 		$path=SITE_PATH.$this->CATEGORYCOLLECTPATH."categoryCollectDetail_".$year."_".$cid.".htmls";
    1461. 

  1461. 		$this->showCache($path);
    1462. 

  1462. 		
    1463. 

  1463. 		Doo::loadModel('statistics');
    1464. 

  1464. 		$statistics=new statistics();
    1465. 

  1465. 		Doo::loadModel("receiptDetail");
    1466. 

  1466. 		$receiptDetail=new receiptDetail();
    1467. 

  1467. 		Doo::loadModel('L_category');
    1468. 

  1468. 		$Lcategory=new L_category();
    1469. 

  1469. 		Doo::loadModel('accountItem');
    1470. 

  1470. 		$accountItem=new accountItem();
    1471. 

  1471. 		
    1472. 

  1472. 		$LcategoryList=$Lcategory->find(array('asArray'=>true));
    1473. 

  1473. 		
    1474. 

  1474. 		if ($cid==0){
    1475. 

  1475. 			$cid=$this->get_args('cid')?$this->get_args('cid'):0;
    1476. 

  1476. 			if ($cid==0)
    1477. 

  1477. 				$cid=$LcategoryList[0]['cid'];
    1478. 

  1478. 		}
    1479. 

  1479. 		$data['LcategoryList']=$LcategoryList;
    1480. 

  1480. 		
    1481. 

  1481. 		
    1482. 

  1482. 		$receiptCollectList=$receiptDetail->find(array('select'=>'staff,item,sum(price) as price,itemCategory,Month(date) as month',
    1483. 

  1483. 		'where'=>'cid='.$cid." and status=1 and Year(date)=".$year,'groupby'=>'item,Month(date)','asArray'=>true));
    1484. 

  1484. 		$accountList=$accountItem->find(array('asArray'=>true));
    1485. 

  1485. 		//create CollectDetail HTML
    1486. 

  1486. 		$collectHtml=array();
    1487. 

  1487. 		foreach ($accountList as $key=>$value){
    1488. 

  1488. 			$html="";$asum=0;
    1489. 

  1489. 			for ($i=1;$i<=12;$i++){
    1490. 

  1490. 				$falg=true;
    1491. 

  1491. 				foreach ($receiptCollectList as $v) {
    1492. 

  1492. 					if($value['category']==$v['itemCategory']&&$v['item']==$value['name']&&$i==$v['month']){
    1493. 

  1493. 						$asum+=$v['price'];
    1494. 

  1494. 						$html.='<td class="taR">￥'.$v['price'].'</td>';$falg=false;break;
    1495. 

  1495. 					}
    1496. 

  1496. 				}	
    1497. 

  1497. 				if($falg)
    1498. 

  1498. 					$html.='<td class="taR">-</td>';
    1499. 

  1499. 			} 
    1500. 

  1500. 			$html.='<td class="taR colGreen"><b>￥'.$asum.'</b></td>';
    1501. 

  1501. 			$collectHtml[$value['category']][$value['name']]=$html;
    1502. 

  1502. 		}
    1503. 

  1503. 		$data['collectHtml']=$collectHtml;
    1504. 

  1504. 		
    1505. 

  1505. 		//create  Adjustment price html
    1506. 

  1506. 		$receiptCollectList=$receiptDetail->find(array('select'=>'staff,sum(price) as price,itemCategory,Month(date) as month',
    1507. 

  1507. 		'where'=>'cid='.$cid." and status=1 and Year(date)=".$year,'groupby'=>'itemCategory,Month(date)','asArray'=>true));
    1508. 

  1508. 		
    1509. 

  1509. 		$adjustment=array();$collectArray=array('日常相关费用'=>array(),'差旅相关费用'=>array(),'培训班费用'=>array(),'其他'=>array());
    1510. 

  1510. 		
    1511. 

  1511. 		$collectHtml=$this->collectHtml($receiptCollectList,'日常相关费用','b');
    1512. 

  1512. 		array_push($collectArray['日常相关费用'], $collectHtml);
    1513. 

  1513. 		
    1514. 

  1514. 		$collectHtml=$this->collectHtml($receiptCollectList,'差旅相关费用','b');
    1515. 

  1515. 		array_push($collectArray['差旅相关费用'], $collectHtml);
    1516. 

  1516. 		
    1517. 

  1517. 		$collectHtml=$this->collectHtml($receiptCollectList,'培训班费用','b');
    1518. 

  1518. 		array_push($collectArray['培训班费用'], $collectHtml);
    1519. 

  1519. 		
    1520. 

  1520. 		$collectHtml=$this->collectHtml($receiptCollectList,'其他','b');
    1521. 

  1521. 		array_push($collectArray['其他'], $collectHtml);
    1522. 

  1522. 		$data['collectArray']=$collectArray;
    1523. 

  1523. 		
    1524. 

  1524. 		$collectHtml=$this->collectHtml($receiptCollectList,'报销金额调整');
    1525. 

  1525. 		array_push($adjustment, $collectHtml);
    1526. 

  1526. 		$data['adjustment']=$adjustment;
    1527. 

  1527. 		
    1528. 

  1528. 		//total price html
    1529. 

  1529. 		$collectHtml="";$total=0;
    1530. 

  1530. 		for ($i=1;$i<=12;$i++){
    1531. 

  1531. 			$sumPrice=0;
    1532. 

  1532. 			foreach ($receiptCollectList as $key=>$value){
    1533. 

  1533. 				if($value['month']==$i){
    1534. 

  1534. 					$sumPrice+=$value['price'];
    1535. 

  1535. 				}
    1536. 

  1536. 			}
    1537. 

  1537. 			if ($sumPrice==0)
    1538. 

  1538. 				$collectHtml.='<td class="taR">-</td>';
    1539. 

  1539. 			else
    1540. 

  1540. 				$collectHtml.='<td class="taR">￥'.$sumPrice.'</td>';
    1541. 

  1541. 			$total+=$sumPrice;
    1542. 

  1542. 		}
    1543. 

  1543. 		$collectHtml.='<td class="taR colGreen">￥'.$total.'</td>';
    1544. 

  1544. 		
    1545. 

  1545. 		//statistics html
    1546. 

  1546. 		$stList=$statistics->statisticsByCid($year,$cid);
    1547. 

  1547. 		if(empty($stList))
    1548. 

  1548. 			$stList=array('rePrice'=>0,'agPrice'=>0);
    1549. 

  1549. 		$data['stList']=array('rePrice'=>$stList['rePrice'],'agPrice'=>$stList['agPrice'],'skPrice'=>($stList['rePrice']-$stList['agPrice']));
    1550. 

  1550. 		
    1551. 

  1551. 		$data['totalYear']=$total;
    1552. 

  1552. 		$data['year']=$year;
    1553. 

  1553. 		$data['cid']=$cid;
    1554. 

  1554. 		
    1555. 

  1555. 		$data['memu']="receipt";
    1556. 

  1556. 		$data['staff']=$this->staff;
    1557. 

  1557. 		$data['receiptMemu']='companyCategoryCollect';
    1558. 

  1558. 		$data['verifyId']=$this->verifyId;
    1559. 

  1559. 		
    1560. 

  1560. 		//year staff status 2,4
    1561. 

  1561. 		if($year<date("Y")){
    1562. 

  1562. 			Doo::loadModel('receipt');
    1563. 

  1563. 			$receipt=new receipt();
    1564. 

  1564. 			$receiptList=$receipt->find(array('where'=>'Year(date) ='.$year.' and cid ='.$cid.' and (status=2 or status=4)','asArray'=>true));
    1565. 

  1565. 			if(empty($receiptList)){
    1566. 

  1566. 				ob_start();
    1567. 

  1567. 			$this->render ( "/admin/saeaCategoryCollectDetail", $data );
    1568. 

  1568. 			$this->cacheFile($path);die;
    1569. 

  1569. 			}
    1570. 

  1570. 		}
    1571. 

  1571. 		
    1572. 

  1572. 		$this->render ( "/admin/saeaCategoryCollectDetail", $data );
    1573. 

  1573. 	}
    1574. 

  1574. 	
    1575. 

  1575. 	function staffCollect(){
    1576. 

  1576. 		
    1577. 

  1577. 		$year=$this->get_args('year')?$this->get_args('year'):date("Y");
    1578. 

  1578. 		
    1579. 

  1579. 		$path=SITE_PATH.$this->STAFFCOLLECTPATH."staffCollect_".$year."_.htmls";
    1580. 

  1580. 		//$this->showCache($path);
    1581. 

  1581. 		
    1582. 

  1582. 		Doo::loadModel('statistics');
    1583. 

  1583. 		$statistics=new statistics();
    1584. 

  1584. 		Doo::loadModel("receiptDetail");
    1585. 

  1585. 		$receiptDetail=new receiptDetail();
    1586. 

  1586. 		Doo::loadModel('L_category');
    1587. 

  1587. 		$Lcategory=new L_category();
    1588. 

  1588. 		Doo::loadModel('accountItem');
    1589. 

  1589. 		$accountItem=new accountItem();
    1590. 

  1590. 		Doo::loadModel('staff');
    1591. 

  1591. 		$staff=new staff();
    1592. 

  1592. 		Doo::loadModel('itemStatistics');
    1593. 

  1593. 		$itemStatistics=new itemStatistics();
    1594. 

  1594. 		
    1595. 

  1595. 		/*
    1596. 

  1596. 		$stList=$statistics->getOne(array('select'=>'sum(rePrice) as rePrice,sum(agPrice) as agPrice',
    1597. 

  1597. 		'where'=>" Year(date)=".$year,'groupby'=>'Month(date)','asArray'=>true));
    1598. 

  1598. 		if(empty($stList))
    1599. 

  1599. 			$stList=array('rePrice'=>0,'agPrice'=>0);
    1600. 

  1600. 		$data['stList']=array('rePrice'=>$stList['rePrice'],'agPrice'=>$stList['agPrice'],'skPrice'=>($stList['rePrice']-$stList['agPrice']));
    1601. 

  1601. 		*/
    1602. 

  1602. 		
    1603. 

  1603. 		//statistics html
    1604. 

  1604. 		$stList=$statistics->statisticsByComPanyYear($year,$this->staff[0]['sid']);
    1605. 

  1605. 		if(empty($stList))
    1606. 

  1606. 			$stList=array('rePrice'=>0,'agPrice'=>0);
    1607. 

  1607. 		$data['stList']=array('rePrice'=>$stList['rePrice'],'agPrice'=>$stList['agPrice'],'skPrice'=>($stList['rePrice']-$stList['agPrice']));
    1608. 

  1608. 		
    1609. 

  1609. 		//---
    1610. 

  1610. 		$staffList=$staff->find(array('where'=>'username !="admin"','asArray'=>true));
    1611. 

  1611. 		$LcategoryList=$Lcategory->find(array('asArray'=>true));//'staff='.$this->staff[0]['sid']." and
    1612. 

  1612. 		$itemStatisticsList=$itemStatistics->find(array('select'=>'cid,staff,sum(price) as price,itemCategory,Month(date) as month',
    1613. 

  1613. 		'where'=>" Year(date)=".$year,'groupby'=>'staff,Month(date)','asArray'=>true));
    1614. 

  1614. 		$categoryList=$staff->find(array('select'=>'COUNT(*) as count,cid,category','where'=>'username !="admin"','groupby'=>'cid','asArray'=>true));
    1615. 

  1615. 		
    1616. 

  1616. 		//ceatre companyCollectHtml
    1617. 

  1617. 		foreach ($categoryList as $vlu){
    1618. 

  1618. 			$count=$vlu['count']+1;
    1619. 

  1619. 			$html='<th rowspan="'.$count.'">'.$vlu['category'].'</th>';
    1620. 

  1620. 			$m1=0;$m2=0;$m3=0;$m4=0;$m5=0;$m6=0;$m7=0;$m8=0;$m9=0;$m10=0;$m11=0;$m12=0;$m13=0;
    1621. 

  1621. 			foreach ($staffList as $value){
    1622. 

  1622. 				if ($vlu['cid']==$value['cid']){
    1623. 

  1623. 					
    1624. 

  1624. 					$html.='<td><a href="/staffCollectDetail/'.$value['username'].'">'.$value['username'].'</a></td>';
    1625. 

  1625. 					$asum=0;
    1626. 

  1626. 					for ($i=1;$i<=12;$i++){
    1627. 

  1627. 						$falg=true;
    1628. 

  1628. 						foreach ($itemStatisticsList as $v){
    1629. 

  1629. 							if($value['sid']==$v['staff']&&$i==$v['month']){
    1630. 

  1630. 								if ($v['month']==1)
    1631. 

  1631. 									$m1+=$v['price'];
    1632. 

  1632. 								if ($v['month']==2)
    1633. 

  1633. 									$m2+=$v['price'];
    1634. 

  1634. 								if ($v['month']==3)
    1635. 

  1635. 									$m3+=$v['price'];
    1636. 

  1636. 								if ($v['month']==4)
    1637. 

  1637. 									$m4+=$v['price'];
    1638. 

  1638. 								if ($v['month']==5)
    1639. 

  1639. 									$m5+=$v['price'];	
    1640. 

  1640. 								if ($v['month']==6)
    1641. 

  1641. 									$m6+=$v['price'];
    1642. 

  1642. 								if ($v['month']==7)
    1643. 

  1643. 									$m7+=$v['price'];
    1644. 

  1644. 								if ($v['month']==8)
    1645. 

  1645. 									$m8+=$v['price'];
    1646. 

  1646. 								if ($v['month']==9)
    1647. 

  1647. 									$m9+=$v['price'];
    1648. 

  1648. 								if ($v['month']==10)
    1649. 

  1649. 									$m10+=$v['price'];
    1650. 

  1650. 								if ($v['month']==11)
    1651. 

  1651. 									$m11+=$v['price'];	
    1652. 

  1652. 								if ($v['month']==12)
    1653. 

  1653. 									$m12+=$v['price'];
    1654. 

  1654. 								$asum+=$v['price'];
    1655. 

  1655. 								$html.='<td class="taR">￥'.$v['price'].'</td>';$falg=false;break;
    1656. 

  1656. 							}
    1657. 

  1657. 						}
    1658. 

  1658. 						if($falg)
    1659. 

  1659. 							$html.='<td class="taR">-</td>';
    1660. 

  1660. 					}
    1661. 

  1661. 					$m13+=$asum;
    1662. 

  1662. 					$html.='<td class="taR colGreen"><b>￥'.$asum.'</b></td>';
    1663. 

  1663. 					$collectHtml[$value['username']]=array('html'=>$html,'sid'=>$value['sid']);
    1664. 

  1664. 					$html="";
    1665. 

  1665. 				}
    1666. 

  1666. 			}
    1667. 

  1667. 			$hl='<th class="taR">小计</th><td class="taR">￥'.$m1.'</td><td class="taR">￥'.$m2.'</td><td class="taR">￥'.$m3.'</td><td class="taR">￥'.$m4.'</td><td class="taR">￥'.$m5.'</td>
    1668. 

  1668. 				<td class="taR">￥'.$m6.'</td><td class="taR">￥'.$m7.'</td><td class="taR">￥'.$m8.'</td><td class="taR">￥'.$m9.'</td><td class="taR">￥'.$m10.'</td><td class="taR">￥'.$m11.'</td>
    1669. 

  1669. 				<td class="taR">￥'.$m12.'</td><td class="taR">￥'.$m13.'</td>';
    1670. 

  1670. 			$collectHtml[$vlu['cid']]=array('html'=>$hl,'sid'=>'');
    1671. 

  1671. 		}
    1672. 

  1672. 		$data['companyHtml']=$collectHtml;
    1673. 

  1673. 		
    1674. 

  1674. 		//total price html
    1675. 

  1675. 		$collectHtml="";$total=0;
    1676. 

  1676. 		for ($i=1;$i<=12;$i++){
    1677. 

  1677. 			$sumPrice=0;
    1678. 

  1678. 			foreach ($itemStatisticsList as $key=>$value){
    1679. 

  1679. 				if($value['month']==$i){
    1680. 

  1680. 					$sumPrice+=$value['price'];
    1681. 

  1681. 				}
    1682. 

  1682. 			}
    1683. 

  1683. 			if ($sumPrice==0)
    1684. 

  1684. 				$collectHtml.='<td class="taR">-</td>';
    1685. 

  1685. 			else
    1686. 

  1686. 				$collectHtml.='<td class="taR">￥'.$sumPrice.'</td>';
    1687. 

  1687. 			$total+=$sumPrice;
    1688. 

  1688. 		}
    1689. 

  1689. 		$collectHtml.='<td class="taR colGreen">￥'.$total.'</td>';
    1690. 

  1690. 		$data['companyTotalHtml']=$collectHtml;
    1691. 

  1691. 		$data['total']=$total;
    1692. 

  1692. 		
    1693. 

  1693. 		$data['year']=$year;
    1694. 

  1694. 		
    1695. 

  1695. 		$data['memu']="receipt";
    1696. 

  1696. 		$data['staff']=$this->staff;
    1697. 

  1697. 		$data['receiptMemu']='companyCategoryCollect';
    1698. 

  1698. 		$data['verifyId']=$this->verifyId;
    1699. 

  1699. 		
    1700. 

  1700. 		if ($year<=date("Y")){	
    1701. 

  1701. 			Doo::loadModel('receipt');
    1702. 

  1702. 			$receipt=new receipt();
    1703. 

  1703. 			$receiptList=$receipt->find(array('where'=>'(status=2 or status=4) and Year(date) ='.$year,'asArray'=>true));
    1704. 

  1704. 			if(empty($receiptList)){ //generated files
    1705. 

  1705. 				ob_start();
    1706. 

  1706. 				$this->render ( "/admin/saeaStaffCollectB", $data );
    1707. 

  1707. 				$this->cacheFile($path);die;
    1708. 

  1708. 			}
    1709. 

  1709. 		}
    1710. 

  1710. 		
    1711. 

  1711. 		$this->render ( "/admin/saeaStaffCollectB", $data );
    1712. 

  1712. 		
    1713. 

  1713. 	}
    1714. 

  1714. 	
    1715. 

  1715. 	function staffCollectBak(){
    1716. 

  1716. 		
    1717. 

  1717. 		$year=$this->get_args('year')?$this->get_args('year'):date("Y");
    1718. 

  1718. 		$month=$this->get_args('month')?$this->get_args('month'):1;
    1719. 

  1719. 		
    1720. 

  1720. 		$path=SITE_PATH.$this->STAFFCOLLECTPATH."staffCollect_".$year."_".$month.".htmls";
    1721. 

  1721. 		$this->showCache($path);
    1722. 

  1722. 		
    1723. 

  1723. 		Doo::loadModel('statistics');
    1724. 

  1724. 		$statistics=new statistics();
    1725. 

  1725. 		Doo::loadModel("receiptDetail");
    1726. 

  1726. 		$receiptDetail=new receiptDetail();
    1727. 

  1727. 		Doo::loadModel('L_category');
    1728. 

  1728. 		$Lcategory=new L_category();
    1729. 

  1729. 		Doo::loadModel('accountItem');
    1730. 

  1730. 		$accountItem=new accountItem();
    1731. 

  1731. 		Doo::loadModel('staff');
    1732. 

  1732. 		$staff=new staff();
    1733. 

  1733. 		Doo::loadModel('itemStatistics');
    1734. 

  1734. 		$itemStatistics=new itemStatistics();
    1735. 

  1735. 		
    1736. 

  1736. 		$itemStatisticsList=$itemStatistics->find(array('select'=>'cid,staff,sum(price) as price,itemCategory,Month(date) as month',
    1737. 

  1737. 		'where'=>'Month(date)='.$month." and Year(date)=".$year,'groupby'=>'staff,itemCategory,Month(date)','asArray'=>true));
    1738. 

  1738. 		$itemCategoryList=$itemStatistics->find(array('select'=>'cid,staff,sum(price) as price,itemCategory,Month(date) as month',
    1739. 

  1739. 		'where'=>'Month(date)='.$month." and Year(date)=".$year,'groupby'=>'cid,itemCategory,Month(date)','asArray'=>true));
    1740. 

  1740. 		
    1741. 

  1741. 		$LcategoryList=$Lcategory->find(array('asArray'=>true));
    1742. 

  1742. 		$staffList=$staff->find(array('asArray'=>true));
    1743. 

  1743. 		
    1744. 

  1744. 		$htmlArray=array();
    1745. 

  1745. 		foreach ($LcategoryList as $value){
    1746. 

  1746. 			$htmlArray[$value['title']]=array();
    1747. 

  1747. 			foreach ($staffList as $v){
    1748. 

  1748. 				if($value['cid']==$v['cid']){
    1749. 

  1749. 					$html="";$falg=true;$staffSumPrice=0;
    1750. 

  1750. 					
    1751. 

  1751. 					foreach ($itemStatisticsList as $a){
    1752. 

  1752. 						if($v['sid']==$a['staff']&&$a['itemCategory']=="日常相关费用"){
    1753. 

  1753. 							if(empty($a['price'])){
    1754. 

  1754. 								$html.='<td class="taR">-</td>';$falg=false;break;
    1755. 

  1755. 							}else{ 
    1756. 

  1756. 								$staffSumPrice+=$a['price'];
    1757. 

  1757. 								$html.='<td class="taR">￥'.$a['price'].'</td>';$falg=false;break;
    1758. 

  1758. 							}
    1759. 

  1759. 						}
    1760. 

  1760. 					}
    1761. 

  1761. 					if ($falg){
    1762. 

  1762. 						$html.='<td class="taR">-</td>';$falg=true;
    1763. 

  1763. 					}
    1764. 

  1764. 					
    1765. 

  1765. 					$falg=true;
    1766. 

  1766. 					foreach ($itemStatisticsList as $a){
    1767. 

  1767. 						if($v['sid']==$a['staff']&&$a['itemCategory']=="差旅相关费用"){
    1768. 

  1768. 							if(empty($a['price'])){
    1769. 

  1769. 								$html.='<td class="taR">-</td>';$falg=false;break;
    1770. 

  1770. 							}else{ 
    1771. 

  1771. 								$staffSumPrice+=$a['price'];
    1772. 

  1772. 								$html.='<td class="taR">￥'.$a['price'].'</td>';$falg=false;break;
    1773. 

  1773. 							}
    1774. 

  1774. 						}
    1775. 

  1775. 					}
    1776. 

  1776. 					if ($falg){
    1777. 

  1777. 						$html.='<td class="taR">-</td>';$falg=true;
    1778. 

  1778. 					}
    1779. 

  1779. 					
    1780. 

  1780. 					$falg=true;
    1781. 

  1781. 					foreach ($itemStatisticsList as $a){
    1782. 

  1782. 						if($v['sid']==$a['staff']&&$a['itemCategory']=="培训班费用"){
    1783. 

  1783. 							if(empty($a['price'])){
    1784. 

  1784. 								$html.='<td class="taR">-</td>';$falg=false;break;
    1785. 

  1785. 							}else{ 
    1786. 

  1786. 								$staffSumPrice+=$a['price'];
    1787. 

  1787. 								$html.='<td class="taR">￥'.$a['price'].'</td>';$falg=false;break;
    1788. 

  1788. 							}
    1789. 

  1789. 						}
    1790. 

  1790. 					}
    1791. 

  1791. 					if ($falg){
    1792. 

  1792. 						$html.='<td class="taR">-</td>';$falg=true;
    1793. 

  1793. 					}
    1794. 

  1794. 					
    1795. 

  1795. 					$falg=true;
    1796. 

  1796. 					foreach ($itemStatisticsList as $a){
    1797. 

  1797. 						if($v['sid']==$a['staff']&&$a['itemCategory']=="其他"){
    1798. 

  1798. 							if(!empty($a['price'])){
    1799. 

  1799. 								$staffSumPrice+=$a['price'];
    1800. 

  1800. 								$html.='<td class="taR">￥'.$a['price'].'</td>';$falg=false;break;
    1801. 

  1801. 							}else{ 
    1802. 

  1802. 								$html.='<td class="taR">-</td>';$falg=false;break;
    1803. 

  1803. 							}
    1804. 

  1804. 						}
    1805. 

  1805. 					}
    1806. 

  1806. 					if ($falg){
    1807. 

  1807. 						$html.='<td class="taR">-</td>';$falg=true;
    1808. 

  1808. 					}
    1809. 

  1809. 					
    1810. 

  1810. 					$falg=true;
    1811. 

  1811. 					foreach ($itemStatisticsList as $a){
    1812. 

  1812. 						if($v['sid']==$a['staff']&&$a['itemCategory']=="报销金额调整"){
    1813. 

  1813. 							if(!empty($a['price'])){
    1814. 

  1814. 								$staffSumPrice+=$a['price'];
    1815. 

  1815. 								$html.='<td class="taR">￥'.$a['price'].'</td>';$falg=false;break;
    1816. 

  1816. 							}else{ 
    1817. 

  1817. 								$html.='<td class="taR">-</td>';$falg=false;break;
    1818. 

  1818. 							}
    1819. 

  1819. 						}
    1820. 

  1820. 					}
    1821. 

  1821. 					if ($falg){
    1822. 

  1822. 						$html.='<td class="taR">-</td>';$falg=true;
    1823. 

  1823. 					}
    1824. 

  1824. 					
    1825. 

  1825. 					$html.='<td class="colGreen taR">￥'.$staffSumPrice.'</td>';
    1826. 

  1826. 					$htmlArray[$value['title']][$v['username']]=$html;
    1827. 

  1827. 				}
    1828. 

  1828. 			}
    1829. 

  1829. 			
    1830. 

  1830. 			/*-- ---*/
    1831. 

  1831. 			//合计费用
    1832. 

  1832. 			$cateHtml="";$catePrice=0;$cateFalg=true;
    1833. 

  1833. 			foreach ($itemCategoryList as $l){
    1834. 

  1834. 				if($value['cid']==$l['cid']&&$l['itemCategory']=="日常相关费用"){
    1835. 

  1835. 					if(empty($l['price'])){
    1836. 

  1836. 						$cateHtml.='<td class="colGreen taR">-</td>';$cateFalg=false;break;
    1837. 

  1837. 					}else{
    1838. 

  1838. 						$catePrice+=$l['price'];
    1839. 

  1839. 						$cateHtml.='<td class="colGreen taR">￥'.$l['price'].'</td>';$cateFalg=false;break;
    1840. 

  1840. 					}
    1841. 

  1841. 				}
    1842. 

  1842. 			}
    1843. 

  1843. 			if ($cateFalg){
    1844. 

  1844. 					$cateHtml.='<td class="colGreen taR">-</td>';$cateFalg=true;
    1845. 

  1845. 			}
    1846. 

  1846. 			
    1847. 

  1847. 			$cateFalg=true;
    1848. 

  1848. 			foreach ($itemCategoryList as $l){
    1849. 

  1849. 				if($value['cid']==$l['cid']&&$l['itemCategory']=="差旅相关费用"){
    1850. 

  1850. 					if(empty($l['price'])){
    1851. 

  1851. 						$cateHtml.='<td class="colGreen taR">-</td>';$cateFalg=false;break;
    1852. 

  1852. 					}else{
    1853. 

  1853. 						$catePrice+=$l['price'];
    1854. 

  1854. 						$cateHtml.='<td class="colGreen taR">￥'.$l['price'].'</td>';$cateFalg=false;break;
    1855. 

  1855. 					}
    1856. 

  1856. 				}
    1857. 

  1857. 			}
    1858. 

  1858. 			if ($cateFalg){
    1859. 

  1859. 					$cateHtml.='<td class="colGreen taR">-</td>';$cateFalg=true;
    1860. 

  1860. 			}
    1861. 

  1861. 			
    1862. 

  1862. 			$cateFalg=true;
    1863. 

  1863. 			foreach ($itemCategoryList as $l){
    1864. 

  1864. 				if($value['cid']==$l['cid']&&$l['itemCategory']=="培训班费用"){
    1865. 

  1865. 					if(empty($l['price'])){
    1866. 

  1866. 						$cateHtml.='<td class="colGreen taR">-</td>';$cateFalg=false;break;
    1867. 

  1867. 					}else{
    1868. 

  1868. 						$catePrice+=$l['price'];
    1869. 

  1869. 						$cateHtml.='<td class="colGreen taR">￥'.$l['price'].'</td>';$cateFalg=false;break;
    1870. 

  1870. 					}
    1871. 

  1871. 				}
    1872. 

  1872. 			}
    1873. 

  1873. 			if ($cateFalg){
    1874. 

  1874. 					$cateHtml.='<td class="colGreen taR">-</td>';$cateFalg=true;
    1875. 

  1875. 			}
    1876. 

  1876. 			
    1877. 

  1877. 			$cateFalg=true;
    1878. 

  1878. 			foreach ($itemCategoryList as $l){
    1879. 

  1879. 				if($value['cid']==$l['cid']&&$l['itemCategory']=="其他"){
    1880. 

  1880. 					if(empty($l['price'])){
    1881. 

  1881. 						$cateHtml.='<td class="colGreen taR">-</td>';$cateFalg=false;break;
    1882. 

  1882. 					}else{
    1883. 

  1883. 						$catePrice+=$l['price'];
    1884. 

  1884. 						$cateHtml.='<td class="colGreen taR">￥'.$l['price'].'</td>';$cateFalg=false;break;
    1885. 

  1885. 					}
    1886. 

  1886. 				}
    1887. 

  1887. 			}
    1888. 

  1888. 			if ($cateFalg){
    1889. 

  1889. 					$cateHtml.='<td class="colGreen taR">-</td>';$cateFalg=true;
    1890. 

  1890. 			}
    1891. 

  1891. 			
    1892. 

  1892. 			$cateFalg=true;
    1893. 

  1893. 			foreach ($itemCategoryList as $l){
    1894. 

  1894. 				if($value['cid']==$l['cid']&&$l['itemCategory']=="报销金额调整"){
    1895. 

  1895. 					if(empty($l['price'])){
    1896. 

  1896. 						$cateHtml.='<td class="colGreen taR">-</td>';$cateFalg=false;break;
    1897. 

  1897. 					}else{
    1898. 

  1898. 						$catePrice+=$l['price'];
    1899. 

  1899. 						$cateHtml.='<td class="colGreen taR">￥'.$l['price'].'</td>';$cateFalg=false;break;
    1900. 

  1900. 					}
    1901. 

  1901. 				}
    1902. 

  1902. 			}
    1903. 

  1903. 			if ($cateFalg){
    1904. 

  1904. 					$cateHtml.='<td class="colGreen taR">-</td>';$cateFalg=true;
    1905. 

  1905. 			}
    1906. 

  1906. 			
    1907. 

  1907. 			$cateHtml.='<td class="colGreen taR">￥'.$catePrice.'</td>';
    1908. 

  1908. 			$htmlArray[$value['title']]['合计']=$cateHtml;
    1909. 

  1909. 			/*-- ---*/
    1910. 

  1910. 		}
    1911. 

  1911. 		
    1912. 

  1912. 		//print_r($htmlArray);die;
    1913. 

  1913. 		$data['htmlArray']=$htmlArray;
    1914. 

  1914. 		
    1915. 

  1915. 		//statistics html
    1916. 

  1916. 		$stList=$statistics->getOne(array('select'=>'sum(rePrice) as rePrice,sum(agPrice) as agPrice',
    1917. 

  1917. 		'where'=>'Month(date)='.$month." and Year(date)=".$year,'groupby'=>'Month(date)','asArray'=>true));
    1918. 

  1918. 		if(empty($stList))
    1919. 

  1919. 			$stList=array('rePrice'=>0,'agPrice'=>0);
    1920. 

  1920. 		$data['stList']=array('rePrice'=>$stList['rePrice'],'agPrice'=>$stList['agPrice'],'skPrice'=>($stList['rePrice']-$stList['agPrice']));
    1921. 

  1921. 		
    1922. 

  1922. 		$monthHtml="";
    1923. 

  1923. 		for ($i=1;$i<=12;$i++){
    1924. 

  1924. 			if ($i==$month)
    1925. 

  1925. 				$monthHtml.='<option selected value="'.$i.'">'.$i.'</option>';
    1926. 

  1926. 			else 
    1927. 

  1927. 				$monthHtml.='<option value="'.$i.'">'.$i.'</option>';
    1928. 

  1928. 		}
    1929. 

  1929. 		
    1930. 

  1930. 		$data['monthHtml']=$monthHtml;
    1931. 

  1931. 		$data['year']=$year;
    1932. 

  1932. 		$data['month']=$month;
    1933. 

  1933. 		
    1934. 

  1934. 		$data['memu']="receipt";
    1935. 

  1935. 		$data['staff']=$this->staff;
    1936. 

  1936. 		$data['receiptMemu']='companyCategoryCollect';
    1937. 

  1937. 		$data['verifyId']=$this->verifyId;
    1938. 

  1938. 		
    1939. 

  1939. 		if (!empty($month)&&($year<=date("Y"))&&($month<date("m"))){	
    1940. 

  1940. 			Doo::loadModel('receipt');
    1941. 

  1941. 			$receipt=new receipt();
    1942. 

  1942. 			$receiptList=$receipt->find(array('where'=>'(status=2 or status=4) and Year(date) ='.$year.' and Month(date) ='.$month,'asArray'=>true));
    1943. 

  1943. 			if(empty($receiptList)){ //generated files
    1944. 

  1944. 				ob_start();
    1945. 

  1945. 				$this->render ( "/admin/saeaStaffCollect", $data );
    1946. 

  1946. 				$this->cacheFile($path);die;
    1947. 

  1947. 			}
    1948. 

  1948. 		}
    1949. 

  1949. 		
    1950. 

  1950. 		$this->render ( "/admin/saeaStaffCollect", $data );
    1951. 

  1951. 	}
    1952. 

  1952. 	
    1953. 

  1953. 	function staffCollectMonthDetail(){
    1954. 

  1954. 		
    1955. 

  1955. 		$year=$this->get_args('year')?$this->get_args('year'):"";
    1956. 

  1956. 		$month=$this->get_args('month')?$this->get_args('month'):"";
    1957. 

  1957. 		if(!$year)
    1958. 

  1958. 			$year=isset($this->params['year'])?$this->params['year']:date("Y");
    1959. 

  1959. 		if(!$month)
    1960. 

  1960. 			$month=isset($this->params['month'])?$this->params['month']:1;
    1961. 

  1961. 		
    1962. 

  1962. 		Doo::loadModel('staff');
    1963. 

  1963. 		$staff=new staff();
    1964. 

  1964. 		Doo::loadModel("receiptDetail");
    1965. 

  1965. 		$receiptDetail=new receiptDetail();
    1966. 

  1966. 		Doo::loadModel('accountItem');
    1967. 

  1967. 		$accountItem=new accountItem();
    1968. 

  1968. 		Doo::loadModel('statistics');
    1969. 

  1969. 		$statistics=new statistics();
    1970. 

  1970. 		Doo::loadModel('L_category');
    1971. 

  1971. 		$lCategory=new L_category();
    1972. 

  1972. 		
    1973. 

  1973. 		$staffList=$staff->find(array('where'=>'username!="admin"','asArray'=>true));
    1974. 

  1974. 		$categoryList=$staff->find(array('select'=>'COUNT(*) as count,cid,category','where'=>'username !="admin"','groupby'=>'cid','asArray'=>true));
    1975. 

  1975. 		
    1976. 

  1976. 		$list=array();
    1977. 

  1977. 		foreach ($categoryList as $vlu){
    1978. 

  1978. 			//$html='<th rowspan="'.$v['count'].'">'.$v['category'].'</th>';
    1979. 

  1979. 			$r1=0;$r2=0;$r3=0;$r4=0;$r5=0;$r6=0;$r7=0;$r8=0;$r9=0;$r10=0;$r11=0;$r12=0;$r13=0;
    1980. 

  1980. 			$c1=0;$c2=0;$c3=0;$c4=0;$c5=0;$c6=0;
    1981. 

  1981. 			$p1=0;$p2=0;$p3=0;$p4=0;$p5=0;$p6=0;$p7=0;$p8=0;$p9=0;
    1982. 

  1982. 			$t1=0;$t2=0;$t3=0;$t4=0;$t5=0;
    1983. 

  1983. 			$s1=0;
    1984. 

  1984. 			$m1=0;
    1985. 

  1985. 		foreach ($staffList as $value){
    1986. 

  1986. 			if ($vlu['cid']==$value['cid']){
    1987. 

  1987. 				
    1988. 

  1988. 				$receiptCollectList=$receiptDetail->find(array('select'=>'staff,item,sum(price) as price,itemCategory,Month(date) as month',
    1989. 

  1989. 				'where'=>'staff='.$value['sid']." and status=1 and Year(date)=".$year.' and Month(date)='.$month,'groupby'=>'item,Month(date),itemCategory','asArray'=>true));
    1990. 

  1990. 				
    1991. 

  1991. 				if(!empty($receiptCollectList)){
    1992. 

  1992. 				
    1993. 

  1993. 					$receiptL=array('日常相关费用'=>array(),'差旅相关费用'=>array(),'培训班费用'=>array(),'其他'=>array());
    1994. 

  1994. 					
    1995. 

  1995. 					
    1996. 

  1996. 					$html="";
    1997. 

  1997. 					$psum=0;
    1998. 

  1998. 					$item=array('市内交通费','市内出租费','办事处房租','电话费','水费','电费','办公费用','邮寄费','其他费用','车辆费用','广告费','团队建设费');
    1999. 

  1999. 					foreach ($item as $va){
    2000. 

  2000. 						$falg=true;
    2001. 

  2001. 						foreach ($receiptCollectList as $v){
    2002. 

  2002. 							if($v['itemCategory']=='日常相关费用'){
    2003. 

  2003. 								
    2004. 

  2004. 								if($v['item']==$va){
    2005. 

  2005. 									if ($va=='市内交通费')
    2006. 

  2006. 										$r1+=$v['price'];
    2007. 

  2007. 									if ($va=='市内出租费')
    2008. 

  2008. 										$r2+=$v['price'];
    2009. 

  2009. 									if ($va=='办事处房租')
    2010. 

  2010. 										$r3+=$v['price'];
    2011. 

  2011. 									if ($va=='电话费')
    2012. 

  2012. 										$r4+=$v['price'];
    2013. 

  2013. 									if ($va=='水费')
    2014. 

  2014. 										$r5+=$v['price'];
    2015. 

  2015. 									if ($va=='电费')
    2016. 

  2016. 										$r6+=$v['price'];
    2017. 

  2017. 									if ($va=='办公费用')
    2018. 

  2018. 										$r7+=$v['price'];
    2019. 

  2019. 									if ($va=='邮寄费')
    2020. 

  2020. 										$r8+=$v['price'];
    2021. 

  2021. 									if ($va=='其他费用')
    2022. 

  2022. 										$r9+=$v['price'];
    2023. 

  2023. 									if ($va=='车辆费用')
    2024. 

  2024. 										$r10+=$v['price'];
    2025. 

  2025. 									if ($va=='广告费')
    2026. 

  2026. 										$r11+=$v['price'];	
    2027. 

  2027. 									if ($va=='团队建设费')
    2028. 

  2028. 										$r13+=$v['price'];	
    2029. 

  2029. 									$psum+=$v['price'];
    2030. 

  2030. 									$html.='<td class="taR">'.$v['price'].'</td>';$falg=false;break;
    2031. 

  2031. 								}
    2032. 

  2032. 							}
    2033. 

  2033. 						}
    2034. 

  2034. 						if($falg)
    2035. 

  2035. 							$html.='<td class="taR">-</td>';
    2036. 

  2036. 					}
    2037. 

  2037. 					
    2038. 

  2038. 					$r12+=$psum;
    2039. 

  2039. 					if(!empty($psum))
    2040. 

  2040. 						$psum='<td class="colGreen taR">￥'.$psum.'</td>';
    2041. 

  2041. 					else
    2042. 

  2042. 						$psum='<td class="colGreen taR">-</td>';
    2043. 

  2043. 					$receiptL['日常相关费用']=$psum.$html;
    2044. 

  2044. 				
    2045. 

  2045. 				/*-----------------------------------*/
    2046. 

  2046. 				
    2047. 

  2047. 				$html="";
    2048. 

  2048. 					$psum=0;
    2049. 

  2049. 				$item=array('往来交通费','市内交通费','出差住宿费','出差补助','其他费用');
    2050. 

  2050. 				foreach ($item as $va){
    2051. 

  2051. 						$falg=true;
    2052. 

  2052. 						foreach ($receiptCollectList as $v){
    2053. 

  2053. 							if($v['itemCategory']=='差旅相关费用'){
    2054. 

  2054. 								
    2055. 

  2055. 								if($v['item']==$va){
    2056. 

  2056. 									if ($va=='往来交通费')
    2057. 

  2057. 										$c1+=$v['price'];
    2058. 

  2058. 									if ($va=='市内交通费')
    2059. 

  2059. 										$c2+=$v['price'];
    2060. 

  2060. 									if ($va=='出差住宿费')
    2061. 

  2061. 										$c3+=$v['price'];
    2062. 

  2062. 									if ($va=='出差补助')
    2063. 

  2063. 										$c4+=$v['price'];
    2064. 

  2064. 									if ($va=='其他费用')
    2065. 

  2065. 										$c5+=$v['price'];
    2066. 

  2066. 										
    2067. 

  2067. 									$psum+=$v['price'];
    2068. 

  2068. 									$html.='<td class="taR">'.$v['price'].'</td>';$falg=false;break;
    2069. 

  2069. 								}
    2070. 

  2070. 							}
    2071. 

  2071. 						}
    2072. 

  2072. 						if($falg)
    2073. 

  2073. 							$html.='<td class="taR">-</td>';
    2074. 

  2074. 					}
    2075. 

  2075. 					$c6+=$psum;
    2076. 

  2076. 					if(!empty($psum))
    2077. 

  2077. 						$psum='<td class="colGreen taR">￥'.$psum.'</td>';
    2078. 

  2078. 					else
    2079. 

  2079. 						$psum='<td class="colGreen taR">-</td>';
    2080. 

  2080. 					$receiptL['差旅相关费用']=$psum.$html;	
    2081. 

  2081. 					/*-------------------------------------*/
    2082. 

  2082. 					$html="";
    2083. 

  2083. 					$psum=0;
    2084. 

  2084. 				$item=array('场租费','薪酬','住宿费','交通费','餐饮费','办公费','公关费','其他');
    2085. 

  2085. 				foreach ($item as $va){
    2086. 

  2086. 						$falg=true;
    2087. 

  2087. 						foreach ($receiptCollectList as $v){
    2088. 

  2088. 							if($v['itemCategory']=='培训班费用'){
    2089. 

  2089. 								
    2090. 

  2090. 								if($v['item']==$va){
    2091. 

  2091. 									
    2092. 

  2092. 									if ($va=='场租费')
    2093. 

  2093. 										$p1+=$v['price'];
    2094. 

  2094. 									if ($va=='薪酬')
    2095. 

  2095. 										$p2+=$v['price'];
    2096. 

  2096. 									if ($va=='住宿费')
    2097. 

  2097. 										$p3+=$v['price'];
    2098. 

  2098. 									if ($va=='交通费')
    2099. 

  2099. 										$p4+=$v['price'];
    2100. 

  2100. 									if ($va=='餐饮费')
    2101. 

  2101. 										$p5+=$v['price'];
    2102. 

  2102. 									if ($va=='办公费')
    2103. 

  2103. 										$p6+=$v['price'];
    2104. 

  2104. 									if ($va=='公关费')
    2105. 

  2105. 										$p7+=$v['price'];
    2106. 

  2106. 									if ($va=='其他')
    2107. 

  2107. 										$p8+=$v['price'];
    2108. 

  2108. 										
    2109. 

  2109. 									$psum+=$v['price'];
    2110. 

  2110. 									$html.='<td class="taR">'.$v['price'].'</td>';$falg=false;break;
    2111. 

  2111. 								}
    2112. 

  2112. 							}
    2113. 

  2113. 						}
    2114. 

  2114. 						if($falg)
    2115. 

  2115. 							$html.='<td class="taR">-</td>';
    2116. 

  2116. 					}
    2117. 

  2117. 					$p9+=$psum;
    2118. 

  2118. 					if(!empty($psum))
    2119. 

  2119. 						$psum='<td class="colGreen taR">￥'.$psum.'</td>';
    2120. 

  2120. 					else
    2121. 

  2121. 						$psum='<td class="colGreen taR">-</td>';
    2122. 

  2122. 					$receiptL['培训班费用']=$psum.$html;	
    2123. 

  2123. 	
    2124. 

  2124. 					/*-------------------------------------*/
    2125. 

  2125. 					$html="";
    2126. 

  2126. 					$psum=0;
    2127. 

  2127. 				$item=array('公关费','广告费','借款','可自加费用');
    2128. 

  2128. 				foreach ($item as $va){
    2129. 

  2129. 						$falg=true;
    2130. 

  2130. 						foreach ($receiptCollectList as $v){
    2131. 

  2131. 							if($v['itemCategory']=='其他'){
    2132. 

  2132. 								
    2133. 

  2133. 								if($v['item']==$va){
    2134. 

  2134. 									if ($va=='公关费')
    2135. 

  2135. 										$t1+=$v['price'];
    2136. 

  2136. 									if ($va=='广告费')
    2137. 

  2137. 										$t2+=$v['price'];
    2138. 

  2138. 									if ($va=='借款')
    2139. 

  2139. 										$t3+=$v['price'];
    2140. 

  2140. 									if ($va=='可自加费用')
    2141. 

  2141. 										$t4+=$v['price'];
    2142. 

  2142. 									$psum+=$v['price'];
    2143. 

  2143. 									$html.='<td class="taR">'.$v['price'].'</td>';$falg=false;break;
    2144. 

  2144. 								}
    2145. 

  2145. 							}
    2146. 

  2146. 						}
    2147. 

  2147. 						if($falg)
    2148. 

  2148. 							$html.='<td class="taR">-</td>';
    2149. 

  2149. 					}
    2150. 

  2150. 					$t5+=$psum;
    2151. 

  2151. 					if(!empty($psum))
    2152. 

  2152. 						$psum='<td class="colGreen taR">￥'.$psum.'</td>';
    2153. 

  2153. 					else
    2154. 

  2154. 						$psum='<td class="colGreen taR">-</td>';
    2155. 

  2155. 					$receiptL['其他']=$psum.$html;	
    2156. 

  2156. 		
    2157. 

  2157. 					/*-------------------------------------*/
    2158. 

  2158. 					$html="";
    2159. 

  2159. 					$psum=0;
    2160. 

  2160. 					foreach ($receiptCollectList as $v){
    2161. 

  2161. 						if($v['itemCategory']=='报销金额调整'){
    2162. 

  2162. 							
    2163. 

  2163. 							if (!empty($v['price'])){
    2164. 

  2164. 								$psum+=$v['price'];
    2165. 

  2165. 							}
    2166. 

  2166. 						}
    2167. 

  2167. 					}
    2168. 

  2168. 					$s1+=$psum;
    2169. 

  2169. 					if(!empty($psum))
    2170. 

  2170. 						$psum='<td class="taR colOrange">￥'.$psum.'</td>';
    2171. 

  2171. 					else
    2172. 

  2172. 						$psum='<td class="taR colOrange">-</td>';
    2173. 

  2173. 					$receiptL['报销金额调整']=$psum.$html;	
    2174. 

  2174. 	
    2175. 

  2175. 				}else{
    2176. 

  2176. 					$receiptL['日常相关费用']='<td class="colGreen taR">-</td><td class="taR">-</td><td class="taR">-</td><td class="taR">-</td><td class="taR">-</td>
    2177. 

  2177. 		  						<td class="taR">-</td><td class="taR">-</td><td class="taR">-</td><td class="taR">-</td><td class="taR">-</td><td class="taR">-</td><td class="taR">-</td><td class="taR">-</td>';
    2178. 

  2178. 					$receiptL['差旅相关费用']='<td class="colGreen taR">-</td><td class="taR">-</td>
    2179. 

  2179. 		  						<td class="taR">-</td><td class="taR">-</td><td class="taR">-</td><td class="taR">-</td>';
    2180. 

  2180. 					$receiptL['培训班费用']='<td class="colGreen taR">-</td><td class="taR">-</td><td class="taR">-</td><td class="taR">-</td><td class="taR">-</td>
    2181. 

  2181. 		  						<td class="taR">-</td><td class="taR">-</td><td class="taR">-</td><td class="taR">-</td>';
    2182. 

  2182. 					$receiptL['其他']='<td class="colGreen taR">-</td><td class="taR">-</td><td class="taR">-</td><td class="taR">-</td><td class="taR">-</td>';
    2183. 

  2183. 					$receiptL['报销金额调整']='<td class="taR colOrange">-</td>';
    2184. 

  2184. 				}
    2185. 

  2185. 				
    2186. 

  2186. 				$monthStaffPrice=$receiptDetail->find(array('select'=>'staff,item,sum(price) as price,itemCategory,Month(date) as month',
    2187. 

  2187. 				'where'=>'staff='.$value['sid']." and status=1 and Year(date)=".$year.' and Month(date)='.$month,'asArray'=>true));
    2188. 

  2188. 				
    2189. 

  2189. 				if(!empty($monthStaffPrice[0]['price'])){
    2190. 

  2190. 					$m1+=$monthStaffPrice[0]['price'];
    2191. 

  2191. 					$receiptL['monthStaffPrice']='<td><b>￥'.$monthStaffPrice[0]['price'].'</b></td>';
    2192. 

  2192. 				}else
    2193. 

  2193. 					$receiptL['monthStaffPrice']='<td><b>-</b></td>';
    2194. 

  2194. 				$list[$value['username']]=$receiptL;
    2195. 

  2195. 				
    2196. 

  2196. 				
    2197. 

  2197. 			}
    2198. 

  2198. 		}
    2199. 

  2199. 			$receiptL['日常相关费用']='<td class="colGreen taR">'.$r12.'</td><td class="taR">'.$r1.'</td><td class="taR">'.$r2.'</td><td class="taR">'.$r3.'</td><td class="taR">'.$r4.'</td><td class="taR">'.$r5.'</td>
    2200. 

  2200. 		  						<td class="taR">'.$r6.'</td><td class="taR">'.$r7.'</td><td class="taR">'.$r8.'</td><td class="taR">'.$r9.'</td><td class="taR">'.$r10.'</td><td class="taR">'.$r11.'</td><td class="taR">'.$r13.'</td>';
    2201. 

  2201. 					$receiptL['差旅相关费用']='<td class="colGreen taR">'.$c6.'</td><td class="taR">'.$c1.'</td>
    2202. 

  2202. 		  						<td class="taR">'.$c2.'</td><td class="taR">'.$c3.'</td><td class="taR">'.$c4.'</td><td class="taR">'.$c5.'</td>';
    2203. 

  2203. 					$receiptL['培训班费用']='<td class="colGreen taR">'.$p9.'</td><td class="taR">'.$p1.'</td><td class="taR">'.$p2.'</td><td class="taR">'.$p3.'</td><td class="taR">'.$p4.'</td>
    2204. 

  2204. 		  						<td class="taR">'.$p5.'</td><td class="taR">'.$p6.'</td><td class="taR">'.$p7.'</td><td class="taR">'.$p8.'</td>';
    2205. 

  2205. 					$receiptL['其他']='<td class="colGreen taR">'.$t5.'</td><td class="taR">'.$t1.'</td><td class="taR">'.$t2.'</td><td class="taR">'.$t3.'</td><td class="taR">'.$t4.'</td>';
    2206. 

  2206. 					$receiptL['报销金额调整']='<td class="taR colOrange">'.$s1.'</td>';
    2207. 

  2207. 					$receiptL['monthStaffPrice']='<td><b>￥'.$m1.'</b></td>';
    2208. 

  2208. 			$list['<span class=colRed >'.$vlu['category'].'小计</span>']=$receiptL;
    2209. 

  2209. 		}
    2210. 

  2210. 		$data['list']=$list;
    2211. 

  2211. 		
    2212. 

  2212. 		$receiptCollectList=$receiptDetail->find(array('select'=>'staff,item,sum(price) as price,itemCategory,Month(date) as month',
    2213. 

  2213. 			'where'=>" status=1 and Year(date)=".$year.' and Month(date)='.$month,'groupby'=>'item,Month(date),itemCategory','asArray'=>true));
    2214. 

  2214. 		
    2215. 

  2215. 		$data['monthPriceHtml']=$this->_getMonthCollectDetail($receiptCollectList);
    2216. 

  2216. 		
    2217. 

  2217. 		//statistics html
    2218. 

  2218. 		$stList=$statistics->getOne(array('select'=>'sum(rePrice) as rePrice,sum(agPrice) as agPrice',
    2219. 

  2219. 		'where'=>'Month(date)='.$month." and Year(date)=".$year,'groupby'=>'Month(date)','asArray'=>true));
    2220. 

  2220. 		if(empty($stList))
    2221. 

  2221. 			$stList=array('rePrice'=>0,'agPrice'=>0);
    2222. 

  2222. 		$data['stList']=array('rePrice'=>$stList['rePrice'],'agPrice'=>$stList['agPrice'],'skPrice'=>($stList['rePrice']-$stList['agPrice']));
    2223. 

  2223. 		
    2224. 

  2224. 		$monthHtml="";
    2225. 

  2225. 		for ($i=1;$i<=12;$i++){
    2226. 

  2226. 			if ($i==$month)
    2227. 

  2227. 				$monthHtml.='<option selected value="'.$i.'">'.$i.'</option>';
    2228. 

  2228. 			else 
    2229. 

  2229. 				$monthHtml.='<option value="'.$i.'">'.$i.'</option>';
    2230. 

  2230. 		}
    2231. 

  2231. 		
    2232. 

  2232. 		$data['monthHtml']=$monthHtml;
    2233. 

  2233. 		$data['year']=$year;
    2234. 

  2234. 		$data['month']=$month;
    2235. 

  2235. 		
    2236. 

  2236. 		$data['memu']="receipt";
    2237. 

  2237. 		$data['staff']=$this->staff;
    2238. 

  2238. 		$data['receiptMemu']='companyCategoryCollect';
    2239. 

  2239. 		$data['verifyId']=$this->verifyId;
    2240. 

  2240. 		
    2241. 

  2241. 		$this->render ( "/admin/staffCollectMonthDetail", $data );
    2242. 

  2242. 		//$this->render ( "/admin/saeaStaffCollectDetail", $data );
    2243. 

  2243. 	}
    2244. 

  2244. 	
    2245. 

  2245. function staffCollectMonthDetail2(){
    2246. 

  2246. 		
    2247. 

  2247. 		$year=$this->get_args('year')?$this->get_args('year'):"";
    2248. 

  2248. 		$month=$this->get_args('month')?$this->get_args('month'):"";
    2249. 

  2249. 		if(!$year)
    2250. 

  2250. 			$year=isset($this->params['year'])?$this->params['year']:date("Y");
    2251. 

  2251. 		if(!$month)
    2252. 

  2252. 			$month=isset($this->params['month'])?$this->params['month']:1;
    2253. 

  2253. 		
    2254. 

  2254. 		Doo::loadModel('staff');
    2255. 

  2255. 		$staff=new staff();
    2256. 

  2256. 		Doo::loadModel("receiptDetail");
    2257. 

  2257. 		$receiptDetail=new receiptDetail();
    2258. 

  2258. 		Doo::loadModel('accountItem');
    2259. 

  2259. 		$accountItem=new accountItem();
    2260. 

  2260. 		Doo::loadModel('statistics');
    2261. 

  2261. 		$statistics=new statistics();
    2262. 

  2262. 		Doo::loadModel('L_category');
    2263. 

  2263. 		$lCategory=new L_category();
    2264. 

  2264. 		
    2265. 

  2265. 		$staffList=$staff->find(array('where'=>'username!="admin"','asArray'=>true));
    2266. 

  2266. 		$categoryList=$staff->find(array('select'=>'COUNT(*) as count,cid,category','where'=>'username !="admin"','groupby'=>'cid','asArray'=>true));
    2267. 

  2267. 		
    2268. 

  2268. 		$list=array();
    2269. 

  2269. 		foreach ($categoryList as $vlu){
    2270. 

  2270. 			//$html='<th rowspan="'.$v['count'].'">'.$v['category'].'</th>';
    2271. 

  2271. 			$r1=0;$r2=0;$r3=0;$r4=0;$r5=0;$r6=0;$r7=0;$r8=0;$r9=0;$r10=0;$r11=0;$r12=0;$r13=0;
    2272. 

  2272. 			$c1=0;$c2=0;$c3=0;$c4=0;$c5=0;$c6=0;
    2273. 

  2273. 			$p1=0;$p2=0;$p3=0;$p4=0;$p5=0;$p6=0;$p7=0;$p8=0;$p9=0;
    2274. 

  2274. 			$t1=0;$t2=0;$t3=0;$t4=0;$t5=0;
    2275. 

  2275. 			$s1=0;
    2276. 

  2276. 			$m1=0;
    2277. 

  2277. 		foreach ($staffList as $value){
    2278. 

  2278. 			if ($vlu['cid']==$value['cid']){
    2279. 

  2279. 				
    2280. 

  2280. 				$receiptCollectList=$receiptDetail->find(array('select'=>'staff,item,sum(price) as price,itemCategory,Month(date) as month',
    2281. 

  2281. 				'where'=>'staff='.$value['sid']." and status=1 and Year(date)=".$year.' and Month(date)='.$month,'groupby'=>'item,Month(date),itemCategory','asArray'=>true));
    2282. 

  2282. 				
    2283. 

  2283. 				if(!empty($receiptCollectList)){
    2284. 

  2284. 				
    2285. 

  2285. 					$receiptL=array('日常相关费用'=>array(),'差旅相关费用'=>array(),'培训班费用'=>array(),'其他'=>array());
    2286. 

  2286. 					
    2287. 

  2287. 					
    2288. 

  2288. 					$html="";
    2289. 

  2289. 					$psum=0;
    2290. 

  2290. 					$item=array('市内交通费','市内出租费','办事处房租','电话费','水费','电费','办公费用','邮寄费','其他费用','车辆费用','广告费','团队建设费');
    2291. 

  2291. 					foreach ($item as $va){
    2292. 

  2292. 						$falg=true;
    2293. 

  2293. 						foreach ($receiptCollectList as $v){
    2294. 

  2294. 							if($v['itemCategory']=='日常相关费用'){
    2295. 

  2295. 								
    2296. 

  2296. 								if($v['item']==$va){
    2297. 

  2297. 									if ($va=='市内交通费')
    2298. 

  2298. 										$r1+=$v['price'];
    2299. 

  2299. 									if ($va=='市内出租费')
    2300. 

  2300. 										$r2+=$v['price'];
    2301. 

  2301. 									if ($va=='办事处房租')
    2302. 

  2302. 										$r3+=$v['price'];
    2303. 

  2303. 									if ($va=='电话费')
    2304. 

  2304. 										$r4+=$v['price'];
    2305. 

  2305. 									if ($va=='水费')
    2306. 

  2306. 										$r5+=$v['price'];
    2307. 

  2307. 									if ($va=='电费')
    2308. 

  2308. 										$r6+=$v['price'];
    2309. 

  2309. 									if ($va=='办公费用')
    2310. 

  2310. 										$r7+=$v['price'];
    2311. 

  2311. 									if ($va=='邮寄费')
    2312. 

  2312. 										$r8+=$v['price'];
    2313. 

  2313. 									if ($va=='其他费用')
    2314. 

  2314. 										$r9+=$v['price'];
    2315. 

  2315. 									if ($va=='车辆费用')
    2316. 

  2316. 										$r10+=$v['price'];
    2317. 

  2317. 									if ($va=='广告费')
    2318. 

  2318. 										$r11+=$v['price'];	
    2319. 

  2319. 									if ($va=='团队建设费')
    2320. 

  2320. 										$r13+=$v['price'];	
    2321. 

  2321. 									$psum+=$v['price'];
    2322. 

  2322. 									$html.='<td class="taR">'.$v['price'].'</td>';$falg=false;break;
    2323. 

  2323. 								}
    2324. 

  2324. 							}
    2325. 

  2325. 						}
    2326. 

  2326. 						if($falg)
    2327. 

  2327. 							$html.='<td class="taR">-</td>';
    2328. 

  2328. 					}
    2329. 

  2329. 					
    2330. 

  2330. 					$r12+=$psum;
    2331. 

  2331. 					if(!empty($psum))
    2332. 

  2332. 						$psum='<td class="colGreen taR">￥'.$psum.'</td>';
    2333. 

  2333. 					else
    2334. 

  2334. 						$psum='<td class="colGreen taR">-</td>';
    2335. 

  2335. 					$receiptL['日常相关费用']=$psum.$html;
    2336. 

  2336. 				
    2337. 

  2337. 				/*-----------------------------------*/
    2338. 

  2338. 				
    2339. 

  2339. 				$html="";
    2340. 

  2340. 					$psum=0;
    2341. 

  2341. 				$item=array('往来交通费','市内交通费','出差住宿费','出差补助','其他费用');
    2342. 

  2342. 				foreach ($item as $va){
    2343. 

  2343. 						$falg=true;
    2344. 

  2344. 						foreach ($receiptCollectList as $v){
    2345. 

  2345. 							if($v['itemCategory']=='差旅相关费用'){
    2346. 

  2346. 								
    2347. 

  2347. 								if($v['item']==$va){
    2348. 

  2348. 									if ($va=='往来交通费')
    2349. 

  2349. 										$c1+=$v['price'];
    2350. 

  2350. 									if ($va=='市内交通费')
    2351. 

  2351. 										$c2+=$v['price'];
    2352. 

  2352. 									if ($va=='出差住宿费')
    2353. 

  2353. 										$c3+=$v['price'];
    2354. 

  2354. 									if ($va=='出差补助')
    2355. 

  2355. 										$c4+=$v['price'];
    2356. 

  2356. 									if ($va=='其他费用')
    2357. 

  2357. 										$c5+=$v['price'];
    2358. 

  2358. 										
    2359. 

  2359. 									$psum+=$v['price'];
    2360. 

  2360. 									$html.='<td class="taR">'.$v['price'].'</td>';$falg=false;break;
    2361. 

  2361. 								}
    2362. 

  2362. 							}
    2363. 

  2363. 						}
    2364. 

  2364. 						if($falg)
    2365. 

  2365. 							$html.='<td class="taR">-</td>';
    2366. 

  2366. 					}
    2367. 

  2367. 					$c6+=$psum;
    2368. 

  2368. 					if(!empty($psum))
    2369. 

  2369. 						$psum='<td class="colGreen taR">￥'.$psum.'</td>';
    2370. 

  2370. 					else
    2371. 

  2371. 						$psum='<td class="colGreen taR">-</td>';
    2372. 

  2372. 					$receiptL['差旅相关费用']=$psum.$html;	
    2373. 

  2373. 					/*-------------------------------------*/
    2374. 

  2374. 					$html="";
    2375. 

  2375. 					$psum=0;
    2376. 

  2376. 				$item=array('场租费','薪酬','住宿费','交通费','餐饮费','办公费','公关费','其他');
    2377. 

  2377. 				foreach ($item as $va){
    2378. 

  2378. 						$falg=true;
    2379. 

  2379. 						foreach ($receiptCollectList as $v){
    2380. 

  2380. 							if($v['itemCategory']=='培训班费用'){
    2381. 

  2381. 								
    2382. 

  2382. 								if($v['item']==$va){
    2383. 

  2383. 									
    2384. 

  2384. 									if ($va=='场租费')
    2385. 

  2385. 										$p1+=$v['price'];
    2386. 

  2386. 									if ($va=='薪酬')
    2387. 

  2387. 										$p2+=$v['price'];
    2388. 

  2388. 									if ($va=='住宿费')
    2389. 

  2389. 										$p3+=$v['price'];
    2390. 

  2390. 									if ($va=='交通费')
    2391. 

  2391. 										$p4+=$v['price'];
    2392. 

  2392. 									if ($va=='餐饮费')
    2393. 

  2393. 										$p5+=$v['price'];
    2394. 

  2394. 									if ($va=='办公费')
    2395. 

  2395. 										$p6+=$v['price'];
    2396. 

  2396. 									if ($va=='公关费')
    2397. 

  2397. 										$p7+=$v['price'];
    2398. 

  2398. 									if ($va=='其他')
    2399. 

  2399. 										$p8+=$v['price'];
    2400. 

  2400. 										
    2401. 

  2401. 									$psum+=$v['price'];
    2402. 

  2402. 									$html.='<td class="taR">'.$v['price'].'</td>';$falg=false;break;
    2403. 

  2403. 								}
    2404. 

  2404. 							}
    2405. 

  2405. 						}
    2406. 

  2406. 						if($falg)
    2407. 

  2407. 							$html.='<td class="taR">-</td>';
    2408. 

  2408. 					}
    2409. 

  2409. 					$p9+=$psum;
    2410. 

  2410. 					if(!empty($psum))
    2411. 

  2411. 						$psum='<td class="colGreen taR">￥'.$psum.'</td>';
    2412. 

  2412. 					else
    2413. 

  2413. 						$psum='<td class="colGreen taR">-</td>';
    2414. 

  2414. 					$receiptL['培训班费用']=$psum.$html;	
    2415. 

  2415. 	
    2416. 

  2416. 					/*-------------------------------------*/
    2417. 

  2417. 					$html="";
    2418. 

  2418. 					$psum=0;
    2419. 

  2419. 				$item=array('公关费','广告费','借款','可自加费用');
    2420. 

  2420. 				foreach ($item as $va){
    2421. 

  2421. 						$falg=true;
    2422. 

  2422. 						foreach ($receiptCollectList as $v){
    2423. 

  2423. 							if($v['itemCategory']=='其他'){
    2424. 

  2424. 								
    2425. 

  2425. 								if($v['item']==$va){
    2426. 

  2426. 									if ($va=='公关费')
    2427. 

  2427. 										$t1+=$v['price'];
    2428. 

  2428. 									if ($va=='广告费')
    2429. 

  2429. 										$t2+=$v['price'];
    2430. 

  2430. 									if ($va=='借款')
    2431. 

  2431. 										$t3+=$v['price'];
    2432. 

  2432. 									if ($va=='可自加费用')
    2433. 

  2433. 										$t4+=$v['price'];
    2434. 

  2434. 									$psum+=$v['price'];
    2435. 

  2435. 									$html.='<td class="taR">'.$v['price'].'</td>';$falg=false;break;
    2436. 

  2436. 								}
    2437. 

  2437. 							}
    2438. 

  2438. 						}
    2439. 

  2439. 						if($falg)
    2440. 

  2440. 							$html.='<td class="taR">-</td>';
    2441. 

  2441. 					}
    2442. 

  2442. 					$t5+=$psum;
    2443. 

  2443. 					if(!empty($psum))
    2444. 

  2444. 						$psum='<td class="colGreen taR">￥'.$psum.'</td>';
    2445. 

  2445. 					else
    2446. 

  2446. 						$psum='<td class="colGreen taR">-</td>';
    2447. 

  2447. 					$receiptL['其他']=$psum.$html;	
    2448. 

  2448. 		
    2449. 

  2449. 					/*-------------------------------------*/
    2450. 

  2450. 					$html="";
    2451. 

  2451. 					$psum=0;
    2452. 

  2452. 					foreach ($receiptCollectList as $v){
    2453. 

  2453. 						if($v['itemCategory']=='报销金额调整'){
    2454. 

  2454. 							
    2455. 

  2455. 							if (!empty($v['price'])){
    2456. 

  2456. 								$psum+=$v['price'];
    2457. 

  2457. 							}
    2458. 

  2458. 						}
    2459. 

  2459. 					}
    2460. 

  2460. 					$s1+=$psum;
    2461. 

  2461. 					if(!empty($psum))
    2462. 

  2462. 						$psum='<td class="taR colOrange">￥'.$psum.'</td>';
    2463. 

  2463. 					else
    2464. 

  2464. 						$psum='<td class="taR colOrange">-</td>';
    2465. 

  2465. 					$receiptL['报销金额调整']=$psum.$html;	
    2466. 

  2466. 	
    2467. 

  2467. 				}else{
    2468. 

  2468. 					$receiptL['日常相关费用']='<td class="colGreen taR">-</td><td class="taR">-</td><td class="taR">-</td><td class="taR">-</td><td class="taR">-</td>
    2469. 

  2469. 		  						<td class="taR">-</td><td class="taR">-</td><td class="taR">-</td><td class="taR">-</td><td class="taR">-</td><td class="taR">-</td><td class="taR">-</td><td class="taR">-</td>';
    2470. 

  2470. 					$receiptL['差旅相关费用']='<td class="colGreen taR">-</td><td class="taR">-</td>
    2471. 

  2471. 		  						<td class="taR">-</td><td class="taR">-</td><td class="taR">-</td><td class="taR">-</td>';
    2472. 

  2472. 					$receiptL['培训班费用']='<td class="colGreen taR">-</td><td class="taR">-</td><td class="taR">-</td><td class="taR">-</td><td class="taR">-</td>
    2473. 

  2473. 		  						<td class="taR">-</td><td class="taR">-</td><td class="taR">-</td><td class="taR">-</td>';
    2474. 

  2474. 					$receiptL['其他']='<td class="colGreen taR">-</td><td class="taR">-</td><td class="taR">-</td><td class="taR">-</td><td class="taR">-</td>';
    2475. 

  2475. 					$receiptL['报销金额调整']='<td class="taR colOrange">-</td>';
    2476. 

  2476. 				}
    2477. 

  2477. 				
    2478. 

  2478. 				$monthStaffPrice=$receiptDetail->find(array('select'=>'staff,item,sum(price) as price,itemCategory,Month(date) as month',
    2479. 

  2479. 				'where'=>'staff='.$value['sid']." and status=1 and Year(date)=".$year.' and Month(date)='.$month,'asArray'=>true));
    2480. 

  2480. 				
    2481. 

  2481. 				if(!empty($monthStaffPrice[0]['price'])){
    2482. 

  2482. 					$m1+=$monthStaffPrice[0]['price'];
    2483. 

  2483. 					$receiptL['monthStaffPrice']='<td><b>￥'.$monthStaffPrice[0]['price'].'</b></td>';
    2484. 

  2484. 				}else
    2485. 

  2485. 					$receiptL['monthStaffPrice']='<td><b>-</b></td>';
    2486. 

  2486. 				$list[$value['username']]=$receiptL;
    2487. 

  2487. 				
    2488. 

  2488. 				
    2489. 

  2489. 			}
    2490. 

  2490. 		}
    2491. 

  2491. 			$receiptL['日常相关费用']='<td class="colGreen taR">'.$r12.'</td><td class="taR">'.$r1.'</td><td class="taR">'.$r2.'</td><td class="taR">'.$r3.'</td><td class="taR">'.$r4.'</td><td class="taR">'.$r5.'</td>
    2492. 

  2492. 		  						<td class="taR">'.$r6.'</td><td class="taR">'.$r7.'</td><td class="taR">'.$r8.'</td><td class="taR">'.$r9.'</td><td class="taR">'.$r10.'</td><td class="taR">'.$r11.'</td><td class="taR">'.$r13.'</td>';
    2493. 

  2493. 					$receiptL['差旅相关费用']='<td class="colGreen taR">'.$c6.'</td><td class="taR">'.$c1.'</td>
    2494. 

  2494. 		  						<td class="taR">'.$c2.'</td><td class="taR">'.$c3.'</td><td class="taR">'.$c4.'</td><td class="taR">'.$c5.'</td>';
    2495. 

  2495. 					$receiptL['培训班费用']='<td class="colGreen taR">'.$p9.'</td><td class="taR">'.$p1.'</td><td class="taR">'.$p2.'</td><td class="taR">'.$p3.'</td><td class="taR">'.$p4.'</td>
    2496. 

  2496. 		  						<td class="taR">'.$p5.'</td><td class="taR">'.$p6.'</td><td class="taR">'.$p7.'</td><td class="taR">'.$p8.'</td>';
    2497. 

  2497. 					$receiptL['其他']='<td class="colGreen taR">'.$t5.'</td><td class="taR">'.$t1.'</td><td class="taR">'.$t2.'</td><td class="taR">'.$t3.'</td><td class="taR">'.$t4.'</td>';
    2498. 

  2498. 					$receiptL['报销金额调整']='<td class="taR colOrange">'.$s1.'</td>';
    2499. 

  2499. 					$receiptL['monthStaffPrice']='<td><b>￥'.$m1.'</b></td>';
    2500. 

  2500. 			$list['<span class=colRed >'.$vlu['category'].'小计</span>']=$receiptL;
    2501. 

  2501. 		}
    2502. 

  2502. 		$data['list']=$list;
    2503. 

  2503. 		
    2504. 

  2504. 		$receiptCollectList=$receiptDetail->find(array('select'=>'staff,item,sum(price) as price,itemCategory,Month(date) as month',
    2505. 

  2505. 			'where'=>" status=1 and Year(date)=".$year.' and Month(date)='.$month,'groupby'=>'item,Month(date),itemCategory','asArray'=>true));
    2506. 

  2506. 		
    2507. 

  2507. 		$data['monthPriceHtml']=$this->_getMonthCollectDetail($receiptCollectList);
    2508. 

  2508. 		
    2509. 

  2509. 		//statistics html
    2510. 

  2510. 		$stList=$statistics->getOne(array('select'=>'sum(rePrice) as rePrice,sum(agPrice) as agPrice',
    2511. 

  2511. 		'where'=>'Month(date)='.$month." and Year(date)=".$year,'groupby'=>'Month(date)','asArray'=>true));
    2512. 

  2512. 		if(empty($stList))
    2513. 

  2513. 			$stList=array('rePrice'=>0,'agPrice'=>0);
    2514. 

  2514. 		$data['stList']=array('rePrice'=>$stList['rePrice'],'agPrice'=>$stList['agPrice'],'skPrice'=>($stList['rePrice']-$stList['agPrice']));
    2515. 

  2515. 		
    2516. 

  2516. 		$monthHtml="";
    2517. 

  2517. 		for ($i=1;$i<=12;$i++){
    2518. 

  2518. 			if ($i==$month)
    2519. 

  2519. 				$monthHtml.='<option selected value="'.$i.'">'.$i.'</option>';
    2520. 

  2520. 			else 
    2521. 

  2521. 				$monthHtml.='<option value="'.$i.'">'.$i.'</option>';
    2522. 

  2522. 		}
    2523. 

  2523. 		
    2524. 

  2524. 		$data['monthHtml']=$monthHtml;
    2525. 

  2525. 		$data['year']=$year;
    2526. 

  2526. 		$data['month']=$month;
    2527. 

  2527. 		
    2528. 

  2528. 		$data['memu']="receipt";
    2529. 

  2529. 		$data['staff']=$this->staff;
    2530. 

  2530. 		$data['receiptMemu']='companyCategoryCollect';
    2531. 

  2531. 		$data['verifyId']=$this->verifyId;
    2532. 

  2532. 		
    2533. 

  2533. 		$this->render ( "/admin/staffCollectMonthDetail2", $data );
    2534. 

  2534. 		//$this->render ( "/admin/saeaStaffCollectDetail", $data );
    2535. 

  2535. 	}
    2536. 

  2536. 	
    2537. 

  2537. 	function companyMonthCollectDetail(){
    2538. 

  2538. 		
    2539. 

  2539. 		$year=$this->get_args('year')?$this->get_args('year'):"";
    2540. 

  2540. 		$month=$this->get_args('month')?$this->get_args('month'):"";
    2541. 

  2541. 		if(!$year)
    2542. 

  2542. 			$year=isset($this->params['year'])?$this->params['year']:date("Y");
    2543. 

  2543. 		if(!$month)
    2544. 

  2544. 			$month=isset($this->params['month'])?$this->params['month']:1;
    2545. 

  2545. 		
    2546. 

  2546. 		Doo::loadModel('staff');
    2547. 

  2547. 		$staff=new staff();
    2548. 

  2548. 		Doo::loadModel("receiptDetail");
    2549. 

  2549. 		$receiptDetail=new receiptDetail();
    2550. 

  2550. 		Doo::loadModel('accountItem');
    2551. 

  2551. 		$accountItem=new accountItem();
    2552. 

  2552. 		Doo::loadModel('statistics');
    2553. 

  2553. 		$statistics=new statistics();
    2554. 

  2554. 		Doo::loadModel('L_category');
    2555. 

  2555. 		$lCategory=new L_category();
    2556. 

  2556. 		
    2557. 

  2557. 		$staffList=$staff->find(array('where'=>'username!="admin"','asArray'=>true));
    2558. 

  2558. 		
    2559. 

  2559. 		$categoryList=$lCategory->find(array('asArray'=>true));
    2560. 

  2560. 		
    2561. 

  2561. 		$list=array();
    2562. 

  2562. 		foreach ($categoryList as $value){
    2563. 

  2563. 			$receiptCollectList=$receiptDetail->find(array('select'=>'staff,item,sum(price) as price,itemCategory,Month(date) as month',
    2564. 

  2564. 			'where'=>'cid='.$value['cid']." and status=1 and Year(date)=".$year.' and Month(date)='.$month,'groupby'=>'item,Month(date),itemCategory','asArray'=>true));
    2565. 

  2565. 			
    2566. 

  2566. 			if(!empty($receiptCollectList)){
    2567. 

  2567. 			
    2568. 

  2568. 				$receiptL=array('日常相关费用'=>array(),'差旅相关费用'=>array(),'培训班费用'=>array(),'其他'=>array());
    2569. 

  2569. 				
    2570. 

  2570. 				$html="";
    2571. 

  2571. 				$psum=0;
    2572. 

  2572. 				$item=array('市内交通费','市内出租费','办事处房租','电话费','水费','电费','办公费用','邮寄费','其他费用','车辆费用','广告费','团队建设费');
    2573. 

  2573. 				foreach ($item as $va){
    2574. 

  2574. 					$falg=true;
    2575. 

  2575. 					foreach ($receiptCollectList as $v){
    2576. 

  2576. 						if($v['itemCategory']=='日常相关费用'){
    2577. 

  2577. 							
    2578. 

  2578. 							if($v['item']==$va){
    2579. 

  2579. 								$psum+=$v['price'];
    2580. 

  2580. 								$html.='<td class="taR">'.$v['price'].'</td>';$falg=false;break;
    2581. 

  2581. 							}
    2582. 

  2582. 						}
    2583. 

  2583. 					}
    2584. 

  2584. 					if($falg)
    2585. 

  2585. 						$html.='<td class="taR">-</td>';
    2586. 

  2586. 				}
    2587. 

  2587. 				
    2588. 

  2588. 				if(!empty($psum))
    2589. 

  2589. 					$psum='<td class="colGreen taR">￥'.$psum.'</td>';
    2590. 

  2590. 				else
    2591. 

  2591. 					$psum='<td class="colGreen taR">-</td>';
    2592. 

  2592. 				$receiptL['日常相关费用']=$psum.$html;
    2593. 

  2593. 			
    2594. 

  2594. 			/*-----------------------------------*/
    2595. 

  2595. 			
    2596. 

  2596. 			$html="";
    2597. 

  2597. 				$psum=0;
    2598. 

  2598. 			$item=array('往来交通费','市内交通费','出差住宿费','出差补助','其他费用');
    2599. 

  2599. 			foreach ($item as $va){
    2600. 

  2600. 					$falg=true;
    2601. 

  2601. 					foreach ($receiptCollectList as $v){
    2602. 

  2602. 						if($v['itemCategory']=='差旅相关费用'){
    2603. 

  2603. 							
    2604. 

  2604. 							if($v['item']==$va){
    2605. 

  2605. 								$psum+=$v['price'];
    2606. 

  2606. 								$html.='<td class="taR">'.$v['price'].'</td>';$falg=false;break;
    2607. 

  2607. 							}
    2608. 

  2608. 						}
    2609. 

  2609. 					}
    2610. 

  2610. 					if($falg)
    2611. 

  2611. 						$html.='<td class="taR">-</td>';
    2612. 

  2612. 				}
    2613. 

  2613. 				if(!empty($psum))
    2614. 

  2614. 					$psum='<td class="colGreen taR">￥'.$psum.'</td>';
    2615. 

  2615. 				else
    2616. 

  2616. 					$psum='<td class="colGreen taR">-</td>';
    2617. 

  2617. 				$receiptL['差旅相关费用']=$psum.$html;	
    2618. 

  2618. 				/*-------------------------------------*/
    2619. 

  2619. 				$html="";
    2620. 

  2620. 				$psum=0;
    2621. 

  2621. 			$item=array('场租费','薪酬','住宿费','交通费','餐饮费','办公费','公关费','其他');
    2622. 

  2622. 			foreach ($item as $va){
    2623. 

  2623. 					$falg=true;
    2624. 

  2624. 					foreach ($receiptCollectList as $v){
    2625. 

  2625. 						if($v['itemCategory']=='培训班费用'){
    2626. 

  2626. 							
    2627. 

  2627. 							if($v['item']==$va){
    2628. 

  2628. 								$psum+=$v['price'];
    2629. 

  2629. 								$html.='<td class="taR">'.$v['price'].'</td>';$falg=false;break;
    2630. 

  2630. 							}
    2631. 

  2631. 						}
    2632. 

  2632. 					}
    2633. 

  2633. 					if($falg)
    2634. 

  2634. 						$html.='<td class="taR">-</td>';
    2635. 

  2635. 				}
    2636. 

  2636. 				if(!empty($psum))
    2637. 

  2637. 					$psum='<td class="colGreen taR">￥'.$psum.'</td>';
    2638. 

  2638. 				else
    2639. 

  2639. 					$psum='<td class="colGreen taR">-</td>';
    2640. 

  2640. 				$receiptL['培训班费用']=$psum.$html;	
    2641. 

  2641. 

  2642. 				/*-------------------------------------*/
    2643. 

  2643. 				$html="";
    2644. 

  2644. 				$psum=0;
    2645. 

  2645. 			$item=array('公关费','广告费','借款','可自加费用');
    2646. 

  2646. 			foreach ($item as $va){
    2647. 

  2647. 					$falg=true;
    2648. 

  2648. 					foreach ($receiptCollectList as $v){
    2649. 

  2649. 						if($v['itemCategory']=='其他'){
    2650. 

  2650. 							
    2651. 

  2651. 							if($v['item']==$va){
    2652. 

  2652. 								$psum+=$v['price'];
    2653. 

  2653. 								$html.='<td class="taR">'.$v['price'].'</td>';$falg=false;break;
    2654. 

  2654. 							}
    2655. 

  2655. 						}
    2656. 

  2656. 					}
    2657. 

  2657. 					if($falg)
    2658. 

  2658. 						$html.='<td class="taR">-</td>';
    2659. 

  2659. 				}
    2660. 

  2660. 				if(!empty($psum))
    2661. 

  2661. 					$psum='<td class="colGreen taR">￥'.$psum.'</td>';
    2662. 

  2662. 				else
    2663. 

  2663. 					$psum='<td class="colGreen taR">-</td>';
    2664. 

  2664. 				$receiptL['其他']=$psum.$html;	
    2665. 

  2665. 	
    2666. 

  2666. 				/*-------------------------------------*/
    2667. 

  2667. 				$html="";
    2668. 

  2668. 				$psum=0;
    2669. 

  2669. 				foreach ($receiptCollectList as $v){
    2670. 

  2670. 					if($v['itemCategory']=='报销金额调整'){
    2671. 

  2671. 						
    2672. 

  2672. 						if (!empty($v['price']))
    2673. 

  2673. 							$psum+=$v['price'];
    2674. 

  2674. 					}
    2675. 

  2675. 				}
    2676. 

  2676. 				
    2677. 

  2677. 				if(!empty($psum))
    2678. 

  2678. 					$psum='<td class="taR colOrange">￥'.$psum.'</td>';
    2679. 

  2679. 				else
    2680. 

  2680. 					$psum='<td class="taR colOrange">-</td>';
    2681. 

  2681. 				$receiptL['报销金额调整']=$psum.$html;	
    2682. 

  2682. 

  2683. 			}else{
    2684. 

  2684. 				$receiptL['日常相关费用']='<td class="colGreen taR">-</td><td class="taR">-</td><td class="taR">-</td><td class="taR">-</td><td class="taR">-</td><td class="taR">-</td><td class="taR">-</td>
    2685. 

  2685. 	  						<td class="taR">-</td><td class="taR">-</td><td class="taR">-</td><td class="taR">-</td><td class="taR">-</td><td class="taR">-</td>';
    2686. 

  2686. 				$receiptL['差旅相关费用']='<td class="colGreen taR">-</td><td class="taR">-</td>
    2687. 

  2687. 	  						<td class="taR">-</td><td class="taR">-</td><td class="taR">-</td><td class="taR">-</td>';
    2688. 

  2688. 				$receiptL['培训班费用']='<td class="colGreen taR">-</td><td class="taR">-</td><td class="taR">-</td><td class="taR">-</td><td class="taR">-</td>
    2689. 

  2689. 	  						<td class="taR">-</td><td class="taR">-</td><td class="taR">-</td><td class="taR">-</td>';
    2690. 

  2690. 				$receiptL['其他']='<td class="colGreen taR">-</td><td class="taR">-</td><td class="taR">-</td><td class="taR">-</td><td class="taR">-</td>';
    2691. 

  2691. 				$receiptL['报销金额调整']='<td class="taR colOrange">-</td>';
    2692. 

  2692. 			}
    2693. 

  2693. 			
    2694. 

  2694. 			$monthStaffPrice=$receiptDetail->find(array('select'=>'staff,item,sum(price) as price,itemCategory,Month(date) as month',
    2695. 

  2695. 			'where'=>'cid='.$value['cid']." and status=1 and Year(date)=".$year.' and Month(date)='.$month,'asArray'=>true));
    2696. 

  2696. 			
    2697. 

  2697. 			if(!empty($monthStaffPrice[0]['price']))
    2698. 

  2698. 				$receiptL['monthStaffPrice']='<td><b>￥'.$monthStaffPrice[0]['price'].'</b></td>';
    2699. 

  2699. 			else
    2700. 

  2700. 				$receiptL['monthStaffPrice']='<td><b>-</b></td>';
    2701. 

  2701. 			$list[$value['title']]=$receiptL;
    2702. 

  2702. 		}
    2703. 

  2703. 		
    2704. 

  2704. 		$data['list']=$list;
    2705. 

  2705. 		
    2706. 

  2706. 		
    2707. 

  2707. 		$receiptCollectList=$receiptDetail->find(array('select'=>'staff,item,sum(price) as price,itemCategory,Month(date) as month',
    2708. 

  2708. 			'where'=>" status=1 and Year(date)=".$year.' and Month(date)='.$month,'groupby'=>'item,Month(date),itemCategory','asArray'=>true));
    2709. 

  2709. 		
    2710. 

  2710. 		$data['monthPriceHtml']=$this->_getMonthCollectDetail($receiptCollectList);
    2711. 

  2711. 		
    2712. 

  2712. 		
    2713. 

  2713. 		
    2714. 

  2714. 		//statistics html
    2715. 

  2715. 		$stList=$statistics->getOne(array('select'=>'sum(rePrice) as rePrice,sum(agPrice) as agPrice',
    2716. 

  2716. 		'where'=>'Month(date)='.$month." and Year(date)=".$year,'groupby'=>'Month(date)','asArray'=>true));
    2717. 

  2717. 		if(empty($stList))
    2718. 

  2718. 			$stList=array('rePrice'=>0,'agPrice'=>0);
    2719. 

  2719. 		$data['stList']=array('rePrice'=>$stList['rePrice'],'agPrice'=>$stList['agPrice'],'skPrice'=>($stList['rePrice']-$stList['agPrice']));
    2720. 

  2720. 		
    2721. 

  2721. 		$monthHtml="";
    2722. 

  2722. 		for ($i=1;$i<=12;$i++){
    2723. 

  2723. 			if ($i==$month)
    2724. 

  2724. 				$monthHtml.='<option selected value="'.$i.'">'.$i.'</option>';
    2725. 

  2725. 			else 
    2726. 

  2726. 				$monthHtml.='<option value="'.$i.'">'.$i.'</option>';
    2727. 

  2727. 		}
    2728. 

  2728. 		
    2729. 

  2729. 		$data['monthHtml']=$monthHtml;
    2730. 

  2730. 		$data['year']=$year;
    2731. 

  2731. 		$data['month']=$month;
    2732. 

  2732. 		
    2733. 

  2733. 		$data['memu']="receipt";
    2734. 

  2734. 		$data['staff']=$this->staff;
    2735. 

  2735. 		$data['receiptMemu']='companyCategoryCollect';
    2736. 

  2736. 		$data['verifyId']=$this->verifyId;
    2737. 

  2737. 		
    2738. 

  2738. 		
    2739. 

  2739. 		
    2740. 

  2740. 		$this->render ( "/admin/companyMonthCollectDetail", $data );
    2741. 

  2741. 	}
    2742. 

  2742. 	
    2743. 

  2743. 	function staffCollectDetail(){
    2744. 

  2744. 		$year=$this->get_args('year')?$this->get_args('year'):date("Y");
    2745. 

  2745. 		$staffname=$this->get_args('username')?$this->get_args('username'):"";
    2746. 

  2746. 		$pcid=$this->get_args('category')?$this->get_args('category'):"";
    2747. 

  2747. 		if(!$staffname){
    2748. 

  2748. 			$staffname=isset($this->params['staffname'])?$this->params['staffname']:"";
    2749. 

  2749. 			$staffname= urldecode($staffname);
    2750. 

  2750. 		}
    2751. 

  2751. 		
    2752. 

  2752. 		Doo::loadModel('staff');
    2753. 

  2753. 		$staff=new staff();
    2754. 

  2754. 		Doo::loadModel("receiptDetail");
    2755. 

  2755. 		$receiptDetail=new receiptDetail();
    2756. 

  2756. 		Doo::loadModel('accountItem');
    2757. 

  2757. 		$accountItem=new accountItem();
    2758. 

  2758. 		Doo::loadModel('statistics');
    2759. 

  2759. 		$statistics=new statistics();
    2760. 

  2760. 		Doo::loadModel('L_category');
    2761. 

  2761. 		$lCategory=new L_category();
    2762. 

  2762. 		
    2763. 

  2763. 		$staffList=$staff->find(array('asArray'=>true));
    2764. 

  2764. 		
    2765. 

  2765. 		$stHtml='';$stTitle="";$staffId=0;$cid=0;$ocid=0;
    2766. 

  2766. 		foreach ($staffList as $value){
    2767. 

  2767. 			if ($value['username']==$staffname&&$value['username']!='admin'){
    2768. 

  2768. 				$stTitle=$value['category'].'-'.$value['username'];
    2769. 

  2769. 				$staffId=$value['sid'];
    2770. 

  2770. 				$cid=$value['cid'];
    2771. 

  2771. 				$ocid=$value['cid'];
    2772. 

  2772. 				if (!empty($value['othercid']))
    2773. 

  2773. 					$cid=$value['cid'].','.$value['othercid'];
    2774. 

  2774. 				$stHtml.='<option selected value="'.$value['username'].'">'.$value['category'].'-'.$value['username'].'</option>';
    2775. 

  2775. 			}elseif ($value['username']!='admin') 
    2776. 

  2776. 				$stHtml.='<option value="'.$value['username'].'">'.$value['category'].'-'.$value['username'].'</option>';
    2777. 

  2777. 		}
    2778. 

  2778. 		$data['lCategoryHtml']=$lCategory->find(array('where'=>'cid in('.$cid.')','asArray'=>true));
    2779. 

  2779. 		if(empty($pcid))
    2780. 

  2780. 			$pcid=$ocid;
    2781. 

  2781. 		
    2782. 

  2782. 		$data['ocid']=$pcid;
    2783. 

  2783. 		
    2784. 

  2784. 		$path=SITE_PATH.$this->STAFFCOLLECTPATH."staffCollectDetail_".$year."_".$staffId.".htmls";
    2785. 

  2785. 		$this->showCache($path);
    2786. 

  2786. 		
    2787. 

  2787. 		//
    2788. 

  2788. 		$receiptCollectList=$receiptDetail->find(array('select'=>'staff,item,sum(price) as price,itemCategory,Month(date) as month',
    2789. 

  2789. 		'where'=>'staff='.$staffId." and cid=".$pcid." and status=1 and Year(date)=".$year,'groupby'=>'item,Month(date),itemCategory','asArray'=>true));
    2790. 

  2790. 		
    2791. 

  2791. 		$accountList=$accountItem->find(array('asArray'=>true));
    2792. 

  2792. 		//create CollectDetail HTML
    2793. 

  2793. 		$collectHtml=array();
    2794. 

  2794. 		foreach ($accountList as $key=>$value){
    2795. 

  2795. 			$html="";$asum=0;
    2796. 

  2796. 			for ($i=1;$i<=12;$i++){
    2797. 

  2797. 				$falg=true;
    2798. 

  2798. 				foreach ($receiptCollectList as $v) {
    2799. 

  2799. 					if($value['category']==$v['itemCategory']&&$v['item']==$value['name']&&$i==$v['month']){
    2800. 

  2800. 						$asum+=$v['price'];
    2801. 

  2801. 						$html.='<td class="taR">￥'.$v['price'].'</td>';$falg=false;break;
    2802. 

  2802. 					}
    2803. 

  2803. 				}	
    2804. 

  2804. 				if($falg)
    2805. 

  2805. 					$html.='<td class="taR">-</td>';
    2806. 

  2806. 			} 
    2807. 

  2807. 			$html.='<td class="taR colGreen"><b>￥'.$asum.'</b></td>';
    2808. 

  2808. 			$collectHtml[$value['category']][$value['name']]=$html;
    2809. 

  2809. 		}
    2810. 

  2810. 		$data['collectHtml']=$collectHtml;
    2811. 

  2811. 		
    2812. 

  2812. 		//create  Adjustment price html
    2813. 

  2813. 		$receiptCollectList=$receiptDetail->find(array('select'=>'staff,sum(price) as price,itemCategory,Month(date) as month',
    2814. 

  2814. 		'where'=>'staff='.$staffId." and cid=".$pcid." and status=1 and Year(date)=".$year,'groupby'=>'itemCategory,Month(date)','asArray'=>true));
    2815. 

  2815. 		
    2816. 

  2816. 		$adjustment=array();$collectArray=array('日常相关费用'=>array(),'差旅相关费用'=>array(),'培训班费用'=>array(),'其他'=>array());
    2817. 

  2817. 		
    2818. 

  2818. 		$collectHtml=$this->collectHtml($receiptCollectList,'日常相关费用','b');
    2819. 

  2819. 		array_push($collectArray['日常相关费用'], $collectHtml);
    2820. 

  2820. 		
    2821. 

  2821. 		$collectHtml=$this->collectHtml($receiptCollectList,'差旅相关费用','b');
    2822. 

  2822. 		array_push($collectArray['差旅相关费用'], $collectHtml);
    2823. 

  2823. 		
    2824. 

  2824. 		$collectHtml=$this->collectHtml($receiptCollectList,'培训班费用','b');
    2825. 

  2825. 		array_push($collectArray['培训班费用'], $collectHtml);
    2826. 

  2826. 		
    2827. 

  2827. 		$collectHtml=$this->collectHtml($receiptCollectList,'其他','b');
    2828. 

  2828. 		array_push($collectArray['其他'], $collectHtml);
    2829. 

  2829. 		$data['collectArray']=$collectArray;
    2830. 

  2830. 		
    2831. 

  2831. 		$collectHtml=$this->collectHtml($receiptCollectList,'报销金额调整');
    2832. 

  2832. 		array_push($adjustment, $collectHtml);
    2833. 

  2833. 		$data['adjustment']=$adjustment;
    2834. 

  2834. 		
    2835. 

  2835. 		//total price html
    2836. 

  2836. 		$collectHtml="";$total=0;
    2837. 

  2837. 		for ($i=1;$i<=12;$i++){
    2838. 

  2838. 			$sumPrice=0;
    2839. 

  2839. 			foreach ($receiptCollectList as $key=>$value){
    2840. 

  2840. 				if($value['month']==$i){
    2841. 

  2841. 					$sumPrice+=$value['price'];
    2842. 

  2842. 				}
    2843. 

  2843. 			}
    2844. 

  2844. 			if ($sumPrice==0)
    2845. 

  2845. 				$collectHtml.='<td class="taR">-</td>';
    2846. 

  2846. 			else
    2847. 

  2847. 				$collectHtml.='<td class="taR">￥'.$sumPrice.'</td>';
    2848. 

  2848. 			$total+=$sumPrice;
    2849. 

  2849. 		}
    2850. 

  2850. 		$collectHtml.='<td class="taR colGreen">￥'.$total.'</td>';
    2851. 

  2851. 		
    2852. 

  2852. 		//statistics html
    2853. 

  2853. 		$stList=$statistics->statisticsByYear($year,$staffId);
    2854. 

  2854. 		if(empty($stList))
    2855. 

  2855. 			$stList=array('rePrice'=>0,'agPrice'=>0);
    2856. 

  2856. 		$data['stList']=array('rePrice'=>$stList['rePrice'],'agPrice'=>$stList['agPrice'],'skPrice'=>($stList['rePrice']-$stList['agPrice']));
    2857. 

  2857. 		
    2858. 

  2858. 		$data['totalPrice']=$collectHtml;
    2859. 

  2859. 		$data['totalYear']=$total;
    2860. 

  2860. 		
    2861. 

  2861. 		$data['stHtml']=$stHtml;
    2862. 

  2862. 		$data['year']=$year;
    2863. 

  2863. 		$data['stTitle']=$stTitle;
    2864. 

  2864. 		
    2865. 

  2865. 		$data['memu']="receipt";
    2866. 

  2866. 		$data['staff']=$this->staff;
    2867. 

  2867. 		$data['receiptMemu']='companyCategoryCollect';
    2868. 

  2868. 		$data['verifyId']=$this->verifyId;
    2869. 

  2869. 		
    2870. 

  2870. 		if ($year<date("Y")){	
    2871. 

  2871. 			Doo::loadModel('receipt');
    2872. 

  2872. 			$receipt=new receipt();
    2873. 

  2873. 			$receiptList=$receipt->find(array('where'=>'staff='.$staffId.' and (status=2 or status=4) and Year(date) ='.$year,'asArray'=>true));
    2874. 

  2874. 			if(empty($receiptList)){ //generated files
    2875. 

  2875. 				ob_start();
    2876. 

  2876. 				$this->render ( "/admin/saeaStaffCollectDetail", $data );
    2877. 

  2877. 				$this->cacheFile($path);die;
    2878. 

  2878. 			}
    2879. 

  2879. 		}
    2880. 

  2880. 		
    2881. 

  2881. 		$this->render ( "/admin/saeaStaffCollectDetail", $data );
    2882. 

  2882. 	}
    2883. 

  2883. 	
    2884. 

  2884. 	function _getMonthCollectDetail($receiptCollectList){
    2885. 

  2885. 		
    2886. 

  2886. 	if(!empty($receiptCollectList)){
    2887. 

  2887. 			
    2888. 

  2888. 				$receiptL=array('日常相关费用'=>array(),'差旅相关费用'=>array(),'培训班费用'=>array(),'其他'=>array());
    2889. 

  2889. 				
    2890. 

  2890. 				$html="";
    2891. 

  2891. 				$psum=0;
    2892. 

  2892. 				$item=array('市内交通费','市内出租费','办事处房租','电话费','水费','电费','办公费用','邮寄费','其他费用','车辆费用','广告费','团队建设费');
    2893. 

  2893. 				foreach ($item as $value){
    2894. 

  2894. 					$falg=true;
    2895. 

  2895. 					foreach ($receiptCollectList as $v){
    2896. 

  2896. 						if($v['itemCategory']=='日常相关费用'){
    2897. 

  2897. 							
    2898. 

  2898. 							if($v['item']==$value){
    2899. 

  2899. 								$psum+=$v['price'];
    2900. 

  2900. 								$html.='<td class="taR">'.$v['price'].'</td>';$falg=false;break;
    2901. 

  2901. 							}
    2902. 

  2902. 						}
    2903. 

  2903. 					}
    2904. 

  2904. 					if($falg)
    2905. 

  2905. 						$html.='<td class="taR">-</td>';
    2906. 

  2906. 				}
    2907. 

  2907. 				
    2908. 

  2908. 				if(!empty($psum))
    2909. 

  2909. 					$psum='<td class="colGreen taR">￥'.$psum.'</td>';
    2910. 

  2910. 				else
    2911. 

  2911. 					$psum='<td class="colGreen taR">-</td>';
    2912. 

  2912. 				$receiptL['日常相关费用']=$psum.$html;
    2913. 

  2913. 			
    2914. 

  2914. 			/*-----------------------------------*/
    2915. 

  2915. 			
    2916. 

  2916. 			$html="";
    2917. 

  2917. 				$psum=0;
    2918. 

  2918. 			$item=array('往来交通费','市内交通费','出差住宿费','出差补助','其他费用');
    2919. 

  2919. 			foreach ($item as $value){
    2920. 

  2920. 				$falg=true;
    2921. 

  2921. 				foreach ($receiptCollectList as $v){
    2922. 

  2922. 					if($v['itemCategory']=='差旅相关费用'){
    2923. 

  2923. 						if($v['item']==$value){
    2924. 

  2924. 								$psum+=$v['price'];
    2925. 

  2925. 								$html.='<td class="taR">'.$v['price'].'</td>';$falg=false;break;
    2926. 

  2926. 						}
    2927. 

  2927. 					}
    2928. 

  2928. 				}
    2929. 

  2929. 				if($falg)
    2930. 

  2930. 						$html.='<td class="taR">-</td>';
    2931. 

  2931. 			}
    2932. 

  2932. 			
    2933. 

  2933. 				if(!empty($psum))
    2934. 

  2934. 					$psum='<td class="colGreen taR">￥'.$psum.'</td>';
    2935. 

  2935. 				else
    2936. 

  2936. 					$psum='<td class="colGreen taR">-</td>';
    2937. 

  2937. 				$receiptL['差旅相关费用']=$psum.$html;	
    2938. 

  2938. 				/*-------------------------------------*/
    2939. 

  2939. 				$html="";
    2940. 

  2940. 				$psum=0;
    2941. 

  2941. 				$item=array('场租费','薪酬','住宿费','交通费','餐饮费','办公费','公关费','其他');
    2942. 

  2942. 			foreach ($item as $value){
    2943. 

  2943. 				$falg=true;
    2944. 

  2944. 				foreach ($receiptCollectList as $v){
    2945. 

  2945. 					if($v['itemCategory']=='培训班费用'){
    2946. 

  2946. 					if($v['item']==$value){
    2947. 

  2947. 							$psum+=$v['price'];
    2948. 

  2948. 							$html.='<td class="taR">'.$v['price'].'</td>';$falg=false;break;
    2949. 

  2949. 						}
    2950. 

  2950. 					}
    2951. 

  2951. 				}
    2952. 

  2952. 				if($falg)
    2953. 

  2953. 						$html.='<td class="taR">-</td>';
    2954. 

  2954. 			}
    2955. 

  2955. 				
    2956. 

  2956. 				
    2957. 

  2957. 				if(!empty($psum))
    2958. 

  2958. 					$psum='<td class="colGreen taR">￥'.$psum.'</td>';
    2959. 

  2959. 				else
    2960. 

  2960. 					$psum='<td class="colGreen taR">-</td>';
    2961. 

  2961. 				$receiptL['培训班费用']=$psum.$html;	
    2962. 

  2962. 

  2963. 				/*-------------------------------------*/
    2964. 

  2964. 				$html="";
    2965. 

  2965. 				$psum=0;
    2966. 

  2966. 				$item=array('公关费','广告费','借款','可自加费用');
    2967. 

  2967. 			foreach ($item as $value){
    2968. 

  2968. 				$falg=true;
    2969. 

  2969. 				foreach ($receiptCollectList as $v){
    2970. 

  2970. 					if($v['itemCategory']=='其他'){
    2971. 

  2971. 					if($v['item']==$value){
    2972. 

  2972. 							$psum+=$v['price'];
    2973. 

  2973. 							$html.='<td class="taR">'.$v['price'].'</td>';$falg=false;break;
    2974. 

  2974. 						}
    2975. 

  2975. 					}
    2976. 

  2976. 				}
    2977. 

  2977. 				if($falg)
    2978. 

  2978. 						$html.='<td class="taR">-</td>';
    2979. 

  2979. 			}
    2980. 

  2980. 				
    2981. 

  2981. 				if(!empty($psum))
    2982. 

  2982. 					$psum='<td class="colGreen taR">￥'.$psum.'</td>';
    2983. 

  2983. 				else
    2984. 

  2984. 					$psum='<td class="colGreen taR">-</td>';
    2985. 

  2985. 				$receiptL['其他']=$psum.$html;	
    2986. 

  2986. 	
    2987. 

  2987. 				/*-------------------------------------*/
    2988. 

  2988. 				$html="";
    2989. 

  2989. 				$psum=0;
    2990. 

  2990. 				foreach ($receiptCollectList as $v){
    2991. 

  2991. 					if($v['itemCategory']=='报销金额调整'){
    2992. 

  2992. 						
    2993. 

  2993. 						if (!empty($v['price']))
    2994. 

  2994. 							$psum+=$v['price'];
    2995. 

  2995. 					}
    2996. 

  2996. 				}
    2997. 

  2997. 				
    2998. 

  2998. 				if(!empty($psum))
    2999. 

  2999. 					$psum='<td class="taR colOrange">￥'.$psum.'</td>';
    3000. 

  3000. 				else
    3001. 

  3001. 					$psum='<td class="taR colOrange">-</td>';
    3002. 

  3002. 				$receiptL['报销金额调整']=$psum.$html;	
    3003. 

  3003. 

  3004. 			}else{
    3005. 

  3005. 				$receiptL['日常相关费用']='<td class="colGreen taR">-</td><td class="taR">-</td><td class="taR">-</td><td class="taR">-</td><td class="taR">-</td><td class="taR">-</td><td class="taR">-</td>
    3006. 

  3006. 	  						<td class="taR">-</td><td class="taR">-</td><td class="taR">-</td><td class="taR">-</td><td class="taR">-</td><td class="taR">-</td>';
    3007. 

  3007. 				$receiptL['差旅相关费用']='<td class="colGreen taR">-</td><td class="taR">-</td>
    3008. 

  3008. 	  						<td class="taR">-</td><td class="taR">-</td><td class="taR">-</td><td class="taR">-</td>';
    3009. 

  3009. 				$receiptL['培训班费用']='<td class="colGreen taR">-</td><td class="taR">-</td><td class="taR">-</td><td class="taR">-</td><td class="taR">-</td>
    3010. 

  3010. 	  						<td class="taR">-</td><td class="taR">-</td><td class="taR">-</td><td class="taR">-</td>';
    3011. 

  3011. 				$receiptL['其他']='<td class="colGreen taR">-</td><td class="taR">-</td><td class="taR">-</td><td class="taR">-</td><td class="taR">-</td>';
    3012. 

  3012. 				$receiptL['报销金额调整']='<td class="taR colOrange">-</td>';
    3013. 

  3013. 			}
    3014. 

  3014. 			return $receiptL;
    3015. 

  3015. 	}
    3016. 

  3016. 	
    3017. 

  3017. 	function eMail(){
    3018. 

  3018. 		Doo::loadModel('staff');
    3019. 

  3019. 		$staff=new staff();
    3020. 

  3020. 		Doo::loadModel('receipt');
    3021. 

  3021. 		$receipt=new receipt();
    3022. 

  3022. 		Doo::loadModel('L_category');
    3023. 

  3023. 		$Lcategory=new L_category();
    3024. 

  3024. 		Doo::loadModel("verify");
    3025. 

  3025. 		$verify=new verify();
    3026. 

  3026. 		
    3027. 

  3027. 		$staffList=$staff->find(array('asArray'=>true));
    3028. 

  3028. 		
    3029. 

  3029. 		foreach ($staffList as $key=>$value){
    3030. 

  3030. 			
    3031. 

  3031. 			if($value['username']!='admin'){
    3032. 

  3032. 				//提交人
    3033. 

  3033. 				
    3034. 

  3034. 				$receiptList=$receipt->find(array('where'=>'staff='.$value['sid'].' and status=1 and notice=0','asArray'=>true));
    3035. 

  3035. 				if(!empty($receiptList)){
    3036. 

  3036. 					
    3037. 

  3037. 					$html='<br><div><style></style>
    3038. 

  3038.     <table style="background-color:#fff; width:100%;" cellpadding="0" cellspacing="0"><tbody>
    3039. 

  3039.       <tr><td><table style="background-color:#fff; width:640px;" cellpadding="0" cellspacing="0" align="center"><tbody>
    3040. 

  3040.           <tr><td style="background-color:#8E0950;padding:30px 0 40px;" align="center">
    3041. 

  3041.            <span style="vertical-align:bottom;font-size:20px;color:#fff;">CLD 邮件提醒</span>
    3042. 

  3042.            </td></tr><tr><td><table style="background-color:#fff;border:1px solid #ddd;border-bottom:0px;width:100%;" cellpadding="0" cellspacing="0" align="left">
    3043. 

  3043.              <tbody><tr>
    3044. 

  3044.                <td style="padding: 0 40px;" align="left">
    3045. 

  3045.                <p style="margin-top:40px;margin-bottom:20px;color:#383838;font-size:20px;line-height:32px;">Hi，'.$value['username'].'</p>
    3046. 

  3046.                </td></tr><tr>
    3047. 

  3047.                <td style="padding: 0 40px;" align="left"><p style="margin-top:0px;margin-bottom:40px;color:#383838;font-size:20px;line-height:32px;">美好的一天从今天开始，您需要关注以下事项：</p></td>
    3048. 

  3048.               </tr>
    3049. 

  3049.              </tbody> </table></td> </tr> <tr><td>
    3050. 

  3050.             <table style="background-color:#f5f6f7;width:100%;padding:0 0 20px;border-left:1px solid #ddd;border-right:1px solid #ddd;" cellpadding="0" cellspacing="0" align="left">
    3051. 

  3051.              <tbody> <tr><td>
    3052. 

  3052.              <p style="margin-top:20px;margin-bottom:10px;margin-left:40px;color:#383838;font-size:18px;font-weight:bold;line-height:36px;">
    3053. 

  3053.              	以下报销单完成了审批，等着收款吧：</p>
    3054. 

  3054.              </td></tr><tr><td><table style="width:100%;padding-right:30px;" cellpadding="0" cellspacing="0" align="left"> <tbody>';
    3055. 

  3055. 

  3056. 				foreach ($receiptList as $k=>$v){
    3057. 

  3057. 					$category=$Lcategory->getOne(array('where'=>'cid='.$v['cid'],'asArray'=>true));
    3058. 

  3058. 				$html.='
    3059. 

  3059.                   <tr>
    3060. 

  3060.                   <td style="border-left:7px solid transparent;" align="left" width="30px"><br></td>
    3061. 

  3061.                    <td align="left">
    3062. 

  3062.                     <p style="font-size:16px;line-height:22px;margin:0">'.$v['receiptOrder'].'</p></td>
    3063. 

  3063.                    <td style="" align="left"><p style="font-size:16px;line-height:22px;margin:0">'.$category['title'].'</p></td>
    3064. 

  3064.                    <td style="" align="left"><p style="font-size:16px;line-height:22px;margin:0">￥'.$v['sum'].'元</p></td>
    3065. 

  3065.                    <td align="right"><span class="past" style="font-size:16px;line-height:22px;">'.$v['date'].'</span></td>
    3066. 

  3066.                   </tr>';
    3067. 

  3067. 				}
    3068. 

  3068. 				
    3069. 

  3069.                 $html.=' </tbody></table></td></tr></tbody></table></td></tr>
    3070. 

  3070.           <tr><td style="height:150px;border:1px solid #ddd;border-top:none;background-color:#fff;" align="center"><a href="http://cld.smartcost.com.cn/approval" style="display:block;height:50px;width:260px;background-color:#0390ff;font-weight:normal;font-size:18px;color:white;line-height:50px;text-align:center;text-decoration:none;border-radius:3px;">立即登录</a></td>
    3071. 

  3071.           </tr></tbody></table></td> </tr></tbody></table> </div><br>';
    3072. 

  3072. 					
    3073. 

  3073.                 if(filter_var($value['email'], FILTER_VALIDATE_EMAIL)){
    3074. 

  3074.                 	$this->SMail($value['email'], "CLD提醒您，您的报销单已同意支付", $html);
    3075. 

  3075.                 	$this->SMail('1971614655@qq.com', "CLD提醒您，您的报销单已同意支付", $html);
    3076. 

  3076.                 	$this->SMail('cpthought@vip.qq.com', "CLD提醒您，您的报销单已同意支付", $html);
    3077. 

  3077. 					$receipt=new receipt();
    3078. 

  3078. 					$receipt->notice=1;
    3079. 

  3079. 					$receipt->update(array('where'=>'staff='.$value['sid'].' and status=1 and notice=0'));
    3080. 

  3080. 	                }
    3081. 

  3081. 				}
    3082. 

  3082. 				
    3083. 

  3083. 			//审批人
    3084. 

  3084. 			$verifyList=$verify->find(array('where'=>" staff like '%[\"".$value['sid']."\",%'",'asArray'=>true));
    3085. 

  3085. 			$html='<br><div><style></style> <table style="background-color:#fff; width:100%;" cellpadding="0" cellspacing="0">
    3086. 

  3086.      <tbody><tr><td><table style="background-color:#fff; width:640px;" cellpadding="0" cellspacing="0" align="center"><tbody><tr>
    3087. 

  3087.            <td style="background-color:#8E0950;padding:30px 0 40px;" align="center">
    3088. 

  3088.            <span style="vertical-align:bottom;font-size:20px;color:#fff;">CLD 邮件提醒</span></td>
    3089. 

  3089.           </tr><tr><td><table style="background-color:#fff;border:1px solid #ddd;border-bottom:0px;width:100%;" cellpadding="0" cellspacing="0" align="left">
    3090. 

  3090.              <tbody><tr><td style="padding: 0 40px;" align="left">
    3091. 

  3091.                <p style="margin-top:40px;margin-bottom:20px;color:#383838;font-size:20px;line-height:32px;">Hi，'.$value['username'].'</p>
    3092. 

  3092.                </td></tr><tr><td style="padding: 0 40px;" align="left"><p style="margin-top:0px;margin-bottom:40px;color:#383838;font-size:20px;line-height:32px;">美好的一天从今天开始，您需要关注以下事项：</p></td>
    3093. 

  3093.               </tr></tbody></table></td> </tr> <tr><td><table style="background-color:#f5f6f7;width:100%;padding:0 0 20px;border-left:1px solid #ddd;border-right:1px solid #ddd;" cellpadding="0" cellspacing="0" align="left">
    3094. 

  3094.              <tbody><tr><td><p style="margin-top:20px;margin-bottom:10px;margin-left:40px;color:#383838;font-size:18px;font-weight:bold;line-height:36px;">以下报销单需要您的审批：</p></td>
    3095. 

  3095.               </tr><tr><td><table style="width:100%;padding-right:30px;" cellpadding="0" cellspacing="0" align="left"><tbody>';
    3096. 

  3096.               
    3097. 

  3097. 			foreach ($verifyList as $k=>$v){
    3098. 

  3098. 				$receiptList=$receipt->find(array('where'=>"verify=".$v['vid']." and status=2 and verifyStaff not like '%{\"".$value['sid']."\":%'",'asArray'=>true));
    3099. 

  3099. 				foreach ($receiptList as $r=>$l){
    3100. 

  3100. 				$category=$Lcategory->getOne(array('where'=>'cid='.$l['cid'],'asArray'=>true));
    3101. 

  3101. 				$staffDetile=$staff->getOne(array('where'=>'sid='.$l['staff'],'asArray'=>true));
    3102. 

  3102. 				$html.='
    3103. 

  3103. 	                  <tr>
    3104. 

  3104. 	                  <td style="border-left:7px solid transparent;" align="left" width="30px"><br></td>
    3105. 

  3105. 	                   <td align="left">
    3106. 

  3106. 	                    <p style="font-size:16px;line-height:22px;margin:0">'.$l['receiptOrder'].'</p></td>
    3107. 

  3107. 	                   <td style="" align="left"><p style="font-size:16px;line-height:22px;margin:0">'.$category['title'].'-'.$staffDetile['username'].'</p></td>
    3108. 

  3108. 	                   <td style="" align="left"><p style="font-size:16px;line-height:22px;margin:0">￥'.$l['sum'].'元</p></td>
    3109. 

  3109. 	                   <td align="right"><span class="past" style="font-size:16px;line-height:22px;">'.$l['date'].'</span></td>
    3110. 

  3110. 	                  </tr>';
    3111. 

  3111. 				}
    3112. 

  3112.               
    3113. 

  3113. 			}
    3114. 

  3114.                  $html.=' 
    3115. 

  3115.                  </tbody></table></td></tr> </tbody></table></td></tr><tr>
    3116. 

  3116.            <td style="height:150px;border:1px solid #ddd;border-top:none;background-color:#fff;" align="center"><a href="http://cld.smartcost.com.cn/approval" style="display:block;height:50px;width:260px;background-color:#0390ff;font-weight:normal;font-size:18px;color:white;line-height:50px;text-align:center;text-decoration:none;border-radius:3px;">立即登录</a></td>
    3117. 

  3117.           </tr></tbody></table></td></tr></tbody></table></div><br>';
    3118. 

  3118. 			
    3119. 

  3119. 			if((filter_var($value['email'], FILTER_VALIDATE_EMAIL))&&(!empty($verifyList))&&(!empty($receiptList))){
    3120. 

  3120.                 	$this->SMail($value['email'], "CLD提醒您，有需要你审批的报销单", $html);
    3121. 

  3121. //					$receipt=new receipt();
    3122. 

  3122. //					$receipt->notice=1;
    3123. 

  3123. //					$receipt->update(array('where'=>'staff='.$value['sid'].' and status=1 and notice=0'));
    3124. 

  3124. 	               }
    3125. 

  3125. 				
    3126. 

  3126. 		}
    3127. 

  3127. 		}
    3128. 

  3128. 	}
    3129. 

  3129. 	
    3130. 

  3130. // Email发送函数
    3131. 

  3131.     function SMail($toemail, $subject, $contents) {
    3132. 

  3132.         Doo::loadClass('class.phpmailer');
    3133. 

  3133.         $mail = new PHPMailer();
    3134. 

  3134.         $mail->From = "postmaster@support.zhzdwk.com"; //发送邮箱全名
    3135. 

  3135.         $mail->FromName = "=?UTF-8?B?" . base64_encode("CLD") . "?="; //发送人昵称
    3136. 

  3136.         $mail->Username = "postmaster@websupport.sendcloud.org"; //用户名
    3137. 

  3137.         $mail->Password = "cDO1GjtY1seH"; //密码
    3138. 

  3138.         $mail->CharSet = "UTF8";
    3139. 

  3139.         $mail->SMTPAuth = true;
    3140. 

  3140.         $mail->Host = "smtpcloud.sohu.com"; //邮件主机的smtp地址
    3141. 

  3141.         $mail->Mailer = "smtp";
    3142. 

  3142.         $mail->Port = 25;
    3143. 

  3143.         $mail->Subject = "=?UTF-8?B?" . base64_encode($subject) . "?=";
    3144. 

  3144.         $mail->MsgHTML($contents);
    3145. 

  3145.         $mail->AddAddress($toemail);
    3146. 

  3146.         $mail->CharSet = "UTF-8";
    3147. 

  3147.         return $mail->Send();
    3148. 

  3148.     }
    3149. 

  3149. 	/**
    3150. 

  3150. 	 * 获取get或者POST值
    3151. 

  3151. 	 * @param string $name 属性名称
    3152. 

  3152. 	 * @return fixed 值
    3153. 

  3153. 	 */
    3154. 

  3154. 	function get_args($name) {
    3155. 

  3155. 		if (isset ( $_GET [$name] )) {
    3156. 

  3156. 			if (is_array ( $_GET [$name] ))
    3157. 

  3157. 				return $_GET [$name];
    3158. 

  3158. 			else 
    3159. 

  3159. 				return addslashes ( $_GET [$name] );
    3160. 

  3160. 				
    3161. 

  3161. 		} elseif (isset ( $_POST [$name] )) {
    3162. 

  3162. 			if (is_array ( $_POST [$name] ))
    3163. 

  3163. 				return $_POST [$name];
    3164. 

  3164. 			else 
    3165. 

  3165. 				return addslashes ( $_POST [$name] );
    3166. 

  3166. 		} else
    3167. 

  3167. 			return false;
    3168. 

  3168. 	}
    3169. 

  3169. 

  3170. }
    3171. 

  3171. ?>
    3172.