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;
}
/**
* 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 TmpXml the loaded model
* @throws CHttpException
*/
public function loadModel($id)
{
$model = TmpXml::model()->findByPk($id);
if ($model === null) {
throw new CHttpException(404, 'The requested page does not exist.');
}
return $model;
}
