Beispiel #1
0
 private function readsimple($thefile, $model)
 {
     TmpXml::model()->deleteAll('user='******'user='******'user='******'ALTER TABLE tmp_xml AUTO_INCREMENT = 1;')->execute();
     //            $connection->createCommand('ALTER TABLE tmp_docd AUTO_INCREMENT = 1;')->execute();
     $ii = 0;
     $jj = 0;
     $result = false;
     //			$data=array();
     if (file_exists($thefile)) {
         if (($handle = fopen($thefile, "r")) === FALSE) {
             return 'empty';
         }
         while (($cols = fgetcsv($handle, 1000, ";")) !== FALSE) {
             $ii++;
             if ($ii >= $model->n_str && $ii <= $model->n_fin) {
                 if ($jj == 0) {
                     $jj = 1;
                 }
                 $data = new TmpDocd();
                 $xml = new TmpXml();
                 $data->cnom = $jj;
                 $data->ckey = $jj;
                 $data->user = Yii::app()->user->uid;
                 $xml->user = Yii::app()->user->uid;
                 $xml->ckey = $jj++;
                 $tmp = trim($cols[$model->n_nom - 1]);
                 $tmp = iconv('windows-1251', 'UTF-8', $tmp . "");
                 $tmp = str_replace('""', '"', $tmp);
                 $tmp = preg_replace("/^\"(.*)\"\$/sim", "\$1", $tmp);
                 $xml->cname = $tmp;
                 $tmp = trim($cols[$model->n_art - 1]);
                 $xml->cgr = $tmp;
                 $xml->save();
                 $tmp = trim($cols[$model->n_price - 1]);
                 //									echo $tmp."/";
                 $tmp = str_replace(',', '.', $tmp);
                 //									echo $tmp."/";
                 $price = filter_var($tmp, FILTER_SANITIZE_NUMBER_FLOAT, FILTER_FLAG_ALLOW_FRACTION);
                 $tmp = trim($cols[$model->n_quant - 1]);
                 //									echo $tmp."/";
                 $tmp = str_replace(',', '.', $tmp);
                 //									echo $tmp."/";
                 $sum = filter_var($tmp, FILTER_SANITIZE_NUMBER_FLOAT, FILTER_FLAG_ALLOW_FRACTION);
                 //									echo ":".$price.":".$sum."<hr>";
                 $data->bpri = $price;
                 $data->bsum = $sum;
                 if ($price != 0) {
                     $data->bqua = round($sum / $price, 4);
                 }
                 $data->save();
             }
         }
     }
     return jj;
 }
