// 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();
}
}
/**
