public function readfile()
{
$filename = 'GoodsFile/GoodsPrice.txt';
$readfile = fopen($filename, 'r');
while ($str = fgets($readfile)) {
$items = explode(';', $str);
echo iconv('UTF-8', 'CP1251', $items[2]) . '<br>';
$tp = Typeprice::find()->where(['type_price_name' => $items[5]])->one();
if (!isset($tp)) {
continue;
}
$good = Goods::findOne(['good_1c_id' => $items[1]]);
if (isset($good)) {
echo $good->good_id . '<br>';
} else {
echo iconv('UTF-8', 'CP1251', 'создаем новый объект ') . $items[1] . '<br>';
$good = new Goods();
}
$good->good_1c_id = $items[1];
$good->good_name = $items[2];
$good->good_description = $items[4];
$good->good_price = $items[6] * 100;
$good->typeprices_id = $tp->type_price_id;
$good->save();
}
fclose($readfile);
}
$form = ActiveForm::begin(['options' => ['enctype' => 'multipart/form-data']]);
?>
<? //echo $form->field($model, 'user_id')->textInput() ?>
<?php
if ($upload) {
echo $form->field($model, 'file')->fileInput();
} else {
if (Yii::$app->user->can('admin')) {
echo $form->field($model, 'user_id')->dropDownList(ArrayHelper::map(User::find()->all(), 'id', 'fullname'), ['prompt' => 'Выберите пользователя']);
}
echo $form->field($model, 'customer_1c_id')->textInput();
echo $form->field($model, 'customer_name')->textInput(['maxlength' => 200]);
echo $form->field($model, 'customer_email')->textInput(['maxlength' => 200]);
echo $form->field($model, 'typeprices_id')->dropDownList(ArrayHelper::map(Typeprice::find()->all(), 'type_price_id', 'type_price_name'), ['prompt' => 'Выберите тип цен']);
}
?>
<div class="form-group">
<?php
if ($upload) {
echo Html::submitButton('Загрузить', ['class' => 'btn btn-success']);
} else {
echo Html::submitButton($model->isNewRecord ? 'Создать' : 'Редактировать', ['class' => $model->isNewRecord ? 'btn btn-success' : 'btn btn-primary']);
}
?>
</div>
<?php
ActiveForm::end();
public function getTypePrices()
{
return $this->hasOne(Typeprice::className(), ['type_price_id' => 'typeprices_id']);
}
public function readfile()
{
$filename = 'CustomersFile/Customers.txt';
$readfile = fopen($filename, 'r');
while ($str = fgets($readfile, 1024)) {
$items = explode(';', $str);
//print_r($items);
$usr = User::findByFullname(iconv('CP1251', 'UTF-8', $items[1]));
//print_r($usr);
if (!isset($usr)) {
continue;
}
echo '-->' . $usr->id . '<br>';
//echo $usr->username . '<br>';
echo trim($items[1]) . '<br>';
echo $items[0] . '<br>';
echo $items[2] . '<br>';
echo $items[3] . '<br>';
$tp = Typeprice::findOne(['type_price_name' => iconv('CP1251', 'UTF-8', $items[3])]);
if (isset($tp)) {
//print_r($tp);
echo $tp->type_price_id;
} else {
echo '???';
$tp = new Typeprice();
$tp->type_price_name = iconv('CP1251', 'UTF-8', $items[3]);
$tp->save();
}
$customer = Customers::findOne(['customer_1c_id' => $items[0]]);
if (isset($customer)) {
echo $customer->customer_id;
} else {
echo '???';
$customer = new Customers();
$customer->customer_1c_id = $items[0];
$customer->user_id = $usr->id;
$customer->customer_name = iconv('CP1251', 'UTF-8', $items[2]);
$customer->typeprices_id = $tp->type_price_id;
$customer->save();
}
unset($customer);
unset($tp);
}
fclose($readfile);
}
