public function actionUploadCsv()
{
$model = new XlsxFile();
$filecsv = '';
if ($model->load(Yii::$app->request->post())) {
$file = UploadedFile::getInstance($model, 'file');
$filename = 'Data.' . $file->extension;
$upload = $file->saveAs('uploads/csv/' . $filename);
define('CSV_PATH', 'uploads/csv/');
$inputFileName = CSV_PATH . $filename;
try {
$inputFileType = \PHPExcel_IOFactory::identify($inputFileName);
$objReader = \PHPExcel_IOFactory::createReader($inputFileType);
$objPHPExcel = $objReader->load($inputFileName);
} catch (Exception $e) {
die('Error loading file "' . pathinfo($inputFileName, PATHINFO_BASENAME) . '": ' . $e->getMessage());
}
// Get worksheet dimensions
$sheet = $objPHPExcel->getSheet(0);
$highestRow = $sheet->getHighestRow();
$highestColumn = $sheet->getHighestColumn();
// Loop through each row of the worksheet in turn
for ($row = 1; $row <= $highestRow; $row++) {
// Read a row of data into an array
$fillData = $sheet->rangeToArray('A' . $row . ':' . $highestColumn . $row, NULL, TRUE, FALSE);
// echo $fillData[0][0]."<br/>";
//foreach($rowData[0] as $k=>$v)
//echo "Row: ".$row."- Col: ".($k+1)." = ".$v."<br />";
//echo $v."<br/>";
$oCustomer = new Item();
$oCustomer->title = $fillData[0][1];
$oCustomer->address = $fillData[0][2];
$oCustomer->phone = $fillData[0][3];
$oCustomer->country = $fillData[0][7];
$oCustomer->government = $fillData[0][6];
$oCustomer->city = $fillData[0][5];
$oCustomer->district = $fillData[0][4];
$oCustomer->category_id = 1;
$oCustomer->status = 1;
//$oCustomer->title=$data[0];
$oCustomer->save();
if (strpos($fillData[0][8], ',') !== false) {
$products = explode(",", $fillData[0][8]);
if (!empty($products)) {
foreach ($products as $item) {
$oProduct = new CustomerItems();
$oProduct->customer_id = $oCustomer->item_id;
$oProduct->item_id = $item;
$oProduct->save();
}
}
} else {
if ($fillData[0][8] != '') {
$oProduct = new CustomerItems();
$oProduct->customer_id = $oCustomer->item_id;
$oProduct->item_id = $fillData[0][8];
$oProduct->save();
}
}
}
unlink('uploads/csv/' . $filename);
$this->flash('success', Yii::t('easyii/customers', 'Data Imported successfully'));
return $this->redirect(['/admin/customers/items/1']);
} else {
return $this->render('uploadcsv', ['model' => $model, 'filecsv' => $filecsv]);
}
die;
$model = new CsvForm();
$filecsv = '';
if ($model->load(Yii::$app->request->post())) {
$file = UploadedFile::getInstance($model, 'file');
$filename = 'Data.' . $file->extension;
$upload = $file->saveAs('uploads/csv/' . $filename);
if ($upload) {
define('CSV_PATH', 'uploads/csv/');
$csv_file = CSV_PATH . $filename;
$filecsv = file($csv_file);
if (!empty($filecsv)) {
foreach ($filecsv as $data) {
$fillData = explode(",", $data);
if ($data[0] != 'c') {
$oCustomer = new Item();
$oCustomer->title = $fillData[1];
$oCustomer->address = $fillData[2];
$oCustomer->phone = $fillData[3];
$oCustomer->district = $fillData[4];
$oCustomer->country = $fillData[7];
$oCustomer->government = $fillData[6];
$oCustomer->city = $fillData[5];
$oCustomer->category_id = 1;
$oCustomer->status = 1;
//$oCustomer->title=$data[0];
$oCustomer->save();
if (strpos($fillData[8], ',') !== false) {
$products = explode(",", $fillData[8]);
if (!empty($products)) {
foreach ($products as $item) {
$oProduct = new CustomerItems();
$oProduct->customer_id = $oCustomer->item_id;
$oProduct->item_id = $item;
$oProduct->save();
}
}
} else {
if ($fillData[8] != '') {
$oProduct = new CustomerItems();
$oProduct->customer_id = $oCustomer->item_id;
$oProduct->item_id = $fillData[8];
$oProduct->save();
}
}
}
}
}
unlink('uploads/csv/' . $filename);
$this->flash('success', Yii::t('easyii/customers', 'Data Imported successfully'));
return $this->redirect(['/admin/customers/items/1']);
}
} else {
return $this->render('uploadcsv', ['model' => $model, 'filecsv' => $filecsv]);
}
}
public function actionUploadCities()
{
$model = new XlsxFile();
$filecsv = '';
if ($model->load(Yii::$app->request->post())) {
$file = UploadedFile::getInstance($model, 'file');
$filename = 'Data.' . $file->extension;
$upload = $file->saveAs('uploads/csv/' . $filename);
define('CSV_PATH', 'uploads/csv/');
$inputFileName = CSV_PATH . $filename;
try {
$inputFileType = \PHPExcel_IOFactory::identify($inputFileName);
$objReader = \PHPExcel_IOFactory::createReader($inputFileType);
$objPHPExcel = $objReader->load($inputFileName);
} catch (Exception $e) {
die('Error loading file "' . pathinfo($inputFileName, PATHINFO_BASENAME) . '": ' . $e->getMessage());
}
// Get worksheet dimensions
$sheet = $objPHPExcel->getSheet(0);
$highestRow = $sheet->getHighestRow();
$highestColumn = $sheet->getHighestColumn();
//Delet old governrates
$cityobj = new Cities();
$cityobj->deleteAll();
// Loop through each row of the worksheet in turn
for ($row = 1; $row <= $highestRow; $row++) {
// Read a row of data into an array
$fillData = $sheet->rangeToArray('A' . $row . ':' . $highestColumn . $row, NULL, TRUE, FALSE);
// echo $fillData[0][0].'----'.$fillData[0][1].'-----'.$fillData[0][2]."<br/>";
if ($fillData[0][0] != "gov_code" and $fillData[0][0] != '') {
$cityobj = new Cities();
$cityobj->title = $cityobj->title_ar = $fillData[0][2];
$cityobj->government_code = $fillData[0][0];
$cityobj->id = $fillData[0][1];
if (!$cityobj->save()) {
// var_dump($cityobj->getErrors());
}
}
// foreach($fillData[0] as $k=>$v)
// echo "Row: ".$row."- Col: ".($k+1)." = ".$v."<br />";
// echo $v."<br/>";
// $oCustomer= new Item();
// $oCustomer->title=$fillData[0][1];
// $oCustomer->save();
}
unlink('uploads/csv/' . $filename);
$this->flash('success', Yii::t('easyii/customers', 'Data Imported successfully'));
return $this->redirect(['/admin/customers/items/1']);
} else {
return $this->render('uploadcsv', ['model' => $model, 'filecsv' => $filecsv]);
}
}