| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281128212831284128512861287128812891290129112921293129412951296129712981299130013011302130313041305130613071308130913101311131213131314131513161317131813191320132113221323132413251326132713281329133013311332133313341335133613371338133913401341134213431344134513461347134813491350135113521353135413551356135713581359136013611362136313641365136613671368136913701371137213731374137513761377137813791380138113821383138413851386138713881389139013911392139313941395139613971398139914001401140214031404140514061407140814091410141114121413141414151416141714181419142014211422142314241425142614271428142914301431143214331434143514361437143814391440144114421443144414451446144714481449145014511452145314541455145614571458145914601461146214631464146514661467146814691470147114721473147414751476147714781479148014811482148314841485148614871488148914901491149214931494149514961497149814991500150115021503150415051506150715081509151015111512151315141515151615171518151915201521152215231524152515261527152815291530153115321533153415351536153715381539154015411542154315441545154615471548154915501551155215531554155515561557155815591560156115621563156415651566156715681569157015711572157315741575157615771578157915801581158215831584158515861587158815891590159115921593159415951596159715981599160016011602160316041605160616071608160916101611161216131614161516161617161816191620162116221623162416251626162716281629163016311632163316341635163616371638163916401641164216431644164516461647164816491650165116521653165416551656165716581659166016611662166316641665166616671668166916701671167216731674167516761677167816791680168116821683168416851686168716881689169016911692169316941695169616971698169917001701170217031704170517061707170817091710171117121713171417151716171717181719172017211722172317241725172617271728172917301731173217331734173517361737173817391740174117421743174417451746174717481749175017511752175317541755175617571758175917601761176217631764176517661767176817691770177117721773177417751776177717781779178017811782178317841785178617871788178917901791179217931794179517961797179817991800180118021803180418051806180718081809181018111812181318141815181618171818181918201821182218231824182518261827182818291830183118321833183418351836183718381839184018411842184318441845184618471848184918501851185218531854185518561857185818591860186118621863186418651866186718681869187018711872187318741875187618771878187918801881188218831884188518861887188818891890189118921893189418951896189718981899190019011902190319041905190619071908190919101911191219131914191519161917191819191920192119221923192419251926192719281929193019311932193319341935193619371938193919401941194219431944194519461947194819491950195119521953195419551956195719581959196019611962196319641965196619671968196919701971197219731974197519761977197819791980198119821983198419851986198719881989199019911992199319941995199619971998199920002001200220032004200520062007200820092010201120122013201420152016201720182019202020212022202320242025202620272028202920302031203220332034203520362037203820392040204120422043204420452046204720482049205020512052205320542055205620572058205920602061206220632064206520662067206820692070207120722073207420752076207720782079208020812082208320842085208620872088208920902091209220932094209520962097209820992100210121022103210421052106210721082109211021112112211321142115211621172118211921202121212221232124212521262127212821292130213121322133213421352136213721382139214021412142214321442145214621472148214921502151215221532154215521562157215821592160216121622163216421652166216721682169217021712172217321742175217621772178217921802181218221832184218521862187218821892190219121922193219421952196219721982199220022012202220322042205220622072208220922102211221222132214221522162217221822192220222122222223222422252226222722282229223022312232223322342235223622372238223922402241224222432244224522462247224822492250225122522253225422552256225722582259226022612262226322642265226622672268226922702271227222732274227522762277227822792280228122822283228422852286228722882289229022912292229322942295229622972298229923002301230223032304230523062307230823092310231123122313231423152316231723182319232023212322232323242325232623272328232923302331233223332334233523362337233823392340234123422343234423452346234723482349235023512352235323542355235623572358235923602361236223632364236523662367236823692370237123722373237423752376237723782379238023812382238323842385238623872388238923902391239223932394239523962397239823992400240124022403240424052406240724082409241024112412241324142415241624172418241924202421242224232424242524262427242824292430243124322433243424352436243724382439244024412442244324442445244624472448244924502451245224532454245524562457245824592460246124622463246424652466246724682469247024712472247324742475247624772478247924802481248224832484248524862487248824892490249124922493249424952496249724982499250025012502250325042505250625072508250925102511251225132514251525162517251825192520252125222523252425252526252725282529253025312532253325342535253625372538253925402541254225432544254525462547254825492550255125522553255425552556255725582559256025612562256325642565256625672568256925702571257225732574257525762577257825792580258125822583258425852586258725882589259025912592259325942595259625972598259926002601260226032604260526062607260826092610261126122613261426152616261726182619262026212622262326242625262626272628262926302631263226332634263526362637263826392640264126422643264426452646264726482649265026512652265326542655265626572658265926602661266226632664266526662667266826692670267126722673267426752676267726782679268026812682268326842685268626872688268926902691269226932694269526962697269826992700270127022703270427052706270727082709271027112712271327142715271627172718271927202721272227232724272527262727272827292730273127322733273427352736273727382739274027412742274327442745274627472748274927502751275227532754275527562757275827592760276127622763276427652766276727682769277027712772277327742775277627772778277927802781278227832784278527862787278827892790279127922793279427952796279727982799280028012802280328042805280628072808280928102811281228132814281528162817281828192820282128222823282428252826282728282829283028312832283328342835283628372838283928402841284228432844284528462847284828492850285128522853285428552856285728582859286028612862286328642865286628672868286928702871287228732874287528762877287828792880288128822883288428852886288728882889289028912892289328942895289628972898289929002901290229032904290529062907290829092910291129122913291429152916291729182919292029212922292329242925292629272928292929302931293229332934293529362937293829392940294129422943294429452946294729482949295029512952295329542955295629572958295929602961296229632964296529662967296829692970297129722973297429752976297729782979298029812982298329842985298629872988298929902991299229932994299529962997299829993000300130023003300430053006300730083009301030113012301330143015301630173018301930203021302230233024302530263027302830293030303130323033303430353036303730383039304030413042304330443045304630473048304930503051305230533054305530563057305830593060306130623063306430653066306730683069307030713072307330743075307630773078307930803081308230833084308530863087308830893090309130923093309430953096309730983099310031013102310331043105310631073108310931103111311231133114311531163117311831193120312131223123312431253126312731283129313031313132313331343135313631373138313931403141314231433144314531463147314831493150315131523153315431553156315731583159316031613162316331643165316631673168316931703171317231733174317531763177317831793180318131823183318431853186318731883189319031913192319331943195319631973198319932003201320232033204320532063207320832093210321132123213321432153216321732183219322032213222322332243225322632273228322932303231323232333234323532363237323832393240324132423243324432453246324732483249325032513252325332543255325632573258325932603261326232633264326532663267326832693270327132723273327432753276327732783279328032813282328332843285328632873288328932903291329232933294329532963297329832993300330133023303330433053306330733083309331033113312331333143315331633173318331933203321332233233324332533263327332833293330333133323333333433353336333733383339334033413342334333443345334633473348334933503351335233533354335533563357335833593360336133623363336433653366336733683369337033713372337333743375337633773378337933803381338233833384338533863387338833893390339133923393339433953396339733983399340034013402340334043405340634073408340934103411341234133414341534163417341834193420342134223423342434253426342734283429343034313432343334343435343634373438343934403441344234433444344534463447344834493450345134523453345434553456345734583459346034613462346334643465346634673468346934703471347234733474347534763477347834793480348134823483348434853486348734883489349034913492349334943495349634973498349935003501350235033504350535063507350835093510351135123513351435153516351735183519352035213522352335243525352635273528352935303531353235333534353535363537353835393540354135423543354435453546354735483549355035513552355335543555355635573558355935603561356235633564356535663567356835693570357135723573357435753576357735783579358035813582358335843585358635873588358935903591359235933594359535963597359835993600360136023603360436053606360736083609361036113612361336143615361636173618361936203621362236233624362536263627362836293630363136323633363436353636363736383639364036413642364336443645364636473648364936503651365236533654365536563657365836593660366136623663366436653666366736683669367036713672367336743675 |
- <?php
- /**
- * 开票功能控制器
- * @author CP
- * @version 1.0
- * @namespace invoice
- * @package invoiceController
- */
- class InvoiceController extends DooController {
- public $staff;
- public $NEW;
- public $data;
- private $INVOICEKEY = "APPROVAL";
- private $INVOICECOLLECTPATH = "protected/cache/invoiceCollect/";
- private $ACTION = '';
- public function beforeRun($resource, $action) {
- Doo::loadModel ( "invoiceManage" );
- $invoiceManage = new invoiceManage ();
- Doo::loadClass ( 'XDeode' );
- $XDeode = new XDeode ( 5 );
- $sid = $XDeode->decode ( $_COOKIE ["staff"] );
- header ( 'Content-Type:text/html;charset=utf-8' );
- $moldList = $invoiceManage->getInvoiceByStaff ( $sid );
-
- if (empty ( $moldList )) {
- $flag = false;
- $uGroups = 'ordinary';
- if (Doo::acl ()->isAllowed ( $uGroups, $resource, $action )) {
- $flag = true;
- }
- } else {
- $flag = false;
- array_push ( $moldList, array (
- 'mold' => 'ordinary'
- ) );
-
- // 删除审批人后-加入权限问题-暂时关闭
- // $fileInvoice = file_get_contents ( "protected/config/invoice/invoice.ini" );
- // $fiML=json_decode($fileInvoice,true);
- // foreach ($fiML as $key=>$value){
- // $sidList=explode(',',$value);
- // foreach ($sidList as $k=>$v){
- // if ($v==$sid){
- // array_push ( $moldList, array (
- // 'mold' => $key
- // ) );
- // break;
- // }
- // }
- // }
-
- foreach ( $moldList as $value ) {
- if (Doo::acl ()->isAllowed ( $value ['mold'], $resource, $action )) {
- $flag = true;
- break;
- }
- }
- }
- /*
- * Doo::acl()->isAllowed($uGroups['groups'], $resource, $action);
- */
- // var_dump($flag) ;
- if (! $flag)
- die ( 'illegal request' );
- }
- function __construct() {
- if (isset ( $_COOKIE ["staff"] )) {
- if (! empty ( $_COOKIE ["staff"] )) {
- Doo::loadModel ( 'staff' );
- $staff = new staff ();
-
- $uriPartsOrig = explode ( '/', $_SERVER ['REQUEST_URI'] );
- $this->ACTION = $uriPartsOrig [1];
-
- $this->data ['new'] = $this->isInvoiceNew ();
- $this->staff = $staff->getUserByIdList ( $_COOKIE ["staff"] );
- return "/";
- }
- }
-
- Doo::loadCore ( 'uri/DooUriRouter' );
- $router = new DooUriRouter ();
- $routeRs = $router->execute ( Doo::app ()->route, Doo::conf ()->SUBFOLDER );
-
- if ($routeRs ['1'] != "login") {
- header ( 'Content-Type:text/html;charset=utf-8' );
- @header ( "Location: /login" );
- }
- }
- function invoice() {
- Doo::loadModel ( 'invoice' );
- $invoice = new invoice ();
- Doo::loadModel ( 'express' );
- $express = new express ();
- $expressList = $express->getExpressByAll ();
- $this->data ['expressList'] = $expressList;
- // Doo::loadModel ( 'invoiceReceivables' );
- // $invoiceReceivables = new invoiceReceivables ();
- // $list = $invoiceReceivables->getInvoiceReceivablesByClaim ( $this->staff [0] ['cid'], $this->staff [0] ['sid'] );
-
- Doo::loadModel ( 'invoiceStatistics' );
- $invoiceStatistics = new invoiceStatistics ();
-
- $isMonth = $invoiceStatistics->getStatisticsByMonth ();
-
- $year = date ( "Y" );
- $tmp_date = date ( "Ym" );
- $tmp_year = substr ( $tmp_date, 0, 4 );
- $tmp_mon = substr ( $tmp_date, 4, 2 );
- $tmp_forwardmonth = mktime ( 0, 0, 0, $tmp_mon - 1, 1, $tmp_year );
- $fm_forward_month = date ( "m", $tmp_forwardmonth );
- $path = SITE_PATH . $this->INVOICECOLLECTPATH . "invoiceCollect_" . $year . "_" . $fm_forward_month . ".htm";
- $htm = $this->showCache ( $path );
- Doo::loadClass ( 'XDeode' );
- $XDeode = new XDeode ( 5 );
- $sid = $XDeode->decode ( $_COOKIE ["staff"] );
-
- $invoiceList = $invoice->getMyInvoice ( $sid );
-
- $sql = 'status=2 and printStatus=1 and irid!="" and sid=' . $sid;
- $list = $invoice->getInvoiceByUntreadStatusPage ( 4, $sql );
- // 我的待入账发票 and irid='' and ( (doPost=1 and postStatus=1) or doPost=0 )
- $sql = "status=2 and printStatus=1 and untreadStatus=0 and isDelete=0 and sid=" . $sid;
- $myInvoiceUnAccount = $invoice->getInvoiceByUntreadStatusPage ( 4, $sql );
-
- // print_r($myInvoiceUnAccount);
-
- $this->data ['isMonth'] = $isMonth;
- $this->data ['htm'] = $htm;
-
- $this->data ['invoiceList'] = $invoiceList;
- $this->data ['receivablesList'] = $list;
- $this->data ['myInvoiceUnAccount'] = $myInvoiceUnAccount;
-
- $this->data ['memu'] = "invoice";
- $this->data ['staff'] = $this->staff;
- $this->data ['receiptMemu'] = 'invoice';
- $this->render ( "/admin/invoice", $this->data );
- }
- function invoiceAdd() {
- Doo::loadModel ( 'L_category' );
- $lCategory = new L_category ();
-
- $category = $lCategory->find ( array (
- 'asArray' => true
- ) );
-
- $this->data ['category'] = $category;
-
- $this->data ['memu'] = "invoice";
- $this->data ['staff'] = $this->staff;
- $this->data ['receiptMemu'] = 'invoice';
- $this->render ( "/admin/invoiceAdd", $this->data );
- }
-
- /**
- * 提交一份开票申请,并记录下操作日志
- *
- * @since 1.0.0
- * @var integer cid 办事处ID
- * @var integer invoiceType 发票类型
- * @var integer doPost 是否邮寄
- * @var integer invoicePrice 开票金额
- * @var string invoiceElement 开票内容
- * @var string invoiceTitle 发票抬头
- * @var string invoiceCompany 单位名称
- * @var string TIN 纳税人识别码
- * @var string address 注册地址
- * @var string phone 注册电话
- * @var string bank 开户银行
- * @var string bankAccount 银行账户
- * @var string recipients 收件人
- * @var string recipientsPhone 收件人手机/电话
- * @var string recipientsAddress 收件地址
- * @var string mailItems 邮寄物品
- * @var string remark 备注
- * @return string 返回跳转开票主页路径
- */
- function invoiceAddDo() {
- $cid = $this->get_args ( 'cid' ) && is_numeric ( $this->get_args ( 'cid' ) ) ? $this->get_args ( 'cid' ) : 0;
- $invoiceType = $this->get_args ( 'invoiceType' ) && is_numeric ( $this->get_args ( 'invoiceType' ) ) ? $this->get_args ( 'invoiceType' ) : 0;
- $doPost = $this->get_args ( 'doPost' ) && is_numeric ( $this->get_args ( 'doPost' ) ) ? $this->get_args ( 'doPost' ) : 0;
- $invoicePrice = $this->get_args ( 'invoicePrice' ) ? $this->get_args ( 'invoicePrice' ) : "";
- $invoiceElement = $this->get_args ( 'invoiceElement' ) ? $this->get_args ( 'invoiceElement' ) : "";
- $invoiceTitle = $this->get_args ( 'invoiceTitle' ) ? $this->get_args ( 'invoiceTitle' ) : "";
- $invoiceCompany = $this->get_args ( 'invoiceCompany' ) ? $this->get_args ( 'invoiceCompany' ) : "";
- $TIN = $this->get_args ( 'TIN' ) ? $this->get_args ( 'TIN' ) : "";
- $address = $this->get_args ( 'address' ) ? $this->get_args ( 'address' ) : "";
- $phone = $this->get_args ( 'phone' ) ? $this->get_args ( 'phone' ) : "";
- $bank = $this->get_args ( 'bank' ) ? $this->get_args ( 'bank' ) : "";
- $bankAccount = $this->get_args ( 'bankAccount' ) ? $this->get_args ( 'bankAccount' ) : "";
- $recipients = $this->get_args ( 'recipients' ) ? $this->get_args ( 'recipients' ) : "";
- $recipientsPhone = $this->get_args ( 'recipientsPhone' ) ? $this->get_args ( 'recipientsPhone' ) : "";
- $recipientsAddress = $this->get_args ( 'recipientsAddress' ) ? $this->get_args ( 'recipientsAddress' ) : "";
-
- $remark = $this->get_args ( 'remark' ) ? $this->get_args ( 'remark' ) : "";
-
- $TINT = $this->get_args ( 'TINT' ) ? $this->get_args ( 'TINT' ) : "";
- $addressT = $this->get_args ( 'addressT' ) ? $this->get_args ( 'addressT' ) : "";
- $phoneT = $this->get_args ( 'phoneT' ) ? $this->get_args ( 'phoneT' ) : "";
- $bankT = $this->get_args ( 'bankT' ) ? $this->get_args ( 'bankT' ) : "";
- $bankAccountT = $this->get_args ( 'bankAccountT' ) ? $this->get_args ( 'bankAccountT' ) : "";
-
- $softLock = $this->get_args ( 'softLock' ) ? $this->get_args ( 'softLock' ) : 0;
- $softLockNum = $this->get_args ( 'softLockNum' ) ? $this->get_args ( 'softLockNum' ) : 0;
- $contract = $this->get_args ( 'contract' ) ? $this->get_args ( 'contract' ) : 0;
- $contractNum = $this->get_args ( 'contractNum' ) ? $this->get_args ( 'contractNum' ) : 0;
- $instructions = $this->get_args ( 'instructions' ) ? $this->get_args ( 'instructions' ) : 0;
- $instructionsNum = $this->get_args ( 'instructionsNum' ) ? $this->get_args ( 'instructionsNum' ) : 0;
- $remittance = $this->get_args ( 'remittance' ) ? $this->get_args ( 'remittance' ) : 0;
-
- $mailItems = $this->get_args ( 'mailItems' ) ? $this->get_args ( 'mailItems' ) : "";
-
- /*
- * $mailList=array(); array_push($mailList, array('invoice'=>1)); array_push($mailList, array('mailItems'=>$mailItems)); if (!empty($softLock)) array_push($mailList, array('softLock'=>$softLockNum)); if (!empty($contract)) array_push($mailList, array('contract'=>$contractNum)); if (!empty($instructions)) array_push($mailList, array('instructions'=>$instructionsNum)); if (!empty($remittance)) array_push($mailList, array('remittance'=>$remittance)); echo json_encode($mailList) ; print_r($mailList); die;
- */
-
- if (! empty ( $cid ) && ! empty ( $invoicePrice ) && ! empty ( $invoiceElement )) {
- Doo::loadModel ( 'invoice' );
- $invoice = new invoice ();
- Doo::loadModel ( 'L_category' );
- $lCategory = new L_category ();
- Doo::loadModel ( 'invoiceManage' );
- $invoiceManage = new invoiceManage ();
- Doo::loadModel ( 'invoiceOperationLog' );
- $invoiceOperationLog = new invoiceOperationLog ();
-
- Doo::loadModel ( 'invoiceStatistics' );
- $invoiceStatistics = new invoiceStatistics ();
-
- $categoryDetil = $lCategory->getOne ( array (
- 'SELECT' => 'title',
- 'where' => 'cid=' . $cid,
- 'asArray' => true
- ) );
-
- $invoiceManageList = $invoiceManage->getInvoiceByAll ();
- $invoiceManageDetail = $invoiceManage->getInvoiceByMold ( "发票审批" );
- // print_r(current($invoiceManageDetail ['staffList']));
- // die;
-
- $moldManage = array ();
- foreach ( $invoiceManageList as $key => $value ) {
- if ($value ['mold'] == '发票打印')
- $moldManage [$value ['mold']] = $value ['staffList'];
- elseif ($value ['mold'] == '发票邮寄')
- $moldManage [$value ['mold']] = $value ['staffList'];
- elseif ($value ['mold'] == '发票退票')
- $moldManage [$value ['mold']] = $value ['staffList'];
- }
-
- $item = array (
- 'cid' => $cid,
- 'categoryName' => $categoryDetil ['title'],
- 'invoiceElement' => $invoiceElement,
- 'invoicePrice' => $invoicePrice,
- 'invoiceType' => $invoiceType,
- 'doPost' => $doPost,
- 'status' => 1,
- 'invoiceSerial' => "#F" . date ( "Ymd" ) . mt_rand ( 1000, 9999 ),
- 'date' => date ( "Y-m-d H:i:s" ),
- 'updateTime' => date ( "Y-m-d H:i:s" ),
- 'sid' => $this->staff [0] ['sid'],
- 'userName' => $this->staff [0] ['username'],
- 'invoiceManage' => $invoiceManageDetail ['staff'],
- 'pendingApprovals' => current ( $invoiceManageDetail ['staffList'] ) [0],
- 'moldManage' => json_encode ( $moldManage ),
- 'remark' => $remark
- );
- if ($invoiceType == 0)
- $item += array (
- 'invoiceTitle' => $invoiceTitle,
- 'TIN' => $TINT,
- 'address' => $addressT,
- 'phone' => $phoneT,
- 'bank' => $bankT,
- 'bankAccount' => $bankAccountT
- );
- else {
- $item += array (
- 'invoiceCompany' => $invoiceCompany,
- 'TIN' => $TIN,
- 'address' => $address,
- 'phone' => $phone,
- 'bank' => $bank,
- 'bankAccount' => $bankAccount
- );
- }
- if ($doPost == 1) {
-
- $mailList = array (
- 'invoice' => 1,
- 'mailItems' => $mailItems
- );
- if (! empty ( $softLock ))
- $mailList += array (
- 'softLock' => $softLockNum
- );
- else
- $mailList += array (
- 'softLock' => 0
- );
- if (! empty ( $contract ))
- $mailList += array (
- 'contract' => $contractNum
- );
- else
- $mailList += array (
- 'contract' => 0
- );
- if (! empty ( $instructions ))
- $mailList += array (
- 'instructions' => $instructionsNum
- );
- else
- $mailList += array (
- 'instructions' => 0
- );
- if (! empty ( $remittance ))
- $mailList += array (
- 'remittance' => $remittance
- );
- else
- $mailList += array (
- 'remittance' => ''
- );
-
- $mailString = '发票x1,备注:' . $mailItems;
- if (! empty ( $softLock ))
- $mailString .= ',软件锁x' . $softLockNum;
- if (! empty ( $contract ))
- $mailString .= ',合同x' . $contractNum;
- if (! empty ( $instructions ))
- $mailString .= ',说明书x' . $instructionsNum;
- if (! empty ( $remittance ))
- $mailString .= ',汇款账号单';
-
- $item += array (
- 'recipients' => $recipients,
- 'recipientsPhone' => $recipientsPhone,
- 'recipientsAddress' => $recipientsAddress,
- 'mailItems' => $mailString,
- 'mailItemsJson' => json_encode ( $mailList )
- );
- }
-
- $iid = $invoice->addInvoice ( $item );
-
- $item = array (
- 'date' => date ( "Y-m-d H:i:s" ),
- 'operation' => "创建",
- 'status' => 1,
- 'img' => $this->staff [0] ['avatar'],
- 'username' => $this->staff [0] ['username'],
- 'uid' => $this->staff [0] ['sid'],
- 'category' => $this->staff [0] ['category'],
- 'iid' => $iid
- );
- $invoiceOperationLog->setInvoiceOperationLog ( $item );
- $item = array (
- 'date' => date ( "Y-m-d H:i:s" ),
- 'operation' => "提交审批",
- 'status' => 1,
- 'img' => $this->staff [0] ['avatar'],
- 'username' => $this->staff [0] ['username'],
- 'uid' => $this->staff [0] ['sid'],
- 'category' => $this->staff [0] ['category'],
- 'iid' => $iid
- );
- $invoiceOperationLog->setInvoiceOperationLog ( $item );
-
- $item = array (
- 'date' => date ( "Y-m-d H:i:s" ),
- 'priceClass' => 1,
- 'cid' => $this->staff [0] ['cid'],
- 'staff' => $this->staff [0] ['sid'],
- 'invoicePrice' => $invoicePrice
- );
- $invoiceStatistics->setInvoiceStatisticsByCondition ( $item );
- }
-
- return "/invoice";
- }
- function invoiceEdit() {
- Doo::loadClass ( 'XDeode' );
- $XDeode = new XDeode ( 5 );
-
- $iid = isset ( $this->params ['iid'] ) ? $this->params ['iid'] : "";
- $iid = $XDeode->decode ( $iid );
- if (! is_numeric ( $iid ))
- die ( 'illegal request' );
-
- Doo::loadModel ( 'invoice' );
- $invoice = new invoice ();
- Doo::loadModel ( 'invoiceOperationLog' );
- $invoiceOperationLog = new invoiceOperationLog ();
-
- $invoiceDetail = $invoice->getInvoiceByIid ( $iid );
- $operation = $invoiceOperationLog->getInvoiceOperationByDropped ( $iid );
-
- $invoiceDetail ['mailItemsJson'] = json_decode ( $invoiceDetail ['mailItemsJson'], true );
-
- $this->data ['operation'] = $operation;
- $this->data ['invoiceDetail'] = $invoiceDetail;
- $this->data ['memu'] = "invoice";
- $this->data ['staff'] = $this->staff;
- $this->data ['receiptMemu'] = 'invoice';
- $this->render ( "/admin/invoiceEdit", $this->data );
- }
- /**
- * 重新编辑退回的发票
- * @return string
- */
- function invoiceEditDo() {
- $iidKey = $this->get_args ( 'iidKey' ) ? $this->get_args ( 'iidKey' ) : '';
- Doo::loadModel ( 'invoice' );
- $invoice = new invoice ();
- $iid = $invoice->authcode ( $iidKey );
- if (! empty ( $iid ) && ! is_numeric ( $iid ))
- die ( 'illegal request' );
-
- $cid = $this->get_args ( 'cid' ) ? $this->get_args ( 'cid' ) : 0;
- $invoiceType = $this->get_args ( 'invoiceType' ) && is_numeric ( $this->get_args ( 'invoiceType' ) ) ? $this->get_args ( 'invoiceType' ) : 0;
- $doPost = $this->get_args ( 'doPost' ) && is_numeric ( $this->get_args ( 'doPost' ) ) ? $this->get_args ( 'doPost' ) : 0;
- $invoicePrice = $this->get_args ( 'invoicePrice' ) ? $this->get_args ( 'invoicePrice' ) : "";
- $invoiceElement = $this->get_args ( 'invoiceElement' ) ? $this->get_args ( 'invoiceElement' ) : "";
- $invoiceTitle = $this->get_args ( 'invoiceTitle' ) ? $this->get_args ( 'invoiceTitle' ) : "";
- $invoiceCompany = $this->get_args ( 'invoiceCompany' ) ? $this->get_args ( 'invoiceCompany' ) : "";
- $TIN = $this->get_args ( 'TIN' ) ? $this->get_args ( 'TIN' ) : "";
- $address = $this->get_args ( 'address' ) ? $this->get_args ( 'address' ) : "";
- $phone = $this->get_args ( 'phone' ) ? $this->get_args ( 'phone' ) : "";
- $bank = $this->get_args ( 'bank' ) ? $this->get_args ( 'bank' ) : "";
- $bankAccount = $this->get_args ( 'bankAccount' ) ? $this->get_args ( 'bankAccount' ) : "";
- $recipients = $this->get_args ( 'recipients' ) ? $this->get_args ( 'recipients' ) : "";
- $recipientsPhone = $this->get_args ( 'recipientsPhone' ) ? $this->get_args ( 'recipientsPhone' ) : "";
- $recipientsAddress = $this->get_args ( 'recipientsAddress' ) ? $this->get_args ( 'recipientsAddress' ) : "";
-
- $mailItems = $this->get_args ( 'mailItems' ) ? $this->get_args ( 'mailItems' ) : "";
- $remark = $this->get_args ( 'remark' ) ? $this->get_args ( 'remark' ) : "";
-
- $TINT = $this->get_args ( 'TINT' ) ? $this->get_args ( 'TINT' ) : "";
- $addressT = $this->get_args ( 'addressT' ) ? $this->get_args ( 'addressT' ) : "";
- $phoneT = $this->get_args ( 'phoneT' ) ? $this->get_args ( 'phoneT' ) : "";
- $bankT = $this->get_args ( 'bankT' ) ? $this->get_args ( 'bankT' ) : "";
- $bankAccountT = $this->get_args ( 'bankAccountT' ) ? $this->get_args ( 'bankAccountT' ) : "";
-
- $softLock = $this->get_args ( 'softLock' ) ? $this->get_args ( 'softLock' ) : 0;
- $softLockNum = $this->get_args ( 'softLockNum' ) ? $this->get_args ( 'softLockNum' ) : 0;
- $contract = $this->get_args ( 'contract' ) ? $this->get_args ( 'contract' ) : 0;
- $contractNum = $this->get_args ( 'contractNum' ) ? $this->get_args ( 'contractNum' ) : 0;
- $instructions = $this->get_args ( 'instructions' ) ? $this->get_args ( 'instructions' ) : 0;
- $instructionsNum = $this->get_args ( 'instructionsNum' ) ? $this->get_args ( 'instructionsNum' ) : 0;
- $remittance = $this->get_args ( 'remittance' ) ? $this->get_args ( 'remittance' ) : 0;
-
- if (! empty ( $cid ) && ! empty ( $invoicePrice ) && ! empty ( $invoiceElement ) && ! empty ( $iid )) {
-
- Doo::loadModel ( 'invoiceManage' );
- $invoiceManage = new invoiceManage ();
- Doo::loadModel ( 'invoiceOperationLog' );
- $invoiceOperationLog = new invoiceOperationLog ();
-
- $cid = explode ( ':', $cid );
-
- $invoiceManageList = $invoiceManage->getInvoiceByAll ();
- $invoiceManageDetail = $invoiceManage->getInvoiceByMold ( "发票审批" );
-
- $moldManage = array ();
- foreach ( $invoiceManageList as $key => $value ) {
- if ($value ['mold'] == '发票打印')
- $moldManage [$value ['mold']] = $value ['staffList'];
- elseif ($value ['mold'] == '发票邮寄')
- $moldManage [$value ['mold']] = $value ['staffList'];
- elseif ($value ['mold'] == '发票打印')
- $moldManage [$value ['mold']] = $value ['staffList'];
- }
-
- $item = array (
- 'iid' => $iid,
- 'cid' => $cid [0],
- 'categoryName' => $cid [1],
- 'invoiceElement' => $invoiceElement,
- 'invoicePrice' => $invoicePrice,
- 'invoiceType' => $invoiceType,
- 'doPost' => $doPost,
- 'status' => 1,
- 'updateTime' => date ( "Y-m-d H:i:s" ),
- 'remark' => $remark
- );
- if ($invoiceType == 0)
- $item += array (
- 'invoiceTitle' => $invoiceTitle,
-
- 'TIN' => $TINT,
- 'address' => $addressT,
- 'phone' => $phoneT,
- 'bank' => $bankT,
- 'bankAccount' => $bankAccountT
- );
- else {
- $item += array (
- 'invoiceCompany' => $invoiceCompany,
- 'TIN' => $TIN,
- 'address' => $address,
- 'phone' => $phone,
- 'bank' => $bank,
- 'bankAccount' => $bankAccount
- );
- }
- if ($doPost == 1) {
-
- $mailList = array (
- 'invoice' => 1,
- 'mailItems' => $mailItems
- );
- if (! empty ( $softLock ))
- $mailList += array (
- 'softLock' => $softLockNum
- );
- else
- $mailList += array (
- 'softLock' => '0'
- );
- if (! empty ( $contract ))
- $mailList += array (
- 'contract' => $contractNum
- );
- else
- $mailList += array (
- 'contract' => '0'
- );
- if (! empty ( $instructions ))
- $mailList += array (
- 'instructions' => $instructionsNum
- );
- else
- $mailList += array (
- 'instructions' => '0'
- );
- if (! empty ( $remittance ))
- $mailList += array (
- 'remittance' => $remittance
- );
- else
- $mailList += array (
- 'remittance' => ''
- );
-
- $mailString = '发票x1,备注:' . $mailItems;
- if (! empty ( $softLock ))
- $mailString .= ',软件锁x' . $softLockNum;
- if (! empty ( $contract ))
- $mailString .= ',合同x' . $contractNum;
- if (! empty ( $instructions ))
- $mailString .= ',说明书x' . $instructionsNum;
- if (! empty ( $remittance ))
- $mailString .= ',汇款账号单';
-
- $item += array (
- 'recipients' => $recipients,
- 'recipientsPhone' => $recipientsPhone,
- 'recipientsAddress' => $recipientsAddress,
- 'mailItems' => $mailString,
- 'mailItemsJson' => json_encode ( $mailList )
- );
- }
- $invoice->setInvoiceByCondition ( $item );
-
- $item = array (
- 'date' => date ( "Y-m-d H:i:s" ),
- 'operation' => "重新提交审批",
- 'status' => 1,
- 'img' => $this->staff [0] ['avatar'],
- 'username' => $this->staff [0] ['username'],
- 'uid' => $this->staff [0] ['sid'],
- 'category' => $this->staff [0] ['category'],
- 'iid' => $iid
- );
- $invoiceOperationLog->setInvoiceOperationLog ( $item );
- }
-
- return "/invoice";
- }
-
- /**
- * 终止开票
- */
- function invoiceDroppedDo() {
- $droppedIidKey = $this->get_args ( 'droppedIidKey' ) ? $this->get_args ( 'droppedIidKey' ) : '';
- Doo::loadModel ( 'invoice' );
- $invoice = new invoice ();
- Doo::loadModel ( 'invoiceOperationLog' );
- $invoiceOperationLog = new invoiceOperationLog ();
-
- $iid = $invoice->authcode ( $droppedIidKey );
- if (! empty ( $iid ) && ! is_numeric ( $iid ))
- die ( 'illegal request' );
-
- $item = array (
- 'iid' => $iid,
- 'status' => 4,
- 'updateTime' => date ( "Y-m-d H:i:s" )
- );
- $invoice->setInvoiceByCondition ( $item );
- $item = array (
- 'date' => date ( "Y-m-d H:i:s" ),
- 'operation' => '终止了开票',
- 'status' => 4,
- 'img' => $this->staff [0] ['avatar'],
- 'username' => $this->staff [0] ['username'],
- 'uid' => $this->staff [0] ['sid'],
- 'category' => $this->staff [0] ['category'],
- 'iid' => $iid
- );
- $invoiceOperationLog->setInvoiceOperationLog ( $item );
- return "/invoice";
- }
-
- /**
- * 更新退票的邮寄信息
- */
- function invoiceUntreadMailDo() {
- $untreadIidKey = $this->get_args ( 'untreadIidKey' ) ? $this->get_args ( 'untreadIidKey' ) : '';
- $untreadCompany = $this->get_args ( 'untreadCompany' ) ? $this->get_args ( 'untreadCompany' ) : "";
- $untreadNumber = $this->get_args ( 'untreadNumber' ) ? $this->get_args ( 'untreadNumber' ) : "";
- $untreadItems = $this->get_args ( 'untreadItems' ) ? $this->get_args ( 'untreadItems' ) : "";
- Doo::loadModel ( 'invoice' );
- $invoice = new invoice ();
-
- $iid = $invoice->authcode ( $untreadIidKey );
- if (! empty ( $iid ) && ! is_numeric ( $iid ))
- die ( 'illegal request' );
-
- $item = array (
- 'iid' => $iid,
- 'untreadCompany' => $untreadCompany,
- 'untreadNumber' => $untreadNumber,
- 'untreadItems' => $untreadItems
- );
-
- $invoice->setInvoiceByCondition ( $item );
-
- return "/invoice";
- }
- /**
- * 申请退票 --
- */
- function invoiceUntreadDo() {
- $untreadIidKey = $this->get_args ( 'untreadIidKey' ) ? $this->get_args ( 'untreadIidKey' ) : '';
- $untreadReason = $this->get_args ( 'untreadReason' ) ? $this->get_args ( 'untreadReason' ) : "";
- $untreadPost = $this->get_args ( 'untreadPost' ) ? $this->get_args ( 'untreadPost' ) : "";
-
- Doo::loadModel ( 'invoice' );
- $invoice = new invoice ();
- Doo::loadModel ( 'invoiceOperationLog' );
- $invoiceOperationLog = new invoiceOperationLog ();
- Doo::loadModel ( 'invoiceReceivables' );
- $invoiceReceivables = new invoiceReceivables ();
-
- $iid = $invoice->authcode ( $untreadIidKey );
- if (! empty ( $iid ) && ! is_numeric ( $iid ))
- die ( 'illegal request' );
-
- /*
- * 需求变革 有绑定收款也可以退票 $lt = $invoiceReceivables->getInvoiceReceivablesByIid ( $untreadIidKey ); if (! empty ( $lt )) { header ( 'Content-Type:text/html;charset=utf-8' ); die ( '该发票有收款绑定,请先移除!' ); }
- */
-
- $item = array (
- 'iid' => $iid,
- 'untreadStatus' => 1,
- 'untreadReason' => $untreadReason,
- 'untreadPost' => $untreadPost,
- 'updateTime' => date ( "Y-m-d H:i:s" )
- );
-
- $invoice->setInvoiceByCondition ( $item );
- $item = array (
- 'date' => date ( "Y-m-d H:i:s" ),
- 'operation' => '申请退票',
- 'status' => 7,
- 'img' => $this->staff [0] ['avatar'],
- 'username' => $this->staff [0] ['username'],
- 'uid' => $this->staff [0] ['sid'],
- 'category' => $this->staff [0] ['category'],
- 'iid' => $iid
- );
- $invoiceOperationLog->setInvoiceOperationLog ( $item );
-
- return "/invoice";
- }
-
- /**
- * 删除已终止的开票
- */
- function invoiceDelDo() {
- Doo::loadClass ( 'XDeode' );
- $XDeode = new XDeode ( 5 );
- Doo::loadModel ( 'invoice' );
- $invoice = new invoice ();
- Doo::loadModel ( 'invoiceOperationLog' );
- $invoiceOperationLog = new invoiceOperationLog ();
- Doo::loadClass ( 'XDeode' );
- $XDeode = new XDeode ( 5 );
- $sid = $XDeode->decode ( $_COOKIE ["staff"] );
- $iid = isset ( $this->params ['iid'] ) ? $this->params ['iid'] : "";
- $iid = $XDeode->decode ( $iid );
-
- if (! is_numeric ( $iid ))
- die ( 'illegal request' );
- $invoiceDetail = $invoice->getMyInvoice ( $sid, $iid );
- if (empty ( $invoiceDetail ))
- die ( 'illegal request' );
- $item = array (
- 'iid' => $iid,
- 'isDelete' => 1,
- 'updateTime' => date ( "Y-m-d H:i:s" )
- );
- $invoice->setInvoiceByCondition ( $item );
- $item = array (
- 'date' => date ( "Y-m-d H:i:s" ),
- 'operation' => '删除了已终止的发票',
- 'status' => 4,
- 'img' => $this->staff [0] ['avatar'],
- 'username' => $this->staff [0] ['username'],
- 'uid' => $this->staff [0] ['sid'],
- 'category' => $this->staff [0] ['category'],
- 'iid' => $iid
- );
- $invoiceOperationLog->setInvoiceOperationLog ( $item );
- return "/invoice";
- }
- function invoiceApproval() {
- Doo::loadModel ( 'invoice' );
- $invoice = new invoice ();
- Doo::loadClass ( 'XDeode' );
- $XDeode = new XDeode ( 5 );
- Doo::loadModel ( 'staff' );
- $staff = new staff ();
-
- $invoiceList = $invoice->find ( array (
- 'where' => 'status=1 and pendingApprovals=' . $this->staff [0] ['sid'],
- 'desc' => 'iid',
- 'asArray' => true
- ) );
- foreach ( $invoiceList as $key => $value ) {
- $invoiceList [$key] ['iidKey'] = $XDeode->encode ( $value ['iid'] );
-
- $lastApprover = json_decode ( $value ['processApprovals'], true );
- if (! empty ( $lastApprover )) {
- $lastApproverKey = array_keys ( $lastApprover );
- $lastApprover = end ( $lastApprover );
-
- $staffDetail = $staff->getOne ( array (
- 'where' => 'sid=' . end ( $lastApproverKey ),
- 'asArray' => true
- ) );
- $lastApprover ['username'] = $staffDetail ['username'];
- }
- $invoiceList [$key] ['lastApprover'] = $lastApprover;
- }
-
- $ilist = $invoice->getInvoiceByProcessStatus ();
-
- // print_r($ilist);
-
- $this->data ['invoiceList'] = $invoiceList;
- $this->data ['ilist'] = $ilist;
- $this->data ['memu'] = "invoice";
- $this->data ['staff'] = $this->staff;
- $this->data ['receiptMemu'] = 'invoiceApproval';
- $this->render ( "/admin/invoiceApproval", $this->data );
- }
- function invoiceDetail() {
- Doo::loadClass ( 'XDeode' );
- $XDeode = new XDeode ( 5 );
-
- $iid = isset ( $this->params ['iid'] ) ? $this->params ['iid'] : "";
- $iid = $XDeode->decode ( $iid );
- if (! is_numeric ( $iid ))
- die ( 'illegal request' );
-
- Doo::loadModel ( 'invoice' );
- $invoice = new invoice ();
- Doo::loadModel ( 'invoiceOperationLog' );
- $invoiceOperationLog = new invoiceOperationLog ();
-
- $invoiceDetail = $invoice->getOne ( array (
- 'where' => 'status=1 and pendingApprovals=' . $this->staff [0] ['sid'] . ' and iid=' . $iid,
- 'asArray' => true
- ) );
- if (empty ( $invoiceDetail ))
- die ( 'illegal request' );
-
- $invoiceOperationLogList = $invoiceOperationLog->getInvoiceOperationLogByIid ( $iid );
-
- $this->data ['invoiceDetail'] = $invoiceDetail;
- $this->data ['invoiceOperationLogList'] = $invoiceOperationLogList;
- $this->data ['INVOICEKEY'] = $invoice->authcode ( $invoiceDetail ['iid'], '' );
- $this->data ['memu'] = "invoice";
- $this->data ['staff'] = $this->staff;
- $this->data ['receiptMemu'] = 'invoiceApproval';
- $this->render ( "/admin/invoiceApprovalDetail", $this->data );
- }
-
- /**
- * 对发票进行审批,其中操作有终止,退回,同意动作。操作成功并记录下操作日志
- *
- * @since 1.0.0
- * @var integer iid 开票ID 已加密
- * @var integer status 发票审批状态
- * @var integer opintion 审批发票的意见
- * @return string 如操作成功返回审批首页
- */
- function invoiceApprovalDo() {
- Doo::loadModel ( 'invoice' );
- $invoice = new invoice ();
-
- $iid = $this->get_args ( 'invoiceKey' ) ? $this->get_args ( 'invoiceKey' ) : "";
- $status = $this->get_args ( 'status' ) && is_numeric ( $this->get_args ( 'status' ) ) ? $this->get_args ( 'status' ) : 0;
- $opinion = $this->get_args ( 'opinion' ) ? $this->get_args ( 'opinion' ) : "";
- $iid = $invoice->authcode ( $iid );
- if (! is_numeric ( $iid ))
- die ( 'illegal request' );
-
- if (! empty ( $iid ) && ! empty ( $status ) && ! empty ( $opinion )) {
- if (! ($status == 2 || $status == 3 || $status == 4))
- die ( 'illegal request' );
-
- Doo::loadModel ( 'invoiceOperationLog' );
- $invoiceOperationLog = new invoiceOperationLog ();
-
- $invoiceDetail = $invoice->getOne ( array (
- 'where' => 'status=1 and iid=' . $iid . ' and pendingApprovals=' . $this->staff [0] ['sid'],
- 'asArray' => true
- ) );
- if (empty ( $invoiceDetail ))
- die ( 'illegal request' );
-
- $processApprovals = json_decode ( $invoiceDetail ['processApprovals'], true );
- $invoiceManage = json_decode ( $invoiceDetail ['invoiceManage'], true );
-
- if ($status == 3) {
- $invoice->status = $status;
- $item = array (
- 'operation' => $opinion
- );
- } else {
- if (empty ( $processApprovals )) {
- $processApprovals = array (
- $this->staff [0] ['sid'] => array (
- 'date' => date ( "Y-m-d H:i:s" ),
- 'opinion' => $opinion,
- 'status' => $status
- )
- );
- if ($status != 4 && isset ( $invoiceManage [1] ))
- $invoice->pendingApprovals = $invoiceManage [1] [0];
- $invoice->processApprovals = json_encode ( $processApprovals );
- } else {
- $processApprovals [$this->staff [0] ['sid']] = array (
- 'date' => date ( "Y-m-d H:i:s" ),
- 'opinion' => $opinion,
- 'status' => $status
- );
-
- $pendingApprovals = 0;
- foreach ( $invoiceManage as $key => $value ) {
- if ($value [0] == $this->staff [0] ['sid']) {
- if (isset ( $invoiceManage [$key + 1] ))
- $pendingApprovals = $invoiceManage [$key + 1] [0];
- break;
- }
- }
-
- if ($status != 4 && ! empty ( $pendingApprovals ))
- $invoice->pendingApprovals = $pendingApprovals;
- $invoice->processApprovals = json_encode ( $processApprovals );
- }
-
- $item = array (
- 'operation' => $opinion
- );
- if (count ( $processApprovals ) == count ( $invoiceManage ) && $status != 4) {
- $invoice->status = $status;
- $invoice->pendingApprovals = 0;
- } elseif ($status == 4) {
- $invoice->status = $status;
- $item = array (
- 'operation' => $opinion
- );
- }
- }
- $invoice->updateTime = date ( "Y-m-d H:i:s" );
- $invoice->update ( array (
- 'where' => 'iid=' . $iid
- ) );
-
- $item += array (
- 'date' => date ( "Y-m-d H:i:s" ),
- 'img' => $this->staff [0] ['avatar'],
- 'username' => $this->staff [0] ['username'],
- 'uid' => $this->staff [0] ['sid'],
- 'category' => $this->staff [0] ['category'],
- 'status' => $status,
- 'iid' => $iid
- );
- $invoiceOperationLog->setInvoiceOperationLog ( $item );
-
- return '/invoiceApproval';
- }
- die ( 'illegal request' );
- }
-
- /**
- * 展示需要打印的发票数据
- *
- * @since 1.0.0
- */
- function invoicePrint() {
- Doo::loadModel ( 'invoice' );
- $invoice = new invoice ();
- Doo::loadClass ( 'XDeode' );
- $XDeode = new XDeode ( 5 );
- Doo::loadModel ( 'staff' );
- $staff = new staff ();
-
- $toPrint = $invoice->getPrintInvoiceByManage ( $this->staff [0] ['sid'], 0 );
- $printed = $invoice->getPrintInvoiceByManage ( $this->staff [0] ['sid'], 1 );
-
- foreach ( $toPrint as $key => $value ) {
- $toPrint [$key] ['iidKey'] = $XDeode->encode ( $value ['iid'] );
-
- $lastApprover = json_decode ( $value ['processApprovals'], true );
- if (! empty ( $lastApprover )) {
- $lastApproverKey = array_keys ( $lastApprover );
- $lastApprover = end ( $lastApprover );
-
- $staffDetail = $staff->getOne ( array (
- 'where' => 'sid=' . end ( $lastApproverKey ),
- 'asArray' => true
- ) );
- $lastApprover ['username'] = $staffDetail ['username'];
- }
- $toPrint [$key] ['lastApprover'] = $lastApprover;
- }
-
- foreach ( $printed as $key => $value ) {
- $printed [$key] ['iidKey'] = $XDeode->encode ( $value ['iid'] );
-
- $lastApprover = json_decode ( $value ['processApprovals'], true );
- if (! empty ( $lastApprover )) {
- $lastApproverKey = array_keys ( $lastApprover );
- $lastApprover = end ( $lastApprover );
-
- $staffDetail = $staff->getOne ( array (
- 'where' => 'sid=' . end ( $lastApproverKey ),
- 'asArray' => true
- ) );
- $lastApprover ['username'] = $staffDetail ['username'];
- }
- $printed [$key] ['lastApprover'] = $lastApprover;
- }
-
- $this->data ['printed'] = $printed;
- $this->data ['toPrint'] = $toPrint;
-
- $this->data ['memu'] = "invoice";
- $this->data ['staff'] = $this->staff;
- $this->data ['receiptMemu'] = 'invoicePrint';
- $this->render ( "/admin/invoicePrint", $this->data );
- }
- /**
- * 展示发票打印的详情页面
- *
- * @since 1.0.0
- */
- function invoicePrintDetail() {
- Doo::loadClass ( 'XDeode' );
- $XDeode = new XDeode ( 5 );
-
- $iid = isset ( $this->params ['iid'] ) ? $this->params ['iid'] : "";
- $iid = $XDeode->decode ( $iid );
- if (! is_numeric ( $iid ))
- die ( 'illegal request' );
-
- Doo::loadModel ( 'invoice' );
- $invoice = new invoice ();
- Doo::loadModel ( 'invoiceOperationLog' );
- $invoiceOperationLog = new invoiceOperationLog ();
-
- $invoiceDetail = $invoice->getPrintInvoiceByManage ( $this->staff [0] ['sid'], 0, $iid );
- if (empty ( $invoiceDetail ))
- die ( 'illegal request' );
-
- $invoiceOperationLogList = $invoiceOperationLog->getInvoiceOperationLogByIid ( $iid );
-
- $this->data ['invoiceDetail'] = $invoiceDetail;
- $this->data ['invoiceOperationLogList'] = $invoiceOperationLogList;
- $this->data ['INVOICEKEY'] = $invoice->authcode ( $invoiceDetail ['iid'], '' );
- $this->data ['memu'] = "invoice";
- $this->data ['staff'] = $this->staff;
- $this->data ['receiptMemu'] = 'invoicePrint';
- $this->render ( "/admin/invoicePrintDetail", $this->data );
- }
- /**
- * 填写票号并完成打印
- * @since 1.0.0
- */
- function invoicePrintDo() {
- Doo::loadModel ( 'invoice' );
- $invoice = new invoice ();
- $iid = $this->get_args ( 'invoiceKey' ) ? $this->get_args ( 'invoiceKey' ) : "";
- $invoiceNo = $this->get_args ( 'invoiceNo' ) ? $this->get_args ( 'invoiceNo' ) : "";
-
- $iid = $invoice->authcode ( $iid );
- if (! is_numeric ( $iid ))
- die ( 'illegal request' );
- if (! empty ( $iid ) && ! empty ( $invoiceNo )) {
-
- Doo::loadModel ( 'invoiceOperationLog' );
- $invoiceOperationLog = new invoiceOperationLog ();
-
- // $info=$invoice->getOne(array('where'=>"invoiceNo = '".$invoiceNo."'",'asArray' => TRUE));
-
- $invoicePrintDetail = $invoice->getInvoiceByPrint ( $iid );
- if (empty ( $invoicePrintDetail ))
- die ( 'illegal request' );
- $item = array (
- 'iid' => $iid,
- 'printStatus' => 1,
- 'updateTime' => date ( "Y-m-d H:i:s" ),
- 'printer' => $this->staff [0] ['username'],
- 'printTime' => date ( "Y-m-d H:i:s" ),
- 'invoiceNo' => $invoiceNo
- );
- $invoice->setInvoiceByCondition ( $item );
- $item = array (
- 'date' => date ( "Y-m-d H:i:s" ),
- 'operation' => $invoiceNo,
- 'status' => 5,
- 'img' => $this->staff [0] ['avatar'],
- 'username' => $this->staff [0] ['username'],
- 'uid' => $this->staff [0] ['sid'],
- 'category' => $this->staff [0] ['category'],
- 'iid' => $iid
- );
- $invoiceOperationLog->setInvoiceOperationLog ( $item );
-
- return "/invoicePrint";
- }
- }
- /**
- * 需要邮寄的发票
- * @since 1.0.0
- */
- function invoicePost() {
- Doo::loadModel ( 'invoice' );
- $invoice = new invoice ();
- Doo::loadModel ( 'express' );
- $express = new express ();
-
- $invoicePost = $invoice->getPostByInvoice ();
- $invoicePosted = $invoice->getPostByInvoice ( 1 );
- $expressList = $express->getExpressByAll ();
-
- $this->data ['expressList'] = $expressList;
- $this->data ['invoicePost'] = $invoicePost;
- $this->data ['invoicePosted'] = $invoicePosted;
- $this->data ['memu'] = "invoice";
- $this->data ['staff'] = $this->staff;
- $this->data ['receiptMemu'] = 'invoicePost';
- $this->render ( "/admin/invoicePost", $this->data );
- }
- /**
- * 添加发票邮寄信息
- */
- function invoiceExpressAddDo() {
- Doo::loadModel ( 'invoice' );
- $invoice = new invoice ();
-
- $iid = $this->get_args ( 'iidKey' ) ? $this->get_args ( 'iidKey' ) : "";
- $expressCompany = $this->get_args ( 'express' ) ? $this->get_args ( 'express' ) : "";
- $expressNumber = $this->get_args ( 'nu' ) ? $this->get_args ( 'nu' ) : "";
- $actualItems = $this->get_args ( 'actualItems' ) ? $this->get_args ( 'actualItems' ) : "";
- $iid = $iid = $invoice->authcode ( $iid );
- if (! is_numeric ( $iid ) && empty ( $expressCompany ) && empty ( $expressNumber ) && empty ( $actualItems ))
- die ( 'illegal request' );
-
- $item = array (
- 'iid' => $iid,
- 'postStatus' => 1,
- 'updateTime' => date ( "Y-m-d H:i:s" ),
- 'postTime' => date ( "Y-m-d H:i:s" ),
- 'expressCompany' => $expressCompany,
- 'expressNumber' => $expressNumber,
- 'actualItems' => $actualItems,
- 'poster' => $this->staff [0] ['username']
- );
- $invoice->setInvoiceByCondition ( $item );
-
- // $this->setWXMsg ( $iid );
-
- return '/invoicePost';
- }
- function invoiceExpressUpdateDo() {
- Doo::loadModel ( 'invoice' );
- $invoice = new invoice ();
-
- $action = $this->get_args ( 'action' ) ? $this->get_args ( 'action' ) : "";
-
- $iid = $this->get_args ( 'iidKey' ) ? $this->get_args ( 'iidKey' ) : "";
- $expressCompany = $this->get_args ( 'express' ) ? $this->get_args ( 'express' ) : "";
- $expressNumber = $this->get_args ( 'nu' ) ? $this->get_args ( 'nu' ) : "";
- $actualItems = $this->get_args ( 'actualItems' ) ? $this->get_args ( 'actualItems' ) : "";
- $iid = $invoice->authcode ( $iid );
- if (! is_numeric ( $iid ) && empty ( $expressCompany ) && empty ( $expressNumber ) && empty ( $actualItems ))
- die ( 'illegal request' );
-
- $item = array (
- 'iid' => $iid,
- 'updateTime' => date ( "Y-m-d H:i:s" ),
-
- 'expressCompany' => $expressCompany,
- 'expressNumber' => $expressNumber,
- 'actualItems' => $actualItems,
- 'poster' => $this->staff [0] ['username']
- );
-
- $invoice->setInvoiceByCondition ( $item );
- return $action;
- }
-
- /**
- * 可退票管理
- */
- function invoiceUntreadIsAchieve() {
- Doo::loadModel ( 'invoice' );
- $invoice = new invoice ();
- Doo::loadClass ( 'XDeode' );
- $XDeode = new XDeode ( 5 );
-
- $MebSea = $this->get_args ( 'MebSea' ) ? $this->get_args ( 'MebSea' ) : "";
-
- $page_size = 18;
- $page = isset ( $this->params ['page'] ) && is_numeric ( $this->params ['page'] ) ? $this->params ['page'] : 1;
- $date = $this->get_args ( 'date' ) ? $this->get_args ( 'date' ) : "";
-
- $get = "?date=" . urlencode ( $date ) . "&MebSea=" . urlencode ( $MebSea );
-
- $dateArr = explode ( ':', $date );
- $D1 = '';
- $D2 = '';
- if (! empty ( $date )) {
- $D1 = $dateArr [0];
- $D2 = $dateArr [1];
- }
- $con = '';
- if (! empty ( $D1 ) && ! empty ( $D2 ))
- $con = ' and bindTime BETWEEN "' . $D1 . '" AND "' . $D2 . '" ';
- // if ($date == 'MONTHO')
- // $con = ' and updateTime>DATE_SUB(CURDATE(), INTERVAL 1 MONTH)';
- // elseif ($date == 'MONTHT')
- // $con = ' and updateTime>DATE_SUB(CURDATE(), INTERVAL 3 MONTH)';
- // elseif ($date == 'MONTHY')
- // $con = ' and updateTime>DATE_SUB(CURDATE(), INTERVAL 1 YEAR)';
- if (! empty ( $MebSea )) {
- $con .= ' and ( invoiceTitle like "%' . $MebSea . '%" or invoiceCompany like "%' . $MebSea . '%" or invoicePrice like "%' . $MebSea . '%" )';
- }
- $pageinfo ['page'] = array (
- 'previous' => ''
- );
-
- $sql = " printStatus=1 and untreadStatus=0 and status=2 and sid=" . $this->staff [0] ['sid'] . $con;
- $action = "invoiceUntreadIsAchieve";
-
- $pageinfo = $this->get_page ( "CLD_invoice", $sql, $page, $page_size, $action, $get, "" );
- $limit = $pageinfo ['lower'] . ',' . $page_size;
- $list = $invoice->getInvoiceByUntreadStatusPage ( $limit, $sql );
-
- // print_r($list);
-
- $this->data ['MebSeaEn'] = $MebSea;
- // $this->data ['MebSea'] = urlencode ( $MebSea );
- $this->data ['get'] = $get;
- $this->data ['page'] = $pageinfo;
-
- $this->data ['date'] = $date;
- $this->data ['list'] = $list;
-
- $this->data ['memu'] = "invoice";
- $this->data ['staff'] = $this->staff;
- $this->data ['receiptMemu'] = 'invoice';
-
- $this->render ( "/admin/invoiceUntreadIsAchieve", $this->data );
- }
-
- /**
- * 退票处理页面
- */
- function invoiceUntread() {
- Doo::loadModel ( 'invoice' );
- $invoice = new invoice ();
-
- $untreadInvoice = $invoice->getInvoiceByUntreadStatus ( 1 );
- $establishedInvoice = $invoice->getInvoiceByUntreadStatus ( 2 );
-
- $this->data ['untreadInvoice'] = $untreadInvoice;
- $this->data ['establishedInvoice'] = $establishedInvoice;
-
- $this->data ['memu'] = "invoice";
- $this->data ['staff'] = $this->staff;
- $this->data ['receiptMemu'] = 'invoiceUntread';
- $this->render ( "/admin/invoiceUntread", $this->data );
- }
-
- /**
- * 确认收到退回的发票,开票状态为退回 //收款状态解绑,公司统计扣除入账额度
- */
- function invoiceUntreadEstablishedDo() {
- $untreadIidKey = $this->get_args ( 'untreadIidKey' ) ? $this->get_args ( 'untreadIidKey' ) : '';
-
- Doo::loadModel ( 'invoice' );
- $invoice = new invoice ();
- Doo::loadModel ( 'invoiceOperationLog' );
- $invoiceOperationLog = new invoiceOperationLog ();
- Doo::loadModel ( 'invoiceReceivables' );
- $invoiceReceivables = new invoiceReceivables ();
- Doo::loadModel ( 'invoiceStatistics' );
- $invoiceStatistics = new invoiceStatistics ();
-
- $iid = $invoice->authcode ( $untreadIidKey );
- if (! empty ( $iid ) && ! is_numeric ( $iid ))
- die ( 'illegal request' );
-
- $invoiceDetails = $invoice->getInvoiceByIid ( $iid );
- if ($invoiceDetails ['untreadStatus'] != 1)
- die ( 'illegal request' );
-
- $item = array (
- 'iid' => $iid,
- // 'irid'=>'',
- 'untreadStatus' => 2,
- 'updateTime' => date ( "Y-m-d H:i:s" )
- );
- $invoice->setInvoiceByCondition ( $item );
-
- $item = array (
- 'date' => date ( "Y-m-d H:i:s" ),
- 'operation' => '已确认退票',
- 'status' => 6,
- 'img' => $this->staff [0] ['avatar'],
- 'username' => $this->staff [0] ['username'],
- 'uid' => $this->staff [0] ['sid'],
- 'category' => $this->staff [0] ['category'],
- 'iid' => $iid
- );
- $invoiceOperationLog->setInvoiceOperationLog ( $item );
-
- // 收款解绑以及入账扣除
- if (! empty ( $invoiceDetails ['irid'] )) {
- $iridList = explode ( ',', $invoiceDetails ['irid'] );
-
- foreach ( $iridList as $value ) {
- $irDetails = $invoiceReceivables->getOne ( array (
- 'where' => " irid=" . $value . ' and bindStatus=1',
- 'asArray' => TRUE
- ) );
- $item = array (
- 'irid' => $value,
- 'bindStatus' => 0,
- 'untreadStatus' => 1,
- 'untreadStaff' => $invoiceDetails ['userName'],
- 'unbundlingTime' => date ( "Y-m-d H:i:s" ),
- 'iid' => 0
- );
- $invoiceReceivables->setInvoiceReceivablesByCondition ( $item );
-
- if (! empty ( $irDetails )) {
- $item = array (
- 'date' => date ( 'Y-m-d', strtotime ( $irDetails ['bindDate'] ) ),
- 'priceClass' => 3,
-
- 'cid' => $invoiceDetails ['cid'],
- 'staff' => $invoiceDetails ['sid'],
- 'accountPrice' => - $irDetails ['receivablesPrice']
- );
- $invoiceStatistics->setInvoiceStatisticsByCondition ( $item );
- }
- }
- }
-
- return "/invoiceUntread";
- }
- function invoiceReceivables() {
- $invoiceTC = $this->get_args ( 'invoiceTC' ) ? $this->get_args ( 'invoiceTC' ) : '';
-
- Doo::loadModel ( 'L_category' );
- $lCategory = new L_category ();
- Doo::loadModel ( 'staff' );
- $staff = new staff ();
- Doo::loadModel ( 'invoiceReceivables' );
- $invoiceReceivables = new invoiceReceivables ();
- Doo::loadModel ( 'invoice' );
- $invoice = new invoice ();
- Doo::loadClass ( 'XDeode' );
- $XDeode = new XDeode ( 5 );
-
- $category = $lCategory->getCategory ();
- $staffList = $staff->getStaffByCid ( $this->staff [0] ['cid'] );
-
- $sql = 'bindStatus=1 and iid!=0';
- $receivablesList = $invoiceReceivables->getInvoiceReceivablesByNew ( 4, $sql );
-
- // 获取未入账发票
- $invoiceUnAccount = $invoice->getInvoiceByUnAccount ( $invoiceTC );
-
- foreach ( $invoiceUnAccount as $key => $value ) {
- $invoiceUnAccount [$key] ['iidKey'] = $XDeode->encode ( $value ['iid'] );
-
- $lastApprover = json_decode ( $value ['processApprovals'], true );
- if (! empty ( $lastApprover )) {
- $lastApproverKey = array_keys ( $lastApprover );
- $lastApprover = end ( $lastApprover );
-
- $staffDetail = $staff->getOne ( array (
- 'where' => 'sid=' . end ( $lastApproverKey ),
- 'asArray' => true
- ) );
- $lastApprover ['username'] = $staffDetail ['username'];
- }
- $invoiceUnAccount [$key] ['lastApprover'] = $lastApprover;
- }
-
- $receivablesInput = $invoiceReceivables->getInvoiceReceivablesByInput ();
-
- // print_r($receivablesList);
-
- $this->data ['receivablesInput'] = $receivablesInput;
- $this->data ['year'] = date ( 'Y' );
- $this->data ['invoiceUnAccount'] = $invoiceUnAccount;
- $this->data ['receivablesList'] = $receivablesList;
- $this->data ['staffList'] = $staffList;
- $this->data ['category'] = $category;
-
- $this->data ['memu'] = "invoice";
- $this->data ['staff'] = $this->staff;
- $this->data ['receiptMemu'] = 'invoiceReceivables';
- $this->render ( "/admin/invoiceReceivables", $this->data );
- }
-
- /**
- * 新添加收款直接入账发票
- */
- function invoiceCompareClaimPrice() {
- // 收款录入
- $iidKey = $this->get_args ( 'iidKey' ) ? $this->get_args ( 'iidKey' ) : "";
-
- $receivablesPrice = $this->get_args ( 'receivablesPrice' ) ? $this->get_args ( 'receivablesPrice' ) : "";
- $receivablesMessage = $this->get_args ( 'receivablesMessage' ) ? $this->get_args ( 'receivablesMessage' ) : "";
- $receivablesBank = $this->get_args ( 'receivablesBank' ) ? $this->get_args ( 'receivablesBank' ) : "";
- $receivablesDate = $this->get_args ( 'receivablesDate' ) ? $this->get_args ( 'receivablesDate' ) : "";
-
- if (! empty ( $receivablesPrice ) && ! empty ( $receivablesMessage ) && ! empty ( $receivablesBank ) && ! empty ( $receivablesDate ) && ! empty ( $iidKey )) {
- Doo::loadModel ( 'invoiceReceivables' );
- $invoiceReceivables = new invoiceReceivables ();
- Doo::loadModel ( 'invoiceROLog' );
- $invoiceROLog = new invoiceROLog ();
- Doo::loadModel ( 'invoiceStatistics' );
- $invoiceStatistics = new invoiceStatistics ();
- Doo::loadModel ( 'invoice' );
- $invoice = new invoice ();
- Doo::loadClass ( 'XDeode' );
- $XDeode = new XDeode ( 5 );
- Doo::loadModel ( 'invoiceOperationLog' );
- $invoiceOperationLog = new invoiceOperationLog ();
-
- $iidKey = $XDeode->decode ( $iidKey );
-
- $invoiceDetail = $invoice->getInvoiceByIid ( $iidKey );
- $receivablesSerial = "#SK" . date ( "Ymd" ) . mt_rand ( 1000, 9999 );
-
- // 收款录入 并绑定发票
- Doo::db ()->beginTransaction ();
- $item = array (
- 'bindStatus' => 1,
- 'iid' => $invoiceDetail ['iid'],
- 'bindDate' => date ( "Y-m-d H:i:s" ),
- 'receivablesPrice' => $receivablesPrice,
- 'receivablesMessage' => $receivablesMessage,
- 'receivablesSerial' => $receivablesSerial,
- 'receivablesBank' => $receivablesBank,
- 'receivablesDate' => $receivablesDate,
- 'inputStaff' => $this->staff [0] ['username'],
- 'accountClerk' => $this->staff [0] ['username'],
- 'date' => date ( "Y-m-d" ),
- 'receivablesCategory' => $invoiceDetail ['cid'] . ':' . $invoiceDetail ['categoryName'],
- 'receivablesStaff' => $invoiceDetail ['sid'] . '-' . $invoiceDetail ['userName'],
- 'confirmTime' => date ( "Y-m-d H:i:s" )
- );
-
- $irid = $invoiceReceivables->addInvoiceReceivables ( $item );
-
- $item = array ();
- // 收款操作日志
- $item = array (
- 'operation' => $this->staff [0] ['username'] . " 转入 " . $invoiceDetail ['userName']
- );
- $item += array (
- 'date' => date ( "Y-m-d" ),
- 'status' => 1,
- 'img' => $this->staff [0] ['avatar'],
- 'username' => $this->staff [0] ['username'],
- 'uid' => $this->staff [0] ['sid'],
- 'category' => $this->staff [0] ['category'],
- 'irid' => $irid
- );
- $invoiceROLog->setInvoiceROLog ( $item );
- // 收款统计
- $item = array (
- 'date' => date ( "Y-m-d H:i:s" ),
- 'priceClass' => 2,
- 'irid' => $irid,
- 'cid' => $invoiceDetail ['cid'],
- 'staff' => $invoiceDetail ['sid'],
- 'receivablesPrice' => $receivablesPrice
- );
- $invoiceStatistics->setInvoiceStatisticsByCondition ( $item );
-
- // 收款 入 发票
- $detail = $invoiceDetail;
-
- $iridString = "";
- if (empty ( $detail ['irid'] ))
- $iridString = $irid;
- else
- $iridString = $detail ['irid'] . ',' . $irid;
-
- $item = array (
- 'irid' => $iridString,
- 'bindTime' => date ( "Y-m-d H:i:s" ),
- 'updateTime' => date ( "Y-m-d H:i:s" ),
- 'iid' => $detail ['iid']
- );
- $invoice->setInvoiceByCondition ( $item );
-
- // 操作日志
- $item = array (
- 'date' => date ( "Y-m-d H:i:s" ),
- 'operation' => "收款入账" . $receivablesSerial . "到发票" . $detail ['invoiceSerial'],
- 'status' => 8,
- 'img' => $this->staff [0] ['avatar'],
- 'username' => $this->staff [0] ['username'],
- 'uid' => $this->staff [0] ['sid'],
- 'category' => $this->staff [0] ['category'],
- 'iid' => $detail ['iid']
- );
- $invoiceOperationLog->setInvoiceOperationLog ( $item );
-
- $list = $invoiceReceivables->getInvoiceReceivablesInIridString ( $iridString );
- $accountPrice = 0;
- foreach ( $list as $key => $value ) {
- $accountPrice += $value ['receivablesPrice'];
- }
- $item = array (
- 'date' => date ( "Y-m-d H:i:s" ),
- 'priceClass' => 3,
-
- 'cid' => $invoiceDetail ['cid'],
- 'staff' => $invoiceDetail ['sid'],
- 'accountPrice' => $accountPrice
- );
- $invoiceStatistics->setInvoiceStatisticsByCondition ( $item );
-
- Doo::db ()->commit ();
- }
-
- return '/invoiceReceivables';
- }
-
- /**
- * 检索未入账发票数据 function sir() { }
- */
-
- /**
- * 录入收款数据
- * @return string
- */
- function invoiceReceivablesDo() {
- $receivablesPrice = $this->get_args ( 'receivablesPrice' ) ? $this->get_args ( 'receivablesPrice' ) : "";
- $receivablesMessage = $this->get_args ( 'receivablesMessage' ) ? $this->get_args ( 'receivablesMessage' ) : "";
- $receivablesBank = $this->get_args ( 'receivablesBank' ) ? $this->get_args ( 'receivablesBank' ) : "";
- $receivablesDate = $this->get_args ( 'receivablesDate' ) ? $this->get_args ( 'receivablesDate' ) : "";
- $receivablesCategory = $this->get_args ( 'receivablesCategory' ) ? $this->get_args ( 'receivablesCategory' ) : "";
- $receivablesStaff = $receivablesStaff2 = $this->get_args ( 'receivablesStaff' ) ? $this->get_args ( 'receivablesStaff' ) : "";
-
- Doo::loadModel ( 'invoiceReceivables' );
- $invoiceReceivables = new invoiceReceivables ();
- Doo::loadModel ( 'invoiceROLog' );
- $invoiceROLog = new invoiceROLog ();
- Doo::loadModel ( 'invoiceStatistics' );
- $invoiceStatistics = new invoiceStatistics ();
-
- if (! empty ( $receivablesPrice ) && ! empty ( $receivablesMessage ) && ! empty ( $receivablesBank ) && ! empty ( $receivablesDate ) && ! empty ( $receivablesCategory ) && ! empty ( $receivablesStaff )) {
-
- $item = array (
- 'receivablesPrice' => $receivablesPrice,
- 'receivablesMessage' => $receivablesMessage,
- 'receivablesSerial' => "#SK" . date ( "Ymd" ) . mt_rand ( 1000, 9999 ),
- 'receivablesBank' => $receivablesBank,
- 'receivablesDate' => $receivablesDate,
- 'inputStaff' => $this->staff [0] ['username'],
- 'date' => date ( "Y-m-d" ),
- 'receivablesCategory' => $receivablesCategory,
- 'receivablesStaff' => $receivablesStaff
- );
- if ($receivablesCategory != 'PUBLIC' && $receivablesStaff != 'PUBLIC') {
- $item += array (
- 'confirmTime' => date ( "Y-m-d H:i:s" ),
- 'inputType' => 1
- );
- }
-
- $irid = $invoiceReceivables->addInvoiceReceivables ( $item );
-
- $item = array ();
- // 收款操作日志
- if ($receivablesCategory == 'PUBLIC' && $receivablesStaff == 'PUBLIC')
- $item = array (
- 'operation' => $this->staff [0] ['username'] . " 转入 公共待认领款项 "
- );
- elseif ($receivablesCategory != 'PUBLIC' && $receivablesStaff == 'PUBLIC')
- $item = array (
- 'operation' => $this->staff [0] ['username'] . "转入 办事处待认领款项"
- );
- elseif ($receivablesCategory != 'PUBLIC' && $receivablesStaff != 'PUBLIC') {
- $receivablesStaff = explode ( '-', $receivablesStaff );
- $item = array (
- 'operation' => $this->staff [0] ['username'] . " 转入 " . $receivablesStaff [1]
- );
- }
- $item += array (
- 'date' => date ( "Y-m-d" ),
- 'status' => 1,
- 'img' => $this->staff [0] ['avatar'],
- 'username' => $this->staff [0] ['username'],
- 'uid' => $this->staff [0] ['sid'],
- 'category' => $this->staff [0] ['category'],
- 'irid' => $irid
- );
- $invoiceROLog->setInvoiceROLog ( $item );
-
- $item = array (
- 'date' => date ( "Y-m-d H:i:s" ),
- 'priceClass' => 2,
- 'irid' => $irid,
- 'receivablesPrice' => $receivablesPrice
- );
- if ($receivablesCategory != 'PUBLIC') {
- $receivablesCategory = explode ( ":", $receivablesCategory );
- $item += array (
- 'cid' => $receivablesCategory [0]
- );
- }
-
- if ($receivablesStaff2 != 'PUBLIC') {
- $receivablesStaff = explode ( "-", $receivablesStaff2 );
- $item += array (
- 'staff' => $receivablesStaff [0]
- );
- }
- $invoiceStatistics->setInvoiceStatisticsByCondition ( $item );
- }
-
- return "/invoiceReceivables";
- }
- /**
- * 收款认领页面-包括公共认领 办事处认领 最近已认领数据
- */
- function invoiceReceivablesClaim() {
- Doo::loadModel ( 'invoiceReceivables' );
- $invoiceReceivables = new invoiceReceivables ();
-
- $receivablesList = $invoiceReceivables->getInvoiceReceivablesByClaim ( $this->staff [0] ['cid'], $this->staff [0] ['sid'] );
-
- $this->data ['receivablesList'] = $receivablesList;
-
- $this->data ['memu'] = "invoice";
- $this->data ['staff'] = $this->staff;
- $this->data ['receiptMemu'] = 'invoiceReceivablesClaim';
- $this->render ( "/admin/invoiceReceivablesClaim", $this->data );
- }
-
- /**
- * 更新收款相关数据
- */
- function invoiceReceivablesUpdateClaim() {
- $receivablesPrice = $this->get_args ( 'receivablesPrice' ) ? $this->get_args ( 'receivablesPrice' ) : "";
- $receivablesMessage = $this->get_args ( 'receivablesMessage' ) ? $this->get_args ( 'receivablesMessage' ) : "";
- $receivablesBank = $this->get_args ( 'receivablesBank' ) ? $this->get_args ( 'receivablesBank' ) : "";
- $receivablesDate = $this->get_args ( 'receivablesDate' ) ? $this->get_args ( 'receivablesDate' ) : "";
- $receivablesCategory = $this->get_args ( 'receivablesCategory' ) ? $this->get_args ( 'receivablesCategory' ) : "";
- $receivablesStaff = $receivablesStaff2 = $this->get_args ( 'receivablesStaff' ) ? $this->get_args ( 'receivablesStaff' ) : "";
-
- $claimKey = $this->get_args ( 'claimKey' ) ? $this->get_args ( 'claimKey' ) : "";
-
- if (empty ( $claimKey ))
- die ( 'illegal request' );
-
- Doo::loadModel ( 'invoiceReceivables' );
- $invoiceReceivables = new invoiceReceivables ();
- Doo::loadModel ( 'invoiceROLog' );
- $invoiceROLog = new invoiceROLog ();
- $con = ' and iid=0 and bindStatus=0'; // and receivablesCategory!="PUBLIC" and receivablesStaff!="PUBLIC"
- $detail = $invoiceReceivables->getInvoiceReceivablesByIrid ( $claimKey, $con );
- if (empty ( $detail ))
- die ( 'illegal request' );
-
- $invoiceReceivables = new invoiceReceivables ();
-
- $item = array (
- 'irid' => $detail ['irid']
- );
- if ($receivablesCategory != 'PUBLIC' && $receivablesStaff != 'PUBLIC') {
- $item += array (
- 'confirmTime' => date ( "Y-m-d H:i:s" )
- );
- }
- if (! empty ( $receivablesCategory ))
- $item += array (
- 'receivablesCategory' => $receivablesCategory
- );
- if (! empty ( $receivablesStaff ))
- $item += array (
- 'receivablesStaff' => $receivablesStaff
- );
- if (! empty ( $receivablesPrice ))
- $item += array (
- 'receivablesPrice' => $receivablesPrice
- );
- if (! empty ( $receivablesMessage ))
- $item += array (
- 'receivablesMessage' => $receivablesMessage
- );
- if (! empty ( $receivablesBank ))
- $item += array (
- 'receivablesBank' => $receivablesBank
- );
- if (! empty ( $receivablesDate ))
- $item += array (
- 'receivablesDate' => $receivablesDate
- );
- $invoiceReceivables->setInvoiceReceivablesByCondition ( $item );
-
- // 收款操作日志
- $item = array ();
- if ($receivablesCategory == 'PUBLIC' && $receivablesStaff == 'PUBLIC')
- $item = array (
- 'operation' => $this->staff [0] ['username'] . " 转入 公共待认领款项 "
- );
- elseif ($receivablesCategory != 'PUBLIC' && $receivablesStaff == 'PUBLIC')
- $item = array (
- 'operation' => $this->staff [0] ['username'] . "转入 办事处待认领款项"
- );
- elseif ($receivablesCategory != 'PUBLIC' && $receivablesStaff != 'PUBLIC') {
- $receivablesStaff = explode ( '-', $receivablesStaff );
- $item = array (
- 'operation' => $this->staff [0] ['username'] . " 转入 " . $receivablesStaff [1]
- );
- }
- $item += array (
- 'date' => date ( "Y-m-d" ),
- 'status' => 1,
- 'img' => $this->staff [0] ['avatar'],
- 'username' => $this->staff [0] ['username'],
- 'uid' => $this->staff [0] ['sid'],
- 'category' => $this->staff [0] ['category'],
- 'irid' => $detail ['irid']
- );
- $invoiceROLog->setInvoiceROLog ( $item );
-
- return '/invoiceReceivablesAS';
- }
- function invoiceReceivablesDelete() {
- $claimKey = $this->get_args ( 'claimKey' ) ? $this->get_args ( 'claimKey' ) : "";
-
- if (empty ( $claimKey ))
- die ( 'illegal request' );
-
- Doo::loadModel ( 'invoiceReceivables' );
- $invoiceReceivables = new invoiceReceivables ();
-
- $con = ' and iid=0 and bindStatus=0 and receivablesStaff="PUBLIC"';
- $detail = $invoiceReceivables->getInvoiceReceivablesByIrid ( $claimKey, $con );
- if (empty ( $detail ))
- die ( 'illegal request' );
-
- $invoiceReceivables->delInvoiceReceivablesByIrid ( $detail ['irid'] );
- return '/invoiceReceivablesAS';
- }
-
- /**
- * 管理员录入的收款 ,确认认领到谁的名下.统计收款金额
- */
- function invoiceReceivablesAscription() {
- $irid = $this->get_args ( 'key' ) ? $this->get_args ( 'key' ) : "";
- $recepitTitleMark = $this->get_args ( 'recepitTitleMark' ) ? $this->get_args ( 'recepitTitleMark' ) : "";
-
- Doo::loadModel ( 'invoiceReceivables' );
- $invoiceReceivables = new invoiceReceivables ();
- Doo::loadModel ( 'invoiceROLog' );
- $invoiceROLog = new invoiceROLog ();
- Doo::loadModel ( 'invoiceStatistics' );
- $invoiceStatistics = new invoiceStatistics ();
-
- $detail = $invoiceReceivables->getInvoiceReceivablesByIrid ( $irid );
-
- if (! empty ( $detail ) && $detail ['receivablesStaff'] == 'PUBLIC' && ! empty ( $recepitTitleMark )) {
- $item = array (
- 'irid' => $detail ['irid'],
- 'receivablesCategory' => $this->staff [0] ['cid'] . ":" . $this->staff [0] ['category'],
- 'receivablesStaff' => $this->staff [0] ['sid'] . "-" . $this->staff [0] ['username'],
- 'confirmTime' => date ( "Y-m-d H:i:s" ),
- 'recepitTitleMark' => $recepitTitleMark,
- 'source' => 1
- );
- $invoiceReceivables->setInvoiceReceivablesByCondition ( $item );
-
- $item = array (
- 'date' => date ( "Y-m-d" ),
- 'operation' => $this->staff [0] ['username'] . " 认领 ",
- 'status' => 2,
- 'img' => $this->staff [0] ['avatar'],
- 'username' => $this->staff [0] ['username'],
- 'uid' => $this->staff [0] ['sid'],
- 'category' => $this->staff [0] ['category'],
- 'irid' => $irid
- );
- $invoiceROLog->setInvoiceROLog ( $item );
-
- $item = array (
- 'cid' => $this->staff [0] ['cid'],
- 'staff' => $this->staff [0] ['sid']
- );
- $invoiceStatistics->updateInvoiceStatisticsByIrid ( $item, $detail ['irid'] );
- }
-
- return "/invoiceReceivablesClaim";
- }
-
- /**
- */
- function invoiceMyReceivables() {
- Doo::loadModel ( 'invoiceReceivables' );
- $invoiceReceivables = new invoiceReceivables ();
- Doo::loadModel ( 'invoiceStatistics' );
- $invoiceStatistics = new invoiceStatistics ();
-
- $isMonth = $invoiceStatistics->getStatisticsByMonth ();
-
- $year = date ( "Y" );
- $tmp_date = date ( "Ym" );
- $tmp_year = substr ( $tmp_date, 0, 4 );
- $tmp_mon = substr ( $tmp_date, 4, 2 );
- $tmp_forwardmonth = mktime ( 0, 0, 0, $tmp_mon - 1, 1, $tmp_year );
- $fm_forward_month = date ( "m", $tmp_forwardmonth );
- $path = SITE_PATH . $this->INVOICECOLLECTPATH . "invoiceCollect_" . $year . "_" . $fm_forward_month . ".htm";
- $htm = $this->showCache ( $path );
-
- $list = $invoiceReceivables->getInvoiceReceivablesByClaim ( $this->staff [0] ['cid'], $this->staff [0] ['sid'] );
-
- $this->data ['isMonth'] = $isMonth;
- $this->data ['htm'] = $htm;
- $this->data ['list'] = $list;
-
- $this->data ['memu'] = "invoice";
- $this->data ['staff'] = $this->staff;
- $this->data ['receiptMemu'] = 'invoiceMyReceivables';
- $this->render ( "/admin/invoiceMyReceivables", $this->data );
- }
-
- /**
- * 收款绑定发票 ,一个收款只能绑定一个发票
- */
- function invoiceBindReceivables() {
- $claimKey = $this->get_args ( 'key' ) ? $this->get_args ( 'key' ) : "";
- $invoiceKey = $this->get_args ( 'invoiceKey' ) ? $this->get_args ( 'invoiceKey' ) : "";
-
- Doo::loadModel ( 'invoice' );
- $invoice = new invoice ();
- Doo::loadModel ( 'invoiceReceivables' );
- $invoiceReceivables = new invoiceReceivables ();
- Doo::loadModel ( 'invoiceOperationLog' );
- $invoiceOperationLog = new invoiceOperationLog ();
-
- if (empty ( $invoiceKey ) || empty ( $claimKey ))
- die ( 'illegal request' );
-
- $detail = $invoice->getInvoiceByIid ( $invoiceKey );
- $detailM = $invoiceReceivables->getInvoiceReceivablesByIrid ( $claimKey );
-
- if (empty ( $detail ) && empty ( $detailM ))
- die ( 'illegal request' );
- if ($detail ['untreadStatus'] ==3)
- die ( 'illegal request' );
-
- // if ($detailM ['receivablesPrice'] >= $detail ['invoicePrice']) {
- // $price = $detailM ['receivablesPrice'] - $detail ['invoicePrice'];
- // die ( '<p>收款金额超出开票金额 ¥' . $price . '元,请谨慎操作</p><a href="/invoiceMyReceivables">返回</a>' );
- // }
-
- $item = array (
- 'irid' => $detailM ['irid'],
- 'bindStatus' => 1,
- 'iid' => $detail ['iid'],
- 'accountClerk' => $this->staff [0] ['username'],
- 'bindDate' => date ( "Y-m-d H:i:s" )
- );
- //$invoiceReceivables->setInvoiceReceivablesByCondition ( $item );
-
- $iridString = "";
- if (empty ( $detail ['irid'] ))
- $iridString = $detailM ['irid'];
- else
- $iridString = $detail ['irid'] . ',' . $detailM ['irid'];
-
- $item = array (
- 'iid' => $detail ['iid'],
- 'irid' => $iridString
- );
-
- $sum=$invoiceReceivables->getSumOfReceivablesPrice($iridString);
- if ($detail ['invoicePrice']<=$sum)
- $item += array (
- 'untreadStatus' => 3
- );
-
- $invoice->setInvoiceByCondition ( $item );
-
- // 操作日志
- $item = array (
- 'date' => date ( "Y-m-d H:i:s" ),
- 'operation' => "收款" . $detailM ['receivablesSerial'] . "入账到发票" . $detail ['invoiceSerial'],
- 'status' => 8,
- 'img' => $this->staff [0] ['avatar'],
- 'username' => $this->staff [0] ['username'],
- 'uid' => $this->staff [0] ['sid'],
- 'category' => $this->staff [0] ['category'],
- 'iid' => $detail ['iid']
- );
- $invoiceOperationLog->setInvoiceOperationLog ( $item );
-
- Doo::loadModel ( 'invoiceStatistics' );
- $invoiceStatistics = new invoiceStatistics ();
-
- $list = $invoiceReceivables->getInvoiceReceivablesInIridString ( $iridString );
- $accountPrice = 0;
- foreach ( $list as $key => $value ) {
- $accountPrice += $value ['receivablesPrice'];
- }
- $item = array (
- 'date' => date ( "Y-m-d H:i:s" ),
- 'priceClass' => 3,
-
- 'cid' => $detail ['cid'],
- 'staff' => $detail ['sid'],
- 'accountPrice' => $accountPrice
- );
- $invoiceStatistics->setInvoiceStatisticsByCondition ( $item );
-
- return "/invoiceReceivables";
- }
-
- /**
- * 核销 动作,确认入账统计 发票收款完成--需求更变 废弃 function invoiceEnterReceivables() { $invoiceKey = $this->get_args ( 'key' ) ? $this->get_args ( 'key' ) : ""; // $invoiceClaim = $this->get_args ( 'invoiceClaim' ) ? $this->get_args ( 'invoiceClaim' ) : ""; Doo::loadModel ( 'invoice' ); $invoice = new invoice (); Doo::loadModel ( 'invoiceOperationLog' ); $invoiceOperationLog = new invoiceOperationLog (); Doo::loadModel ( 'invoiceStatistics' ); $invoiceStatistics = new invoiceStatistics (); Doo::loadModel ( 'invoiceReceivables' ); $invoiceReceivables = new invoiceReceivables (); $detail = $invoice->getInvoiceByIid ( $invoiceKey ); if (empty ( $detail )) die ( 'illegal request' ); if (empty ( $detail ['irid'] )) die ( 'illegal request' ); $item = array ( 'untreadStatus' => 3, 'updateTime' => date ( "Y-m-d H:i:s" ), 'iid' => $detail ['iid'] ); $invoice->setInvoiceByCondition ( $item ); // 操作日志 $item = array ( 'date' => date ( "Y-m-d H:i:s" ), 'operation' => "发票" . $detail ['invoiceSerial'] . "收款完成", 'status' => 9, 'img' => $this->staff [0] ['avatar'], 'username' => $this->staff [0] ['username'], 'uid' => $this->staff [0] ['sid'], 'category' => $this->staff [0] ['category'], 'iid' => $detail ['iid'] ); $invoiceOperationLog->setInvoiceOperationLog ( $item ); $list = $invoiceReceivables->getInvoiceReceivablesInIridString ( $detail ['irid'] ); $accountPrice = 0; foreach ( $list as $key => $value ) { $accountPrice += $value ['receivablesPrice']; } $item = array ( 'date' => date ( "Y-m-d H:i:s" ), 'priceClass' => 3, 'cid' => $this->staff [0] ['cid'], 'staff' => $this->staff [0] ['sid'], 'accountPrice' => $accountPrice ); $invoiceStatistics->setInvoiceStatisticsByCondition ( $item ); return "/invoice"; }
- */
- function invoiceAggregate() {
- $year = $this->get_args ( 'year' ) ? $this->get_args ( 'year' ) : date ( "Y" );
-
- Doo::loadModel ( 'invoiceStatistics' );
- $invoiceStatistics = new invoiceStatistics ();
- Doo::loadModel ( 'L_category' );
- $Lcategory = new L_category ();
-
- $isList = $invoiceStatistics->getInvoiceStatisticsByYear ( $year );
- $LcategoryList = $Lcategory->getCategory ();
- // print_r($isList);
-
- $html = ""; // $invoicePriceCategory=0;$receivablesPriceCategory=0;$accountPriceCategory=0;
- foreach ( $LcategoryList as $key => $value ) {
- $html .= '<tr><th><a href="/invoiceAggregateCategory/' . $value ['cidKey'] . '">' . $value ['title'] . '</a></th>';
- $month = 1;
- $invoicePriceYear = 0;
- $receivablesPriceYear = 0;
- $accountPriceYear = 0;
- for(; $month <= 12; $month ++) {
- $flag = true;
- foreach ( $isList ['statisticsMonthCid'] as $k => $v ) {
- if ($value ['cid'] == $v ['cid'] && $month == $v ['month']) {
- $html .= '<td class="taR">¥' . $v ['invoicePrice'] . '</td>
- <td class="taR">¥' . $v ['receivablesPrice'] . '</td>
- <td class="taR"><b>¥' . $v ['accountPrice'] . '</b></td>
- ';
- $invoicePriceYear += $v ['invoicePrice'];
- $receivablesPriceYear += $v ['receivablesPrice'];
- $accountPriceYear += $v ['accountPrice'];
- $flag = false;
- break;
- }
- }
- if ($flag)
- $html .= '<td class="taR"></td>
- <td class="taR"></td>
- <td class="taR"><b></b></td>
- ';
- }
- $html .= '<td class="taR colRed">' . $invoicePriceYear . '</td>
- <td class="taR colOrange">' . $receivablesPriceYear . '</td>
- <td class="taR colGreen"><b>' . $accountPriceYear . '</b></td>
- ';
- $html .= '</tr>';
- }
-
- $html .= '<tr><th><b class="colGreen">月合计</b></th>';
- $invoicePriceYear = 0;
- $receivablesPriceYear = 0;
- $accountPriceYear = 0;
- for($month = 1; $month <= 12; $month ++) {
- $flag = true;
- foreach ( $isList ['statisticsMonth'] as $k => $v ) {
- if ($month == $v ['month']) {
- $html .= '<td class="taR">¥' . $v ['invoicePrice'] . '</td>
- <td class="taR">¥' . $v ['receivablesPrice'] . '</td>
- <td class="taR"><b>¥' . $v ['accountPrice'] . '</b></td>
- ';
- $invoicePriceYear += $v ['invoicePrice'];
- $receivablesPriceYear += $v ['receivablesPrice'];
- $accountPriceYear += $v ['accountPrice'];
- $flag = false;
- break;
- }
- }
- if ($flag) {
- $html .= '<td class="taR"></td>
- <td class="taR"></td>
- <td class="taR"><b></b></td>
- ';
- }
- }
- $html .= '<td class="taR colRed">' . $invoicePriceYear . '</td>
- <td class="taR colOrange">' . $receivablesPriceYear . '</td>
- <td class="taR colGreen"><b>' . $accountPriceYear . '</b></td>
- ';
- $html .= '</tr>';
-
- // print_r($isList);
-
- $this->data ['html'] = $html;
- $this->data ['LcategoryList'] = $LcategoryList;
- $this->data ['isList'] = $isList;
-
- $this->data ['year'] = $year;
- $this->data ['memu'] = "invoice";
- $this->data ['staff'] = $this->staff;
- $this->data ['receiptMemu'] = 'invoiceAggregate';
- $this->render ( "/admin/invoiceAggregate", $this->data );
- }
- function invoiceAggregateStaff() {
- $year = $this->get_args ( 'year' ) ? $this->get_args ( 'year' ) : date ( "Y" );
-
- Doo::loadModel ( 'invoiceStatistics' );
- $invoiceStatistics = new invoiceStatistics ();
- Doo::loadModel ( 'L_category' );
- $Lcategory = new L_category ();
-
- $toteList = $invoiceStatistics->getInvoiceStatisticsByTote ( $year );
- $staffList = $invoiceStatistics->getInvoiceStatisticsByStaff ( $year );
- $cStaff = $Lcategory->getCategoryStaff ();
-
- $html = '';
- foreach ( $cStaff as $key => $value ) {
- $categoryFir = true;
- foreach ( $value ['staff'] as $k => $v ) {
- if ($categoryFir) {
- $width = count ( $value ['staff'] ) + 1;
- $html .= '<tr><th rowspan="' . $width . '">' . $value ['title'] . ' </th>';
- $categoryFir = false;
- } else
- $html .= '<tr>';
- $html .= '<th>' . $v ['username'] . '</th>';
- $invoicePriceStaffYear = 0;
- $receivablesPriceStaffYear = 0;
- $accountPriceStaffYear = 0;
- for($month = 1; $month <= 12; $month ++) {
- $flag = true;
- foreach ( $staffList ['statisticsMonthStaff'] as $sl => $slv ) {
- if ($v ['sid'] == $slv ['staff'] && $month == $slv ['month']) {
- $html .= '<td class="taR">¥' . $slv ['invoicePrice'] . '</td>
- <td class="taR">¥' . $slv ['receivablesPrice'] . '</td>
- <td class="taR"><b>¥' . $slv ['accountPrice'] . '</b></td>
- ';
- $invoicePriceStaffYear += $slv ['invoicePrice'];
- $receivablesPriceStaffYear += $slv ['receivablesPrice'];
- $accountPriceStaffYear += $slv ['accountPrice'];
- $flag = false;
- break;
- }
- }
- if ($flag)
- $html .= '<td class="taR"></td>
- <td class="taR"></td>
- <td class="taR"><b></b></td>
- ';
- }
- $html .= '<td class="taR colRed">' . $invoicePriceStaffYear . '</td>
- <td class="taR colOrange">' . $receivablesPriceStaffYear . '</td>
- <td class="taR colGreen"><b>' . $accountPriceStaffYear . '</b></td>
- ';
- }
- $html .= '</tr>';
-
- // 小计
- if (! empty ( $value ['staff'] )) {
- $html .= '<tr><th class="taR">小计</th>';
- $invoicePriceStaffYear = 0;
- $receivablesPriceStaffYear = 0;
- $accountPriceStaffYear = 0;
- for($month = 1; $month <= 12; $month ++) {
- $flag = true;
- foreach ( $staffList ['statisticsMonthCid'] as $smc => $smcv ) {
- if ($value ['cid'] == $smcv ['cid'] && $month == $slv ['month']) {
- $html .= '<td class="taR">¥' . $smcv ['invoicePrice'] . '</td>
- <td class="taR">¥' . $smcv ['receivablesPrice'] . '</td>
- <td class="taR"><b>¥' . $smcv ['accountPrice'] . '</b></td>
- ';
- $invoicePriceStaffYear += $slv ['invoicePrice'];
- $receivablesPriceStaffYear += $slv ['receivablesPrice'];
- $accountPriceStaffYear += $slv ['accountPrice'];
- $flag = false;
- break;
- }
- }
- if ($flag)
- $html .= '<td class="taR"></td>
- <td class="taR"></td>
- <td class="taR"><b></b></td>
- ';
- }
- $html .= '<td class="taR colRed">' . $invoicePriceStaffYear . '</td>
- <td class="taR colOrange">' . $receivablesPriceStaffYear . '</td>
- <td class="taR colGreen"><b>' . $accountPriceStaffYear . '</b></td>
- ';
- $html .= '</tr>';
- }
- }
-
- $html .= '<tr class="warning"><th colspan="2"><b class="colGreen" >月合计</b></th>';
- $invoicePriceYear = 0;
- $receivablesPriceYear = 0;
- $accountPriceYear = 0;
- for($month = 1; $month <= 12; $month ++) {
- $flag = true;
- foreach ( $staffList ['statisticsMonth'] as $k => $v ) {
- if ($month == $v ['month']) {
- $html .= '<td class="taR colRed">¥' . $v ['invoicePrice'] . '</td>
- <td class="taR colOrange">¥' . $v ['receivablesPrice'] . '</td>
- <td class="taR colGreen"><b>¥' . $v ['accountPrice'] . '</b></td>
- ';
- $invoicePriceYear += $v ['invoicePrice'];
- $receivablesPriceYear += $v ['receivablesPrice'];
- $accountPriceYear += $v ['accountPrice'];
- $flag = false;
- break;
- }
- }
- if ($flag)
- $html .= '<td class="taR"></td>
- <td class="taR"></td>
- <td class="taR"><b></b></td>
- ';
- }
- $html .= '<td class="taR colRed">' . $invoicePriceYear . '</td>
- <td class="taR colOrange">' . $receivablesPriceYear . '</td>
- <td class="taR colGreen"><b>' . $accountPriceYear . '</b></td>
- ';
- $html .= '</tr>';
-
- $this->data ['html'] = $html;
- $this->data ['isList'] = $toteList;
- $this->data ['year'] = $year;
- $this->data ['memu'] = "invoice";
- $this->data ['staff'] = $this->staff;
- $this->data ['receiptMemu'] = 'invoiceAggregate';
- $this->render ( "/admin/invoiceAggregateStaff", $this->data );
- }
- function invoiceAggregateCategory() {
- Doo::loadClass ( 'XDeode' );
- $XDeode = new XDeode ( 5 );
-
- $cid = $cidKey = isset ( $this->params ['cid'] ) ? $this->params ['cid'] : "";
- $cid = $XDeode->decode ( $cid );
- if (! is_numeric ( $cid ))
- die ( 'illegal request' );
-
- $year = $this->get_args ( 'year' ) ? $this->get_args ( 'year' ) : date ( "Y" );
-
- Doo::loadModel ( 'invoiceStatistics' );
- $invoiceStatistics = new invoiceStatistics ();
- Doo::loadModel ( 'staff' );
- $staff = new staff ();
-
- $list = $staff->getStaffByCid ( $cid );
- $isCategory = $invoiceStatistics->getInvoiceStatisticsByStaff ( $year, $cid );
- $toteList = $invoiceStatistics->getInvoiceStatisticsByTote ( $year, $cid );
-
- if (empty ( $list ))
- die ( '该办事处没有成员' );
- $htmlA = $htmlB = $htmlC = $html = '';
- foreach ( $list as $key => $value ) {
- $htmlA = '<tr><th rowspan="3">' . $value ['username'] . '</th><th class="taC">开票</th>';
- $htmlB = '<tr><th class="taC">收款</th>';
- $htmlC = '<tr><th class="taC">入账</th>';
- $invoicePriceStaffYear = 0;
- $receivablesPriceStaffYear = 0;
- $accountPriceStaffYear = 0;
- for($month = 1; $month <= 12; $month ++) {
- $flag = true;
- foreach ( $isCategory ['statisticsMonthStaff'] as $k => $v ) {
- if ($value ['sid'] == $v ['staff'] && $month == $v ['month']) {
- $htmlA .= '<td class="taR">¥' . $v ['invoicePrice'] . '</td>';
- $htmlB .= '<td class="taR">¥' . $v ['receivablesPrice'] . '</td>';
- $htmlC .= '<td class="taR"><b>¥' . $v ['accountPrice'] . '</b></td>';
- $invoicePriceStaffYear += $v ['invoicePrice'];
- $receivablesPriceStaffYear += $v ['receivablesPrice'];
- $accountPriceStaffYear += $v ['accountPrice'];
- $flag = false;
- break;
- }
- }
- if ($flag) {
- $htmlA .= '<td class="taR">-</td>';
- $htmlB .= '<td class="taR">-</td>';
- $htmlC .= '<td class="taR"><b>-</b></td>';
- }
- }
- $htmlA .= '<td class="taR colRed">' . $invoicePriceStaffYear . '</td>';
- $htmlB .= '<td class="taR colOrange">' . $receivablesPriceStaffYear . '</td>';
- $htmlC .= '<td class="taR colGreen"><b>' . $accountPriceStaffYear . '</b></td>';
-
- $htmlA .= '</tr>';
- $htmlB .= '</tr>';
- $htmlC .= '</tr>';
- $html .= $htmlA . $htmlB . $htmlC;
- }
-
- $htmlA = $htmlB = $htmlC = "";
-
- $htmlA = '<tr><th rowspan="3">月合计</th><th class="taC">开票</th>';
- $htmlB = '<tr><th class="taC">收款</th>';
- $htmlC = '<tr><th class="taC">入账</th>';
- $invoicePriceStaffYear = 0;
- $receivablesPriceStaffYear = 0;
- $accountPriceStaffYear = 0;
- for($month = 1; $month <= 12; $month ++) {
- $flag = true;
- foreach ( $isCategory ['statisticsMonth'] as $k => $v ) {
- if ($month == $v ['month']) {
- $htmlA .= '<td class="taR colRed">¥' . $v ['invoicePrice'] . '</td>';
- $htmlB .= '<td class="taR colOrange">¥' . $v ['receivablesPrice'] . '</td>';
- $htmlC .= '<td class="taR colGreen"><b>¥' . $v ['accountPrice'] . '</b></td>';
- $invoicePriceStaffYear += $v ['invoicePrice'];
- $receivablesPriceStaffYear += $v ['receivablesPrice'];
- $accountPriceStaffYear += $v ['accountPrice'];
- $flag = false;
- break;
- }
- }
- if ($flag) {
- $htmlA .= '<td class="taR">-</td>';
- $htmlB .= '<td class="taR">-</td>';
- $htmlC .= '<td class="taR"><b>-</b></td>';
- }
- }
- $htmlA .= '<td class="taR colRed">' . $invoicePriceStaffYear . '</td>';
- $htmlB .= '<td class="taR colOrange">' . $receivablesPriceStaffYear . '</td>';
- $htmlC .= '<td class="taR colGreen"><b>' . $accountPriceStaffYear . '</b></td>';
-
- $htmlA .= '</tr>';
- $htmlB .= '</tr>';
- $htmlC .= '</tr>';
- $html .= $htmlA . $htmlB . $htmlC;
-
- $this->data ['html'] = $html;
-
- $this->data ['cidKey'] = $cidKey;
- $this->data ['slist'] = $list;
- $this->data ['isList'] = $toteList;
- $this->data ['year'] = $year;
- $this->data ['memu'] = "invoice";
- $this->data ['staff'] = $this->staff;
- $this->data ['receiptMemu'] = 'invoiceAggregate';
- $this->render ( "/admin/invoiceAggregateCategory", $this->data );
- }
- function invoiceAchieve() {
- Doo::loadModel ( 'invoice' );
- $invoice = new invoice ();
- Doo::loadClass ( 'XDeode' );
- $XDeode = new XDeode ( 5 );
- $sid = $XDeode->decode ( $_COOKIE ["staff"] );
- $MebSea = isset ( $this->params ['MebSea'] ) ? urldecode ( $this->params ['MebSea'] ) : '';
-
- $page_size = 18;
- $page = isset ( $this->params ['page'] ) && is_numeric ( $this->params ['page'] ) ? $this->params ['page'] : 1;
- $date = isset ( $this->params ['date'] ) ? $this->params ['date'] : 'MONTHO';
-
- $get = "/" . $date;
-
- $con = '';
- if ($date == 'MONTHO')
- $con = ' and updateTime>DATE_SUB(CURDATE(), INTERVAL 1 MONTH)';
- elseif ($date == 'MONTHT')
- $con = ' and updateTime>DATE_SUB(CURDATE(), INTERVAL 3 MONTH)';
- elseif ($date == 'MONTHY')
- $con = ' and updateTime>DATE_SUB(CURDATE(), INTERVAL 1 YEAR)';
-
- if (! empty ( $MebSea )) {
- $con .= ' and ( invoiceTitle like "%' . $MebSea . '%" or invoiceCompany like "%' . $MebSea . '%" or invoicePrice like "%' . $MebSea . '%" )';
- $get .= "/" . $MebSea;
- }
- $pageinfo ['page'] = array (
- 'previous' => ''
- );
- $sql = 'status=2 and printStatus=1 and sid=' . $sid . $con;
- $pageinfo = $this->get_page ( "CLD_invoice", $sql, $page, $page_size, "invoiceAchieve", $get, "" );
-
- $limit = $pageinfo ['lower'] . ',' . $page_size;
-
- $list = $invoice->getInvoiceByUntreadStatusPage ( $limit, $sql );
- // print_r($pageinfo);
- $this->data ['MebSeaEn'] = $MebSea;
- $this->data ['MebSea'] = urlencode ( $MebSea );
- $this->data ['get'] = $get;
- $this->data ['page'] = $pageinfo;
- $this->data ['list'] = $list;
- $this->data ['date'] = $date;
- $this->data ['memu'] = "invoice";
- $this->data ['staff'] = $this->staff;
- $this->data ['receiptMemu'] = 'invoice';
- $this->render ( "/admin/invoiceAchieve", $this->data );
- }
- function invoiceMyUnAccountAchieve() {
- Doo::loadModel ( 'invoice' );
- $invoice = new invoice ();
- Doo::loadClass ( 'XDeode' );
- $XDeode = new XDeode ( 5 );
- Doo::loadModel ( 'staff' );
- $staff = new staff ();
-
- $sid = $XDeode->decode ( $_COOKIE ["staff"] );
- $MebSea = $this->get_args ( 'MebSea' ) ? $this->get_args ( 'MebSea' ) : "";
-
- $page_size = 18;
- $page = isset ( $this->params ['page'] ) && is_numeric ( $this->params ['page'] ) ? $this->params ['page'] : 1;
- $date = $this->get_args ( 'date' ) ? $this->get_args ( 'date' ) : "";
-
- $get = "?date=" . urlencode ( $date ) . "&MebSea=" . urlencode ( $MebSea );
-
- $dateArr = explode ( ':', $date );
- $D1 = '';
- $D2 = '';
- if (! empty ( $date )) {
- $D1 = $dateArr [0];
- $D2 = $dateArr [1];
- }
- $con = '';
- if (! empty ( $D1 ) && ! empty ( $D2 ))
- $con = ' and printTime BETWEEN "' . $D1 . '" AND "' . $D2 . '" ';
-
- if (! empty ( $MebSea )) {
- $con .= ' and ( invoiceTitle like "%' . $MebSea . '%" or invoiceCompany like "%' . $MebSea . '%" or invoicePrice like "%' . $MebSea . '%" )';
- }
- $pageinfo ['page'] = array (
- 'previous' => ''
- );
- // and irid='' and ( (doPost=1 and postStatus=1) or doPost=0 )
- $sql = " status=2 and printStatus=1 and untreadStatus=0 and isDelete=0 and sid= " . $sid . $con;
- $action = "invoiceMyUnAccountAchieve";
-
- $pageinfo = $this->get_page ( "CLD_invoice", $sql, $page, $page_size, $action, $get, "" );
- $limit = $pageinfo ['lower'] . ',' . $page_size;
- $list = $invoice->getInvoiceByUntreadStatusPage ( $limit, $sql );
-
- Doo::loadModel ( 'express' );
- $express = new express ();
- $expressList = $express->getExpressByAll ();
- $this->data ['expressList'] = $expressList;
-
- // print_r($list);
-
- $this->data ['MebSeaEn'] = $MebSea;
-
- $this->data ['get'] = $get;
- $this->data ['page'] = $pageinfo;
-
- $this->data ['date'] = $date;
- $this->data ['list'] = $list;
-
- $this->data ['memu'] = "invoice";
- $this->data ['staff'] = $this->staff;
- $this->data ['receiptMemu'] = 'invoice';
-
- $this->render ( "/admin/invoiceMyUnAccountAchieve", $this->data );
- }
- function invoiceReceivablesAchieve() {
- Doo::loadModel ( 'invoiceReceivables' );
- $invoiceReceivables = new invoiceReceivables ();
- Doo::loadClass ( 'XDeode' );
- $XDeode = new XDeode ( 5 );
- $sid = $XDeode->decode ( $_COOKIE ["staff"] );
- $MebSea = isset ( $this->params ['MebSea'] ) ? urldecode ( $this->params ['MebSea'] ) : '';
-
- $page_size = 1;
- $page = isset ( $this->params ['page'] ) && is_numeric ( $this->params ['page'] ) ? $this->params ['page'] : 1;
- $date = isset ( $this->params ['date'] ) ? $this->params ['date'] : 'MONTHO';
-
- $get = "/" . $date;
-
- $con = '';
- if ($date == 'MONTHO')
- $con = ' and bindDate>DATE_SUB(CURDATE(), INTERVAL 1 MONTH)';
- elseif ($date == 'MONTHT')
- $con = ' and bindDate>DATE_SUB(CURDATE(), INTERVAL 3 MONTH)';
- elseif ($date == 'MONTHY')
- $con = ' and bindDate>DATE_SUB(CURDATE(), INTERVAL 1 YEAR)';
-
- if (! empty ( $MebSea )) {
- $con .= ' and ( receivablesMessage like "%' . $MebSea . '%" or receivablesPrice like "%' . $MebSea . '%" )';
- $get .= "/" . $MebSea;
- }
- $pageinfo ['page'] = array (
- 'previous' => ''
- );
- $sql = " bindStatus=1 and receivablesStaff like '" . $sid . "_%' " . $con;
- $pageinfo = $this->get_page ( "CLD_invoiceReceivables", $sql, $page, $page_size, "invoiceReceivablesAchieve", $get, "" );
-
- $limit = $pageinfo ['lower'] . ',' . $page_size;
-
- $list = $invoiceReceivables->getReceivablesByUntreadStatusPage ( $limit, $sql );
- // print_r($pageinfo);
- $this->data ['MebSeaEn'] = $MebSea;
- $this->data ['MebSea'] = urlencode ( $MebSea );
- $this->data ['get'] = $get;
- $this->data ['page'] = $pageinfo;
- $this->data ['list'] = $list;
- $this->data ['date'] = $date;
- $this->data ['memu'] = "invoice";
- $this->data ['staff'] = $this->staff;
- $this->data ['receiptMemu'] = 'invoiceMyReceivables';
- $this->render ( "/admin/invoiceReceivablesAchieve", $this->data );
- }
-
- /**
- * 收款解绑
- */
- function invoiceUnBundLing() {
- $unBundKey = $this->get_args ( 'unBundKey' ) ? $this->get_args ( 'unBundKey' ) : '';
-
- Doo::loadModel ( 'invoice' );
- $invoice = new invoice ();
- Doo::loadModel ( 'invoiceReceivables' );
- $invoiceReceivables = new invoiceReceivables ();
- Doo::loadModel ( 'invoiceOperationLog' );
- $invoiceOperationLog = new invoiceOperationLog ();
- Doo::loadModel ( 'invoiceROLog' );
- $invoiceROLog = new invoiceROLog ();
- Doo::loadModel ( 'invoiceStatistics' );
- $invoiceStatistics = new invoiceStatistics ();
-
- $irid = $invoice->authcode ( $unBundKey );
- if (! empty ( $irid ) && ! is_numeric ( $irid ))
- die ( 'illegal request' );
-
- $irDetails = $invoiceReceivables->getInvoiceReceivablesByIrid ( $irid );
- $invoiceDetails = $invoice->getInvoiceByIid ( $irDetails ['iid'] );
-
- if ( empty ( $irDetails ) ||$irDetails ['bindStatus'] == 0 || $invoiceDetails ['untreadStatus'] == 2 )
- die ( 'illegal request' );
- // 收款
- $item = array (
- 'irid' => $irDetails ['irid'],
- 'bindStatus' => 0,
- 'iid' => 0
- );
- $invoiceReceivables->setInvoiceReceivablesByCondition ( $item );
-
- // 收款操作日志
- $item = array (
- 'operation' => $this->staff [0] ['username'] . " 解绑 " . $irDetails ['receivablesSerial'],
- 'date' => date ( "Y-m-d" ),
- 'status' => 3,
- 'img' => $this->staff [0] ['avatar'],
- 'username' => $this->staff [0] ['username'],
- 'uid' => $this->staff [0] ['sid'],
- 'category' => $this->staff [0] ['category'],
- 'irid' => $irid
- );
- $invoiceROLog->setInvoiceROLog ( $item );
-
- // 扣除入账统计金额
- $item = array (
- 'date' => date ( 'Y-m-d', strtotime ( $irDetails ['bindDate'] ) ),
- 'priceClass' => 3,
- 'cid' => $invoiceDetails ['cid'],
- 'staff' => $invoiceDetails ['sid'],
- 'accountPrice' => - $irDetails ['receivablesPrice']
- );
- $invoiceStatistics->setInvoiceStatisticsByCondition ( $item );
-
- // 发票解绑去收款ID
- $iridString = $invoiceDetails ['irid'];
- if (! empty ( $invoiceDetails ['irid'] )) {
- $list = explode ( ',', $invoiceDetails ['irid'] );
- foreach ( $list as $key => $value ) {
- if ($value == $irDetails ['irid']) {
- unset ( $list [$key] );
- break;
- }
- }
- $iridString = implode ( ",", $list );
- }
-
- $item = array (
- 'iid' => $invoiceDetails ['iid'],
- 'irid' => $iridString,
- 'updateTime' => date ( "Y-m-d H:i:s" )
- );
- if ($invoiceDetails ['untreadStatus'] == 3)
- $item += array (
- 'untreadStatus' => 0
- );
- $invoice->setInvoiceByCondition ( $item );
-
- $item = array (
- 'date' => date ( "Y-m-d H:i:s" ),
- 'operation' => '解绑 收款 ' . $irDetails ['receivablesSerial'],
- 'status' => 11,
- 'img' => $this->staff [0] ['avatar'],
- 'username' => $this->staff [0] ['username'],
- 'uid' => $this->staff [0] ['sid'],
- 'category' => $this->staff [0] ['category'],
- 'iid' => $invoiceDetails ['iid']
- );
- $invoiceOperationLog->setInvoiceOperationLog ( $item );
-
- return "/invoiceReceivablesAS";
- }
-
- /**
- * 发票管理
- */
- function invoiceAS() {
- Doo::loadModel ( 'invoice' );
- $invoice = new invoice ();
- Doo::loadModel ( 'invoiceReceivables' );
- $invoiceReceivables = new invoiceReceivables ();
-
- $MebSea = $this->get_args ( 'MebSea' ) ? $this->get_args ( 'MebSea' ) : "";
-
- $page_size = 6;
- $page = isset ( $this->params ['page'] ) && is_numeric ( $this->params ['page'] ) ? $this->params ['page'] : 1;
- $status = isset ( $this->params ['status'] ) ? $this->params ['status'] : 'All';
-
- $date = $this->get_args ( 'date' ) ? $this->get_args ( 'date' ) : "";
- $dateArr = explode ( ':', $date );
- $D1 = '';
- $D2 = '';
- if (! empty ( $date )) {
- $D1 = $dateArr [0];
- $D2 = $dateArr [1];
- }
-
- $con = '1';
- if (! empty ( $D1 ) && ! empty ( $D2 ))
- $con .= ' and date BETWEEN "' . $D1 . '" AND "' . $D2 . '" ';
-
- if ($status == 'UNRECORD')
- $con .= ' and untreadStatus=0';
- elseif ($status == 'RECORD')
- $con .= ' and untreadStatus=3';
- elseif ($status == 'BOUNCED')
- $con .= ' and untreadStatus=2';
-
- $get = "/" . $status . "?date=" . urlencode ( $date ) . "&MebSea=" . urlencode ( $MebSea );
-
- if (! empty ( $MebSea )) {
- $con .= ' and ( invoiceTitle like "%' . $MebSea . '%" or invoiceCompany like "%' . $MebSea . '%" )';
- }
- $pageinfo ['page'] = array (
- 'previous' => ''
- );
- $pageinfo = $this->get_page ( "CLD_invoice", $con, $page, $page_size, "invoiceAS", $get, "" );
- $limit = $pageinfo ['lower'] . ',' . $page_size;
-
- $list = $invoice->getInvoiceByUntreadStatusPage ( $limit, $con );
-
- foreach ($list as $key=>$value){
- $list[$key]['rpSum']=0;
- if (!empty($value['irid']))
- $list[$key]['rpSum']=$invoiceReceivables->getSumOfReceivablesPrice($value['irid']);
- }
-
- //print_r($list);
-
- $this->data ['MebSeaEn'] = $MebSea;
- $this->data ['MebSea'] = urlencode ( $MebSea );
- $this->data ['date'] = $date;
- $this->data ['page'] = $pageinfo;
- $this->data ['get'] = $get;
- $this->data ['list'] = $list;
- $this->data ['status'] = $status;
- $this->data ['memu'] = "invoice";
- $this->data ['staff'] = $this->staff;
- $this->data ['receiptMemu'] = 'invoiceReceivables';
-
- $this->render ( "/admin/invoiceAS", $this->data );
- }
-
- /**
- * 收款管理
- */
- function invoiceReceivablesAS() {
- Doo::loadModel ( 'invoiceReceivables' );
- $invoiceReceivables = new invoiceReceivables ();
-
- $MebSea = $this->get_args ( 'MebSea' ) ? $this->get_args ( 'MebSea' ) : "";
- $timeType = $this->get_args ( 'timeType' ) ? $this->get_args ( 'timeType' ) : "CREATE";
-
- $page_size = 6;
- $page = isset ( $this->params ['page'] ) && is_numeric ( $this->params ['page'] ) ? $this->params ['page'] : 1;
- $status = isset ( $this->params ['status'] ) ? $this->params ['status'] : 'All';
-
- $date = $this->get_args ( 'date' ) ? $this->get_args ( 'date' ) : "";
- $dateArr = explode ( ':', $date );
- $D1 = '';
- $D2 = '';
- if (! empty ( $date )) {
- $D1 = $dateArr [0];
- $D2 = $dateArr [1];
- }
-
- $con = '1';
- if (! empty ( $D1 ) && ! empty ( $D2 ))
- $con .= ' and date BETWEEN "' . $D1 . '" AND "' . $D2 . '" ';
-
- $descField = 'bindDate';
- if ($timeType == 'CREATE')
- $descField = 'date';
-
- if ($status == 'Unclaimed')
- $con .= ' and bindStatus=0';
- elseif ($status == 'Credited')
- $con .= ' and bindStatus=1';
- elseif ($status == 'Claim')
- $con .= ' and bindStatus=0 and receivablesStaff="PUBLIC"';
-
- $get = "/" . $status . "?date=" . urlencode ( $date ) . "&MebSea=" . urlencode ( $MebSea );
-
- if (! empty ( $MebSea )) {
- $con .= ' and ( receivablesMessage like "%' . $MebSea . '%" or receivablesPrice like "%' . $MebSea . '%" )';
- }
- $pageinfo ['page'] = array (
- 'previous' => ''
- );
- $pageinfo = $this->get_page ( "CLD_invoiceReceivables", $con, $page, $page_size, "invoiceReceivablesAS", $get, "" );
- $limit = $pageinfo ['lower'] . ',' . $page_size;
-
- $list = $invoiceReceivables->getReceivablesByUntreadStatusPage ( $limit, $con, 'desc', $descField );
- // print_r($list);
-
- $this->data ['timeType'] = $timeType;
- $this->data ['MebSeaEn'] = $MebSea;
- $this->data ['MebSea'] = urlencode ( $MebSea );
- $this->data ['date'] = $date;
- $this->data ['page'] = $pageinfo;
- $this->data ['get'] = $get;
- $this->data ['list'] = $list;
- $this->data ['status'] = $status;
- $this->data ['memu'] = "invoice";
- $this->data ['staff'] = $this->staff;
- $this->data ['receiptMemu'] = 'invoiceReceivables';
- $this->render ( "/admin/invoiceReceivablesAS", $this->data );
- }
- function invoiceApprovalAchieve() {
- Doo::loadModel ( 'invoice' );
- $invoice = new invoice ();
-
- $MebSea = isset ( $this->params ['MebSea'] ) ? urldecode ( $this->params ['MebSea'] ) : '';
-
- $page_size = 2;
- $page = isset ( $this->params ['page'] ) && is_numeric ( $this->params ['page'] ) ? $this->params ['page'] : 1;
- $date = isset ( $this->params ['date'] ) ? $this->params ['date'] : 'MONTHO';
-
- $get = "/" . $date;
-
- $con = '';
- if ($date == 'MONTHO')
- $con = ' and updateTime>DATE_SUB(CURDATE(), INTERVAL 1 MONTH)';
- elseif ($date == 'MONTHT')
- $con = ' and updateTime>DATE_SUB(CURDATE(), INTERVAL 3 MONTH)';
- elseif ($date == 'MONTHY')
- $con = ' and updateTime>DATE_SUB(CURDATE(), INTERVAL 1 YEAR)';
-
- if (! empty ( $MebSea )) {
- $con .= ' and ( invoiceTitle like "%' . $MebSea . '%" or invoiceCompany like "%' . $MebSea . '%" or invoicePrice like "%' . $MebSea . '%" )';
- $get .= "/" . $MebSea;
- }
- $pageinfo ['page'] = array (
- 'previous' => ''
- );
- $sql = '(status=1 or status=3 or status=4) and processApprovals!=""' . $con;
- $pageinfo = $this->get_page ( "CLD_invoice", $sql, $page, $page_size, "invoiceApprovalAchieve", $get, "" );
-
- $limit = $pageinfo ['lower'] . ',' . $page_size;
-
- $list = $invoice->getInvoiceByUntreadStatusPage ( $limit, $sql );
- // print_r($list);
- $this->data ['MebSeaEn'] = $MebSea;
- $this->data ['MebSea'] = urlencode ( $MebSea );
- $this->data ['get'] = $get;
- $this->data ['page'] = $pageinfo;
- $this->data ['list'] = $list;
- $this->data ['date'] = $date;
-
- $this->data ['memu'] = "invoice";
- $this->data ['staff'] = $this->staff;
- $this->data ['receiptMemu'] = 'invoiceApproval';
- $this->render ( "/admin/invoiceApprovalAchieve", $this->data );
- }
- function invoiceTAchieve() {
- Doo::loadModel ( 'invoice' );
- $invoice = new invoice ();
- Doo::loadClass ( 'XDeode' );
- $XDeode = new XDeode ( 5 );
- Doo::loadModel ( 'staff' );
- $staff = new staff ();
-
- $MebSea = isset ( $this->params ['MebSea'] ) ? urldecode ( $this->params ['MebSea'] ) : '';
-
- $page_size = 2;
- $page = isset ( $this->params ['page'] ) && is_numeric ( $this->params ['page'] ) ? $this->params ['page'] : 1;
- $date = isset ( $this->params ['date'] ) ? $this->params ['date'] : 'MONTHO';
-
- $get = "/" . $date;
-
- $con = '';
- if ($date == 'MONTHO')
- $con = ' and updateTime>DATE_SUB(CURDATE(), INTERVAL 1 MONTH)';
- elseif ($date == 'MONTHT')
- $con = ' and updateTime>DATE_SUB(CURDATE(), INTERVAL 3 MONTH)';
- elseif ($date == 'MONTHY')
- $con = ' and updateTime>DATE_SUB(CURDATE(), INTERVAL 1 YEAR)';
-
- if (! empty ( $MebSea )) {
- $con .= ' and ( invoiceTitle like "%' . $MebSea . '%" or invoiceCompany like "%' . $MebSea . '%" or invoicePrice like "%' . $MebSea . '%" )';
- $get .= "/" . $MebSea;
- }
- $pageinfo ['page'] = array (
- 'previous' => ''
- );
-
- $sql = "";
- $action = "";
- if ($this->ACTION == 'invoicePrintAchieve') {
- $sql = "status=2 and printStatus=1 and moldManage like '%[\"" . $this->staff [0] ['sid'] . "\",%'" . $con;
- $action = "invoicePrintAchieve";
- } elseif ($this->ACTION == 'invoicePostAchieve') {
- // and untreadStatus=0
- $sql = "postStatus=1 and doPost=1 and status=2 and isDelete=0" . $con;
- $action = "invoicePostAchieve";
- } elseif ($this->ACTION == 'invoiceUntreadAchieve') {
- $sql = " printStatus=1 and untreadStatus=2 and status=2 " . $con;
- $action = "invoiceUntreadAchieve";
- }
-
- $pageinfo = $this->get_page ( "CLD_invoice", $sql, $page, $page_size, $action, $get, "" );
- $limit = $pageinfo ['lower'] . ',' . $page_size;
- $list = $invoice->getInvoiceByUntreadStatusPage ( $limit, $sql );
-
- $this->data ['MebSeaEn'] = $MebSea;
- $this->data ['MebSea'] = urlencode ( $MebSea );
- $this->data ['get'] = $get;
- $this->data ['page'] = $pageinfo;
-
- $this->data ['date'] = $date;
-
- $this->data ['memu'] = "invoice";
- $this->data ['staff'] = $this->staff;
-
- if ($this->ACTION == 'invoicePrintAchieve') {
- foreach ( $list as $key => $value ) {
- $list [$key] ['iidKey'] = $XDeode->encode ( $value ['iid'] );
-
- $lastApprover = json_decode ( $value ['processApprovals'], true );
- if (! empty ( $lastApprover )) {
- $lastApproverKey = array_keys ( $lastApprover );
- $lastApprover = end ( $lastApprover );
-
- $staffDetail = $staff->getOne ( array (
- 'where' => 'sid=' . end ( $lastApproverKey ),
- 'asArray' => true
- ) );
- $lastApprover ['username'] = $staffDetail ['username'];
- }
- $list [$key] ['lastApprover'] = $lastApprover;
- }
- $this->data ['receiptMemu'] = 'invoicePrint';
- $this->data ['list'] = $list;
- $this->render ( "/admin/invoicePrintAchieve", $this->data );
- } elseif ($this->ACTION == 'invoicePostAchieve') {
-
- Doo::loadModel ( 'express' );
- $express = new express ();
- $expressList = $express->getExpressByAll ();
-
- $this->data ['expressList'] = $expressList;
- $this->data ['receiptMemu'] = 'invoicePost';
- $this->data ['list'] = $list;
- $this->render ( "/admin/invoicePostAchieve", $this->data );
- } elseif ($this->ACTION == 'invoiceUntreadAchieve') {
-
- $this->data ['receiptMemu'] = 'invoiceUntread';
- $this->data ['list'] = $list;
- $this->render ( "/admin/invoiceUntreadAchieve", $this->data );
- }
- }
-
- /**
- *
- * @deprecated 获得与我有关可收款的发票 废弃 function ajaxGetInvoiceByStaff() { $irid = $this->get_args ( 'key' ) ? $this->get_args ( 'key' ) : ""; Doo::loadModel ( 'invoice' ); $invoice = new invoice (); $list = $invoice->getInvoiceByReceivables ( $this->staff [0] ['sid'] ); $html = ""; $i = 1; foreach ( $list as $key => $value ) { $html .= '<tr> <td>' . $value ['invoiceElement'] . '</td> <td>¥' . $value ['invoicePrice'] . '</td>'; if (! empty ( $value ['invoiceType'] )) { $html .= '<td>增值税专用发票</td> <td>' . $value ['invoiceCompany'] . '</td>'; } else { $html .= '<td>增值税普通发票</td> <td>' . $value ['invoiceTitle'] . '</td>'; } $html .= '<td><label><input type="radio" node-Claim="true_' . $i . '" p-data="' . $value ['iidKey'] . '" name="invoiceClaim"> 使用Ta</label></td></tr> <script> $(\'input[node-Claim="true_' . $i . '"]\').click(function() { var invoiceKey= $(this).attr("p-data"); var claimKey=$("input[name=\'key\']").val(); $("p[node-msg=\"true\"]").hide(); var url = "/ajaxCompareInvoicePrice"; $.ajax({ url : url, type : "post", cache : false, dataType : "json", data : { claimKey : claimKey, invoiceKey:invoiceKey }, global : true, success : function(data) { $("input[name=\'invoiceKey\']").val("' . $value ['iidKey'] . '"); if (data.status == 1) { $("p[node-msg=\"true\"]").html("收款金额超出开票金额 ¥"+data.price+"元,请谨慎操作。"); $("p[node-msg=\"true\"]").show(); } }, error : function(err) { } }); }); </script> '; $i ++; } echo json_encode ( array ( 'status' => 1, 'html' => $html ) ); }
- */
-
- /**
- * 获取一条收款信息
- */
- function ajaxGetInvoiceReceivables() {
- $irid = $this->get_args ( 'key' ) ? $this->get_args ( 'key' ) : "";
- Doo::loadModel ( 'invoiceReceivables' );
- $invoiceReceivables = new invoiceReceivables ();
-
- $detail = $invoiceReceivables->getInvoiceReceivablesByIrid ( $irid );
-
- echo json_encode ( array (
- 'status' => 1,
- 'detail' => $detail
- ) );
- }
-
- /**
- * 异步获取办事处用户
- */
- function ajaxGetStaffByCategory() {
- $cid = $this->get_args ( 'cid' ) ? $this->get_args ( 'cid' ) : "";
- Doo::loadModel ( 'staff' );
- $staff = new staff ();
-
- if ($cid == "PUBLIC") {
- echo json_encode ( array (
- 'status' => 1,
- 'html' => '<option value="PUBLIC">办事处待认领款项</option>'
- ) );
- die ();
- }
-
- if (! is_numeric ( $cid )) {
- echo json_encode ( array (
- 'status' => 0,
- 'msg' => 'illegal request'
- ) );
- die ();
- }
-
- $staffList = $staff->getStaffByCid ( $cid );
-
- $html = '<option value="PUBLIC">办事处待认领款项</option>';
- foreach ( $staffList as $key => $value ) {
- $html .= '<option value="' . $value ['sid'] . '-' . $value ['username'] . '">' . $value ['category'] . '-' . $value ['username'] . '</option>';
- }
-
- echo json_encode ( array (
- 'status' => 1,
- 'html' => $html
- ) );
- }
-
- /**
- * 异步获取一条发票的邮寄信息
- */
- function ajaxGetInvoicePostDetail() {
- $iid = $this->get_args ( 'iidKey' ) ? $this->get_args ( 'iidKey' ) : "";
- Doo::loadModel ( 'invoice' );
- $invoice = new invoice ();
- $iid = $invoice->authcode ( $iid );
- Doo::loadModel ( 'express' );
- $express = new express ();
- $expressList = $express->getExpressByAll ();
-
- if (! is_numeric ( $iid )) {
- echo json_encode ( array (
- 'status' => 0,
- 'msg' => 'illegal request'
- ) );
- die ();
- }
-
- $select = "iid,recipients,recipientsPhone,recipientsAddress,mailItems,expressCompany,expressNumber,actualItems";
- $invoiceDetail = $invoice->getInvoiceByIid ( $iid, $select );
-
- $html = "";
- foreach ( $expressList as $key => $value ) {
- if ($value ['company'] == $invoiceDetail ['expressCompany'])
- $html .= '<option selected value="' . $value ['company'] . ':' . $value ['com'] . '">' . $value ['company'] . '</option>';
- else
- $html .= '<option value="' . $value ['company'] . ':' . $value ['com'] . '">' . $value ['company'] . '</option>';
- }
-
- $invoiceDetail ['eaHtml'] = $html;
-
- echo json_encode ( array (
- 'status' => 1,
- 'invoiceDetail' => $invoiceDetail
- ) );
- }
-
- /**
- *
- * @deprecated --需求变更 废弃 function ajaxCompareClaimPrice() { $irid = $this->get_args ( 'irid' ) ? $this->get_args ( 'irid' ) : ""; $invoiceKey = $this->get_args ( 'invoiceKey' ) ? $this->get_args ( 'invoiceKey' ) : ""; Doo::loadModel ( 'invoice' ); $invoice = new invoice (); Doo::loadModel ( 'invoiceReceivables' ); $invoiceReceivables = new invoiceReceivables (); Doo::loadModel ( 'invoiceOperationLog' ); $invoiceOperationLog = new invoiceOperationLog (); $detail = $invoice->getInvoiceByIid ( $invoiceKey ); $detailM = $invoiceReceivables->getInvoiceReceivablesByIrid ( $irid ); if (empty ( $detail ) || empty ( $detailM )) { echo json_encode ( array ( 'status' => 2, 'msg' => '非法请求,请重新登录' ) ); die (); } $iridString = ""; if (empty ( $detail ['irid'] )) $iridString = $detailM ['irid']; else $iridString = $detail ['irid'] . ',' . $detailM ['irid']; $item = array ( 'irid' => $iridString, 'bindTime' => date ( "Y-m-d H:i:s" ), 'updateTime' => date ( "Y-m-d H:i:s" ), 'iid' => $detail ['iid'] ); $invoice->setInvoiceByCondition ( $item ); // 操作日志 $item = array ( 'date' => date ( "Y-m-d H:i:s" ), 'operation' => "收款入账" . $detailM ['receivablesSerial'] . "到发票" . $detail ['invoiceSerial'], 'status' => 8, 'img' => $this->staff [0] ['avatar'], 'username' => $this->staff [0] ['username'], 'uid' => $this->staff [0] ['sid'], 'category' => $this->staff [0] ['category'], 'iid' => $detail ['iid'] ); $invoiceOperationLog->setInvoiceOperationLog ( $item ); $item = array ( 'iid' => $detail ['iid'], 'irid' => $detailM ['irid'], 'bindDate' => date ( "Y-m-d H:i:s" ), 'bindStatus' => 1 ); $invoiceReceivables->setInvoiceReceivablesByCondition ( $item ); $price = 0; $priceStatus = 0; $isReceivables = 0; $invoiceReceivables = new invoiceReceivables (); $list = $invoiceReceivables->getInvoiceReceivablesInIridString ( $iridString ); if (! empty ( $list )) $isReceivables = 1; $receivablesPrice = 0; foreach ( $list as $key => $value ) { $receivablesPrice += $value ['receivablesPrice']; } if ($receivablesPrice > $detail ['invoicePrice']) { $price = $receivablesPrice - $detail ['invoicePrice']; $priceStatus = 1; } elseif ($receivablesPrice < $detail ['invoicePrice']) { $price = $detail ['invoicePrice'] - $receivablesPrice; $priceStatus = 2; } echo json_encode ( array ( 'status' => 1, 'html' => '<tr><td>¥' . $detailM ['receivablesPrice'] . '</td><td>' . $detailM ['receivablesMessage'] . '</td><td>' . $detailM ['receivablesBank'] . '</td> <td>' . $detailM ['receivablesDate'] . '</td><td><a node-remove="Da' . $detailM ['iridKey'] . '" href="javascript:void(0);">移除</a></td></tr> <script> $(\'a[node-remove="Da' . $detailM ['iridKey'] . '"]\').click(function() { var invoiceKey=$("input[name=\'key\']").val(); var irid= $(this).attr("p-data"); var iridKey="' . $detailM ["iridEn"] . '"; var element=($(this)); $("p[node-loading=\"true\"]").show(); $("p[node-loading=\"true\"]").html("移除处理中..."); $("p[node-msg=\"true2\"]").hide(); $("p[node-msg=\"true\"]").hide(); var url = "/ajaxReceivablesRemove"; $.ajax({ url : url, type : "post", cache : false, dataType : "json", data : { key : iridKey, invoiceKey:invoiceKey }, global : true, success : function(data) { $("input[name=\'invoiceKey\']").val("' . $detailM ['iridEn'] . '"); if (data.status == 1) { $(element).parent().parent().remove(); $("tbody[data-invoice=\"myReceivables\"]").append(data.html); $("p[node-loading=\"true\"]").hide(); if(data.priceStatus == 1){ $("p[node-msg=\"true\"]").html("收款金额超出开票金额 ¥"+data.price+"元,请谨慎操作。"); $("p[node-msg=\"true\"]").show(); }else if(data.priceStatus == 2&& data.isReceivables != 0){ $("p[node-msg=\"true\"]").html("收款金额少于开票金额 ¥"+data.price+"元,请谨慎操作。"); $("p[node-msg=\"true\"]").show(); } }else if(data.status == 2){ $("p[node-loading=\"true\"]").html(data.msg); } }, error : function(err) { } }); }); </script> ', 'price' => $price, 'priceStatus' => $priceStatus, 'isReceivables' => $isReceivables ) ); }
- */
-
- /**
- *
- * @deprecated 从发票中移除已经入账的收款 --需求变更 废弃 function ajaxReceivablesRemove() { $iridKey = $this->get_args ( 'key' ) ? $this->get_args ( 'key' ) : ""; $invoiceKey = $this->get_args ( 'invoiceKey' ) ? $this->get_args ( 'invoiceKey' ) : ""; Doo::loadModel ( 'invoice' ); $invoice = new invoice (); Doo::loadModel ( 'invoiceReceivables' ); $invoiceReceivables = new invoiceReceivables (); Doo::loadModel ( 'invoiceOperationLog' ); $invoiceOperationLog = new invoiceOperationLog (); $detail = $invoice->getInvoiceByIid ( $invoiceKey ); $detailM = $invoiceReceivables->getInvoiceReceivablesByIrid ( $iridKey ); // echo $detail['irid']."<br/>"; $invoiceIrid = explode ( ",", $detail ['irid'] ); foreach ( $invoiceIrid as $key => $value ) { if ($value == $detailM ['irid']) unset ( $invoiceIrid [$key] ); } $invoiceIrid = implode ( ",", $invoiceIrid ); // echo $invoiceIrid."ddd"; // print_r($invoiceIrid); $item = array ( 'irid' => $invoiceIrid, 'iid' => $detail ['iid'] ); $invoice->setInvoiceByCondition ( $item ); $item = array ( 'iid' => 0, 'irid' => $detailM ['irid'], 'bindDate' => '', 'bindStatus' => 0 ); $invoiceReceivables->setInvoiceReceivablesByCondition ( $item ); // 操作日志 $item = array ( 'date' => date ( "Y-m-d H:i:s" ), 'operation' => "收款移除" . $detailM ['receivablesSerial'], 'status' => 10, 'img' => $this->staff [0] ['avatar'], 'username' => $this->staff [0] ['username'], 'uid' => $this->staff [0] ['sid'], 'category' => $this->staff [0] ['category'], 'iid' => $detail ['iid'] ); $invoiceOperationLog->setInvoiceOperationLog ( $item ); $price = 0; $priceStatus = 0; $isReceivables = 0; $invoiceReceivables = new invoiceReceivables (); $list = $invoiceReceivables->getInvoiceReceivablesInIridString ( $invoiceIrid ); if (! empty ( $list )) $isReceivables = 1; $receivablesPrice = 0; foreach ( $list as $key => $value ) { $receivablesPrice += $value ['receivablesPrice']; } if ($receivablesPrice > $detail ['invoicePrice']) { $price = $receivablesPrice - $detail ['invoicePrice']; $priceStatus = 1; } elseif ($receivablesPrice < $detail ['invoicePrice']) { $price = $detail ['invoicePrice'] - $receivablesPrice; $priceStatus = 2; } echo json_encode ( array ( 'status' => 1, 'html' => '<tr id="' . $detailM ['receivablesSerial'] . '" > <td>¥' . $detailM ['receivablesPrice'] . '</td> <td>' . $detailM ['receivablesMessage'] . '</td> <td>' . $detailM ['receivablesBank'] . '</td> <td>' . $detailM ['receivablesDate'] . '</td><td> <a href="javascript:void(0)" node-Claim="true_' . $detailM ['iridKey'] . '" p-data="' . $detailM ['iridEn'] . '" name="invoiceClaim" class="button">入账</a> </td></tr> <script> $(\'a[node-Claim="true_' . $detailM ['iridKey'] . '"]\').click(function() { var invoiceKey=$("input[name=\'key\']").val(); var irid= $(this).attr("p-data"); var element=($(this)); $("p[node-loading=\"true\"]").show(); $("p[node-loading=\"true\"]").html("入账处理中..."); $("p[node-msg=\"true2\"]").hide(); $("p[node-msg=\"true\"]").hide(); var url = "/ajaxCompareClaimPrice"; $.ajax({ url : url, type : "post", cache : false, dataType : "json", data : { irid : irid, invoiceKey:invoiceKey }, global : true, success : function(data) { $("input[name=\'invoiceKey\']").val("' . $detailM ['iridEn'] . '"); if (data.status == 1) { $(element).parent().parent().remove(); $("tbody[box-enter=\"true\"]").append(data.html); $("p[node-loading=\"true\"]").hide(); if(data.priceStatus == 1){ $("p[node-msg=\"true\"]").html("收款金额超出开票金额 ¥"+data.price+"元,请谨慎操作。"); $("p[node-msg=\"true\"]").show(); }else if(data.priceStatus == 2&& data.isReceivables != 0){ $("p[node-msg=\"true\"]").html("收款金额少于开票金额 ¥"+data.price+"元,请谨慎操作。"); $("p[node-msg=\"true\"]").show(); } }else if(data.status == 2){ $("p[node-loading=\"true\"]").html(data.msg); } }, error : function(err) { } }); }); </script> ', 'price' => $price, 'priceStatus' => $priceStatus, 'isReceivables' => $isReceivables ) ); }
- */
-
- /**
- * 我的收款中 选择哪个发票入账,进行金额判断
- */
- function ajaxCompareInvoicePrice() {
- $claimKey = $this->get_args ( 'claimKey' ) ? $this->get_args ( 'claimKey' ) : "";
- $invoiceKey = $this->get_args ( 'invoiceKey' ) ? $this->get_args ( 'invoiceKey' ) : "";
-
- Doo::loadModel ( 'invoice' );
- $invoice = new invoice ();
- Doo::loadModel ( 'invoiceReceivables' );
- $invoiceReceivables = new invoiceReceivables ();
-
- $detail = $invoice->getInvoiceByIid ( $invoiceKey );
-
- $keyList = explode ( ';', $claimKey );
- $receivablesPrice = 0;
- foreach ( $keyList as $key => $value ) {
- $detailM = $invoiceReceivables->getInvoiceReceivablesByIrid ( $value );
- $receivablesPrice += $detailM ['receivablesPrice'];
- }
-
- if ($receivablesPrice > $detail ['invoicePrice']) {
- $price = $receivablesPrice - $detail ['invoicePrice'];
- echo json_encode ( array (
- 'status' => 1,
- 'price' => $price
- ) );
- } else
- echo json_encode ( array (
- 'status' => 2
- ) );
- }
-
- /**
- *
- * @deprecated 获得与我有关收款数据 --需求变更 废弃 function ajaxGetReceivalblesByStaff() { $iid = $this->get_args ( 'key' ) ? $this->get_args ( 'key' ) : ""; Doo::loadModel ( 'invoiceReceivables' ); $invoiceReceivables = new invoiceReceivables (); Doo::loadModel ( 'invoice' ); $invoice = new invoice (); $detail = $invoice->getInvoiceByIid ( $iid ); $list = $invoiceReceivables->getInvoiceReceivablesByClaim ( $this->staff [0] ['cid'], $this->staff [0] ['sid'] ); $html = ""; $i = 1; foreach ( $list ['myClaim'] as $key => $value ) { $html .= '<tr id="' . $value ['receivablesSerial'] . '" > <td>¥' . $value ['receivablesPrice'] . '</td> <td>' . $value ['receivablesMessage'] . '</td> <td>' . $value ['receivablesBank'] . '</td> <td>' . $value ['receivablesDate'] . '</td>'; $html .= '<td> <a href="javascript:void(0)" node-Claim="true_' . $i . '" p-data="' . $value ['iidKey'] . '" name="invoiceClaim" class="button">入账</a> </td></tr> <script> $(\'a[node-Claim="true_' . $i . '"]\').click(function() { var invoiceKey=$("input[name=\'key\']").val(); var irid= $(this).attr("p-data"); var element=($(this)); $("p[node-loading=\"true\"]").show(); $("p[node-loading=\"true\"]").html("入账处理中..."); $("p[node-msg=\"true2\"]").hide(); $("p[node-msg=\"true\"]").hide(); var url = "/ajaxCompareClaimPrice"; $.ajax({ url : url, type : "post", cache : false, dataType : "json", data : { irid : irid, invoiceKey:invoiceKey }, global : true, success : function(data) { $("input[name=\'invoiceKey\']").val("' . $value ['iidKey'] . '"); if (data.status == 1) { $(element).parent().parent().remove(); $("tbody[box-enter=\"true\"]").append(data.html); $("p[node-loading=\"true\"]").hide(); if(data.priceStatus == 1){ $("p[node-msg=\"true\"]").html("收款金额超出开票金额 ¥"+data.price+"元,请谨慎操作。"); $("p[node-msg=\"true\"]").show(); }else if(data.priceStatus == 2&& data.isReceivables != 0){ $("p[node-msg=\"true\"]").html("收款金额少于开票金额 ¥"+data.price+"元,请谨慎操作。"); $("p[node-msg=\"true\"]").show(); } }else if(data.status == 2){ $("p[node-loading=\"true\"]").html(data.msg); } }, error : function(err) { } }); }); </script> '; $i ++; } $html2 = ""; $list2 = $invoiceReceivables->getInvoiceReceivablesByIid ( $iid, 1 ); foreach ( $list2 as $key => $value ) { $html2 .= '<tr id="' . $value ['receivablesSerial'] . '" > <td>¥' . $value ['receivablesPrice'] . '</td> <td>' . $value ['receivablesMessage'] . '</td> <td>' . $value ['receivablesBank'] . '</td> <td>' . $value ['receivablesDate'] . '</td>'; $html2 .= '<td> <a href="javascript:void(0)" node-remove="Da' . $value ['iridKey'] . '" >移除</a> </td></tr> <script> $(\'a[node-remove="Da' . $value ['iridKey'] . '"]\').click(function() { var invoiceKey=$("input[name=\'key\']").val(); var irid= $(this).attr("p-data"); var iridKey="' . $value ["iidKey"] . '"; var element=($(this)); $("p[node-loading=\"true\"]").show(); $("p[node-loading=\"true\"]").html("移除处理中..."); $("p[node-msg=\"true2\"]").hide(); $("p[node-msg=\"true\"]").hide(); var url = "/ajaxReceivablesRemove"; $.ajax({ url : url, type : "post", cache : false, dataType : "json", data : { key : iridKey, invoiceKey:invoiceKey }, global : true, success : function(data) { $("input[name=\'invoiceKey\']").val("' . $value ['iidKey'] . '"); if (data.status == 1) { $(element).parent().parent().remove(); $("tbody[data-invoice=\"myReceivables\"]").append(data.html); $("p[node-loading=\"true\"]").hide(); if(data.priceStatus == 1){ $("p[node-msg=\"true\"]").html("收款金额超出开票金额 ¥"+data.price+"元,请谨慎操作。"); $("p[node-msg=\"true\"]").show(); }else if(data.priceStatus == 2&& data.isReceivables != 0){ $("p[node-msg=\"true\"]").html("收款金额少于开票金额 ¥"+data.price+"元,请谨慎操作。"); $("p[node-msg=\"true\"]").show(); } }else if(data.status == 2){ $("p[node-loading=\"true\"]").html(data.msg); } }, error : function(err) { } }); }); </script> '; $i ++; } $price = 0; $priceStatus = 0; $isReceivables = 0; $list = $invoiceReceivables->getInvoiceReceivablesInIridString ( $detail ['irid'] ); if (! empty ( $list )) $isReceivables = 1; $receivablesPrice = 0; foreach ( $list as $key => $value ) { $receivablesPrice += $value ['receivablesPrice']; } if ($receivablesPrice > $detail ['invoicePrice']) { $price = $receivablesPrice - $detail ['invoicePrice']; $priceStatus = 1; } elseif ($receivablesPrice < $detail ['invoicePrice']) { $price = $detail ['invoicePrice'] - $receivablesPrice; $priceStatus = 2; } echo json_encode ( array ( 'status' => 1, 'html' => $html, 'html2' => $html2, 'price' => $price, 'priceStatus' => $priceStatus, 'isReceivables' => $isReceivables ) ); }
- */
- function ajaxGetInvoiceInfoByType() {
- $type = $this->get_args ( 'type' ) ? $this->get_args ( 'type' ) : "";
- $serial = $this->get_args ( 'serial' ) ? $this->get_args ( 'serial' ) : "";
-
- if (empty ( $serial )) {
- echo json_encode ( array (
- 'status' => 2,
- 'msg' => 'illegal request'
- ) );
- die ();
- }
-
- if ($type == 'INVOICE') {
- Doo::loadModel ( 'invoice' );
- $invoice = new invoice ();
- Doo::loadModel ( 'invoiceOperationLog' );
- $invoiceOperationLog = new invoiceOperationLog ();
-
- $detail = $invoice->getInvoiceByIsid ( $serial, $this->staff [0] ['sid'] );
- $invoiceOperationLogList = $invoiceOperationLog->getInvoiceOperationLogByIid ( $detail ['iid'] );
-
- if (empty ( $detail ))
- $html = '';
- else {
- $html = '
- <div class="modal-dialog modal-lg">
- <div class="modal-content"><div class="modal-header"><h3>发票单详情</h3></div>
- <div class="modal-body saeaList"><table class="table table-bordered table-condensed"><tbody>
- <tr>
- <th class="taC" width="150">开票流水号</th><td>' . $detail ['invoiceSerial'] . '</td>
- <th class="taC" width="150">提交时间</th><td>' . $detail ['date'] . '</td>
- </tr>
- <tr>
- <th class="taC" width="150">所在办事处</th><td>' . $detail ['categoryName'] . '(' . $detail ['userName'] . ')</td>
- <th class="taC" width="150">备注</th><td>' . $detail ['remark'] . '</td>
- </tr>
- <tr>
- <th class="taC">开票金额</th><td><b class="colOrange" style="font-size:18px">¥' . $detail ['invoicePrice'] . '</b></td>
- <th class="taC">开票内容</th><td>' . $detail ['invoiceElement'] . '</td>
- </tr></tbody></table>';
-
- if ($detail ['invoiceType'] == 0)
- $html .= '<table class="table table-bordered table-condensed"><tbody>
- <tr><th colspan="4" class="taC">增值税普通发票</th></tr><tr>
- <th class="taC" width="150">发票抬头</th><td >' . $detail ['invoiceTitle'] . '</td>
- <th class="taC" width="150">纳税人识别码</th><td>' . $detail ['TIN'] . '</td>
- </tr>';
- else
- $html .= '<table class="table table-bordered table-condensed"><tbody>
- <tr><th colspan="4" class="taC">增值税专用发票</th></tr><tr>
- <th class="taC" width="150">单位名称</th><td>' . $detail ['invoiceCompany'] . '</td>
- <th class="taC" width="150">纳税人识别码</th><td>' . $detail ['TIN'] . '</td></tr>
-
- ';
-
- $html .= '<tr>
- <th class="taC">注册地址</th><td>' . $detail ['address'] . '</td>
- <th class="taC">注册电话</th><td>' . $detail ['phone'] . '</td>
- </tr>
- <tr>
- <th class="taC">开户银行</th><td>' . $detail ['bankAccount'] . '</td>
- <th class="taC">银行账户</th><td>' . $detail ['bank'] . '</td>
- </tr></tbody></table>';
-
- if ($detail ['doPost'] == 1)
- $html .= '<table class="table table-bordered table-condensed"><tbody><tr><th colspan="4" class="taC">邮寄信息</th></tr><tr>
- <th class="taC" width="150">收件人</th><td>' . $detail ['recipients'] . '</td>
- <th class="taC" width="150">收件人手机/电话</th><td>' . $detail ['recipientsPhone'] . '</td>
- </tr><tr>
- <th class="taC" width="150">收件地址</th><td colspan="3">' . $detail ['recipientsAddress'] . '</td>
- </tr><tr>
- <th class="taC" width="150">邮寄物品</th><td colspan="3">' . $detail ['mailItems'] . '</td>
- </tr></tbody></table>';
- if (! empty ( $invoiceOperationLogList )) {
- $html .= '<table class="table table-bordered table-condensed"><tbody><tr><th width="60%" class="taC">审批流程</th></tr><tr><td>';
- foreach ( $invoiceOperationLogList as $key => $value ) {
- if ($value ['status'] == 1 || $value ['status'] == 2 || $value ['status'] == 3 || $value ['status'] == 4) {
- $html .= '<blockquote><p><span class="colGray">' . $value ['date'] . '</span>
- ' . $value ['category'] . '-' . $value ['username'] . ' ';
- if ($value ['status'] == 2) {
- $html .= '<span class="colGreen">同意</span>';
- } elseif ($value ['status'] == 3) {
- $html .= '<span class="colOrange">退回</span>';
- } elseif ($value ['status'] == 5) {
- $html .= '<span class="colGreen">打印</span>';
- } elseif ($value ['status'] == 4) {
- $html .= '<span class="colRed">终止</span>';
- }
- $html .= $value ['operation'] . '</p></blockquote>';
- }
- }
- $html .= '</td></tr></tbody></table>';
- }
- $html .= '</div><div class="modal-footer"><a href="#" class="button btn-gray" data-dismiss="modal" aria-hidden="true">关闭</a></div></div></div>';
- }
- echo json_encode ( array (
- 'status' => 1,
- 'html' => $html
- ) );
- die ();
- } elseif ($type == 'RECEIVABLES') {
- Doo::loadModel ( 'invoiceReceivables' );
- $invoiceReceivables = new invoiceReceivables ();
-
- $detail = $invoiceReceivables->getInvoiceReceivablesByIrsid ( $serial, $this->staff [0] ['sid'] );
- if (empty ( $detail ))
- $html = '';
- else {
- $html = '<div class="modal-dialog modal-lg"><div class="modal-content"><div class="modal-header"><h3>收款单详情</h3></div><div class="modal-body saeaList"><table class="table table-bordered table-condensed">
- <tbody><tr>
- <th class="taC">收款流水号</th><td>' . $detail ['receivablesSerial'] . '</td>
- <th class="taC">录入收款</th><td>' . $detail ['inputStaff'] . ' ' . $detail ['date'] . '</td>
- </tr><tr>
- <th class="taC">收款金额</th><td><b>¥' . $detail ['receivablesPrice'] . '</b></td>
- <th class="taC">收款信息</th><td>' . $detail ['receivablesMessage'] . '</td>
- </tr>
- <tr>
- <th class="taC">收款银行</th><td>' . $detail ['receivablesBank'] . '</td>
- <th class="taC">银行到帐</th><td>' . $detail ['receivablesDate'] . '</td>
- </tr>
- <tr>
- <th class="taC">认领收款</th><td colspan="3">' . $detail ['inputStaff'] . ' 转入 ' . $detail ['username'] . ' ' . $detail ['bindDate'] . '</td>
- </tr>
- </tbody></table></div><div class="modal-footer"><a href="#" class="button btn-gray" data-dismiss="modal" aria-hidden="true">关闭</a></div></div></div>';
- }
- echo json_encode ( array (
- 'status' => 1,
- 'html' => $html
- ) );
- die ();
- } elseif ($type == 'IRTC') {
-
- Doo::loadModel ( 'invoice' );
- $invoice = new invoice ();
- Doo::loadModel ( 'invoiceOperationLog' );
- $invoiceOperationLog = new invoiceOperationLog ();
-
- $detail = $invoice->getInvoiceByIsid ( $serial, $this->staff [0] ['sid'] );
- $invoiceOperationLogList = $invoiceOperationLog->getInvoiceOperationLogByIid ( $detail ['iid'] );
-
- if (empty ( $detail ))
- $html = '';
- else {
- $html = '
- <table class="table table-bordered table-condensed"><tbody>
- <tr>
- <th class="taC" width="150">开票流水号</th><td>' . $detail ['invoiceSerial'] . '</td>
- <th class="taC" width="150">提交时间</th><td>' . $detail ['date'] . '</td>
- </tr>
- <tr>
- <th class="taC" width="150">所在办事处</th><td>' . $detail ['categoryName'] . '(' . $detail ['userName'] . ')</td>
- <th class="taC" width="150">备注</th><td>' . $detail ['remark'] . '</td>
- </tr>
- <tr>
- <th class="taC">开票金额</th><td><b class="colOrange" style="font-size:18px">¥' . $detail ['invoicePrice'] . '</b></td>
- <th class="taC">开票内容</th><td>' . $detail ['invoiceElement'] . '</td>
- </tr></tbody></table>';
-
- if ($detail ['invoiceType'] == 0)
- $html .= '<table class="table table-bordered table-condensed"><tbody>
- <tr><th colspan="4" class="taC">增值税普通发票</th></tr><tr>
- <th class="taC" width="150">发票抬头</th><td >' . $detail ['invoiceTitle'] . '</td>
- <th class="taC" width="150">纳税人识别码</th><td>' . $detail ['TIN'] . '</td>
- </tr>';
- else
- $html .= '<table class="table table-bordered table-condensed"><tbody>
- <tr><th colspan="4" class="taC">增值税专用发票</th></tr><tr>
- <th class="taC" width="150">单位名称</th><td>' . $detail ['invoiceCompany'] . '</td>
- <th class="taC" width="150">纳税人识别码</th><td>' . $detail ['TIN'] . '</td></tr>
-
- ';
-
- $html .= '<tr>
- <th class="taC">注册地址</th><td>' . $detail ['address'] . '</td>
- <th class="taC">注册电话</th><td>' . $detail ['phone'] . '</td>
- </tr>
- <tr>
- <th class="taC">开户银行</th><td>' . $detail ['bankAccount'] . '</td>
- <th class="taC">银行账户</th><td>' . $detail ['bank'] . '</td>
- </tr></tbody></table>';
-
- if ($detail ['doPost'] == 1)
- $html .= '<table class="table table-bordered table-condensed"><tbody><tr><th colspan="4" class="taC">邮寄信息</th></tr><tr>
- <th class="taC" width="150">收件人</th><td>' . $detail ['recipients'] . '</td>
- <th class="taC" width="150">收件人手机/电话</th><td>' . $detail ['recipientsPhone'] . '</td>
- </tr><tr>
- <th class="taC" width="150">收件地址</th><td colspan="3">' . $detail ['recipientsAddress'] . '</td>
- </tr><tr>
- <th class="taC" width="150">邮寄物品</th><td colspan="3">' . $detail ['mailItems'] . '</td>
- </tr></tbody></table>';
- if (! empty ( $invoiceOperationLogList )) {
- $html .= '<table class="table table-bordered table-condensed"><tbody><tr><th width="60%" class="taC">审批流程</th></tr><tr><td>';
- foreach ( $invoiceOperationLogList as $key => $value ) {
- if ($value ['status'] == 1 || $value ['status'] == 2 || $value ['status'] == 3 || $value ['status'] == 4) {
- $html .= '<blockquote><p><span class="colGray">' . $value ['date'] . '</span>
- ' . $value ['category'] . '-' . $value ['username'] . ' ';
- if ($value ['status'] == 2) {
- $html .= '<span class="colGreen">同意</span>';
- } elseif ($value ['status'] == 3) {
- $html .= '<span class="colOrange">退回</span>';
- } elseif ($value ['status'] == 5) {
- $html .= '<span class="colGreen">打印</span>';
- }
- $html .= $value ['operation'] . '</p></blockquote>';
- }
- }
- $html .= '</td></tr></tbody></table>';
- }
- }
- echo json_encode ( array (
- 'status' => 1,
- 'html' => $html,
- 'iidKey' => $serial
- ) );
- die ();
- }
- }
- function ajaxGetInvoiceReceivablesByStaff() {
- $postData = $this->get_args ( 'postData' ) ? $this->get_args ( 'postData' ) : "";
-
- if (empty ( $postData )) {
- echo json_encode ( array (
- 'status' => 2,
- 'msg' => 'illegal request'
- ) );
- die ();
- }
-
- Doo::loadModel ( 'invoiceReceivables' );
- $invoiceReceivables = new invoiceReceivables ();
-
- $detail = $invoiceReceivables->getInvoiceReceivablesByIrid ( $postData );
- if (empty ( $detail )) {
- echo json_encode ( array (
- 'status' => 2,
- 'msg' => 'illegal request'
- ) );
- die ();
- }
-
- Doo::loadModel ( 'L_category' );
- $lCategory = new L_category ();
- Doo::loadModel ( 'staff' );
- $staff = new staff ();
-
- $staffList = $staff->getStaffByCid ( $detail ['cid'] );
- $category = $lCategory->getCategory ();
-
- $categoryHtml = '<option post-data="PUBLIC" value="PUBLIC" >公共待认领款项</option>';
- $staffHtml = '<option value="PUBLIC">办事处待认领款项</option>';
- foreach ( $category as $key => $value ) {
- $categoryHtml .= '<option post-data="' . $value ['cid'] . '" value="' . $value ['cid'] . ':' . $value ['title'] . '" >' . $value ['title'] . '</option>';
- if ($value ['cid'] == $detail ['cid'])
- $categoryHtml .= '<option selected post-data="' . $value ['cid'] . '" value="' . $value ['cid'] . ':' . $value ['title'] . '" >' . $value ['title'] . '</option>';
- }
- foreach ( $staffList as $key => $value ) {
- $staffHtml .= '<option value="' . $value ['sid'] . '-' . $value ['username'] . '">' . $value ['category'] . '-' . $value ['username'] . '</option>';
- if ($value ['sid'] == $detail ['sid'])
- $staffHtml .= '<option selected value="' . $value ['sid'] . '-' . $value ['username'] . '">' . $value ['category'] . '-' . $value ['username'] . '</option>';
- }
-
- $rbankHtml = '<option value="广发银行珠海分行柠溪支行">广发银行珠海分行柠溪支行</option>';
-
- echo json_encode ( array (
- 'status' => 1,
- 'categoryHtml' => $categoryHtml,
- 'staffHtml' => $staffHtml,
- 'rbankHtml' => $rbankHtml,
- 'detail' => $detail
- ) );
- }
- function ajaxGetInvoiceReceivablesByIrid() {
- $irid = $this->get_args ( 'irid' ) ? $this->get_args ( 'irid' ) : "";
-
- if (empty ( $irid )) {
- echo json_encode ( array (
- 'status' => 2,
- 'msg' => 'illegal request'
- ) );
- die ();
- }
-
- Doo::loadModel ( 'invoiceReceivables' );
- $invoiceReceivables = new invoiceReceivables ();
- Doo::loadModel ( 'invoice' );
- $invoice = new invoice ();
-
- $detail = $invoiceReceivables->getInvoiceReceivablesByIrid ( $irid ); // 入账完成 待定 and postStatus=1
- $invoiceDetail = $invoice->getInvoiceByTitle ( $detail ['recepitTitleMark'], 'EXACTLY', " and status=2 and printStatus=1 and untreadStatus=0 " ); //
-
- $receivablesHtml = '<table class="table table-bordered table-condensed"><tbody><tr><th class="taC" width="70">收款金额</th><th class="taC">银行到帐信息</th><th class="taC">银行/到帐时间</th><th class="taC">收款认领</th><th class="taC">开票单位</th></tr>
- <tr>
- <td><b>¥' . $detail ['receivablesPrice'] . '</b></td>
- <td>' . $detail ['receivablesMessage'] . '</td>
- <td>' . $detail ['receivablesBank'] . '<br>' . $detail ['receivablesDate'] . '</td>
- <td>' . $detail ['title'] . '-' . $detail ['username'] . '<br>' . $detail ['confirmTime'] . '</td>
- <td>' . $detail ['recepitTitleMark'] . '</td>
- </tr></tbody></table>';
-
- $isInvoice = false;
- $invoiceHtml = '';
- if (empty ( $invoiceDetail )) {
- $isInvoice = true;
- } else {
- $invoiceHtml = '<table class="table table-bordered table-condensed">
- <thead><tr><th>开票单位(抬头)</th><th>开票金额</th><th>提交开票</th><th>出票</th><th>开票流水号</th><th width="80">入账</th></tr></thead><tbody><tr>';
- if (! empty ( $invoiceDetail ['invoiceType'] )) {
- $invoiceHtml .= '<td>' . $invoiceDetail ['invoiceCompany'] . '</td>';
- } else {
- $invoiceHtml .= '<td>' . $invoiceDetail ['invoiceTitle'] . '</td>';
- }
-
- if (! empty ( $invoiceDetail ['invoiceType'] )) {
- $invoiceHtml .= '<td>' . $invoiceDetail ['invoicePrice'] . '专</td>';
- } else {
- $invoiceHtml .= '<td>' . $invoiceDetail ['invoicePrice'] . '</td>';
- }
-
- $invoiceHtml .= '
- <td>' . $invoiceDetail ['categoryName'] . $invoiceDetail ['userName'] . ' ' . $invoiceDetail ['date'] . '</td>
- <td>' . $invoiceDetail ['printer'] . ' ' . $invoiceDetail ['printTime'] . '</td>
- <td>' . $invoiceDetail ['invoiceSerial'] . '</td><td><a class="button btn-block" bind-receivables="ir' . $invoiceDetail ['iidKeyXD'] . '" data-ikey="' . $invoiceDetail ['iidKey'] . '" href="javascript:void(0)">入账</a></td>
- </tr>
- ';
- $invoiceHtml .= '</tbody></table>
-
-
- <script>
- $(\'a[bind-receivables="ir' . $invoiceDetail ['iidKeyXD'] . '"]\').click(function() {
- $("input[name=\'invoiceKey\']").val("' . $invoiceDetail ['iidKey'] . '");
- var invoiceKey=$("input[name=\'invoiceKey\']").val();
- if(invoiceKey==""){
- alert("入账错误,请重新刷新页面");
- return false;
- }
- if(window.confirm("确定入账吗?")){
- $("#IBR").submit();
- }else{
- return false;
- }
- });
- </script>
-
-
- ';
- }
-
- echo json_encode ( array (
- 'status' => 1,
- 'irkey' => $detail ['iridEn'],
- 'receivablesHtml' => $receivablesHtml,
- 'isInvoice' => $isInvoice,
- 'invoiceHtml' => $invoiceHtml
- ) );
- }
- function ajaxGetInvoiceReceivablesByTitle() {
- $title = $this->get_args ( 'title' ) ? $this->get_args ( 'title' ) : "";
-
- if (empty ( $title )) {
- echo json_encode ( array (
- 'status' => 2,
- 'msg' => 'illegal request'
- ) );
- die ();
- }
-
- Doo::loadModel ( 'invoice' );
- $invoice = new invoice ();
-
- $invoiceDetail = $invoice->getInvoiceByTitle ( $title, 'EXACTLY', " and status=2 and printStatus=1 and untreadStatus=0 " );
-
- $invoiceHtml = '';
- if (! empty ( $invoiceDetail )) {
- $invoiceHtml = '<table class="table table-bordered table-condensed">
- <thead><tr><th>开票单位(抬头)</th><th>开票金额</th><th>提交开票</th><th>出票</th><th>开票流水号</th><th width="80">入账</th></tr></thead><tbody><tr>';
- if (! empty ( $invoiceDetail ['invoiceType'] )) {
- $invoiceHtml .= '<td>' . $invoiceDetail ['invoiceCompany'] . '</td>';
- } else {
- $invoiceHtml .= '<td>' . $invoiceDetail ['invoiceTitle'] . '</td>';
- }
-
- if (! empty ( $invoiceDetail ['invoiceType'] )) {
- $invoiceHtml .= '<td>' . $invoiceDetail ['invoicePrice'] . '专</td>';
- } else {
- $invoiceHtml .= '<td>' . $invoiceDetail ['invoicePrice'] . '</td>';
- }
-
- $invoiceHtml .= '
- <td>' . $invoiceDetail ['categoryName'] . $invoiceDetail ['userName'] . ' ' . $invoiceDetail ['date'] . '</td>
- <td>' . $invoiceDetail ['printer'] . ' ' . $invoiceDetail ['printTime'] . '</td>
- <td>' . $invoiceDetail ['invoiceSerial'] . '</td><td><a class="button btn-block" bind-receivables="ir' . $invoiceDetail ['iidKeyXD'] . '" data-ikey="' . $invoiceDetail ['iidKey'] . '" href="#">入账</a></td>
- </tr>
- ';
- $invoiceHtml .= '</tbody></table>
-
- <script>
- $(\'a[bind-receivables="ir' . $invoiceDetail ['iidKeyXD'] . '"]\').click(function() {
- $("input[name=\'invoiceKey\']").val("' . $invoiceDetail ['iidKey'] . '");
- var invoiceKey=$("input[name=\'invoiceKey\']").val();
- if(invoiceKey==""){
- alert("入账错误,请重新刷新页面");
- return false;
- }
- if(window.confirm("确定入账吗?")){
- $("#IBR").submit();
- }else{
- return false;
- }
- });
- </script>
- ';
- }
-
- echo json_encode ( array (
- 'status' => 1,
- 'invoiceHtml' => $invoiceHtml
- ) );
- }
- function ajaxInvoicePushNotice() {
- Doo::loadModel ( 'invoice' );
- $invoice = new invoice ();
-
- $approval = $invoice->getOne ( array (
- 'where' => 'status=1 and pendingApprovals=' . $this->staff [0] ['sid'],
- 'desc' => 'iid',
- 'asArray' => true
- ) );
-
- $isNotice = false;
- if (! empty ( $approval ))
- $isNotice = true;
- $response = array (
- 'error' => 0,
- 'isNotice' => $isNotice
- );
-
- echo json_encode ( $response );
- exit ();
- }
- public function ajaxCheckInvoiceNoUniqueness() {
- $invoiceNo = $this->get_args ( 'invoiceNo' ) ? $this->get_args ( 'invoiceNo' ) : "";
-
- Doo::loadModel ( 'invoice' );
- $invoice = new invoice ();
-
- if (! empty ( $invoiceNo )) {
- $info = $invoice->getOne ( array (
- 'where' => "invoiceNo = '" . $invoiceNo . "'",
- 'asArray' => TRUE
- ) );
- if (! empty ( $info )) {
- echo json_encode ( array (
- 'error' => '发票号已存在'
- ) );
- die ();
- } else
- echo json_encode ( array (
- 'ok' => '可以使用!'
- ) );
- die ();
- }
- }
- function _GetFileEXT($filename) {
- $pics = explode ( '.', $filename );
- $num = count ( $pics );
- return $pics [$num - 1];
- }
- function showCache($path = "") {
- // if (file_exists ( $path )) {
- // $htm = file_get_contents ( $path );
- // } else {
- Doo::loadModel ( 'invoiceStatistics' );
- $invoiceStatistics = new invoiceStatistics ();
-
- $isBriefly = $invoiceStatistics->getBrieflyStatistics ();
- $htm = '<tr><th class="taC">' . $isBriefly ['statisticsMonth'] [0] ['month'] . '月累计开票</th>
- <td>¥' . $isBriefly ['statisticsMonth'] [0] ['invoicePrice'] . '</td>
- <th class="taC">' . $isBriefly ['statisticsMonth'] [0] ['month'] . '月累计入账</th>
- <td>¥' . $isBriefly ['statisticsMonth'] [0] ['accountPrice'] . '</td></tr>';
- /*
- * '<tr><th class="taC">今年累计开票</th><td>¥' . $isBriefly ['statisticsYear'] [0] ['invoicePrice'] . '</td> <th class="taC">今年累计入账</th><td>¥' . $isBriefly ['statisticsYear'] [0] ['accountPrice'] . '</td></tr>';
- */
- file_put_contents ( $path, $htm, FILE_APPEND );
- // }
- return $htm;
- }
-
- /**
- * 获取get或者POST值
- *
- * @param string $name 属性名称
- * @return fixed 值
- */
- function get_args($name) {
- if (isset ( $_GET [$name] )) {
- if (is_array ( $_GET [$name] ))
- return $_GET [$name];
- else
- return addslashes ( $_GET [$name] );
- } elseif (isset ( $_POST [$name] )) {
- if (is_array ( $_POST [$name] ))
- return $_POST [$name];
- else
- return addslashes ( $_POST [$name] );
- } else
- return false;
- }
- function SafeFilter(&$arr) {
- $ra = Array (
- '/([\x00-\x08,\x0b-\x0c,\x0e-\x19])/',
- '/script/',
- '/javascript/',
- '/vbscript/',
- '/expression/',
- '/applet/',
- '/meta/',
- '/xml/',
- '/blink/',
- '/link/',
- '/style/',
- '/embed/',
- '/object/',
- '/frame/',
- '/layer/',
- '/title/',
- '/bgsound/',
- '/base/',
- '/onload/',
- '/onunload/',
- '/onchange/',
- '/onsubmit/',
- '/onreset/',
- '/onselect/',
- '/onblur/',
- '/onfocus/',
- '/onabort/',
- '/onkeydown/',
- '/onkeypress/',
- '/onkeyup/',
- '/onclick/',
- '/ondblclick/',
- '/onmousedown/',
- '/onmousemove/',
- '/onmouseout/',
- '/onmouseover/',
- '/onmouseup/',
- '/onunload/'
- );
-
- if (is_array ( $arr )) {
- foreach ( $arr as $key => $value ) {
- if (! is_array ( $value )) {
- if (! get_magic_quotes_gpc ()) // 不对magic_quotes_gpc转义过的字符使用addslashes(),避免双重转义。
- {
- $value = addslashes ( $value ); // 给单引号(')、双引号(")、反斜线(\)与 NUL(NULL 字符)加上反斜线转义
- }
- $value = preg_replace ( $ra, '', $value ); // 删除非打印字符,粗暴式过滤xss可疑字符串
- $arr [$key] = htmlentities ( strip_tags ( $value ) ); // 去除 HTML 和 PHP 标记并转换为 HTML 实体
- } else {
- SafeFilter ( $arr [$key] );
- }
- }
- }
- }
-
- /**
- * Escape String
- *
- * @access public
- * @param string
- * @param bool whether or not the string will be used in a LIKE condition
- * @return string
- */
- function escape_str($str, $like = FALSE) {
- if (is_array ( $str )) {
- foreach ( $str as $key => $val ) {
- $str [$key] = $this->escape_str ( $val, $like );
- }
- return $str;
- }
-
- var_dump ( Doo::db ()->getDbObject () );
- die ();
-
- if (function_exists ( 'mysql_real_escape_string' ) and is_resource ( Doo::db ()->getDbObject () )) { // Doo::db ()->getDbObject()
- $str = mysql_real_escape_string ( $str, Doo::db ()->getDbObject () );
- } elseif (function_exists ( 'mysql_escape_string' )) {
- $str = mysql_escape_string ( $str );
- } else {
- $str = addslashes ( $str );
- }
- // escape LIKE condition wildcards
- if ($like === TRUE) {
- $str = str_replace ( array (
- '%',
- '_'
- ), array (
- '\\%',
- '\\_'
- ), $str );
- }
- return $str;
- }
-
- /**
- * 获得分页数据
- * @param unknown_type $table
- * @param unknown_type $condition
- * @param unknown_type $on_page
- * @param unknown_type $page_size
- */
- function get_page($table = "", $condition = "", $on_page = 1, $page_size = 20, $action = "", $get = "", $other = "page") {
- $page_c = "";
- $page ['previous'] = $this->get_previous ( $on_page );
- $page ['on_page'] = $on_page;
- $total_count = $this->get_table_count ( $table, $condition );
- $total = intval ( $total_count / $page_size );
-
- $page ['total_page'] = ($total_count % $page_size) == 0 ? $total : $total + 1;
- $page ['total_data'] = $total_count;
- $page ['next'] = $on_page == $page ['total_page'] ? $page ['total_page'] : $on_page + 1;
-
- $i = 1;
- $page_max = 1;
- $page_width = 3;
-
- if ($on_page >= $page_width) {
- $page_max = intval ( $on_page / $page_width ) + 1;
- $i = intval ( $on_page / $page_width ) * $page_width - 1;
- }
-
- for(; $i <= $page ['total_page']; $i ++) {
- if ($i == $on_page)
- $page_c .= '<li class="active"><a href="javascript:void(0)">' . $i . '</a></li>';
- else
- $page_c .= '<li><a href="/' . $action . '/' . $i . $get . '">' . $i . '</a></li>';
-
- if ($i == ($page_width * $page_max))
- break;
- }
-
- $page ['page'] = $page_c;
- $page ['lower'] = (-- $on_page) * $page_size;
- return $page;
- }
- /**
- * 获取上一页
- * @param unknown_type $on_page
- */
- function get_previous($on_page = 1) {
- return $on_page != 0 ? $on_page - 1 : $on_page;
- }
- /**
- * 获取总页数
- * @param unknown_type $table
- * @param unknown_type $condition
- */
- public function get_table_count($table = "", $condition = "") {
- // $sql = "select count(*) as count from " . $table . " where 1 " . $condition;
- $sql = "select count(*) as count from " . $table . " where " . $condition;
-
- // echo $sql;die;
- $query = Doo::db ()->query ( $sql );
- $result = $query->fetch ();
- return $result ['count'];
- }
- function isInvoiceNew($type = "GLOBAL") {
- Doo::loadModel ( 'invoice' );
- $invoice = new invoice ();
- Doo::loadModel ( 'invoiceReceivables' );
- $invoiceReceivables = new invoiceReceivables ();
- Doo::loadModel ( 'staff' );
- $staff = new staff ();
-
- $st = $staff->getUserByIdList ( $_COOKIE ["staff"] );
-
- // 我的发票待处理
- $pendingInvoice = $invoice->getOne ( array ( // or (status=2 and printStatus=1 and untreadStatus=0 ) or (status=2 and printStatus=1 and untreadStatus=2 )
- 'where' => "(status=3 or status=4) and isDelete=0 and sid=" . $st [0] ['sid'],
- 'desc' => 'iid',
- 'asArray' => TRUE
- ) );
- // 我的收款待入账
- /*
- * $myClaim = $invoiceReceivables->getOne ( array ( 'where' => " receivablesStaff like '" . $st [0] ['sid'] . "-%' and receivablesCategory like '" . $st [0] ['cid'] . ":%' and bindStatus=0", 'desc' => 'irid', 'asArray' => TRUE ) );
- */
- // 发票审批
- $approval = $invoice->getOne ( array (
- 'where' => 'status=1 and pendingApprovals=' . $st [0] ['sid'],
- 'desc' => 'iid',
- 'asArray' => true
- ) );
- // 发票邮寄
- $post = $invoice->getOne ( array (
- 'where' => "postStatus=0 and doPost=1 and status=2",
- 'asArray' => TRUE
- ) );
- // 发票打印
- $print = $invoice->getOne ( array (
- 'where' => "status=2 and printStatus=0 and moldManage like '%[\"" . $st [0] ['sid'] . "\",%'",
- 'desc' => 'iid',
- 'asArray' => TRUE
- ) );
- // 发票退票
- $untread = $invoice->getOne ( array (
- 'where' => " printStatus=1 and untreadStatus=1 and status=2 ",
- 'asArray' => TRUE
- ) );
-
- $new = array (
- 'GLOBAL' => FALSE,
- 'pendingInvoice' => FALSE,
- // 'myClaim' => FALSE,
- 'approval' => FALSE,
- 'post' => FALSE,
- 'print' => FALSE,
- 'untread' => FALSE
- );
- // || ! empty ( $myClaim )
- if (! empty ( $pendingInvoice ) || ! empty ( $approval ) || ! empty ( $post ) || ! empty ( $print ) || ! empty ( $untread ))
- $new ['GLOBAL'] = TRUE;
- if (! empty ( $pendingInvoice ))
- $new ['pendingInvoice'] = TRUE;
- // if (! empty ( $myClaim ))
- // $new ['myClaim'] = TRUE;
- if (! empty ( $approval ))
- $new ['approval'] = TRUE;
- if (! empty ( $post ))
- $new ['post'] = TRUE;
- if (! empty ( $print ))
- $new ['print'] = TRUE;
- if (! empty ( $untread ))
- $new ['untread'] = TRUE;
- return $new;
- }
- function setWXMsg($rid) {
- Doo::loadModel ( 'invoice' );
- $invoice = new invoice ();
- $invoiceDetail = $invoice->getOne ( array (
- 'where' => 'iid=' . $rid,
- 'asArray' => true
- ) );
-
- if (! empty ( $invoiceDetail )) {
- Doo::loadModel ( 'staff' );
- $staff = new staff ();
- $staffmsg = $staff->getOne ( array (
- 'where' => "sid='" . $invoiceDetail ['sid'] . "'",
- 'asArray' => TRUE
- ) );
- if (! empty ( $staffmsg ['wxid'] )) {
- require_once (SITE_PATH . '/protected/class/client.php');
- $client = new client ( 'http://m.cld.smartcost.com.cn/' );
- $user = $staffmsg ['wxid'];
-
- $expCom = explode ( ":", $invoiceDetail ['expressCompany'] );
- if (empty ( $expCom ))
- $expCom [0] = '';
-
- $msg = '太好了,您的发票' . $invoiceDetail ['invoiceSerial'] . ' 已邮寄 ' . $expCom [0] . ' ,快递号: ' . $invoiceDetail ['expressNumber'];
-
- // $receiptName = '费用';
- // $msg = '';
- // // switch ($receiptDetail ['Rtype']) {
- // // case 0 :
- // // $receiptName = '报销';
- // // break;
- // // case 1 :
- // // $receiptName = '借款';
- // // break;
- // // case 2 :
- // // $receiptName = '对公汇款';
- // // break;
- // // }
-
- // // 单位名称 金额 开票内容 已邮寄,顺丰 123123213
-
- // switch (2) {
- // case 1 :
- // $msg = '太好了,您的' . $receiptName . ' ' . $receiptDetail ['invoiceElement'] . ',¥' . $receiptDetail ['invoicePrice'] . ',已同意支付。';
- // break;
- // case 2 :
- // $msg = '注意,您的' . $receiptName . ' ' . $receiptDetail ['invoiceElement'] . ',¥' . $receiptDetail ['invoicePrice'] . ',已被撤回,请及时处理。';
- // break;
- // case 3 :
- // $msg = '很遗憾,您的' . $receiptName . ' ' . $receiptDetail ['receiptOrder'] . ',¥' . $receiptDetail ['sum'] . ',已被终止。';
- // break;
- // }
-
- $result = $client->SendMsg ( $user, $msg, 'text' );
- }
- }
- }
- }
- ?>
|