// echo "<hr>$ClassName Data: ".count($aData)." - Exists: ".count($aExists)." - New: ".count($aNew)." - Detail: ".implode(",",$aNew); } /** * @Author: ANH DUNG Mar 04, 2015 * @Todo: insert new record to db * @Param: $ClassName name of model * @Param: $field_name field in db * @Param: $aNew array data to insert new */ public function InsertNewRecord($ClassName, $FieldName, $aNew) { $model_ = call_user_func(array($ClassName, 'model')); $tableName = $model_->tableName(); Yii::app()->db->createCommand("truncate table {$tableName}")->query(); // sleep(1); $aRowInsert = array(); foreach ($aNew as $key => $item) { $aRowInsert[] = "( '{$item}' )"; } $sql = "insert into {$tableName} (\r\r {$FieldName}\r\r ) values " . implode(',', $aRowInsert); if (count($aRowInsert) > 0) { // echo "<br> SQL: $sql <br>"; Yii::app()->db->createCommand($sql)->execute(); } } /**