123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967 |
- <?php
- /**
- * @author darkredz
- */
- class SoftController extends DooController {
- public $webPath="http://cld.smartcost.com.cn/upload/emailAnnex/";
- function __construct() {
-
- }
- function longleTest(){
- $this->render ( "/test", array() );
- }
-
- function categoryApi(){
- Doo::loadModel ( 'L_category' );
- $L_category = new L_category ();
- $category=$L_category->getCategoryBySoft();
- header ( 'Content-Type:text/html;charset=utf-8' );
- echo json_encode(array('status'=>1,'categoryList'=>$category),JSON_UNESCAPED_UNICODE);die;
- }
- function productApi(){
- Doo::loadModel ( 'product' );
- $product = new product ();
- $product=$product->getProudct();
- header ( 'Content-Type:text/html;charset=utf-8' );
- echo json_encode(array('status'=>1,'productList'=>$product),JSON_UNESCAPED_UNICODE);die;
- }
-
- function addLockApi(){
- $longleList=isset($_POST['longle'])?$_POST['longle']:"";
- //echo $longleList.'dddd';die;
- header ( 'Content-Type:text/html;charset=utf-8' );
- if($longleList!=""){
- Doo::loadModel ( 'longle' );
- Doo::loadModel ( 'longle_log' );
- //$exlArray=$this->_format_excel_to_array(DOO::conf()->SITE_PATH."upload/".iconv("UTF-8", "GB2312", $path));
- //file_put_contents ( "protected/config/longle.bak", $longleList );
- $longleList=json_decode($longleList,TRUE);
- if (!is_array($longleList)){
- echo json_encode(array('status'=>2,'msg'=>'锁数据不正确'),JSON_UNESCAPED_UNICODE);die;
- }
- //数组格式化,新增字段需要在这新增
- $longleList=$this->array_unique_fb($longleList);
- //$category=$L_category->getCategoryById($cid);
- try {
- Doo::db()->beginTransaction();
- foreach ($longleList as $key=>$value){
- //锁记录
- $longle = new longle ();
- $longle->key_num=$value['key_num'];
- $longle->product=$value['product'];
- $longle->make_day=$value['make_day'];
- $longle->alloted_time=$value['alloted_time'];
- $longle->status=1;
- $longle->statusT="生成";
- $longle->cid=$value['cid'];
- $longle->category=$value['title'];
- $longle->SerialNumber=$value['serialnumber'];
- $longle->version=$value['version'];
- $longle->licences=$value['licences'];
- $lid=$longle->insert();
- //锁日志记录
- $longle_log=new longle_log();
- $longle_log->lid=$lid;
- $longle_log->status=1;
- $longle_log->statusT="生成";
- $longle_log->operator='软件生成';
- $longle_log->product=$longle->product;
- $longle_log->category='总部';
- $longle_log->dateline=date("Y-m-d");
- $id=$longle_log->insert();
- }
- //记录日常行为
- Doo::loadModel("action_log");
- $action_log=new action_log();
- $action_log->action='总部<b href="javascript:void(0)" >软件</b>生成<a href="javascript:void(0)" onclick="showLook(\''.$longleList[0]['key_num'].'\')">'.$longleList[0]['key_num'].'</a>等<b>'.count($longleList).'</b>个锁';
- $action_log->sid=43;
- $action_log->cid=12;
- $action_log->class=$action_log->iconGenerate;
- $action_log->updatetime=date("Y-m-d");
- $action_log->time=date("H:i");
- $action_log->status=11;
- $action_log->insert();
- Doo::db()->commit();
-
-
- } catch (Exception $e) {
- echo json_encode(array('status'=>2,'msg'=>'数据录入发生异常'),JSON_UNESCAPED_UNICODE);
- //print $e->getMessage();
- die;
- }
- echo json_encode(array('status'=>1,'msg'=>'入库'.count($longleList).'个'),JSON_UNESCAPED_UNICODE);die;
- }else{
- echo json_encode(array('status'=>2,'msg'=>'请求参数不正确或者为空'),JSON_UNESCAPED_UNICODE);die;
- }
- }
-
-
- function updateLockApi(){
- /* $serialnumber = $this->get_args ( 'serialnumber' ) ? $this->get_args ( 'serialnumber' ) : "";
- $alloted_time = $this->get_args ( 'alloted_time' ) ? $this->get_args ( 'alloted_time' ) : '';
- $product = $this->get_args ( 'product' ) ? $this->get_args ( 'product' ) : "";
- //$status = $this->get_args ( 'status' ) ? $this->get_args ( 'status' ) : 0;//5升级 10延期
-
- $UpdateStr = $this->get_args ( 'UpdateStr' ) ? $this->get_args ( 'UpdateStr' ) : "";
- $UpdateFile = $this->get_args ( 'UpdateFile' ) ? $this->get_args ( 'UpdateFile' ) : "";
- $AuthorizeStr = $this->get_args ( 'AuthorizeStr' ) ? $this->get_args ( 'AuthorizeStr' ) : "";
- $AuthorizeFile = $this->get_args ( 'AuthorizeFile' ) ? $this->get_args ( 'AuthorizeFile' ) : "";
- $version = $this->get_args ( 'version' ) ? $this->get_args ( 'version' ) : "";
- $licences = $this->get_args ( 'licences' ) ? $this->get_args ( 'licences' ) : ""; */
-
-
- $longleList=isset($_POST['longle'])?$_POST['longle']:"";
- //'[{"serialnumber":"167700074DCEA600","alloted_time":"2020/11/28","version":"年限","AuthorizeStr":"0C534320417574682046696C6564655C53634C6F631E00000080010000762C68DF17103DF2B46828FC9D0A42DE45519A93C56CECD56E6282DCD680997571E19ACFCE497650EFEC739F843033B533B1670F35975FD17A61E539821C0D5EA94C12B8AAD9E5CBDC4BE3F888F559E2210BD512284C2937140131CB7211EDEED2A59E0587A88A664D6BC5B3FD7C5834B5997DC878410103ED4B1B5C111F694EACB8EF5FB4929E8557F2BD074A25966954E3B706195763E8D553BDF64F96FE6E5B94B2AAE91C0EBC5CBD4EF298C75AB923C59C06A962B408C7473E0A9DDCA44592C88471ED273DEBDEDE4491A680D834B579CBB007838AA61FAB5F1DEC0B287C06641A7E4B95C64F69BC18B4F60C5151942473B26C51D5F08A9DA0760987E7F90000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000"}]';//
-
-
- //file_put_contents ( "protected/config/longle.bak", $longleList );
-
- $longleList=json_decode($longleList,TRUE);
-
-
-
- // $file=isset($_POST['file'])?$_POST['file']:"";
- // file_put_contents("protected/config/sites.txt",$file);
-
- header ( 'Content-Type:text/html;charset=utf-8' );
- if (!is_array($longleList)){
- echo json_encode(array('status'=>2,'msg'=>'锁数据不正确'),JSON_UNESCAPED_UNICODE);die;
- }
-
- //数组格式化,新增字段需要在这新增
- $longleList=$this->array_unique_update($longleList);
-
- $serialnumber=$longleList[0]['serialnumber'];
- $alloted_time=$longleList[0]['alloted_time'];
- $product=$longleList[0]['product'];
- $UpdateStr=$longleList[0]['UpdateStr'];
- $UpdateFile='';//$longleList[0]['UpdateFile'];
- $AuthorizeStr='';//$longleList[0]['AuthorizeStr'];
- $AuthorizeFile='';//$longleList[0]['AuthorizeFile'];
-
- $version=$longleList[0]['version'];
- $licences=$longleList[0]['licences'];
- $length=$longleList[0]['length'];
-
- Doo::loadModel ( 'longle' );
- $longle = new longle ();
-
- if (empty($serialnumber)){
- echo json_encode(array('status'=>2,'msg'=>'未找到该锁信息-serialnumber'),JSON_UNESCAPED_UNICODE);
- die;
- }
- $linfo = $longle->getLongleBySerialNumber( $serialnumber );
- if (empty($linfo)){
- echo json_encode(array('status'=>2,'msg'=>'未找到该锁信息-serialnumber2'),JSON_UNESCAPED_UNICODE);
- die;
- }
-
-
- $save_path = DOO::conf ()->SITE_PATH . "upload/longle/";
- $webSite = '/upload/longle/';
- $file_name = $linfo['key_num'].' - '.$serialnumber.'.' . $this->_GetFileEXT ( $_FILES ["file"] ['name'] );
- if (! @move_uploaded_file ( $_FILES ["file"] ["tmp_name"], $save_path . $file_name )){
- echo json_encode(array('status'=>2,'msg'=>'未找到上传文件'),JSON_UNESCAPED_UNICODE);die;
- }else{
- $UpdateFile = $webSite . $file_name;
- }
-
- $strFile=file_get_contents($save_path . $file_name);
- $strFile=substr($strFile , 0 , $length);
- file_put_contents($save_path . $file_name,$strFile);
-
-
- Doo::loadModel ( 'longle_log' );
- $longle_log = new longle_log ();
-
- Doo::loadModel ( 'client' );
- $clientobj = new client ();
- Doo::loadModel ( "action_log" );
-
-
-
-
- if ($product != ""){
- $longle->product = $product;
- }
- $longle->statusT = "升级";
- $longle_log->product = $product;
- $longle_log->statusT = "升级";
-
- $longle_log->client = $linfo ['client'];
- $longle_log->clientid = $linfo ['clientid'];
-
- $clientname = $clientobj->getOne ( array (
- 'where' => "cid= '" . $linfo ['clientid'] . "'",
- 'asArray' => TRUE
- ) );
-
- // 日常行为
- $action_log = new action_log ();
-
- $action_log->action = '软件 为<a href="javascript:void(0)" onclick="showClick(\'' . $linfo ['clientid'] . '\')">' . $linfo ['client'] . '</a>(' . $clientname ['companyname'] . ')升级为<a href="javascript:void(0)" onclick="showLook(\'' . $linfo ['key_num'] . '\')">' . $linfo ['key_num'] . '</a>';
- $action_log->sid = 32;
- $action_log->cid = 12;
- $action_log->updatetime = date ( "Y-m-d" );
- $action_log->time = date ( "H:i" );
- $action_log->class = $action_log->iconUpdate;
- $action_log->status = 7;
-
- $action_log->insert ();
-
-
-
- if(!empty($alloted_time)){
- $longle->alloted_time = $alloted_time;
- }
-
- if(!empty($version)){
- $longle->version=$version;
- }
- if(!empty($licences)){
- $longle->licences=$licences;
- }
- if(!empty($AuthorizeStr)){
- $longle->AuthorizeStr=$AuthorizeStr;
- }
- if(!empty($AuthorizeFile)){
- $longle->AuthorizeFile=$AuthorizeFile;
- }
- if(!empty($UpdateStr)){
- $longle->UpdateStr=$UpdateStr;
- }
- if(!empty($UpdateFile)){
- $longle->UpdateFile=$UpdateFile;
- }
-
- $longle->status = 5;
-
- $longle->lid = $linfo['lid'];
- $longle->update ();
-
- $longle_log->lid = $linfo['lid'];
- $longle_log->status = 5;
- $longle_log->operator = '软件';
-
- // 责任人
- $longle_log->category = '总部';
- $longle_log->dateline = date ( "Y-m-d" );
- $longle_log->insert ();
- echo json_encode(array('status'=>1,'msg'=>'变更成功'),JSON_UNESCAPED_UNICODE);
- die;
- }
-
- function syncLongleData(){
- //$longleList='{"serialnumber":"1676000455CBB200","licences":"0","version":"","AuthorizeStr":"0C534320417574682046696C6564655C53634C6F631E00000080010000D09E2CB35293F221CD984B02D7AA32B4F193902E05D5B8A04532B2D6AB25F38EE3933ECA7199B142ABCEA8773DD467D24112C2AFFAB792EA715B72838C912DB9DE66EA4F00CEB927A21D1F83444101D70469B1DE23B0B407EB115347AA756D8C6B1D6A1E2C4C811FB538EA5C5E096C1F000D227F129F332475CCBF955811BB7BD86FCFD08F52E57508DCE48DEB808CDDA1A93D0D30825ED4844F5C0B991E4A62137FF548C508243AC59E454A6C63AEF3486A0F3F066F545F4CC71052FEE860270A59FD966877277CED6D939BEA91C104608C146BD1EDED0F6500CB3C7890E15CC1DB5976365BFE498002D4F010AF8D95CE791735B7FA0E0D62077BEAF4470A930000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000","UpdateStr":"","AuthorizeFileLength":"413","UpdateFileLength":"0"}';
- $longleList=isset($_POST['longle'])?$_POST['longle']:"";
-
-
- //file_put_contents ( "protected/config/longle.bak", $longleList );
-
- $longleList=json_decode($longleList,TRUE);
- //print_r($longleList);
- header ( 'Content-Type:text/html;charset=utf-8' );
- if (!is_array($longleList)){
- echo json_encode(array('status'=>2,'msg'=>'锁数据不正确'),JSON_UNESCAPED_UNICODE);die;
- }
-
- //数组格式化,新增字段需要在这新增
- //$longleList=$this->array_unique_sync($longleList);
- //print_r($longleList);
- $serialnumber=$longleList['serialnumber'];
- //$alloted_time=$longleList[0]['alloted_time'];
- $version=$longleList['version'];
- $licences=$longleList['licences'];
- $UpdateStr=$longleList['UpdateStr'];
- $UpdateFile='';
- $AuthorizeStr=$longleList['AuthorizeStr'];
- $AuthorizeFile='';
- $AuthorizeFileLength=$longleList['AuthorizeFileLength'];
- $UpdateFileLength=$longleList['UpdateFileLength'];
-
-
- //文件上传处理
- Doo::loadModel ( 'longle' );
- $longle = new longle ();
-
- if (empty($serialnumber)){
- echo json_encode(array('status'=>2,'msg'=>'未找到该锁信息-empty'),JSON_UNESCAPED_UNICODE);
- die;
- }
-
- $linfo = $longle->getLongleBySerialNumber( $serialnumber );
- if (empty($linfo)){
- echo json_encode(array('status'=>2,'msg'=>'未找到该锁信息-serialnumber'),JSON_UNESCAPED_UNICODE);
- die;
- }
-
- $save_path = DOO::conf ()->SITE_PATH . "upload/longle/";
- $webSite = '/upload/longle/';
-
- //处理注册文件
- // var_dump($_FILES);
- // $file_name = ' - 123.' . $this->_GetFileEXT ( $_FILES ["authorizefile"] ['name'] );
- // move_uploaded_file ( $_FILES ["authorizefile"] ["tmp_name"], $save_path . $file_name );
- // die;
- if(!empty($AuthorizeStr)){
- if(isset($_FILES ["AuthorizeFile"])){
- $file_name = $linfo['key_num'].' - '.$serialnumber.'.' . $this->_GetFileEXT ( $_FILES ["AuthorizeFile"] ['name'] );
- if (!@move_uploaded_file ( $_FILES ["AuthorizeFile"] ["tmp_name"], $save_path . $file_name )){
- echo json_encode(array('status'=>2,'msg'=>'上传文件失败-AuthorizeFile'),JSON_UNESCAPED_UNICODE);die;
- }else{
- $AuthorizeFile = $webSite . $file_name;
- $strFile=file_get_contents($save_path . $file_name);
- $strFile=substr($strFile , 0 , $AuthorizeFileLength);
- file_put_contents($save_path . $file_name,$strFile);
- }
- }else{
- echo json_encode(array('status'=>2,'msg'=>'检查不到AuthorizeFile变量'),JSON_UNESCAPED_UNICODE);die;
- }
- }
-
- //处理升级文件
- if(!empty($UpdateStr)){
- if(isset($_FILES ["UpdateFile"])){
- $file_name = $linfo['key_num'].' - '.$serialnumber.'.' . $this->_GetFileEXT ( $_FILES ["UpdateFile"] ['name'] );
- if (! @move_uploaded_file ( $_FILES ["UpdateFile"] ["tmp_name"], $save_path . $file_name )){
- echo json_encode(array('status'=>2,'msg'=>'上传文件失败-UpdateFile'),JSON_UNESCAPED_UNICODE);die;
- }else{
- $UpdateFile = $webSite . $file_name;
- $strFile=file_get_contents($save_path . $file_name);
- $strFile=substr($strFile , 0 , $UpdateFileLength);
- file_put_contents($save_path . $file_name,$strFile);
- }
- }else{
- echo json_encode(array('status'=>2,'msg'=>'检查不到UpdateFile变量'),JSON_UNESCAPED_UNICODE);die;
- }
- }
-
-
- // 日常行为
- Doo::loadModel ( "action_log" );
- $action_log = new action_log ();
- Doo::loadModel ( 'longle_log' );
- $longle_log = new longle_log ();
-
- $mark='软件 更新';$mark2='';
- if(!empty($AuthorizeStr)){
- $longle->AuthorizeStr=$AuthorizeStr;
- $mark.=' 注册码 ';
- $mark2.=' 注册码 ';
- }
- if(!empty($UpdateStr)){
- $longle->UpdateStr=$UpdateStr;
- $mark.=' 文件 ';
- $mark2.=' 文件 ';
- }
-
- $action_log->action = '软件 更新<a href="javascript:void(0)" onclick="showLook(\'' . $linfo ['key_num'] . '\')">' . $linfo ['key_num'] . '</a> '.$mark2;
- $action_log->status = 13;
-
- $longle_log->status = 8;
- $longle_log->mark =$mark;
-
-
- //日常操作记录
- $action_log->sid = 32;
- $action_log->cid = 12;
- $action_log->updatetime = date ( "Y-m-d" );
- $action_log->time = date ( "H:i" );
-
- $action_log->class = $action_log->iconLock;
- $action_log->insert ();
-
- //锁信息更新
- if(!empty($version)){
- $longle->version=$version;
- }
- if(!empty($licences)){
- $longle->licences=$licences;
- }
-
-
-
- if(!empty($AuthorizeFile)){
- $longle->AuthorizeFile=$AuthorizeFile;
- }
- if(!empty($UpdateFile)){
- $longle->UpdateFile=$UpdateFile;
- }
-
- $longle->lid = $linfo['lid'];
- $longle->update ();
-
- //锁操作日志
- $longle_log->lid = $linfo['lid'];
-
- $longle_log->operator = '软件';
- // 责任人
- $longle_log->category = '总部';
- $longle_log->dateline = date ( "Y-m-d" );
- $longle_log->insert ();
-
-
- echo json_encode(array('status'=>1,'msg'=>'同步成功'),JSON_UNESCAPED_UNICODE);
- die;
-
-
- }
-
- function alterationLongle(){
-
- $longleList=isset($_POST['longle'])?$_POST['longle']:"";
- //'[{"serialnumber":"167700074DCEA600","alloted_time":"2020/11/28","version":"年限","AuthorizeStr":"0C534320417574682046696C6564655C53634C6F631E00000080010000762C68DF17103DF2B46828FC9D0A42DE45519A93C56CECD56E6282DCD680997571E19ACFCE497650EFEC739F843033B533B1670F35975FD17A61E539821C0D5EA94C12B8AAD9E5CBDC4BE3F888F559E2210BD512284C2937140131CB7211EDEED2A59E0587A88A664D6BC5B3FD7C5834B5997DC878410103ED4B1B5C111F694EACB8EF5FB4929E8557F2BD074A25966954E3B706195763E8D553BDF64F96FE6E5B94B2AAE91C0EBC5CBD4EF298C75AB923C59C06A962B408C7473E0A9DDCA44592C88471ED273DEBDEDE4491A680D834B579CBB007838AA61FAB5F1DEC0B287C06641A7E4B95C64F69BC18B4F60C5151942473B26C51D5F08A9DA0760987E7F90000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000"}]';//
-
-
- //file_put_contents ( "protected/config/longle.bak", $longleList );
-
- // $file=isset($_POST['file'])?$_POST['file']:"";
- // file_put_contents("protected/config/sites.txt",$file);
-
- $longleList=json_decode($longleList,TRUE);
-
- header ( 'Content-Type:text/html;charset=utf-8' );
- if (!is_array($longleList)){
- echo json_encode(array('status'=>2,'msg'=>'锁数据不正确'),JSON_UNESCAPED_UNICODE);die;
- }
-
- //数组格式化,新增字段需要在这新增
- $longleList=$this->array_unique_alteration($longleList);
-
- $serialnumber=$longleList[0]['serialnumber'];
- $alloted_time=$longleList[0]['alloted_time'];
- $version=$longleList[0]['version'];
- $UpdateStr='';//$longleList[0]['UpdateStr'];
- $UpdateFile='';//$longleList[0]['UpdateFile'];
- $AuthorizeStr=$longleList[0]['AuthorizeStr'];
- $AuthorizeFile='';
- $length=$longleList[0]['length'];
-
-
- //文件上传处理
- Doo::loadModel ( 'longle' );
- $longle = new longle ();
-
- if (empty($serialnumber)){
- echo json_encode(array('status'=>2,'msg'=>'未找到该锁信息'),JSON_UNESCAPED_UNICODE);
- die;
- }
-
- $linfo = $longle->getLongleBySerialNumber( $serialnumber );
- if (empty($linfo)){
- echo json_encode(array('status'=>2,'msg'=>'未找到该锁信息'),JSON_UNESCAPED_UNICODE);
- die;
- }
-
- $save_path = DOO::conf ()->SITE_PATH . "upload/longle/";
- $webSite = '/upload/longle/';
- $file_name = $linfo['key_num'].' - '.$serialnumber.'.' . $this->_GetFileEXT ( $_FILES ["file"] ['name'] );
- if (! @move_uploaded_file ( $_FILES ["file"] ["tmp_name"], $save_path . $file_name )){
- echo json_encode(array('status'=>2,'msg'=>'未找到上传文件'),JSON_UNESCAPED_UNICODE);die;
- }else{
- $AuthorizeFile = $webSite . $file_name;
- }
-
- $strFile=file_get_contents($save_path . $file_name);
- $strFile=substr($strFile , 0 , $length);
- file_put_contents($save_path . $file_name,$strFile);
-
-
-
- $licences='';//$longleList[0]['licences'];
-
-
- /* $serialnumber = $this->get_args ( 'serialnumber' ) ? $this->get_args ( 'serialnumber' ) : "";
-
- $alloted_time = isset($_POST['alloted_time'])?$_POST['alloted_time']:"";
-
- //$alloted_time = $this->get_args ( 'alloted_time' ) ? $this->get_args ( 'alloted_time' ) : '';
- //$status = $this->get_args ( 'status' ) ? $this->get_args ( 'status' ) : 0;//5升级 10延期
-
- $UpdateStr = $this->get_args ( 'UpdateStr' ) ? $this->get_args ( 'UpdateStr' ) : "";
- $UpdateFile = $this->get_args ( 'UpdateFile' ) ? $this->get_args ( 'UpdateFile' ) : "";
- $AuthorizeStr = $this->get_args ( 'AuthorizeStr' ) ? $this->get_args ( 'AuthorizeStr' ) : "";
- $AuthorizeFile = $this->get_args ( 'AuthorizeFile' ) ? $this->get_args ( 'AuthorizeFile' ) : "";
- $version = $this->get_args ( 'version' ) ? $this->get_args ( 'version' ) : "";
- $licences = $this->get_args ( 'licences' ) ? $this->get_args ( 'licences' ) : ""; */
-
- // 日常行为
- Doo::loadModel ( "action_log" );
- $action_log = new action_log ();
- Doo::loadModel ( 'longle_log' );
- $longle_log = new longle_log ();
-
- $mark='软件 更新';$mark2='';
- if(!empty($AuthorizeStr)){
- $longle->AuthorizeStr=$AuthorizeStr;
- $mark.=' 注册码 ';
- $mark2.=' 注册码 ';
- }
- if(!empty($UpdateStr)){
- $longle->UpdateStr=$UpdateStr;
- $mark.=' 文件 ';
- $mark2.=' 文件 ';
- }
-
- if(empty($version)){
- $action_log->action = '软件 为<a href="javascript:void(0)" onclick="showLook(\'' . $linfo ['key_num'] . '\')">' . $linfo ['key_num'] . '</a> 延期至 ';
- $action_log->status = 12;
-
- $longle->alloted_time = '';//更新锁延期时间
- $longle->status = 10;
-
- $longle_log->status = 10;
- $longle_log->mark ='由'.$linfo['alloted_time'].'延期至 ';
-
-
- /*$action_log->action = '软件 更新<a href="javascript:void(0)" onclick="showLook(\'' . $linfo ['key_num'] . '\')">' . $linfo ['key_num'] . '</a> '.$mark2;
- $action_log->status = 13;
-
- $longle_log->status = 8;
- $longle_log->mark =$mark; */
-
- }else{
- if (empty($alloted_time)){
-
- $action_log->action = '软件 为<a href="javascript:void(0)" onclick="showLook(\'' . $linfo ['key_num'] . '\')">' . $linfo ['key_num'] . '</a> 延期至 ';
- $action_log->status = 12;
-
- $longle->alloted_time = '';//更新锁延期时间
- $longle->status = 10;
-
- $longle_log->status = 10;
- $longle_log->mark ='由'.$linfo['alloted_time'].'延期至 ';
-
- /*
- echo json_encode(array('status'=>2,'msg'=>'限制时间未接收'),JSON_UNESCAPED_UNICODE);die;
-
- $action_log->action = '软件 更新<a href="javascript:void(0)" onclick="showLook(\'' . $linfo ['key_num'] . '\')">' . $linfo ['key_num'] . '</a> '.$mark2;
- $action_log->status = 13;
-
- $longle_log->status = 8;
- $longle_log->mark =$mark; */
- }else{
- $action_log->action = '软件 为<a href="javascript:void(0)" onclick="showLook(\'' . $linfo ['key_num'] . '\')">' . $linfo ['key_num'] . '</a> 延期至'.$alloted_time;
- $action_log->status = 12;
-
- $longle->alloted_time = $alloted_time;//更新锁延期时间
- $longle->status = 10;
-
- $longle_log->status = 10;
- $longle_log->mark ='由'.$linfo['alloted_time'].'延期至'.$alloted_time;
- }
-
- }
-
-
-
- //日常操作记录
- $action_log->sid = 32;
- $action_log->cid = 12;
- $action_log->updatetime = date ( "Y-m-d" );
- $action_log->time = date ( "H:i" );
-
- $action_log->class = $action_log->iconLock;
- $action_log->insert ();
-
- //锁信息更新
- if(!empty($version)){
- $longle->version=$version;
- }
- if(!empty($licences)){
- $longle->licences=$licences;
- }
-
-
-
- if(!empty($AuthorizeFile)){
- $longle->AuthorizeFile=$AuthorizeFile;
- }
- if(!empty($UpdateFile)){
- $longle->UpdateFile=$UpdateFile;
- }
-
- $longle->lid = $linfo['lid'];
- $longle->update ();
-
- //锁操作日志
- $longle_log->lid = $linfo['lid'];
-
- $longle_log->operator = '软件';
- // 责任人
- $longle_log->category = '总部';
- $longle_log->dateline = date ( "Y-m-d" );
- $longle_log->insert ();
-
-
- echo json_encode(array('status'=>1,'msg'=>'变更成功'),JSON_UNESCAPED_UNICODE);
- die;
-
- }
-
-
- /**
- * 获取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 postEmail($elid){
-
- if (!empty($elid)){
-
-
- $url = 'http://sendcloud.sohu.com/webapi/mail.send.json';
-
-
- $param = array('api_user' => 'cldmail',
- 'api_key' => 'cDO1GjtY1seH',
- 'to'=>'cpthought@vip.qq.com',
- 'from' =>'cpthought@vip.qq.com',
- 'fromname' => '软件导入CLD锁接口',
- 'subject' => '软件导入CLD锁接口通知',
- 'html' => $elid);
- $post_data = http_build_query($param);
- $ch = curl_init();
- curl_setopt($ch, CURLOPT_POST, 1);
- curl_setopt($ch, CURLOPT_URL,$url);
- curl_setopt($ch, CURLOPT_HEADER, false); //设定是否输出页面内容
- curl_setopt($ch, CURLOPT_NOBODY, false);
- curl_setopt($ch, CURLOPT_POSTFIELDS, $post_data);
-
- $result =curl_exec($ch);
- curl_close($ch);
- }
- }
-
-
- function array_unique_fb($array2D){
- foreach ($array2D as $k=>$v){
- $v=join(',',$v); //降维,也可以用implode,将一维数组转换为用逗号连接的字符串
- $temp[$k]=$v;
- }
- $temp=array_unique($temp); //去掉重复的字符串,也就是重复的一维数组
- foreach ($temp as $k => $v){
- $array=explode(',',$v); //再将拆开的数组重新组装
- //下面的索引根据自己的情况进行修改即可
- $temp2[$k]['key_num'] =$array[0];
- $temp2[$k]['serialnumber'] =$array[1];
- $temp2[$k]['product'] =$array[2];
- $temp2[$k]['make_day'] =$array[3];
-
- $temp2[$k]['alloted_time'] =$array[4];
- $temp2[$k]['version'] =$array[5];
- $temp2[$k]['cid'] =$array[6];
- $temp2[$k]['title'] =$array[7];
- $temp2[$k]['licences'] =$array[8];
-
- $temp2[$k]['AuthorizeStr'] =$array[9];
- $temp2[$k]['UpdateStr'] =$array[10];
-
- }
-
- return $temp2;
- }
-
-
- function array_unique_sync($array2D){
- foreach ($array2D as $k=>$v){
- $v=join(',',$v); //降维,也可以用implode,将一维数组转换为用逗号连接的字符串
- $temp[$k]=$v;
- }
- $temp=array_unique($temp); //去掉重复的字符串,也就是重复的一维数组
- foreach ($temp as $k => $v){
- $array=explode(',',$v); //再将拆开的数组重新组装
- //下面的索引根据自己的情况进行修改即可
- $temp2[$k]['serialnumber'] =$array[0];
- $temp2[$k]['licences'] =$array[1];
- $temp2[$k]['version'] =$array[2];
- $temp2[$k]['AuthorizeStr'] =$array[3];
- $temp2[$k]['UpdateStr'] =$array[4];
- $temp2[$k]['AuthorizeFileLength'] =$array[5];
- $temp2[$k]['UpdateFileLength'] =$array[6];
-
- }
-
- return $temp2;
- }
-
-
- function array_unique_alteration($array2D){
- foreach ($array2D as $k=>$v){
- $v=join(',',$v); //降维,也可以用implode,将一维数组转换为用逗号连接的字符串
- $temp[$k]=$v;
- }
- $temp=array_unique($temp); //去掉重复的字符串,也就是重复的一维数组
- foreach ($temp as $k => $v){
- $array=explode(',',$v); //再将拆开的数组重新组装
- //下面的索引根据自己的情况进行修改即可
- $temp2[$k]['serialnumber'] =$array[0];
- $temp2[$k]['alloted_time'] =$array[1];
- $temp2[$k]['version'] =$array[2];
- $temp2[$k]['AuthorizeStr'] =$array[3];
- $temp2[$k]['length'] =$array[4];
-
- //$temp2[$k]['AuthorizeFile'] =$array[4];
-
- }
-
- return $temp2;
- }
-
- function array_unique_update($array2D){
- foreach ($array2D as $k=>$v){
- $v=join(',',$v); //降维,也可以用implode,将一维数组转换为用逗号连接的字符串
- $temp[$k]=$v;
- }
- $temp=array_unique($temp); //去掉重复的字符串,也就是重复的一维数组
- foreach ($temp as $k => $v){
- $array=explode(',',$v); //再将拆开的数组重新组装
- //下面的索引根据自己的情况进行修改即可
- $temp2[$k]['serialnumber'] =$array[0];
- $temp2[$k]['product'] =$array[1];
-
- $temp2[$k]['alloted_time'] =$array[2];
- $temp2[$k]['version'] =$array[3];
- $temp2[$k]['licences'] =$array[4];
- $temp2[$k]['UpdateStr'] =$array[5];
- $temp2[$k]['length'] =$array[6];
- //$temp2[$k]['UpdateFile'] =$array[6];
-
- }
-
- return $temp2;
- }
-
- /**
- * 格式化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 _GetFileEXT($filename) {
- $pics = explode ( '.', $filename );
- $num = count ( $pics );
- return $pics [$num - 1];
- }
-
- /* function updateLockApi(){
- $longleList=isset($_POST['longle'])?$_POST['longle']:"";
-
- header ( 'Content-Type:text/html;charset=utf-8' );
- if($longleList!=""){
- Doo::loadModel ( 'longle' );
- Doo::loadModel ( 'longle_log' );
-
- //$exlArray=$this->_format_excel_to_array(DOO::conf()->SITE_PATH."upload/".iconv("UTF-8", "GB2312", $path));
- //file_put_contents ( "protected/config/longle.bak", $longleList );
-
- $longleList=json_decode($longleList,TRUE);
-
- if (!is_array($longleList)){
- echo json_encode(array('status'=>2,'msg'=>'锁数据不正确'),JSON_UNESCAPED_UNICODE);die;
- }
-
- //数组格式化,新增字段需要在这新增
- $longleList=$this->array_unique_Update($longleList);
-
- //$category=$L_category->getCategoryById($cid);
- try {
- Doo::db()->beginTransaction();
- foreach ($longleList as $key=>$value){
-
- $longle = new longle ();
- $detail=$longle->getLongleBySerialNumber($value['serialnumber']);
- if(empty($detail)){
- echo json_encode(array('status'=>2,'msg'=>'找不到相关锁信息'),JSON_UNESCAPED_UNICODE);die;
- }
-
- //锁记录
- $longle = new longle ();
-
- if(!empty($value['product'])){
- $longle->product=$detail['product'].'+'.$value['product'];
- }
- if(!empty($value['alloted_time'])){
- $longle->alloted_time=$value['alloted_time'];
- }
- if(!empty($value['version'])){
- $longle->version=$value['version'];
- }
- if(!empty($value['licences'])){
- $longle->licences=$value['licences'];
- }
- if(!empty($value['AuthorizeStr'])){
- $longle->AuthorizeStr=$value['AuthorizeStr'];
- }
- if(!empty($value['AuthorizeFile'])){
- $longle->AuthorizeFile=$value['AuthorizeFile'];
- }
- if(!empty($value['UpdateStr'])){
- $longle->UpdateStr=$value['UpdateStr'];
- }
- if(!empty($value['UpdateFile'])){
- $longle->UpdateFile=$value['UpdateFile'];
- }
-
-
- //更新方法
- $longle->update ( array (
- 'where' => 'lid=' . $detail['lid']
- ) );
-
- //锁日志记录
- $longle_log=new longle_log();
- $longle_log->lid=$detail['lid'];
- $longle_log->status=11;
- $longle_log->statusT="更新";
- $longle_log->operator='软件更新锁信息';
- $longle_log->product=$longle->product;
- $longle_log->category='总部';
- $longle_log->dateline=date("Y-m-d");
- $id=$longle_log->insert();
-
- }
- //记录日常行为
- Doo::loadModel("action_log");
- $action_log=new action_log();
- $action_log->action='总部<b href="javascript:void(0)" >软件</b>更新<a href="javascript:void(0)" onclick="showLook(\''.$detail['key_num'].'\')">'.$detail['key_num'].'</a>锁';
- $action_log->sid=32;
- $action_log->cid=12;
- $action_log->class=$action_log->iconGenerate;
- $action_log->updatetime=date("Y-m-d");
- $action_log->time=date("H:i");
- $action_log->status=12;
-
- $action_log->insert();
- Doo::db()->commit();
-
-
- } catch (Exception $e) {
- echo json_encode(array('status'=>2,'msg'=>'数据更新发生异常'),JSON_UNESCAPED_UNICODE);
- //print $e->getMessage();
- die;
- }
- echo json_encode(array('status'=>1,'msg'=>'更新成功'),JSON_UNESCAPED_UNICODE);die;
- }else{
- echo json_encode(array('status'=>2,'msg'=>'请求参数不正确或者为空'),JSON_UNESCAPED_UNICODE);die;
- }
- } */
- }
- ?>
|