123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281128212831284128512861287128812891290129112921293129412951296129712981299130013011302130313041305130613071308130913101311131213131314131513161317131813191320132113221323132413251326132713281329133013311332133313341335133613371338133913401341134213431344134513461347134813491350135113521353135413551356135713581359136013611362136313641365136613671368136913701371137213731374137513761377137813791380138113821383138413851386138713881389139013911392139313941395139613971398139914001401140214031404140514061407140814091410141114121413141414151416141714181419142014211422142314241425142614271428142914301431143214331434143514361437143814391440144114421443144414451446144714481449145014511452145314541455145614571458145914601461146214631464146514661467146814691470147114721473147414751476147714781479148014811482148314841485148614871488148914901491149214931494149514961497149814991500150115021503150415051506150715081509151015111512151315141515151615171518151915201521152215231524152515261527152815291530153115321533153415351536153715381539154015411542154315441545154615471548154915501551155215531554155515561557155815591560156115621563156415651566156715681569157015711572157315741575157615771578157915801581158215831584158515861587158815891590159115921593159415951596159715981599160016011602160316041605160616071608160916101611161216131614161516161617161816191620162116221623162416251626162716281629163016311632163316341635163616371638163916401641164216431644164516461647164816491650165116521653165416551656165716581659166016611662166316641665166616671668166916701671167216731674167516761677167816791680168116821683168416851686168716881689169016911692169316941695169616971698169917001701170217031704170517061707170817091710171117121713171417151716171717181719172017211722172317241725172617271728172917301731173217331734173517361737173817391740174117421743174417451746174717481749175017511752175317541755175617571758175917601761176217631764176517661767176817691770177117721773177417751776177717781779178017811782178317841785178617871788178917901791179217931794179517961797179817991800180118021803180418051806180718081809181018111812181318141815181618171818181918201821182218231824182518261827182818291830183118321833183418351836183718381839184018411842184318441845184618471848184918501851185218531854185518561857185818591860186118621863186418651866186718681869187018711872187318741875187618771878187918801881188218831884188518861887188818891890189118921893189418951896189718981899190019011902190319041905190619071908190919101911191219131914191519161917191819191920192119221923192419251926192719281929193019311932193319341935193619371938193919401941194219431944194519461947194819491950195119521953195419551956195719581959196019611962196319641965196619671968196919701971197219731974197519761977197819791980198119821983198419851986198719881989199019911992199319941995199619971998199920002001200220032004200520062007200820092010201120122013201420152016201720182019202020212022202320242025202620272028202920302031203220332034203520362037203820392040204120422043204420452046204720482049205020512052205320542055205620572058205920602061206220632064206520662067206820692070207120722073207420752076207720782079208020812082208320842085208620872088208920902091209220932094209520962097209820992100210121022103210421052106210721082109211021112112211321142115211621172118211921202121212221232124212521262127212821292130213121322133213421352136213721382139214021412142214321442145214621472148214921502151215221532154215521562157215821592160216121622163216421652166216721682169217021712172217321742175217621772178217921802181218221832184218521862187218821892190219121922193219421952196219721982199220022012202220322042205220622072208220922102211221222132214221522162217221822192220222122222223222422252226222722282229223022312232223322342235223622372238223922402241224222432244224522462247224822492250225122522253225422552256225722582259226022612262226322642265226622672268226922702271227222732274227522762277227822792280228122822283228422852286228722882289229022912292229322942295229622972298229923002301230223032304230523062307230823092310231123122313231423152316231723182319232023212322232323242325232623272328232923302331233223332334233523362337233823392340234123422343234423452346234723482349235023512352235323542355235623572358235923602361236223632364236523662367236823692370237123722373237423752376237723782379238023812382238323842385238623872388238923902391239223932394239523962397239823992400240124022403240424052406240724082409241024112412241324142415241624172418241924202421242224232424242524262427242824292430243124322433243424352436243724382439244024412442244324442445244624472448244924502451245224532454245524562457245824592460246124622463246424652466246724682469247024712472247324742475247624772478247924802481248224832484248524862487248824892490249124922493249424952496249724982499250025012502250325042505250625072508250925102511 |
- <?php
- /**
- * @author darkredz
- */
- class AdminController extends DooController {
- public $staff;
- public $nature = array (
- '1' => '设计',
- '2' => '造价管理',
- '3' => '业主',
- '4' => '交通局',
- '5' => '公路局',
- '6' => '审计',
- '7' => '财政',
- '8' => '审核',
- '9' => '施工',
- '10' => '咨询',
- '11' => '招标代理',
- '12' => '监理',
- '13' => '学校',
- '14' => '个人',
- '15' => '合作伙伴'
- );
- public $tooltip = array (
- '1' => array (
- 'L',
- '点击筛选标签'
- ),
- '2' => array (
- 'M',
- '点击筛选标签'
- ),
- '3' => array (
- 'N',
- '点击筛选标签'
- ),
- '4' => array (
- 'O',
- '点击筛选标签'
- ),
- '5' => array (
- 'P',
- '点击筛选标签'
- ),
- '6' => array (
- 'Q',
- '点击筛选标签'
- ),
- '7' => array (
- 'R',
- '点击筛选标签'
- )
- );
- public $webPath = "http://cld.smartcost.com.cn/upload/emailAnnex/";
- function __construct() {
- if (isset ( $_COOKIE ["adStaff"] )) {
- if (! empty ( $_COOKIE ["adStaff"] )) {
- Doo::loadModel ( 'staff' );
- $staff = new staff ();
- $this->staff = $staff->getUserByIdList ( $_COOKIE ["adStaff"] );
-
- if ($this->staff [0] ['isadmin'] == 1 && $this->staff [0] ['username'] == 'admin') {
- return "/adminoffice";
- }
- }
- }
-
- Doo::loadCore ( 'uri/DooUriRouter' );
- $router = new DooUriRouter ();
- $routeRs = $router->execute ( Doo::app ()->route, Doo::conf ()->SUBFOLDER );
-
- if ($routeRs ['1'] != "adlogin") {
- header ( 'Content-Type:text/html;charset=utf-8' );
- @header ( "Location: /adlogin" );
- }
- }
- function adlogin() {
- $passwork = $this->get_args ( 'passwork' ) ? $this->get_args ( 'passwork' ) : "";
- $uid = $this->get_args ( 'user' ) ? $this->get_args ( 'user' ) : "";
-
- Doo::loadModel ( 'staff' );
- $staff = new staff ();
- Doo::loadClass ( 'XDeode' );
- $XDeode = new XDeode ( 5 );
-
- if (! empty ( $passwork )) {
- $userinfo = $staff->getOne ( array (
- 'where' => "username='admin'",
- 'asArray' => true
- ) );
-
- if (! empty ( $userinfo )) {
- if ($userinfo ['username'] == $uid && $userinfo ['passwork'] == md5 ( $passwork )) {
- setcookie ( "adStaff", $XDeode->encode ( $userinfo ['sid'] ), time () + 36000, "/" );
- return "/adminoffice";
- }
- }
- }
-
- $data ['staff'] = "";
- $data ['login'] = "";
- if (! empty ( $passwork ))
- $data ['login'] = "inputErrow";
-
- $this->render ( "/admin/adminLogin", $data );
- }
- function adout() {
- setcookie ( "adStaff", "", time () - 3600, "/" );
- return "/adlogin";
- }
- function adminPW() {
- $msg = $this->params ['msg'] ? $this->params ['msg'] : "";
-
- $data ['msg'] = "msg";
- $data ['memu'] = "adminpw";
- $data ['staff'] = $this->staff;
- $data ['msg'] = urldecode ( $this->params ['msg'] );
- $this->render ( "/admin/admin-admininfo", $data );
- }
- function upAdP() {
- $opw = $this->get_args ( 'opw' ) ? $this->get_args ( 'opw' ) : "";
- $npw1 = $this->get_args ( 'npw1' ) ? $this->get_args ( 'npw1' ) : "";
- $npw2 = $this->get_args ( 'npw2' ) ? $this->get_args ( 'npw2' ) : "";
-
- if (! empty ( $opw )) {
- Doo::loadModel ( 'staff' );
- $staff = new staff ();
-
- $userinfo = $staff->getOne ( array (
- 'where' => "username='admin'",
- 'asArray' => true
- ) );
-
- if (! empty ( $userinfo )) {
- if ($userinfo ['sid'] == $_COOKIE ["adStaff"] && $userinfo ['passwork'] == md5 ( $opw )) {
- if (($npw1 == $npw2) && ($npw1 != "")) {
- $staff->passwork = md5 ( $npw1 );
- $staff->update ( array (
- 'where' => "sid='" . $_COOKIE ["adStaff"] . "'"
- ) );
- return "/adminpw/" . urlencode ( '密码修改成功' );
- } else
- return "/adminpw/" . urlencode ( '新密码不一致' );
- } else
- return "/adminpw/" . urlencode ( '旧密码不正确' );
- } else
- return "/adminpw/" . urlencode ( '未找到用户' );
- } else
- return "/adminpw/" . urlencode ( '请输入旧密码' );
- }
- function adminoffice() {
- $data ['memu'] = "adminoffice";
-
- $data ['staff'] = $this->staff;
-
- Doo::loadModel ( 'L_category' );
- Doo::loadModel ( 'staff' );
- Doo::loadModel ( 'district' );
-
- $district = new district ();
- $staff = new staff ();
- $L_category = new L_category ();
-
- $data ['category'] = $L_category->getCategory ();
-
- $data ['district'] = $district->get_lv ( 1 );
-
- foreach ( $data ['category'] as $key => $value ) {
- $data ['category'] [$key] ['count'] = $staff->count ( array (
- 'where' => 'cid=' . $value ['cid']
- ) );
- }
-
- $data ['msg'] = urldecode ( $this->params ['msg'] );
- $this->render ( "/admin/admin_group", $data );
- }
- function addCategory() {
- $msg = "添加成功";
-
- $title = $this->get_args ( 'title' ) ? $this->get_args ( 'title' ) : "";
- $district = $this->get_args ( 'district' ) ? $this->get_args ( 'district' ) : "";
-
- if (! empty ( $title ) && ! empty ( $district )) {
- Doo::loadModel ( 'L_category' );
-
- $L_category = new L_category ();
-
- $L_category->title = $title;
-
- $L_category->districtid = $district;
-
- $L_category->insert ();
- } else {
- $msg = "请输入正确的信息";
- }
-
- return "/adminoffice/" . $msg;
- }
- function adminuser() {
- $data ['memu'] = "adminuser";
- $data ['staff'] = $this->staff;
-
- Doo::loadModel ( 'L_category' );
- Doo::loadModel ( 'staff' );
- $staff = new staff ();
- $L_category = new L_category ();
- Doo::loadModel ( 'district' );
- $district = new district ();
- Doo::loadClass ( 'XDeode' );
- $XDeode = new XDeode ( 5 );
-
- $stafflist = $staff->getStaff ();
- foreach ( $stafflist as $key => $value ) {
- $info = $staff->getUserById ( $value ['sid'] );
- $didList = explode ( ',', $info [0] ['did'] );
- $didList = array_filter ( $didList );
- $list = array ();
-
- if (! empty ( $didList )) {
- foreach ( $didList as $k => $v ) {
- array_push ( $list, $XDeode->decode ( $v ) );
- }
- $stafflist [$key] ['idDistrictList'] = $district->getDistrictInId ( implode ( ',', $list ) );
- } else {
- $stafflist [$key] ['idDistrictList'] = array ();
- }
- }
-
- $data ['districtList'] = $district->get_lv ( 1 );
- $data ['category'] = $L_category->getCategory ();
- $data ['stafflist'] = $stafflist;
- $data ['staff'] = $this->staff;
- $this->render ( "/admin/admin_user", $data );
- }
-
- /**
- * 删除省份权限
- */
- function delUserDistrictAuthor() {
- $didKey = isset ( $this->params ['didKey'] ) ? $this->params ['didKey'] : "";
- $sidKey = isset ( $this->params ['sidKey'] ) ? $this->params ['sidKey'] : "";
- if (! empty ( $sidKey ) && ! empty ( $didKey )) {
- Doo::loadClass ( 'XDeode' );
- $XDeode = new XDeode ( 5 );
- Doo::loadModel ( 'staff' );
- $staff = new staff ();
- $sid = $XDeode->decode ( $sidKey );
- $sDetail = $staff->getStaffBySid ( $sid );
- $sDidList = explode ( ',', $sDetail ['did'] );
-
- foreach ( $sDidList as $key => $value ) {
- if ($value == $didKey)
- unset ( $sDidList [$key] );
- }
-
- $staff->did = implode ( ',', $sDidList );
- $staff->sid = $sid;
- $staff->update ();
- return '/edi/user/' . $sid;
- }
- die ( 'illegal request' );
- }
- function adduser() {
- $username = $this->get_args ( 'username' ) ? $this->get_args ( 'username' ) : "";
- $password = $this->get_args ( 'password' ) ? $this->get_args ( 'password' ) : "";
- $cid = is_numeric ( $this->get_args ( 'cid' ) ) ? $this->get_args ( 'cid' ) : 0;
- $hiredate = $this->get_args ( 'hiredate' ) ? $this->get_args ( 'hiredate' ) : "";
- $nature = is_numeric ( $this->get_args ( 'nature' ) ) ? $this->get_args ( 'nature' ) : 1;
-
- $didKey = $this->get_args ( 'didKey' ) ? $this->get_args ( 'didKey' ) : array ();
-
- if (! empty ( $username ) && ! empty ( $password ) && ! empty ( $cid ) && ! empty ( $hiredate ) && ! empty ( $nature )) {
-
- Doo::loadModel ( 'L_category' );
- Doo::loadModel ( 'staff' );
- Doo::loadModel ( 'tag' );
- Doo::loadModel ( 'holidaystaff' );
-
- $staff = new staff ();
- $L_category = new L_category ();
-
- // 加入默认总部分类
- $cagegory = $L_category->getCategoryById ( $cid );
-
- // 根据这个分类加入管理权限
- if ($cagegory [0] ['defult'] == 1) {
- $staff->isadmin = 1;
- }
-
- $staff->username = $username;
- $staff->passwork = md5 ( $password );
- $staff->cid = $cagegory [0] ['cid'];
- $staff->category = $cagegory [0] ['title'];
- $staff->hiredate = $hiredate;
- $staff->nature = $nature;
-
- $staff->did = implode ( ',', $didKey );
-
- $id = $staff->insert ();
-
- $holidaystaff = new HStaff ();
- $holidaystaff->uid = $id;
-
- $holidaystaff->insert ();
-
- $staffmsg = $staff->getUserById ( $id );
- $this->updateAnnualLeave ( $staffmsg [0] );
-
- for($i = 1; $i <= 7; $i ++) {
-
- $tag = new tag ();
- $tag->name = "个人标签";
- $tag->sid = $id;
- $tag->colorid = $i;
- $tag->insert ();
- }
- }
- return "/adminuser";
- }
- function adminEdiUser() {
- $sid = is_numeric ( $this->params ['sid'] ) ? $this->params ['sid'] : 0;
- $msg = isset ( $this->params ['msg'] ) ? $this->params ['msg'] : "";
-
- if (! empty ( $sid )) {
-
- Doo::loadModel ( 'district' );
- $district = new district ();
-
- $data ['msg'] = urldecode ( $msg );
- Doo::loadModel ( 'L_category' );
- $L_category = new L_category ();
- Doo::loadModel ( 'staff' );
- $staff = new staff ();
- Doo::loadClass ( 'XDeode' );
- $XDeode = new XDeode ( 5 );
-
- $info = $staff->getUserById ( $sid );
- $didList = explode ( ',', $info [0] ['did'] );
- $didList = array_filter ( $didList );
- $list = array ();
- if (! empty ( $didList )) {
- foreach ( $didList as $key => $value ) {
- array_push ( $list, $XDeode->decode ( $value ) );
- }
- $idDistrictList = $district->getDistrictInId ( implode ( ',', $list ) );
- } else {
- $idDistrictList = array ();
- }
- $data ['idDistrictList'] = $idDistrictList;
- $data ['districtList'] = $district->get_lv ( 1 );
- $data ['newPw'] = '';
- $data ['staffInfo'] = $info;
- $data ['category'] = $L_category->getCategory ();
- $data ['staff'] = $this->staff;
- $data ['memu'] = "adminuser";
- $this->render ( "/admin/admin_EdiUser", $data );
- } else
- return "/adminuser";
- }
- function adminResetUserPw() {
- $sid = is_numeric ( $this->params ['sid'] ) ? $this->params ['sid'] : 0;
- $msg = isset ( $this->params ['msg'] ) ? $this->params ['msg'] : "";
- if (! empty ( $sid )) {
-
- $data ['msg'] = urldecode ( $msg );
- Doo::loadModel ( 'L_category' );
- Doo::loadModel ( 'staff' );
- $staff = new staff ();
- $L_category = new L_category ();
-
- $newPw = $this->getRandChar ( 6 );
- $staff->sid = $sid;
- $staff->passwork = md5 ( $newPw );
- $staff->update ();
-
- $data ['newPw'] = $newPw;
- $data ['staffInfo'] = $staff->getUserById ( $sid );
- $data ['category'] = $L_category->getCategory ();
- $data ['staff'] = $this->staff;
- $data ['memu'] = "adminuser";
- $this->render ( "/admin/admin_EdiUser", $data );
- } else
- return "/adminuser";
- }
- function adminDoEdiUser() {
- $sid = is_numeric ( $this->get_args ( 'sid' ) ) ? $this->get_args ( 'sid' ) : 0;
- $cid = is_numeric ( $this->get_args ( 'cid' ) ) ? $this->get_args ( 'cid' ) : 0;
- $gender = $this->get_args ( 'gender' ) ? $this->get_args ( 'gender' ) : "";
- $qq = is_numeric ( $this->get_args ( 'qq' ) ) ? $this->get_args ( 'qq' ) : 0;
- $phone = $this->get_args ( 'phone' ) ? $this->get_args ( 'phone' ) : "";
- $telephone = $this->get_args ( 'telephone' ) ? $this->get_args ( 'telephone' ) : "";
- $email = $this->get_args ( 'email' ) ? $this->get_args ( 'email' ) : "";
- $username = $this->get_args ( 'username' ) ? $this->get_args ( 'username' ) : "";
- $nature = $this->get_args ( 'nature' ) ? $this->get_args ( 'nature' ) : "";
- $hiredate = $this->get_args ( 'hiredate' ) ? $this->get_args ( 'hiredate' ) : "";
-
- if (! empty ( $sid )) {
- $msg = "";
-
- Doo::loadModel ( 'L_category' );
- Doo::loadModel ( 'staff' );
-
- $staff = new staff ();
- $L_category = new L_category ();
-
- $categoryInfo = $L_category->getCategoryById ( $cid );
-
- $staff->sid = $sid;
-
- if ($cid != 0) {
- $staff->cid = $categoryInfo [0] ['cid'];
- $staff->category = $categoryInfo [0] ['title'];
- }
-
- if ($categoryInfo [0] ['defult'] == 1) {
- $staff->isadmin = 1;
- } else {
- $staff->isadmin = 0;
- }
-
- if (! empty ( $username ))
- $staff->username = $username;
- if (! empty ( $gender ))
- $staff->gender = $gender;
-
- if (! empty ( $qq ) && is_numeric ( $qq ))
- $staff->qq = $qq;
-
- if (! empty ( $phone ))
- $staff->phone = $phone;
-
- if (! empty ( $telephone ))
- $staff->telephone = $telephone;
-
- if (! empty ( $email ) && filter_var ( $email, FILTER_VALIDATE_EMAIL ))
- $staff->email = $email;
- else
- $msg = "邮箱不正确";
-
- if (! empty ( $hiredate ))
- $staff->hiredate = $hiredate;
-
- $staff->nature = $nature;
-
- $staff->update ();
-
- $staffmsg = $staff->getUserById ( $sid );
- $this->updateAnnualLeave ( $staffmsg [0] );
-
- return "/edi/user/" . $sid . "/" . $msg;
- } else {
- return "/adminuser";
- }
- }
- function adminDoAddCategory() {
- $sid = is_numeric ( $this->get_args ( 'sid' ) ) ? $this->get_args ( 'sid' ) : 0;
- $cid = is_numeric ( $this->get_args ( 'cid' ) ) ? $this->get_args ( 'cid' ) : 0;
-
- if (! empty ( $sid )) {
- Doo::loadModel ( 'L_category' );
- Doo::loadModel ( 'staff' );
- $staff = new staff ();
- $L_category = new L_category ();
-
- $stfInfo = $staff->getOne ( array (
- 'where' => 'sid =' . $sid,
- 'asArray' => true
- ) );
- if ($stfInfo ['cid'] == $cid)
- return "/adminuser";
-
- $othcid = explode ( ',', $stfInfo ['othercid'] );
- if (in_array ( $cid, $othcid ))
- return "/adminuser";
-
- array_push ( $othcid, $cid );
- $strCid = implode ( ',', array_filter ( $othcid ) );
- $catename = $L_category->getCategoryById ( $cid );
- $othcategory = explode ( ',', $stfInfo ['othercategory'] );
- array_push ( $othcategory, $catename [0] ['title'] );
- $strcategory = implode ( ',', array_filter ( $othcategory ) );
- $staff->sid = $sid;
- $staff->othercid = $strCid;
- $staff->othercategory = $strcategory;
- $staff->update ();
- }
- return "/adminuser";
- }
- function adminDeleteUser() {
- $sid = is_numeric ( $this->params ['sid'] ) ? $this->params ['sid'] : 0;
- if (! empty ( $sid )) {
- Doo::loadModel ( 'staff' );
- $staff = new staff ();
- $staff->sid = $sid;
- $staff->delete ();
-
- Doo::loadModel ( 'holidaystaff' );
- $hstaff = new HStaff ();
- $hstaff->uid = $sid;
- $hstaff->delete ();
- }
- return "/adminuser";
- }
- function adminproduct() {
- $data ['memu'] = "adminproduct";
- $data ['staff'] = $this->staff;
-
- Doo::loadModel ( 'product' );
- Doo::loadModel ( 'longle' );
-
- $product = new product ();
- $longle = new longle ();
-
- $data ['product'] = $product->getProudct ();
- foreach ( $data ['product'] as $key => $value ) {
- $data ['product'] [$key] ['count'] = $longle->count ( array (
- 'where' => 'product="' . $value ['title'] . '"'
- ) );
- }
-
- $this->render ( "/admin/admin_product", $data );
- }
- function addproduct() {
- $title = $this->get_args ( 'title' ) ? $this->get_args ( 'title' ) : "";
-
- if (! empty ( $title )) {
- Doo::loadModel ( 'product' );
- $product = new product ();
- $product->title = $title;
- $product->insert ();
- }
- return "/adminproduct";
- }
- function adminDeleteProduct() {
- $pid = is_numeric ( $this->params ['pid'] ) ? $this->params ['pid'] : 0;
- if (! empty ( $pid )) {
- Doo::loadModel ( 'product' );
- $product = new product ();
- $product->pid = $pid;
- $product->delete ();
- }
- return "/adminproduct";
- }
- function adminEdiProduct() {
- $pid = is_numeric ( $this->params ['pid'] ) ? $this->params ['pid'] : 0;
- $msg = isset ( $this->params ['msg'] ) ? $this->params ['msg'] : "";
-
- if (! empty ( $pid )) {
- $data ['msg'] = urldecode ( $msg );
- Doo::loadModel ( 'product' );
- $product = new product ();
-
- $data ['productInfo'] = $product->getProductById ( $pid );
-
- $data ['memu'] = "adminproduct";
- $data ['staff'] = $this->staff;
- $this->render ( "/admin/admin_EdiProduct", $data );
- } else
- return "/adminproduct";
- }
- function adminDoEdiProduct() {
- $pid = is_numeric ( $this->get_args ( 'pid' ) ) ? $this->get_args ( 'pid' ) : "";
- $title = $this->get_args ( 'title' ) ? $this->get_args ( 'title' ) : "";
- $typeid = $this->get_args ( 'typeid' ) ? $this->get_args ( 'typeid' ) : "";
- if (! empty ( $pid ) && ! empty ( $title ) && ! empty ( $typeid )) {
- $msg = "";
- Doo::loadModel ( 'product' );
- $product = new product ();
- $product->pid = $pid;
- $product->title = $title;
- $product->typeid = $typeid;
- $product->update ();
- return "/adminproduct";
- } else {
- return "/adminproduct";
- }
- }
- function adminverify() {
- Doo::loadModel ( 'staff' );
- Doo::loadModel ( "verify" );
- $verify = new verify ();
- $staff = new staff ();
- Doo::loadModel ( "role" );
- $role = new role ();
-
- $data ['staffList'] = $staff->find ( array (
- 'select' => 'username,sid,avatar',
- 'asArray' => true
- ) );
- $list = $verify->find ( array (
- 'asArray' => true
- ) );
- $roleList = $role->find ( array (
- 'asArray' => true
- ) );
-
- foreach ( $roleList as $key => $value ) {
- $staffList = json_decode ( $value ['staff'] );
-
- foreach ( $staffList as $k => $v ) {
- $staffList [$k] = substr ( strstr ( $v, '_' ), 1 );
- }
-
- $roleList [$key] ['staff'] = implode ( ',', $staffList );
- }
-
- foreach ( $list as $key => $value ) {
- $name = json_decode ( $value ['staff'] );
- $list [$key] ['staff'] = "";
- foreach ( $name as $k => $v ) {
- if ($v [1] == 'ROLE') {
- $roleInfo = $role->getOne ( array (
- 'where' => 'rid = "' . $v [0] . '"',
- 'asArray' => true
- ) );
- $v [1] = $roleInfo ['name'];
- }
- $list [$key] ['staff'] .= " " . $v [1];
- }
- }
-
- $data ['roleList'] = $roleList;
- $data ['verify'] = $list;
- $data ['memu'] = "verify";
- $data ['adminReceiptMenu'] ='adminverify';
- $data ['staff'] = $this->staff;
-
- $this->render ( "/admin/admin_reportGroup", $data );
- }
- function addVerify() {
- $description = $this->get_args ( 'description' ) ? $this->get_args ( 'description' ) : "";
- $staff = $this->get_args ( 'staff' ) ? $this->get_args ( 'staff' ) : "";
-
- $uidlist = $this->get_args ( 'uidlist' ) ? $this->get_args ( 'uidlist' ) : "";
-
- $uidlist = explode ( ",", $uidlist );
-
- Doo::loadModel ( "role" );
- $role = new role ();
-
- $list = array ();
- foreach ( $uidlist as $key => $value ) {
- $info = explode ( ":", $value );
- if ($info [1] == 'ROLE') {
- $roleInfo = $role->getOne ( array (
- 'where' => 'rid = "' . $info [0] . '"',
- 'asArray' => true
- ) );
- array_push ( $info, $roleInfo ['staff'] );
- }
- array_push ( $list, $info );
- }
-
- if (! empty ( $description ) && ! empty ( $list )) {
- Doo::loadModel ( "verify" );
- $verify = new verify ();
-
- $verify->description = $description;
- $verify->staff = json_encode ( $list );
- $verify->insert ();
- }
-
- return "/adminverify";
- }
- function adminRole() {
- Doo::loadModel ( 'staff' );
- $staff = new staff ();
- Doo::loadModel ( "verify" );
- $verify = new verify ();
- Doo::loadModel ( "role" );
- $role = new role ();
-
- $data ['staffList'] = $staff->find ( array (
- 'select' => 'username,sid,avatar',
- 'asArray' => true
- ) );
- $list = $verify->find ( array (
- 'asArray' => true
- ) );
- $roleList = $role->find ( array (
- 'asArray' => true
- ) );
-
- foreach ( $list as $key => $value ) {
- $name = json_decode ( $value ['staff'] );
- $list [$key] ['staff'] = "";
- foreach ( $name as $k => $v ) {
- $list [$key] ['staff'] .= " " . $v [1];
- }
- }
-
- foreach ( $roleList as $key => $value ) {
- $staff = json_decode ( $value ['staff'] );
-
- foreach ( $staff as $k => $v ) {
- // print_r($info);
- // $staff[$k]=substr(strstr($v, '_'), 1);
- $info = explode ( '_', $v );
- $staff [$k] = $info;
- }
- $roleList [$key] ['list'] = $staff;
- }
-
- $data ['roleList'] = $roleList;
- $data ['verify'] = $list;
- $data ['memu'] = "verify";
- $data ['staff'] = $this->staff;
- $data ['adminReceiptMenu'] ='adminRole';
- $this->render ( "/admin/adminReportGroupRole", $data );
- }
- function addRole() {
- $name = $this->get_args ( 'title' ) ? $this->get_args ( 'title' ) : "";
- $staff = $this->get_args ( 'staff' ) ? $this->get_args ( 'staff' ) : "";
-
- $list = array ();
- foreach ( $staff as $key => $value ) {
- $na = explode ( ":", $value );
- array_push ( $list, $na [0] . '_' . $na [1] );
- }
-
- if (! empty ( $name ) && ! empty ( $list )) {
- Doo::loadModel ( "role" );
- $role = new role ();
-
- $role->name = $name;
- $role->staff = json_encode ( $list );
- $role->insert ();
- }
- return "/adminRole";
- }
- function delRole() {
- $rid = isset ( $this->params ['rid'] ) ? $this->params ['rid'] : 0;
-
- if (! empty ( $rid )) {
- Doo::loadModel ( "role" );
- $role = new role ();
- $role->delete ( array (
- 'where' => 'rid="' . $rid . '"'
- ) );
- }
- return "/adminRole";
- }
- function updateRole() {
- $oldStaff = $this->get_args ( 'oldStaff' ) ? $this->get_args ( 'oldStaff' ) : "";
- $newStaff = $this->get_args ( 'newStaff' ) ? $this->get_args ( 'newStaff' ) : "";
- $rid = $this->get_args ( 'rid' ) ? $this->get_args ( 'rid' ) : "";
-
- if (! empty ( $oldStaff ) && ! empty ( $newStaff ) && ! empty ( $rid )) {
- Doo::loadModel ( "role" );
- $role = new role ();
-
- $roleInfo = $role->getOne ( array (
- 'where' => 'rid = "' . $rid . '"',
- 'asArray' => true
- ) );
-
- $staffList = json_decode ( $roleInfo ['staff'], true );
-
- foreach ( $staffList as $key => $value ) {
- if ($value == $oldStaff) {
- $staffList [$key] = $newStaff;
- break;
- }
- }
-
- $role->staff = json_encode ( $staffList );
- $role->update ( array (
- 'where' => 'rid = "' . $rid . '"'
- ) );
- }
- return "/adminRole";
- }
- function adminExecute() {
- Doo::loadModel ( 'staff' );
- $staff = new staff ();
- Doo::loadModel ( "execute" );
- $execute = new execute ();
-
- $data ['staffList'] = $staff->find ( array (
- 'select' => 'username,sid,avatar',
- 'asArray' => true
- ) );
- $list = $execute->find ( array (
- 'asArray' => true
- ) );
-
- $execute = array (
- '借款执行人' => '',
- '借款费用执行人' => '',
- '报销单执行人' => '',
- '对公汇款执行人' => '',
- '培训班结算' => ''
- );
- foreach ( $list as $key => $value ) {
- $name = json_decode ( $value ['staff'] );
- $staffString = "";
- if (! empty ( $name )) {
- foreach ( $name as $k => $v ) {
-
- $staffString .= " " . $v [1] . '<a href="javascript:if(window.confirm(\'确认删除?\'))window.location=\'/delExecute/' . $v [0] . '/' . $value ['eid'] . '\'" title="删除" class="icon-">k</a>';
- }
- }
- foreach ( $execute as $k => $v ) {
- if ($k == $value ['mold']) {
- $execute [$k] = $name = $staffString;
- }
- }
- }
- // print_r($execute);die;
- $data ['execute'] = $execute;
- $data ['memu'] = "verify";
- $data ['adminReceiptMenu'] ='adminExecute';
- $data ['staff'] = $this->staff;
-
- $this->render ( "/admin/adminCarriedout", $data );
- }
- function addExecute() {
- $mold = $this->get_args ( 'mold' ) ? $this->get_args ( 'mold' ) : "";
- $staff = $this->get_args ( 'staff' ) ? $this->get_args ( 'staff' ) : "";
-
- if (! empty ( $mold ) && ! empty ( $staff )) {
- Doo::loadModel ( "execute" );
- $execute = new execute ();
-
- $executeInfo = $execute->getOne ( array (
- 'where' => 'mold ="' . $mold . '" ',
- 'asArray' => true
- ) );
- if (empty ( $executeInfo )) {
-
- $list = array ();
- foreach ( $staff as $key => $value ) {
- $info = explode ( ":", $value );
- array_push ( $list, $info );
- }
-
- $execute->mold = $mold;
- $execute->staff = json_encode ( $list );
-
- $execute->insert ();
- } else {
- $list = json_decode ( $executeInfo ['staff'], true );
-
- foreach ( $staff as $k => $v ) {
- $info = explode ( ":", $v );
- foreach ( $list as $key => $value ) {
- if ($value [1] == $info [1]) {
- unset ( $staff [$k] );
- break;
- }
- }
- }
- foreach ( $staff as $k => $v ) {
- $info = explode ( ":", $v );
- array_push ( $list, $info );
- }
-
- $execute->staff = json_encode ( $list );
- $execute->update ( array (
- 'where' => 'eid = ' . $executeInfo ['eid']
- ) );
- }
- }
- if ($mold == '日常收支')
- return "/adminPaymentsAuthority";
- else
- return "/adminExecute";
- }
- function delExecute() {
- $uid = isset ( $this->params ['uid'] ) && is_numeric ( $this->params ['uid'] ) ? $this->params ['uid'] : 0;
- $eid = isset ( $this->params ['eid'] ) && is_numeric ( $this->params ['eid'] ) ? $this->params ['eid'] : 0;
-
- if (! empty ( $uid ) && ! empty ( $eid )) {
- Doo::loadModel ( "execute" );
- $execute = new execute ();
-
- $executeInfo = $execute->getOne ( array (
- 'where' => 'eid ="' . $eid . '" ',
- 'asArray' => true
- ) );
- if (empty ( $executeInfo ))
- return "/adminExecute";
-
- $ini = array ();
- $list = json_decode ( $executeInfo ['staff'], true );
- foreach ( $list as $k => $v ) {
- if ($v [0] == $uid) {
- $ini = $list [$k];
- unset ( $list [$k] );
- break;
- }
- }
-
- file_put_contents ( "protected/config/execute/execute.ini", "," . $ini [0], FILE_APPEND );
-
- $execute->staff = json_encode ( $list );
- $execute->update ( array (
- 'where' => 'eid = ' . $executeInfo ['eid']
- ) );
- }
- if ($executeInfo ['mold'] == '日常收支')
- return "/adminPaymentsAuthority";
- else
- return "/adminExecute";
- }
-
- // 日常收支权限
- function adminPaymentsAuthority() {
- Doo::loadModel ( 'staff' );
- $staff = new staff ();
- Doo::loadModel ( "execute" );
- $execute = new execute ();
-
- $data ['staffList'] = $staff->find ( array (
- 'select' => 'username,sid,avatar',
- 'asArray' => true
- ) );
- $list = $execute->find ( array (
- 'asArray' => true
- ) );
-
- $execute = array (
- '日常收支' => ''
- );
- foreach ( $list as $key => $value ) {
- $name = json_decode ( $value ['staff'] );
- $staffString = "";
- if (! empty ( $name )) {
- foreach ( $name as $k => $v ) {
-
- $staffString .= " " . $v [1] . '<a href="javascript:if(window.confirm(\'确认删除?\'))window.location=\'/delExecute/' . $v [0] . '/' . $value ['eid'] . '\'" title="删除" class="icon-">k</a>';
- }
- }
- foreach ( $execute as $k => $v ) {
- if ($k == $value ['mold']) {
- $execute [$k] = $name = $staffString;
- }
- }
- }
- // print_r($execute);die;
- $data ['execute'] = $execute;
- $data ['memu'] = "verify";
- $data ['adminReceiptMenu'] ='adminPaymentsAuthority';
- $data ['staff'] = $this->staff;
-
- $this->render ( "/admin/adminPaymentsAuthority", $data );
- }
-
- /**
- * 添加讲师
- */
- function adminReceiptLecturer() {
- Doo::loadModel ( 'staff' );
- $staff = new staff ();
- Doo::loadModel ( "lecturer" );
- $lecturer = new lecturer ();
-
- Doo::loadModel ( 'L_category' );
- $category = new L_category ();
- $categoryList = $category->getCategory ();
-
- $data ['staffList'] = $staff->find ( array (
- 'select' => 'username,sid,avatar',
- 'asArray' => true
- ) );
- $list = $lecturer->getLecturerAll();
-
- $staffList = $staff->getStaff ();
-
- $lecturerList = array (
- '外聘' => '',
- '员工' => ''
- );
-
- foreach ( $lecturerList as $k => $v ) {
- foreach ( $list as $key => $value ) {
- if ($k == $value ['mold']) {
- $staffString = " " . $value ['staff'] . '<a href="javascript:if(window.confirm(\'确认删除?\'))window.location=\'/adminReceiptLecturerDelDo/' . $value ['lidKey'] . '\'" title="删除" class="icon-">k</a>';
- $lecturerList [$k] .= $staffString;
- }
- }
- }
-
- $invoiceStaff = array ();
- foreach ( $categoryList as $key => $value ) {
- $invoiceStaff [$value ['cidKey']] = array ();
- foreach ( $staffList as $k => $v ) {
- $ul = array ();
- if ($value ['cid'] == $v ['cid']) {
- array_push ( $ul, $v ['sidKey'] );
- array_push ( $ul, $v ['username'] );
- array_push ( $invoiceStaff [$value ['cidKey']], $ul );
- }
- }
- }
-
- $data ['invoiceStaff'] = json_encode ( $invoiceStaff );
-
- // print_r($execute);die;
- $data ['categoryList'] = $categoryList;
- $data ['lecturerList'] = $lecturerList;
-
- $data ['adminReceiptMenu'] ='adminReceiptLecturer';
- $data ['memu'] = "verify";
- $data ['staff'] = $this->staff;
-
- $this->render ( "/admin/adminReceiptLecturer", $data );
- }
-
- /**
- * 添加讲师
- */
- function adminReceiptLecturerAddDo() {
- $mold = $this->get_args ( 'mold' ) ? $this->get_args ( 'mold' ) : "";
- $sidKey = $this->get_args ( 'sidKey' ) ? $this->get_args ( 'sidKey' ) : "";
- $cidKey = $this->get_args ( 'cidKey' ) ? $this->get_args ( 'cidKey' ) : "";
-
- if (!empty($mold)) {
- Doo::loadModel ( "lecturer" );
- $lecturer = new lecturer ();
- if ($mold=='员工'){
- if (! empty ( $cidKey ) && ! empty ( $sidKey )){
- Doo::loadClass ( 'XDeode' );
- $XDeode = new XDeode ( 5 );
- Doo::loadModel ( 'staff' );
- $staff = new staff ();
- Doo::loadModel ( 'L_category' );
- $category = new L_category ();
-
- $cid = $XDeode->decode ( $cidKey );
- $sid = $XDeode->decode ( $sidKey );
- if (! is_numeric ( $cid ) || ! is_numeric ( $sid ))
- die ( 'illegal request' );
-
- $detail=$staff->getStaffBySid($sid);
- $cateDetail=$category->getCategoryById($cid);
-
- $lecturer->cid=$cid;
- $lecturer->sid=$sid;
- $lecturer->staff=$detail['username'];
- $lecturer->mold='员工';
- $lecturer->category=$cateDetail[0]['title'];
- $lecturer->ltype='INSIDE';
- $lecturer->insert ();
- }
- }elseif($mold=='外聘'){
- $staff = $this->get_args ( 'staff' ) ? $this->get_args ( 'staff' ) : "";
-
- $lecturer->staff=$staff;
- $lecturer->mold='外聘';
- $lecturer->ltype='OUTSIDE';
- $lecturer->insert ();
- }
-
- return '/adminReceiptLecturer';
- }
- die ( 'illegal request' );
- }
-
- /**
- * 删除讲师
- */
- function adminReceiptLecturerDelDo(){
- $lidKey = isset ( $this->params ['lidKey'] ) ? $this->params ['lidKey'] : '';
-
- if (! empty ( $lidKey )) {
- Doo::loadModel ( "lecturer" );
- $lecturer = new lecturer ();
-
- $lecturer->delLecturerByLid( $lidKey );
- }
- return "/adminReceiptLecturer";
-
- }
-
- function adminInvoice() {
- Doo::loadModel ( 'staff' );
- $staff = new staff ();
- Doo::loadModel ( "invoiceManage" );
- $invoiceManage = new invoiceManage ();
-
- $data ['staffList'] = $staff->find ( array (
- 'select' => 'username,sid,avatar',
- 'asArray' => true
- ) );
- $list = $invoiceManage->find ( array (
- 'asArray' => true
- ) );
-
- $execute = array (
- '收款管理' => '',
- '发票审批' => '',
- '发票打印' => '',
- '发票邮寄' => '',
- '发票退票' => '',
- '公司汇总查阅' => '',
- '纸票管理' => ''
- );
- foreach ( $list as $key => $value ) {
- $name = json_decode ( $value ['staff'] );
- $staffString = "";
- if (! empty ( $name )) {
- foreach ( $name as $k => $v ) {
-
- $staffString .= "<span class='tagGroup'> " . $v [1] . '<a href="javascript:if(window.confirm(\'确认删除?\'))window.location=\'/delInvoiceManage/' . $v [0] . '/' . $value ['iid'] . '\'" title="删除" class="icon-">k</a></span>';
- }
- }
- foreach ( $execute as $k => $v ) {
- if ($k == $value ['mold']) {
- $execute [$k] = $name = $staffString;
- }
- }
- }
-
- $data ['invoice'] = $execute;
- $data ['memu'] = "invoice";
- $data ['staff'] = $this->staff;
-
- $this->render ( "/admin/adminInvoice", $data );
- }
- function addInvoiceManage() {
- $mold = $this->get_args ( 'mold' ) ? $this->get_args ( 'mold' ) : "";
- $staff = $this->get_args ( 'staff' ) ? $this->get_args ( 'staff' ) : "";
-
- if (! empty ( $mold ) && ! empty ( $staff )) {
- Doo::loadModel ( "invoiceManage" );
- $execute = new invoiceManage ();
-
- $executeInfo = $execute->getOne ( array (
- 'where' => 'mold ="' . $mold . '" ',
- 'asArray' => true
- ) );
- if (empty ( $executeInfo )) {
-
- $list = array ();
- foreach ( $staff as $key => $value ) {
- $info = explode ( ":", $value );
- array_push ( $list, $info );
- }
-
- $execute->mold = $mold;
- $execute->staff = json_encode ( $list );
-
- $execute->insert ();
- } else {
- $list = json_decode ( $executeInfo ['staff'], true );
-
- foreach ( $staff as $k => $v ) {
- $info = explode ( ":", $v );
- foreach ( $list as $key => $value ) {
- if ($value [1] == $info [1]) {
- unset ( $staff [$k] );
- break;
- }
- }
- }
- foreach ( $staff as $k => $v ) {
- $info = explode ( ":", $v );
- array_push ( $list, $info );
- }
-
- $execute->staff = json_encode ( $list );
- $execute->update ( array (
- 'where' => 'iid = ' . $executeInfo ['iid']
- ) );
- }
- }
- return "/adminInvoice";
- }
-
- /**
- * 发票相关权限配置,把相关组的审批人删除。不会影响已经生成发票数据,修改后只会影响修改后生成的发票数据
- * @return string 返回配置页
- */
- function delInvoiceManage() {
- $uid = isset ( $this->params ['uid'] ) && is_numeric ( $this->params ['uid'] ) ? $this->params ['uid'] : 0;
- $iid = isset ( $this->params ['iid'] ) && is_numeric ( $this->params ['iid'] ) ? $this->params ['iid'] : 0;
-
- if (! empty ( $uid ) && ! empty ( $iid )) {
- Doo::loadModel ( "invoiceManage" );
- $execute = new invoiceManage ();
-
- $executeInfo = $execute->getOne ( array (
- 'where' => 'iid ="' . $iid . '" ',
- 'asArray' => true
- ) );
- if (empty ( $executeInfo ))
- return "/adminInvoice";
-
- $ini = array ();
- $list = json_decode ( $executeInfo ['staff'], true );
- foreach ( $list as $k => $v ) {
- if ($v [0] == $uid) {
- $ini = $list [$k];
- unset ( $list [$k] );
- break;
- }
- }
-
- $fileInvoice = file_get_contents ( "protected/config/invoice/invoice.ini" );
- if (! empty ( $fileInvoice )) {
- $fileInvoice = json_decode ( $fileInvoice, true );
- if (isset ( $fileInvoice [$executeInfo ['mold']] ))
- $fileInvoice [$executeInfo ['mold']] .= "," . $ini [0];
- else
- $fileInvoice [$executeInfo ['mold']] = '';
- $moldArray = explode ( ',', $fileInvoice [$executeInfo ['mold']] );
- $moldArray = array_unique ( $moldArray );
- $fileInvoice [$executeInfo ['mold']] = implode ( ',', $moldArray );
- $fileInvoice = json_encode ( $fileInvoice );
- file_put_contents ( "protected/config/invoice/invoice.ini", $fileInvoice );
- } else {
- $fileInvoice = array (
- $executeInfo ['mold'] => $ini [0]
- );
- $fileInvoice = json_encode ( $fileInvoice );
- file_put_contents ( "protected/config/invoice/invoice.ini", $fileInvoice );
- }
-
- file_put_contents ( "protected/config/execute/invoice.ini", "," . $ini [0], FILE_APPEND );
-
- $execute->staff = json_encode ( $list );
- $execute->update ( array (
- 'where' => 'iid = ' . $executeInfo ['iid']
- ) );
- }
- return "/adminInvoice";
- }
-
- /**
- * 报销单汇总权限配置
- */
- function adminReceiptAuthority() {
- Doo::loadClass ( 'XDeode' );
- $XDeode = new XDeode ( 5 );
- Doo::loadModel ( 'staff' );
- $staff = new staff ();
- Doo::loadModel ( "receiptAuthorityManage" );
- $receiptAuthorityManage = new receiptAuthorityManage ();
- Doo::loadModel ( 'L_category' );
- $category = new L_category ();
-
- $categoryList = $category->getCategory ();
- $managelist = $receiptAuthorityManage->find ( array (
- 'asArray' => true
- ) );
- $staffList = $staff->getStaff ();
-
- $invoiceStaff = array ();
- foreach ( $categoryList as $key => $value ) {
- $invoiceStaff [$value ['cidKey']] = array ();
- $categoryList [$key] ['html'] = '';
- foreach ( $staffList as $k => $v ) {
- $ul = array ();
- if ($value ['cid'] == $v ['cid']) {
- array_push ( $ul, $v ['sidKey'] );
- array_push ( $ul, $v ['username'] );
- array_push ( $invoiceStaff [$value ['cidKey']], $ul );
- }
- }
-
- foreach ( $managelist as $e => $a ) {
- if ($value ['cid'] == $a ['cid']) {
- $name = json_decode ( $a ['staff'] );
- $staffString = "";
- foreach ( $name as $y => $l ) {
- $sidKey = $XDeode->encode ( $l [0] );
- $icidKey = $XDeode->encode ( $a ['icid'] );
- $staffString .= $l [1] . '<a href="javascript:if(window.confirm(\'确认删除?\'))window.location=\'/delReceiptAuthorityManage/' . $sidKey . '/' . $icidKey . '\'" role="button" title="删除" class="icon-">k</a> ';
- }
- $categoryList [$key] ['html'] = $staffString;
- break;
- }
- }
- }
-
- $data ['categoryList'] = $categoryList;
- $data ['invoiceStaff'] = json_encode ( $invoiceStaff );
-
- $data ['memu'] = "verify";
- $data ['adminReceiptMenu'] = "adminReceiptAuthority";
- $data ['staff'] = $this->staff;
- $this->render ( "/admin/adminReceiptAuthority", $data );
- }
-
- /**
- * 添加报销单汇总查看权限
- */
- function addReceiptAuthorityManage() {
- $cidKey = $this->get_args ( 'cidKey' ) ? $this->get_args ( 'cidKey' ) : "";
- $sidKey = $this->get_args ( 'sidKey' ) ? $this->get_args ( 'sidKey' ) : "";
-
- if (! empty ( $cidKey ) && ! empty ( $sidKey )) {
- Doo::loadModel ( "receiptAuthorityManage" );
- $receiptAuthorityManage = new receiptAuthorityManage ();
- Doo::loadClass ( 'XDeode' );
- $XDeode = new XDeode ( 5 );
- Doo::loadModel ( 'staff' );
- $staff = new staff ();
-
- $cid = $XDeode->decode ( $cidKey );
- $sid = $XDeode->decode ( $sidKey );
- if (! is_numeric ( $cid ) || ! is_numeric ( $sid ))
- die ( 'illegal request' );
-
- $icm = $receiptAuthorityManage->getOne ( array (
- 'where' => 'cid =' . $cid,
- 'asArray' => true
- ) );
- $staffDetail = $staff->getStaffBySid ( $sid );
-
- if (empty ( $icm )) {
- $receiptAuthorityManage = new receiptAuthorityManage ();
- $list = array ();
-
- $info = array (
- $staffDetail ['sid'],
- $staffDetail ['username']
- );
- array_push ( $list, $info );
-
- $receiptAuthorityManage->cid = $cid;
- $receiptAuthorityManage->staff = json_encode ( $list );
-
- $receiptAuthorityManage->insert ();
- } else {
- $invoiceCompanyManage = new receiptAuthorityManage ();
- $list = json_decode ( $icm ['staff'], true );
-
- $flag = true;
- foreach ( $list as $key => $value ) {
- if ($value [0] == $sid) {
- $flag = false;
- break;
- }
- }
- if ($flag) {
- $info = array (
- $staffDetail ['sid'],
- $staffDetail ['username']
- );
- array_push ( $list, $info );
- }
- $invoiceCompanyManage->staff = json_encode ( $list );
- $invoiceCompanyManage->update ( array (
- 'where' => 'icid = ' . $icm ['icid']
- ) );
- }
- return '/adminReceiptAuthority';
- }
- die ( 'illegal request' );
- }
-
- /**
- * 去除查看办事处汇总人员
- */
- function delReceiptAuthorityManage() {
- $sidKey = isset ( $this->params ['sidKey'] ) ? $this->params ['sidKey'] : '';
- $icidKey = isset ( $this->params ['icidKey'] ) ? $this->params ['icidKey'] : '';
-
- Doo::loadClass ( 'XDeode' );
- $XDeode = new XDeode ( 5 );
-
- $icid = $XDeode->decode ( $icidKey );
- $sid = $XDeode->decode ( $sidKey );
- if (! is_numeric ( $icid ) || ! is_numeric ( $sid ))
- die ( 'illegal request' );
-
- Doo::loadModel ( "receiptAuthorityManage" );
- $receiptAuthorityManage = new receiptAuthorityManage ();
-
- $icmDetail = $receiptAuthorityManage->getInvoiceCMByIcid ( $icid );
- if (empty ( $icmDetail ))
- die ( 'illegal request' );
-
- $list = json_decode ( $icmDetail ['staff'], true );
-
- foreach ( $list as $k => $v ) {
- if ($v [0] == $sid) {
- unset ( $list [$k] );
- break;
- }
- }
- $invoiceCompanyManage = new receiptAuthorityManage ();
- $invoiceCompanyManage->staff = json_encode ( $list );
- $invoiceCompanyManage->update ( array (
- 'where' => 'icid = ' . $icmDetail ['icid']
- ) );
-
- return '/adminReceiptAuthority';
- }
-
- /**
- * 开票应收款权限设置
- */
- function adminInvoiceCompany() {
- Doo::loadClass ( 'XDeode' );
- $XDeode = new XDeode ( 5 );
- Doo::loadModel ( 'staff' );
- $staff = new staff ();
- Doo::loadModel ( "invoiceCompanyManage" );
- $invoiceCompanyManage = new invoiceCompanyManage ();
- Doo::loadModel ( 'L_category' );
- $category = new L_category ();
-
- $categoryList = $category->getCategory ();
- $managelist = $invoiceCompanyManage->find ( array (
- 'asArray' => true
- ) );
- $staffList = $staff->getStaff ();
-
- $invoiceStaff = array ();
- foreach ( $categoryList as $key => $value ) {
- $invoiceStaff [$value ['cidKey']] = array ();
- $categoryList [$key] ['html'] = '';
- foreach ( $staffList as $k => $v ) {
- $ul = array ();
- if ($value ['cid'] == $v ['cid']) {
- array_push ( $ul, $v ['sidKey'] );
- array_push ( $ul, $v ['username'] );
- array_push ( $invoiceStaff [$value ['cidKey']], $ul );
- }
- }
-
- foreach ( $managelist as $e => $a ) {
- if ($value ['cid'] == $a ['cid']) {
- $name = json_decode ( $a ['staff'] );
- $staffString = "";
- foreach ( $name as $y => $l ) {
- $sidKey = $XDeode->encode ( $l [0] );
- $icidKey = $XDeode->encode ( $a ['icid'] );
- $staffString .= $l [1] . '<a href="javascript:if(window.confirm(\'确认删除?\'))window.location=\'/delInvoiceCompanyManage/' . $sidKey . '/' . $icidKey . '\'" role="button" title="删除" class="icon-">k</a> ';
- }
- $categoryList [$key] ['html'] = $staffString;
- break;
- }
- }
- }
-
- $data ['categoryList'] = $categoryList;
- $data ['invoiceStaff'] = json_encode ( $invoiceStaff );
-
- $data ['memu'] = "invoice";
- $data ['staff'] = $this->staff;
- $this->render ( "/admin/adminInvoiceCompany", $data );
- }
-
- /**
- * 添加办事处查看权限
- */
- function addInvoiceCompanyManage() {
- $cidKey = $this->get_args ( 'cidKey' ) ? $this->get_args ( 'cidKey' ) : "";
- $sidKey = $this->get_args ( 'sidKey' ) ? $this->get_args ( 'sidKey' ) : "";
-
- if (! empty ( $cidKey ) && ! empty ( $sidKey )) {
- Doo::loadModel ( "invoiceCompanyManage" );
- $invoiceCompanyManage = new invoiceCompanyManage ();
- Doo::loadClass ( 'XDeode' );
- $XDeode = new XDeode ( 5 );
- Doo::loadModel ( 'staff' );
- $staff = new staff ();
-
- $cid = $XDeode->decode ( $cidKey );
- $sid = $XDeode->decode ( $sidKey );
- if (! is_numeric ( $cid ) || ! is_numeric ( $sid ))
- die ( 'illegal request' );
-
- $icm = $invoiceCompanyManage->getOne ( array (
- 'where' => 'cid =' . $cid,
- 'asArray' => true
- ) );
- $staffDetail = $staff->getStaffBySid ( $sid );
-
- if (empty ( $icm )) {
- $invoiceCompanyManage = new invoiceCompanyManage ();
- $list = array ();
-
- $info = array (
- $staffDetail ['sid'],
- $staffDetail ['username']
- );
- array_push ( $list, $info );
-
- $invoiceCompanyManage->cid = $cid;
- $invoiceCompanyManage->staff = json_encode ( $list );
-
- $invoiceCompanyManage->insert ();
- } else {
- $invoiceCompanyManage = new invoiceCompanyManage ();
- $list = json_decode ( $icm ['staff'], true );
-
- $flag = true;
- foreach ( $list as $key => $value ) {
- if ($value [0] == $sid) {
- $flag = false;
- break;
- }
- }
- if ($flag) {
- $info = array (
- $staffDetail ['sid'],
- $staffDetail ['username']
- );
- array_push ( $list, $info );
- }
- $invoiceCompanyManage->staff = json_encode ( $list );
- $invoiceCompanyManage->update ( array (
- 'where' => 'icid = ' . $icm ['icid']
- ) );
- }
- return '/adminInvoiceCompany';
- }
- die ( 'illegal request' );
- }
-
- /**
- * 去除查看办事处汇总人员
- */
- function delInvoiceCompanyManage() {
- $sidKey = isset ( $this->params ['sidKey'] ) ? $this->params ['sidKey'] : '';
- $icidKey = isset ( $this->params ['icidKey'] ) ? $this->params ['icidKey'] : '';
-
- Doo::loadClass ( 'XDeode' );
- $XDeode = new XDeode ( 5 );
-
- $icid = $XDeode->decode ( $icidKey );
- $sid = $XDeode->decode ( $sidKey );
- if (! is_numeric ( $icid ) || ! is_numeric ( $sid ))
- die ( 'illegal request' );
-
- Doo::loadModel ( "invoiceCompanyManage" );
- $invoiceCompanyManage = new invoiceCompanyManage ();
-
- $icmDetail = $invoiceCompanyManage->getInvoiceCMByIcid ( $icid );
- if (empty ( $icmDetail ))
- die ( 'illegal request' );
-
- $list = json_decode ( $icmDetail ['staff'], true );
-
- foreach ( $list as $k => $v ) {
- if ($v [0] == $sid) {
- unset ( $list [$k] );
- break;
- }
- }
- $invoiceCompanyManage = new invoiceCompanyManage ();
- $invoiceCompanyManage->staff = json_encode ( $list );
- $invoiceCompanyManage->update ( array (
- 'where' => 'icid = ' . $icmDetail ['icid']
- ) );
-
- return '/adminInvoiceCompany';
- }
-
- /**
- * 开票办事处权限设置
- */
- function adminInvoiceCategory() {
- Doo::loadClass ( 'XDeode' );
- $XDeode = new XDeode ( 5 );
- Doo::loadModel ( 'staff' );
- $staff = new staff ();
- Doo::loadModel ( "invoiceCategoryManage" );
- $invoiceCategoryManage = new invoiceCategoryManage ();
- Doo::loadModel ( 'L_category' );
- $category = new L_category ();
-
- $categoryList = $category->getCategory ();
- $managelist = $invoiceCategoryManage->find ( array (
- 'asArray' => true
- ) );
- $staffList = $staff->getStaff ();
-
- $invoiceStaff = array ();
- foreach ( $categoryList as $key => $value ) {
- $invoiceStaff [$value ['cidKey']] = array ();
- $categoryList [$key] ['html'] = '';
- foreach ( $staffList as $k => $v ) {
- $ul = array ();
- if ($value ['cid'] == $v ['cid']) {
- array_push ( $ul, $v ['sidKey'] );
- array_push ( $ul, $v ['username'] );
- array_push ( $invoiceStaff [$value ['cidKey']], $ul );
- }
- }
-
- foreach ( $managelist as $e => $a ) {
- if ($value ['cid'] == $a ['cid']) {
- $name = json_decode ( $a ['staff'] );
- $staffString = "";
- foreach ( $name as $y => $l ) {
- $sidKey = $XDeode->encode ( $l [0] );
- $icidKey = $XDeode->encode ( $a ['icid'] );
- $staffString .= $l [1] . '<a href="javascript:if(window.confirm(\'确认删除?\'))window.location=\'/delInvoiceCategoryManage/' . $sidKey . '/' . $icidKey . '\'" role="button" title="删除" class="icon-">k</a> ';
- }
- $categoryList [$key] ['html'] = $staffString;
- break;
- }
- }
- }
-
- // print_r($invoiceStaff);
-
- $data ['categoryList'] = $categoryList;
- $data ['invoiceStaff'] = json_encode ( $invoiceStaff );
-
- $data ['memu'] = "invoice";
- $data ['staff'] = $this->staff;
- $this->render ( "/admin/adminInvoiceCategory", $data );
- }
-
- /**
- * 添加办事处查看权限
- */
- function addInvoiceCategoryManage() {
- $cidKey = $this->get_args ( 'cidKey' ) ? $this->get_args ( 'cidKey' ) : "";
- $sidKey = $this->get_args ( 'sidKey' ) ? $this->get_args ( 'sidKey' ) : "";
-
- if (! empty ( $cidKey ) && ! empty ( $sidKey )) {
- Doo::loadModel ( "invoiceCategoryManage" );
- $invoiceCategoryManage = new invoiceCategoryManage ();
- Doo::loadClass ( 'XDeode' );
- $XDeode = new XDeode ( 5 );
- Doo::loadModel ( 'staff' );
- $staff = new staff ();
-
- $cid = $XDeode->decode ( $cidKey );
- $sid = $XDeode->decode ( $sidKey );
- if (! is_numeric ( $cid ) || ! is_numeric ( $sid ))
- die ( 'illegal request' );
-
- $icm = $invoiceCategoryManage->getOne ( array (
- 'where' => 'cid =' . $cid,
- 'asArray' => true
- ) );
- $staffDetail = $staff->getStaffBySid ( $sid );
-
- if (empty ( $icm )) {
- $invoiceCategoryManage = new invoiceCategoryManage ();
- $list = array ();
-
- $info = array (
- $staffDetail ['sid'],
- $staffDetail ['username']
- );
- array_push ( $list, $info );
-
- $invoiceCategoryManage->cid = $cid;
- $invoiceCategoryManage->staff = json_encode ( $list );
-
- $invoiceCategoryManage->insert ();
- } else {
- $invoiceCategoryManage = new invoiceCategoryManage ();
- $list = json_decode ( $icm ['staff'], true );
-
- $flag = true;
- foreach ( $list as $key => $value ) {
- if ($value [0] == $sid) {
- $flag = false;
- break;
- }
- }
- if ($flag) {
- $info = array (
- $staffDetail ['sid'],
- $staffDetail ['username']
- );
- array_push ( $list, $info );
- }
- $invoiceCategoryManage->staff = json_encode ( $list );
- $invoiceCategoryManage->update ( array (
- 'where' => 'icid = ' . $icm ['icid']
- ) );
- }
- return '/adminInvoiceCategory';
- }
- die ( 'illegal request' );
- }
-
- /**
- * 去除查看办事处汇总人员
- */
- function delInvoiceCategoryManage() {
- $sidKey = isset ( $this->params ['sidKey'] ) ? $this->params ['sidKey'] : '';
- $icidKey = isset ( $this->params ['icidKey'] ) ? $this->params ['icidKey'] : '';
-
- Doo::loadClass ( 'XDeode' );
- $XDeode = new XDeode ( 5 );
-
- $icid = $XDeode->decode ( $icidKey );
- $sid = $XDeode->decode ( $sidKey );
- if (! is_numeric ( $icid ) || ! is_numeric ( $sid ))
- die ( 'illegal request' );
-
- Doo::loadModel ( "invoiceCategoryManage" );
- $invoiceCategoryManage = new invoiceCategoryManage ();
-
- $icmDetail = $invoiceCategoryManage->getInvoiceCMByIcid ( $icid );
- if (empty ( $icmDetail ))
- die ( 'illegal request' );
-
- $list = json_decode ( $icmDetail ['staff'], true );
-
- foreach ( $list as $k => $v ) {
- if ($v [0] == $sid) {
- unset ( $list [$k] );
- break;
- }
- }
- $invoiceCategoryManage = new invoiceCategoryManage ();
- $invoiceCategoryManage->staff = json_encode ( $list );
- $invoiceCategoryManage->update ( array (
- 'where' => 'icid = ' . $icmDetail ['icid']
- ) );
-
- return '/adminInvoiceCategory';
- }
- function ajaxRoleStaff() {
- $name = $this->get_args ( 'name' ) ? $this->get_args ( 'name' ) : "";
-
- Doo::loadModel ( 'staff' );
- $staff = new staff ();
-
- $staffList = $staff->find ( array (
- 'select' => 'username,sid,avatar',
- 'where' => 'username != "' . $name . '" and username !="admin"',
- 'asArray' => true
- ) );
-
- $html = '';
- foreach ( $staffList as $key => $value ) {
- $html .= '<option value=' . $value ['sid'] . '_' . $value ['username'] . '>' . $value ['username'] . '</option>';
- }
-
- echo json_encode ( array (
- "success" => true,
- 'html' => $html
- ) );
- die ();
- }
- function loadCVS() {
- $key = $this->get_args ( 'key' ) ? $this->get_args ( 'key' ) : "";
-
- Doo::loadModel ( 'longle' );
- $longle = new longle ();
- $list = $longle->find ( array (
- 'where' => 'SerialNumber=""',
- 'select' => 'key_num',
- 'asArray' => TRUE
- ) );
-
- $file = fopen ( DOO::conf ()->SITE_PATH . "upload/" . $key . ".csv", 'r' );
-
- while ( $data = fgetcsv ( $file ) ) {
- $goods_list [$data [0]] = $data [1];
- }
- fclose ( $file );
-
- // print_r($goods_list);
-
- $sqlArray = array ();
- $sql = 'UPDATE CLD_longle SET SerialNumber = CASE key_num ';
- foreach ( $list as $key => $value ) {
-
- if (array_key_exists ( $value ['key_num'], $goods_list )) {
- // echo $value['key_num'].'-'.$goods_list[$value['key_num']].'<br/>';
- // $longle->SerialNumber=$goods_list[$value['key_num']];
- // $longle->update(array('where'=>'key_num="'.$value['key_num'].'"'));
- $sql .= ' WHEN "' . $value ['key_num'] . '" THEN "' . $goods_list [$value ['key_num']] . '" ';
-
- array_push ( $sqlArray, '"' . $value ['key_num'] . '"' );
- unset ( $goods_list [$value ['key_num']] );
- }
- }
- $sql .= 'END WHERE key_num IN (' . implode ( ',', $sqlArray ) . ')';
- echo $sql; // . '<br/>--------------------------------<br/>';
- foreach ( $goods_list as $key => $value ) {
- // echo $key . ',' . $value . '<br/>';
- }
- }
- private function getRandChar($length) {
- $str = null;
- $strPol = "ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789abcdefghijklmnopqrstuvwxyz";
- $max = strlen ( $strPol ) - 1;
-
- for($i = 0; $i < $length; $i ++) {
- $str .= $strPol [rand ( 0, $max )]; // rand($min,$max)生成介于min和max两个数之间的一个随机整数
- }
-
- return $str;
- }
- private function getReceiptCount() {
- $status = 2;
- $year = date ( 'Y' );
-
- Doo::loadModel ( 'receipt' );
- $receipt = new receipt ();
- Doo::loadModel ( 'verify' );
- $verify = new verify ();
-
- // user verify ID
- $vidList = array ();
- $verifyDetail = $verify->find ( array (
- 'where' => 'staff like "%\"' . $this->staff [0] ['sid'] . '\"%"',
- 'asArray' => true
- ) );
- foreach ( $verifyDetail as $key => $value ) {
- array_push ( $vidList, $value ['vid'] );
- }
- $vid = implode ( ",", $vidList );
- if (empty ( $verifyDetail ))
- $vid = 0;
-
- $dateCondition = " and Year(date) =" . $year;
- $approvalCondition = ' and verifyStaff not like "%\"' . $this->staff [0] ['sid'] . '\":{%" ';
-
- $receiptList = $receipt->find ( array (
- 'where' => 'verify in(' . $vid . ') and status=' . $status . $dateCondition . $approvalCondition,
- 'desc' => 'rid',
- 'asArray' => true
- ) );
-
- return count ( $receiptList );
- }
-
- /**
- * 格式化excel文件为数组
- * @param unknown_type $file_url
- * @param unknown_type $mcid
- */
- function _format_excel_to_array($file_url = "") {
- if (! file_exists ( $file_url ))
- return array ();
-
- Doo::loadClass ( 'PHPExcel' );
-
- $PHPExcel = new PHPExcel ();
-
- $PHPReader = new PHPExcel_Reader_Excel2007 ();
-
- if (! $PHPReader->canRead ( $file_url )) {
- $PHPReader = new PHPExcel_Reader_Excel5 ();
- if (! $PHPReader->canRead ( $file_url )) {
-
- echo 'no Excel';
- return;
- }
- }
-
- $PHPExcel = $PHPReader->load ( $file_url );
- /**
- * 读取excel文件中的第一个工作表
- */
- $currentSheet = $PHPExcel->getSheet ( 0 );
- /**
- * 取得最大的列号
- */
- $allColumn = $currentSheet->getHighestColumn ();
- /**
- * 取得一共有多少行
- */
- $allRow = $currentSheet->getHighestRow ();
-
- $excel_array = array ();
-
- for($currentRow = 2; $currentRow <= $allRow; $currentRow ++) {
-
- $excel_column = array ();
-
- // 后期改进
- if ($allColumn == 'AM')
- $allColumn = 'Z';
-
- /**
- * 从第A列开始输出
- */
- for($currentColumn = 'A'; $currentColumn <= $allColumn; $currentColumn ++) {
-
- $val = $currentSheet->getCellByColumnAndRow ( ord ( $currentColumn ) - 65, $currentRow )->getValue ();
-
- /**
- * ord()将字符转为十进制数 iconv ( 'utf-8', 'gb2312',
- */
- $val = "'" . addslashes ( $val ) . "'";
- if ($currentColumn == 'A')
- $excel_column ['key_num'] = $val;
- elseif ($currentColumn == 'C')
- $excel_column ['product'] = $val;
- elseif ($currentColumn == 'D') {
-
- $val = str_replace ( "'", "", $val );
-
- $excel_column ['make_day'] = $this->excelTime ( $val );
- } elseif ($currentColumn == 'E') {
- $val = str_replace ( "'", "", $val );
-
- $excel_column ['alloted_time'] = $this->excelTime ( $val );
- } elseif ($currentColumn == 'F') {
- $val = str_replace ( "'", "", $val );
-
- $excel_column ['version'] = $val;
- } elseif ($currentColumn == 'B') {
- $val = str_replace ( "'", "", $val );
- $excel_column ['SerialNumber'] = $val;
- }
- }
- array_push ( $excel_array, $excel_column );
- }
-
- return $excel_array;
- }
- function excelTime($date, $time = false) {
- if (function_exists ( 'GregorianToJD' )) {
- if (is_numeric ( $date )) {
- $jd = GregorianToJD ( 1, 1, 1970 );
- $gregorian = JDToGregorian ( $jd + intval ( $date ) - 25569 );
- $date = explode ( '/', $gregorian );
- $date_str = str_pad ( $date [2], 4, '0', STR_PAD_LEFT ) . "-" . str_pad ( $date [0], 2, '0', STR_PAD_LEFT ) . "-" . str_pad ( $date [1], 2, '0', STR_PAD_LEFT ) . ($time ? " 00:00:00" : '');
- return $date_str;
- }
- } else {
- $date = $date > 25568 ? $date + 1 : 25569;
- /* There was a bug if Converting date before 1-1-1970 (tstamp 0) */
- $ofs = (70 * 365 + 17 + 2) * 86400;
- $date = date ( "Y-m-d", ($date * 86400) - $ofs ) . ($time ? " 00:00:00" : '');
- }
- return $date;
- }
- function _GetFileEXT($filename) {
- $pics = explode ( '.', $filename );
-
- $num = count ( $pics );
-
- return $pics [$num - 1];
- }
-
- /**
- * 获取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 get_previous($on_page = 1) {
- return $on_page != 0 ? $on_page - 1 : $on_page;
- }
-
- /**
- * 获得分页数据
- * @param unknown_type $table
- * @param unknown_type $condition
- * @param unknown_type $on_page
- * @param unknown_type $page_size
- */
- function get_Tpage($table = "", $condition = "", $on_page = 1, $page_size = 20, $action = "", $tagSQL) {
- $page_c = "";
- $page ['previous'] = $this->get_previous ( $on_page );
- $page ['on_page'] = $on_page;
- $total_count = $this->get_table_Tcount ( $table, $condition, $tagSQL );
- $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;
- if ($on_page > 10) {
- $page_max = intval ( $on_page / 10 ) + 1;
- $i = intval ( $on_page / 10 ) * 10 - 1;
- }
- $page ['page'] = $page_c;
- $page ['lower'] = (-- $on_page) * $page_size;
- return $page;
- }
-
- /**
- * 获得分页数据
- * @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", $staffid = "", $search, $tooltip, $cateid, $tagSQL) {
- $page_c = "";
-
- $page ['previous'] = $this->get_previous ( $on_page );
-
- $page ['on_page'] = $on_page;
-
- $total_count = $this->get_table_count ( $table, $condition, $staffid, $search, $tooltip, $cateid, $tagSQL );
-
- $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;
-
- if ($on_page > 10) {
- $page_max = intval ( $on_page / 10 ) + 1;
- $i = intval ( $on_page / 10 ) * 10 - 1;
- }
-
- for(; $i <= $page ['total_page']; $i ++) {
-
- if ($i == $on_page) {
- if ($other == "page")
- $page_c .= '<a href="javascript:void(0);" class="current">' . $i . '</a>';
- else
- $page_c .= ' <span class="current">' . $i . '</span> ';
- } else if ($other == "page")
- $page_c .= '<a href="' . $action . $i . $get . '" class="paginate">' . $i . '</a>';
- else
- $page_c .= ' <a href="' . $action . $i . $get . '" class="paginate">' . $i . '</a> ';
- if ($i == (10 * $page_max))
- break;
- }
-
- $page ['page'] = $page_c;
-
- $page ['lower'] = (-- $on_page) * $page_size;
-
- return $page;
- }
-
- /**
- * 获取总页数
- * @param unknown_type $table
- * @param unknown_type $condition
- */
- public function get_table_Tcount($table = "", $condition = "", $tagSQL) {
- if ($tagSQL)
- $sql = "select count(*) as count from CLD_tagCompanyNexus as a left join CLD_company as b on (a.company=b.cid ) where " . $condition;
- else
- $sql = "select count(*) as count from CLD_company where " . $condition;
-
- $query = Doo::db ()->query ( $sql );
- $result = $query->fetch ();
- return $result ['count'];
- }
-
- /**
- * 获取总页数
- * @param unknown_type $table
- * @param unknown_type $condition
- */
- public function get_table_count($table = "", $condition = "", $staffid = "", $search, $tooltip, $cateid, $tagSQL) {
- // $sql = "select count(*) as count from " . $table . " where 1 " . $condition;
- // echo $staffid;die;
- //
- if (! empty ( $staffid )) {
- // $staffid="and a.sid= '".$staffid."'"; " . $table . " as a left join on (a.cid=b.cid ".$staffid.")
- $sql = "select count(*) as count from CLD_client as b left join CLD_tag_client as c on (b.cid=c.client) where 1 " . $condition;
- } else {
- if (strlen ( $condition ) == 1 || empty ( $condition ))
- $sql = "select count(*) as count from CLD_client as a " . $condition;
- else
- $sql = "select count(*) as count from CLD_client as a left join CLD_tag_client as c on (a.cid=c.client) where 1 " . $condition;
- }
-
- if (! empty ( $search ))
- $sql = "select count(*) as count from CLD_client as a where 1 " . $condition;
-
- if (! empty ( $tooltip )) {
- $condition = str_replace ( "a.", "c.", $condition );
- if ($tagSQL)
- $sql = "select count(*) as count from CLD_C_tooltip as a left join CLD_tag_client as c on (a.cid=c.client) left join CLD_client as b on (c.client=b.cid ) where a.name like '%" . $tooltip . "%' and a.cateid = " . $cateid . " " . $condition;
- else
- $sql = "select count(*) as count from CLD_C_tooltip as a left join CLD_client as b on (a.cid=b.cid ) where a.name like '%" . $tooltip . "%' and a.cateid = " . $cateid . " " . $condition;
- }
- // echo $sql;
- $query = Doo::db ()->query ( $sql );
-
- $result = $query->fetch ();
-
- return $result ['count'];
- }
- public function holidayGroup() {
- Doo::loadModel ( 'staff' );
- Doo::loadModel ( "holidayacman" );
- Doo::loadModel ( 'L_category' );
- $L_category = new L_category ();
- $acman = new HACMan ();
- $staff = new staff ();
-
- $data ['staffList'] = $staff->find ( array (
- 'select' => 'username,sid,wxid',
- 'where' => 'cid!=1',
- 'asArray' => true
- ) );
- $acmanlist = $acman->find ( array (
- 'where' => 'type=0',
- 'desc' => 'id',
- 'asArray' => true
- ) );
- if (! empty ( $acmanlist )) {
- foreach ( $acmanlist as $k => $v ) {
- $acmanlist [$k] ['name'] = implode ( '->', explode ( ' ', $v ['name'] ) );
- $category = explode ( ',', $v ['category'] );
- $categoryname = array ();
- if (! empty ( $category )) {
- foreach ( $category as $key => $value ) {
- $name = $L_category->getOne ( array (
- 'where' => 'cid="' . $value . '"',
- 'asArray' => TRUE
- ) );
- array_push ( $categoryname, $name ['title'] );
- }
- }
- $acmanlist [$k] ['categoryname'] = implode ( ',', $categoryname );
- }
- }
-
- // 获取办事处列表
-
- $data ['category'] = $L_category->getCategory ();
- $data ['acmanlist'] = $acmanlist;
- $data ['staff'] = $this->staff;
- $data ['memu'] = 'holiday';
- $data ['noindexjs'] = 'noindexjs';
- $this->render ( "/admin/admin_holidayGroup", $data );
- }
- public function addHolidayApprover() {
- if (! isset ( $_POST ['title'] ) || empty ( $_POST ['title'] )) {
- exit ( '请输入组名' );
- }
- if (! isset ( $_POST ['staff'] ) || empty ( $_POST ['staff'] )) {
- exit ( '请选择成员' );
- }
-
- $idname = $name = $pinyinname = array ();
- $stafflist = explode ( ',', $_POST ['staff'] );
- foreach ( $stafflist as $k => $v ) {
- $msg = explode ( ':', $v );
- array_push ( $idname, $msg [0] );
- array_push ( $name, $msg [1] );
- array_push ( $pinyinname, $msg [2] );
- }
-
- Doo::loadModel ( "holidayacman" );
- $acman = new HACMan ();
- $acman->typename = $_POST ['title'];
- $acman->idname = implode ( ',', $idname );
- $acman->name = implode ( ' ', $name );
- $acman->pinyinname = implode ( '|', $pinyinname );
- $acman->type = 0;
- $result = $acman->insert ();
- if ($result) {
- $acman2 = new HACMan ();
- $acman2->type = $result;
- $acman2->insert ();
-
- Doo::loadModel ( 'holidaystaff' );
- foreach ( $idname as $ik => $iv ) {
- $hstaff = new HStaff ();
- $hstaff->uid = $iv;
- $hstaff->isadmin = 1;
- $hstaff->update ();
- }
- }
- return '/holidaygroup';
- }
- public function setHolidaySee() {
- if (! isset ( $_POST ['groupid'] ) || empty ( $_POST ['groupid'] ) || ! is_numeric ( $_POST ['groupid'] )) {
- exit ( '审批组id出错' );
- }
- $category = ! empty ( $_POST ['category'] ) ? implode ( ',', $_POST ['category'] ) : '';
- Doo::loadModel ( 'holidayacman' );
- $acman = new HACMan ();
- $acman->id = $_POST ['groupid'];
- $acman->category = $category;
- $acman->update ();
-
- return '/holidaygroup';
- }
- public function delHolidayGroup() {
- if (! isset ( $_POST ['approvalid'] ) || empty ( $_POST ['approvalid'] ) || ! is_numeric ( $_POST ['approvalid'] )) {
- exit ( '审批组id出错' );
- }
- Doo::loadModel ( 'holidayacman' );
- $acman = new HACMan ();
- $idname = $acman->getOne ( array (
- 'where' => 'id=' . $_POST ['approvalid'],
- 'asArray' => TRUE
- ) );
- $idname = explode ( ',', $idname ['idname'] );
-
- $acman->id = $_POST ['approvalid'];
- $acman->delete ();
-
- // $acman2 = new HACMan();
- // $acman2->type = $_POST['approvalid'];
- // $acman2->delete();
-
- // 删除管理员资格
- $acman3 = new HACMan ();
- foreach ( $idname as $k => $v ) {
- $same = 0;
- $approverlist = $acman3->find ( array (
- 'where' => 'idname like "%' . $v . '%" and type=0',
- 'asArray' => TRUE
- ) );
- if (! empty ( $approverlist )) {
- foreach ( $approverlist as $ak => $av ) {
- $aidname = explode ( ',', $av ['idname'] );
- foreach ( $aidname as $ik => $iv ) {
- if ($iv == $v) {
- $same = 1;
- break;
- }
- }
- }
- }
- if ($same == 0) {
- Doo::loadModel ( 'holidaystaff' );
- $hstaff = new HStaff ();
- $hstaff->uid = $v;
- $hstaff->isadmin = 0;
- $hstaff->update ();
- }
- }
-
- return '/holidaygroup';
- }
- public function holidayCSGroup() {
- Doo::loadModel ( 'staff' );
- Doo::loadModel ( 'holidayacman' );
- $acman = new HACMan ();
- $staff = new staff ();
-
- $approverlist = $acman->find ( array (
- 'where' => 'type=0',
- 'desc' => 'id',
- 'asArray' => TRUE
- ) );
- if (! empty ( $approverlist )) {
- foreach ( $approverlist as $k => $v ) {
- $csman = $acman->getOne ( array (
- 'where' => 'type=' . $v ['id'],
- 'asArray' => TRUE
- ) );
- if (! empty ( $csman ['name'] )) {
- $idname = explode ( ',', $csman ['idname'] );
- $name = explode ( ' ', $csman ['name'] );
- $pinyinname = explode ( '|', $csman ['pinyinname'] );
- $csmsg = array ();
- foreach ( $idname as $ik => $iv ) {
- $csmsg [$ik] ['csidname'] = $iv;
- $csmsg [$ik] ['csname'] = $name [$ik];
- $csmsg [$ik] ['cspinyinname'] = $pinyinname [$ik];
- }
- $approverlist [$k] ['csmsg'] = $csmsg;
- }
- }
- $data ['approverlist'] = $approverlist;
- }
-
- // 获取总部人员列表
- $zongbu = $staff->getStaffByCid ( 12 );
- $data ['zongbu'] = $zongbu;
-
- // 获取办事处列表
- Doo::loadModel ( 'L_category' );
- $L_category = new L_category ();
- $data ['category'] = $L_category->getCategory ();
-
- $data ['memu'] = 'holiday';
- $data ['noindexjs'] = 'noindexjs';
- $this->render ( "/admin/admin_holidayGroup_cc", $data );
- }
- public function getStaffCategory() {
- if (isset ( $_POST ['cid'] ) && is_numeric ( $_POST ['cid'] )) {
- Doo::loadModel ( 'staff' );
- $staff = new staff ();
- $stafflist = $staff->getStaffByCid ( $_POST ['cid'] );
- exit ( json_encode ( array (
- 'code' => 200,
- 'stafflist' => $stafflist
- ) ) );
- }
- exit ( json_encode ( array (
- 'code' => 400
- ) ) );
- }
- public function addHolidayCS() {
- if (! isset ( $_POST ['approvalid'] ) || empty ( $_POST ['approvalid'] ) || ! is_numeric ( $_POST ['approvalid'] )) {
- exit ( '审批组出错' );
- }
- if (! isset ( $_POST ['cidstaff'] ) || empty ( $_POST ['cidstaff'] )) {
- exit ( '抄送人出错' );
- }
- $cidstaff = explode ( ':', $_POST ['cidstaff'] );
-
- Doo::loadModel ( 'holidayacman' );
- $acman = new HACMan ();
- $csmsg = $acman->getOne ( array (
- 'where' => 'type=' . $_POST ['approvalid'],
- 'asArray' => TRUE
- ) );
- $csidmsg = ! empty ( $csmsg ['idname'] ) ? $csmsg ['idname'] . ',' . $cidstaff [0] : $cidstaff [0];
- $csnamemsg = ! empty ( $csmsg ['name'] ) ? $csmsg ['name'] . ' ' . $cidstaff [1] : $cidstaff [1];
- $cspinyinnamemsg = ! empty ( $csmsg ['pinyinname'] ) ? $csmsg ['pinyinname'] . '|' . $cidstaff [2] : $cidstaff [2];
-
- $acman->id = $csmsg ['id'];
- $acman->idname = $csidmsg;
- $acman->name = $csnamemsg;
- $acman->pinyinname = $cspinyinnamemsg;
- $acman->update ();
-
- Doo::loadModel ( 'holidaystaff' );
- $hstaff = new HStaff ();
- $hstaffmsg = $hstaff->getOne ( array (
- 'where' => 'uid=?',
- 'param' => array (
- $cidstaff [0]
- ),
- 'asArray' => TRUE
- ) );
- if (! empty ( $hstaffmsg ) && $hstaffmsg ['iscc'] == 0) {
- $hstaff->uid = $cidstaff [0];
- $hstaff->iscc = 1;
- $hstaff->update ();
- }
- return '/hcsgroup';
- }
- public function delHolidayCS() {
- if (! isset ( $_POST ['approvalid'] ) || empty ( $_POST ['approvalid'] ) || ! is_numeric ( $_POST ['approvalid'] )) {
- exit ( '审批id出错' );
- }
- if (! isset ( $_POST ['cidstaff'] ) || empty ( $_POST ['cidstaff'] )) {
- exit ( '抄送信息出错' );
- }
- $cidstaff = explode ( ':', $_POST ['cidstaff'] );
-
- Doo::loadModel ( 'holidayacman' );
- $acman = new HACMan ();
- $csmsg = $acman->getOne ( array (
- 'where' => 'type=' . $_POST ['approvalid'],
- 'asArray' => TRUE
- ) );
- if (! empty ( $csmsg ['idname'] )) {
- $idnamearr = explode ( ',', $csmsg ['idname'] );
- foreach ( $idnamearr as $ik => $iv ) {
- if ($iv == $cidstaff [0]) {
- unset ( $idnamearr [$ik] );
- break;
- }
- }
- $csidmsg = implode ( ',', $idnamearr );
- }
- if (! empty ( $csmsg ['name'] )) {
- $namearr = explode ( ' ', $csmsg ['name'] );
- foreach ( $namearr as $nk => $nv ) {
- if ($nv == $cidstaff [1]) {
- unset ( $namearr [$nk] );
- break;
- }
- }
- $csnamemsg = implode ( ' ', $namearr );
- }
- if (! empty ( $csmsg ['pinyinname'] )) {
- $pinyinnamearr = explode ( '|', $csmsg ['pinyinname'] );
- foreach ( $pinyinnamearr as $pk => $pv ) {
- if ($pv == $cidstaff [2]) {
- unset ( $pinyinnamearr [$pk] );
- break;
- }
- }
- $cspinyinnamemsg = implode ( '|', $pinyinnamearr );
- }
-
- $acman->id = $csmsg ['id'];
- if (isset ( $csidmsg )) {
- $acman->idname = $csidmsg;
- }
- if (isset ( $csnamemsg )) {
- $acman->name = $csnamemsg;
- }
- if (isset ( $cspinyinnamemsg )) {
- $acman->pinyinname = $cspinyinnamemsg;
- }
- $acman->update ();
-
- // 删除抄送员资格
- $acman3 = new HACMan ();
- $same = 0;
- $approverlist = $acman3->find ( array (
- 'where' => 'idname like "%' . $cidstaff [0] . '%" and type!=0',
- 'asArray' => TRUE
- ) );
- if (! empty ( $approverlist )) {
- foreach ( $approverlist as $ak => $av ) {
- $aidname = explode ( ',', $av ['idname'] );
- foreach ( $aidname as $ik => $iv ) {
- if ($iv == $cidstaff [0]) {
- $same = 1;
- break;
- }
- }
- }
- }
- if ($same == 0) {
- Doo::loadModel ( 'holidaystaff' );
- $hstaff = new HStaff ();
- $hstaff->uid = $cidstaff [0];
- $hstaff->iscc = 0;
- $hstaff->update ();
- }
-
- return '/hcsgroup';
- }
- public function HolidayAdmin() {
- Doo::loadModel ( 'staff' );
- $staff = new staff ();
- $staffList = $staff->find ( array (
- 'select' => 'username,sid',
- 'where' => 'cid!=1',
- 'asArray' => true
- ) );
-
- Doo::loadModel ( 'holidayadmin' );
- $admin = new HAdmin ();
- $adminList = $admin->find ( array (
- 'asArray' => TRUE
- ) );
-
- if (! empty ( $adminList )) {
- foreach ( $adminList as $k => $v ) {
- foreach ( $staffList as $sk => $sv ) {
- if ($sv ['sid'] == $v ['uid']) {
- array_splice ( $staffList, $sk, 1 );
- break;
- }
- }
- }
- }
-
- $data ['staffList'] = $staffList;
- $data ['adminList'] = $adminList;
- $data ['memu'] = 'holiday';
- $data ['noindexjs'] = 'noindexjs';
- $this->render ( "/admin/admin_holidayuser", $data );
- }
- public function addHolidayAdmin() {
- if (! isset ( $_POST ['staff'] ) || empty ( $_POST ['staff'] )) {
- exit ( '请选择管理人' );
- }
-
- Doo::loadModel ( 'holidayadmin' );
- foreach ( $_POST ['staff'] as $k => $v ) {
- $staffmsg = explode ( ':', $v );
- $admin = new HAdmin ();
- $admin->uid = $staffmsg [0];
- $admin->username = $staffmsg [1];
- $admin->insert ();
- }
- return '/holidayadmin';
- }
- public function delHolidayAdmin() {
- if (! isset ( $_POST ['cidstaff'] ) || empty ( $_POST ['cidstaff'] )) {
- exit ( '请选择管理人删除' );
- }
-
- Doo::loadModel ( 'holidayadmin' );
- $admin = new HAdmin ();
- $admin->id = $_POST ['cidstaff'];
- $admin->delete ();
-
- return '/holidayadmin';
- }
-
- // 检查年假是否过期并更新年假
- private function updateAnnualLeave($staff) {
- Doo::loadModel ( 'holidaystaff' );
- $hstaff = new HStaff ();
- $hstaffmsg = $hstaff->getOne ( array (
- 'where' => 'uid=' . $staff ['sid'],
- 'asArray' => TRUE
- ) );
- $hiredate = $staff ['hiredate'];
- $hadyear = intval ( (time () - strtotime ( $hiredate )) / (86400 * 365) );
- if ($hadyear != $hstaffmsg ['hadyear']) {
- $hstaff->uid = $staff ['sid'];
- $hstaff->hadyear = $hadyear;
- $hstaff->yearnum = $hadyear == 0 ? 0 : (($hadyear < 10 && $hadyear >= 1) ? 5 : (($hadyear >= 10 && $hadyear < 20) ? 10 : 15));
- $hstaff->update ();
- }
- }
- }
- ?>
|