Beispiel #2
0
 /**
  * Manages all models.
  */
 private function readsimple($thefile)
 {
     $clis = array();
     $firs = array();
     $ords = array();
     $invs = array();
     $inf = array();
     TmpXml::model()->deleteAll('user='******'user='******'user='******'ALTER TABLE tmp_xml AUTO_INCREMENT = 1;')->execute();
     //            $connection->createCommand('ALTER TABLE tmp_docd AUTO_INCREMENT = 1;')->execute();
     $ii = 0;
     $result = false;
     if (file_exists($thefile)) {
         $result = simplexml_load_file($thefile);
     }
     $db = 1;
     foreach ($result as $key => $value) {
         switch ($key) {
             case 'xNom':
                 $model = new TmpXml();
                 $model->ckey = (string) $value[0]->cKey;
                 $model->cname = (string) $value[0]->tNam;
                 $model->cgr = (string) $value[0]->cGr;
                 $model->ctype = 0;
                 $model->user = Yii::app()->user->uid;
                 if ($model->save()) {
                     $ii++;
                 }
                 $model = new TmpXml();
                 $model->ckey = (string) $value[0]->cKey;
                 $model->cname = (string) $value[0]->it;
                 $model->ctype = 10;
                 $model->user = Yii::app()->user->uid;
                 if ($model->save()) {
                     $ii++;
                 }
                 break;
             case 'xCli':
                 $model = new TmpXml();
                 $model->ckey = (string) $value[0]->cKey;
                 $model->cname = (string) $value[0]->tNam;
                 $model->cgr = (string) $value[0]->cGr;
                 $model->ctype = 1;
                 $model->user = Yii::app()->user->uid;
                 if ($model->save()) {
                     $clis[$model->ckey] = $model->cname;
                     $ii++;
                 }
                 foreach ($value[0]->props[0] as $ke => $valu) {
                     $model = new TmpXml();
                     $model->ckey = (string) $value[0]->cKey;
                     $model->cname = (string) $ke;
                     $model->lname = (string) $valu[0];
                     $model->ctype = 11;
                     $model->user = Yii::app()->user->uid;
                     if ($model->save()) {
                         $ii++;
                     }
                 }
                 foreach ($value[0]->acc[0] as $ke => $valu) {
                     $model = new TmpXml();
                     $model->ckey = (string) $value[0]->cKey;
                     $model->cname = (string) $ke;
                     $model->lname = (string) $valu[0];
                     $model->ctype = 12;
                     $model->user = Yii::app()->user->uid;
                     if ($model->save()) {
                         $ii++;
                     }
                 }
                 break;
             case 'xFir':
                 $model = new TmpXml();
                 $model->ckey = (string) $value[0]->cKey;
                 $model->cname = (string) $value[0]->tNam;
                 $model->ctype = 2;
                 $model->user = Yii::app()->user->uid;
                 if ($model->save()) {
                     $firs[$model->ckey] = $model->cname;
                     $ii++;
                 }
                 break;
             case 'xAcc':
                 $model = new TmpXml();
                 $id = (string) $value[0]->host;
                 foreach ($value[0] as $ke => $valu) {
                     $model = new TmpXml();
                     $model->ckey = $id;
                     $model->cname = (string) $ke;
                     $model->lname = (string) $valu[0];
                     $model->ctype = 13;
                     $model->user = Yii::app()->user->uid;
                     if ($model->save()) {
                         $ii++;
                     }
                 }
                 break;
             case 'xGrN':
                 $model = new TmpXml();
                 $model->ckey = (string) $value[0]->cKey;
                 $model->cname = (string) $value[0]->tNam;
                 $model->ctype = 3;
                 $model->user = Yii::app()->user->uid;
                 if ($model->save()) {
                     $ii++;
                 }
                 break;
             case 'xGrC':
                 $model = new TmpXml();
                 $model->ckey = (string) $value[0]->cKey;
                 $model->cname = (string) $value[0]->tNam;
                 $model->ctype = 4;
                 $model->user = Yii::app()->user->uid;
                 if ($model->save()) {
                     $ii++;
                 }
                 break;
             case 'xInv':
                 $model = new TmpDoc();
                 $model->id = (int) $value[0]->cKey + 100 * Yii::app()->user->uid;
                 $model->tnum = (string) $value[0]->tNum;
                 $model->tonum = (string) $value[0]->tONum;
                 $model->ddat = (string) $value[0]->dDat;
                 $model->dodat = (string) $value[0]->dODat;
                 $model->cfir = (string) $value[0]->cFir;
                 $model->ccli = (string) $value[0]->cCli;
                 $model->bsum = (double) $value[0]->bSum;
                 $model->transport = (string) $value[0]->cClix;
                 $model->ctype = 1;
                 $model->user = Yii::app()->user->uid;
                 if ($model->save()) {
                     $ii++;
                     $invs[$model->id] = array($model->tnum, $model->ddat, $model->tonum, $model->dodat);
                 }
                 break;
             case 'xOrd':
                 $model = new TmpDoc();
                 $model->id = (int) $value[0]->cKey + 100 * Yii::app()->user->uid;
                 $model->tnum = (string) $value[0]->tNum;
                 $model->tonum = (string) $value[0]->Acc;
                 $model->ddat = (string) $value[0]->dDat;
                 $model->cfir = (string) $value[0]->cFir;
                 $model->ccli = (string) $value[0]->cCli;
                 $model->bsum = (double) $value[0]->bSum;
                 $model->transport = (string) $value[0]->Tran;
                 $model->dbank = (string) $value[0]->Acc;
                 $model->cbank = (string) $value[0]->cCAc;
                 $model->man = (int) $value[0]->Man;
                 $model->ctype = 0;
                 $model->user = Yii::app()->user->uid;
                 if ($model->save()) {
                     $ii++;
                     $ords[$model->id] = array($model->tnum, $model->ddat);
                 }
                 if (isset($value[0]->Inf)) {
                     $modelx = new TmpXml();
                     $modelx->ckey = $model->id;
                     $modelx->cname = (string) $value[0]->Inf;
                     $modelx->ctype = 14;
                     $modelx->user = Yii::app()->user->uid;
                     if ($modelx->save()) {
                         $ii++;
                     }
                 }
                 break;
             case 'xInvT':
                 $model = new TmpDocd();
                 $model->ckey = (int) $value[0]->cDoc + 100 * Yii::app()->user->uid;
                 $model->cnom = (string) $value[0]->cNom;
                 $model->bqua = (string) $value[0]->bQua;
                 $model->bvat = (string) $value[0]->bVat;
                 $model->bpri = (string) $value[0]->bPri;
                 $model->bsum = (double) $value[0]->bSum;
                 $model->state = 1;
                 $model->user = Yii::app()->user->uid;
                 if ($model->save()) {
                     $ii++;
                 }
                 break;
             case 'xOrdT':
                 $model = new TmpDocd();
                 $model->ckey = (int) $value[0]->cDoc + 100 * Yii::app()->user->uid;
                 $model->cnom = (string) $value[0]->cNom;
                 $model->bqua = (string) $value[0]->bQua;
                 $model->bvat = (string) $value[0]->bVat;
                 $model->bpri = (string) $value[0]->bPri;
                 $model->bsum = (double) $value[0]->bSum;
                 $model->state = 0;
                 $model->user = Yii::app()->user->uid;
                 if ($model->save()) {
                     $ii++;
                 }
                 break;
         }
     }
     $ii = 0;
     $prods = TmpXml::model()->with('productid')->findAll('user='******'lid'] = $value['productid']['product1']['ckey'];
             $value['lname'] = $value['productid']['product1']['tnam'];
             $value['state'] = 10;
             $value->save();
         }
     }
     $inf[] = "Товары:{$ii}";
     $prods = TmpXml::model()->with('clientid')->findAll('user='******'lid'] = $value['clientid']['client1']['id'];
             $value['lname'] = $value['clientid']['client1']['name'];
             $value['state'] = 10;
             $value->save();
         }
     }
     $inf[] = "Клиенты:{$ii}";
     $prods = TmpXml::model()->with('departmentid')->findAll('user='******'lid'] = $value['departmentid']['department1']['id'];
             $value['lname'] = $value['departmentid']['department1']['name'];
             $value['state'] = 10;
             $value->save();
         }
     }
     $inf[] = "Фирмы:{$ii}";
     $prods = TmpXml::model()->with('productgroupid')->findAll('user='******'lid'] = $value['productgroupid']['productgroup1']['ckey'];
             $value['lname'] = $value['productgroupid']['productgroup1']['tnam'];
             $value['state'] = 10;
             $value->save();
         }
     }
     $prods = TmpXml::model()->with('countryid')->findAll('user='******'lid'] = $value['countryid']['country1']['id'];
             $value['lname'] = $value['countryid']['country1']['name'];
             $value['state'] = 10;
             $value->save();
         }
     }
     foreach ($ords as $key => $value) {
         $criteria = new CDbCriteria();
         $Datet = $value[1];
         $Datef = date('Y-m-d', strtotime($Datet . ' - 3 days'));
         $Datet = date('Y-m-d', strtotime($Datet . ' + 3 days'));
         $criteria->addCondition("date  >= '{$Datef}' and t.date <= '{$Datet}'");
         $exp = Exp::model()->with(array('client', 'department'))->findByAttributes(array('name' => $value[0]), $criteria);
         $prod = TmpDoc::model()->findByPk($key);
         $prod->cliname = $clis[$prod->ccli];
         $prod->firname = $firs[$prod->cfir];
         if (!($exp === null)) {
             $prod->expid = $exp->id;
             $prod->expinfo = $exp->name . " - " . Yii::app()->dateFormatter->formatDateTime($exp->date, 'short', null) . " - " . $exp->depname . " - " . $exp->cliname . " - " . Yii::app()->numberFormatter->formatCurrency($exp->amount, '');
         }
         $prod->save();
     }
     foreach ($invs as $key => $value) {
         $criteria = new CDbCriteria();
         $Datet = $value[1];
         $Datef = date('Y-m-d', strtotime($Datet . ' - 3 days'));
         $Datet = date('Y-m-d', strtotime($Datet . ' + 3 days'));
         $criteria->addCondition("t.date  >= '{$Datef}' and t.date <= '{$Datet}'");
         $inv = Inv::model()->with(array('exp', 'exp.client', 'exp.department'))->findByAttributes(array('name' => $value[0]), $criteria);
         $prod = TmpDoc::model()->findByPk($key);
         $prod->cliname = $clis[$prod->ccli];
         $prod->firname = $firs[$prod->cfir];
         if ($inv === null) {
             $criteria = new CDbCriteria();
             $Datet = $value[3];
             $Datef = date('Y-m-d', strtotime($Datet . ' - 3 days'));
             $Datet = date('Y-m-d', strtotime($Datet . ' + 3 days'));
             $criteria->addCondition("date  >= '{$Datef}' and t.date <= '{$Datet}'");
             $exp = Exp::model()->with(array('client', 'department'))->findByAttributes(array('name' => $value[2]), $criteria);
             if (!($exp === null)) {
                 $prod->expid = $exp->id;
                 $prod->expinfo = $exp->name . " - " . Yii::app()->dateFormatter->formatDateTime($exp->date, 'short', null) . " - " . $exp->depname . " - " . $exp->cliname . " - " . Yii::app()->numberFormatter->formatCurrency($exp->amount, '');
             }
         } else {
             $prod->docid = $inv->id;
             $prod->docinfo = $inv->name . " - " . Yii::app()->dateFormatter->formatDateTime($inv->date, 'short', null) . " - " . Yii::app()->numberFormatter->formatCurrency($inv->amount, '');
             $prod->expid = $inv->exp_id;
             $prod->expinfo = $inv->exp->name . " - " . Yii::app()->dateFormatter->formatDateTime($inv->exp->date, 'short', null) . " - " . $inv->depname . " - " . $inv->cliname . " - " . Yii::app()->numberFormatter->formatCurrency($inv->exp->amount, '');
         }
         $prod->save();
     }
     return $ii;
 }
Beispiel #3
0
 /**
  * Returns the data model based on the primary key given in the GET variable.
  * If the data model is not found, an HTTP exception will be raised.
  * @param integer $id the ID of the model to be loaded
  * @return TmpDoc the loaded model
  * @throws CHttpException
  */
 public function loadModel($id)
 {
     $model = TmpDoc::model()->findByPk($id);
     if ($model === null) {
         throw new CHttpException(404, 'The requested page does not exist.');
     }
     return $model;
 }