public function actionImport()
 {
     $total_records = 0;
     $inserted_records = 0;
     $msg = "";
     $model = new Product();
     $model->setScenario('importFile');
     $file = CUploadedFile::getInstance($model, 'csv_file');
     if (isset($_POST['Product'])) {
         //                          echo $_POST['Product']['import_option']; die();
         if (!empty($_FILES['Product']['tmp_name']['import_file'])) {
             $file = CUploadedFile::getInstance($model, 'import_file');
             $fp = fopen($file->tempName, 'r');
             $row = 1;
             if ($fp) {
                 $line = fgetcsv($fp, 1000, ",");
                 $first_time = true;
                 $c = 1;
                 if ($_POST['Product']['import_option'] == "Insert") {
                     do {
                         //var_dump($line); die();
                         if ($first_time == true) {
                             $first_time = false;
                             $headerLine = $line;
                             continue;
                         }
                         //$data = explode(",",$line);
                         //$data = $line[0];
                         //$data = explode(';',$line);
                         $fData = array_combine($headerLine, $line);
                         //echo '<pre>'; var_dump($fData); echo '</pre>'; die();
                         $email_id = $fData["business_email_id1"];
                         //echo '<pre>'; var_dump($modelObj); echo '</pre>'; die();
                         $modelObj = new Product();
                         $modelObj->setIsNewRecord(true);
                         $modelObj->attributes = $fData;
                         $modelObj->logo_photo_name = $fData['logo_photo_name'];
                         $modelObj->cover_photo_name = $fData['cover_photo_name'];
                         // echo '<pre>'; var_dump($modelObj); echo '</pre>'; die();
                         if ($modelObj->validate()) {
                             $modelObj->save();
                             var_dump($model->getErrors());
                         } else {
                             die(CVarDumper::dump($modelObj->errors, 10, true));
                         }
                         $modelObj->product_id;
                         $inserted_records = $inserted_records + 1;
                         $total_records = $total_records + 1;
                     } while (($line = fgetcsv($fp, 1000, ",")) != FALSE);
                     $msg = $inserted_records . " records are inserted" . " out of " . $total_records;
                     $this->render('import', array('model' => $model, 'total_records' => $total_records, 'inserted_records' => $inserted_records, 'msg' => $msg));
                 }
                 if ($_POST['Product']['import_option'] == "Update") {
                     do {
                         if ($first_time == true) {
                             $first_time = false;
                             $headerLine = $line;
                             continue;
                         }
                         //$data = explode(",",$line);
                         //$data = $line[0];
                         //$data = explode(',',$data);
                         //echo '<pre>'; var_dump($data); echo '</pre>'; die();
                         $fData = array_combine($headerLine, $line);
                         $email_id = $fData['business_email_id1'];
                         $modelObj = Product::model()->find('business_email_id1=:business_email_id1', array(':business_email_id1' => $email_id));
                         //echo '<pre>'; var_dump($modelObj); echo '</pre>'; die();
                         //                                                echo var_dump($modelObj);
                         if ($modelObj) {
                             $modelObj->attributes = $fData;
                             $modelObj->logo_photo_name = $fData['logo_photo_name'];
                             $modelObj->cover_photo_name = $fData['cover_photo_name'];
                             //   echo '<pre>'; var_dump($modelObj); echo '</pre>'; die();
                             $modelObj->save();
                             $modelObj->product_id;
                             $inserted_records = $inserted_records + 1;
                         }
                         $total_records = $total_records + 1;
                     } while (($line = fgetcsv($fp, 1000, ",")) != FALSE);
                     // echo "count:".$inserted_records.'---'.$total_records; die();
                     $msg = $inserted_records . " records are updated" . " out of " . $total_records;
                     $this->render('import', array('model' => $model, 'total_records' => $total_records, 'inserted_records' => $inserted_records, 'msg' => $msg));
                     //$this->redirect('././view');
                 }
             } else {
                 $msg = "Please select insert or update option for import file.";
                 $this->render('import', array('model' => $model, 'total_records' => $total_records, 'inserted_records' => $inserted_records, 'msg' => $msg));
             }
         } else {
             $msg = "Please upload file.";
             $this->render('import', array('model' => $model, 'total_records' => $total_records, 'inserted_records' => $inserted_records, 'msg' => $msg));
         }
     } else {
         $this->render('import', array('model' => $model, 'total_records' => $total_records, 'inserted_records' => $inserted_records, 'msg' => $msg));
     }
 }