示例#1
0
 /**
  * This command import office supervision data.
  * @param string $filename the file to be imported to DB.
  */
 public function actionScorer($filename = 'scorer.csv')
 {
     $file = Yii::$app->getRuntimePath() . DIRECTORY_SEPARATOR . 'imported_data' . DIRECTORY_SEPARATOR . $filename;
     $fh = fopen($file, "r");
     $i = 0;
     while (!feof($fh)) {
         $line = fgets($fh);
         $i++;
         if (empty($line)) {
             continue;
         }
         $fields = explode(",", $line);
         $scorer_name = trim($fields[0]);
         $scorer_name_utf8 = iconv('GBK', 'UTF-8//IGNORE', $scorer_name);
         $scorer_department = trim(trim($fields[1]), "0..9");
         $scorer_department_utf8 = iconv('GBK', 'UTF-8//IGNORE', $scorer_department);
         $scorer_position = trim(trim($fields[2]), "0..9");
         $scorer_position_utf8 = iconv('GBK', 'UTF-8//IGNORE', $scorer_position);
         $scorer_mobile = trim($fields[3]);
         $scorer = \app\models\MOfficeCampaignScorer::findOne(['name' => $scorer_name_utf8, 'mobile' => $scorer_mobile]);
         if (empty($scorer)) {
             $scorer = new \app\models\MOfficeCampaignScorer();
             $scorer->name = $scorer_name_utf8;
             $scorer->department = $scorer_department_utf8;
             $scorer->position = $scorer_position_utf8;
             $scorer->mobile = $scorer_mobile;
             $scorer->save(false);
         }
     }
     fclose($fh);
 }
 /**
  * Finds the MOfficeCampaignScorer model based on its primary key value.
  * If the model is not found, a 404 HTTP exception will be thrown.
  * @param integer $id
  * @return MOfficeCampaignScorer the loaded model
  * @throws NotFoundHttpException if the model cannot be found
  */
 protected function findModel($id)
 {
     if (($model = MOfficeCampaignScorer::findOne($id)) !== null) {
         return $model;
     } else {
         throw new NotFoundHttpException('The requested page does not exist.');
     }
 }