/** * Function displays a template for products image bulk uploading * * * @return array */ function productImagesBulkUpload() { include 'classes/Core/CRoleChecking.php'; $chkuser = Core_CRoleChecking::checkRoles(); if ($chkuser) { include 'classes/Core/CAdminHome.php'; include 'classes/Core/CProductBulkUpload.php'; include 'classes/Lib/ThumbImage.php'; include 'classes/Lib/FileOperations.php'; //$default=new Core_CProductBulkUpload(); //$default->productImagesBulkUpload(); $output['username'] = Core_CAdminHome::userName(); $output['currentDate'] = date('l, M d, Y H:i:s'); $output['currency_type'] = $_SESSION['currency']['currency_tocken']; $output['monthlyorders'] = (int) Core_CAdminHome::monthlyOrders(); $output['previousmonthorders'] = (int) Core_CAdminHome::previousMonthOrders(); $output['totalorders'] = (int) Core_CAdminHome::totalOrders(); $output['currentmonthuser'] = (int) Core_CAdminHome::currentMonthUser(); $output['previousmonthuser'] = (int) Core_CAdminHome::previousMonthUser(); $output['totalusers'] = (int) Core_CAdminHome::totalUsers(); $output['currentmonthincome'] = Core_CAdminHome::currentMonthIncome(); $output['previousmonthincome'] = Core_CAdminHome::previoustMonthIncome(); $output['totalincome'] = Core_CAdminHome::totalIncome(); $output['currentmonthproudctquantity'] = (int) Core_CAdminHome::currentMonthProudctQuantity(); $output['previousmonthproudctquantity'] = (int) Core_CAdminHome::previousMonthProudctQuantity(); $output['totalproudctquantity'] = (int) Core_CAdminHome::totalProudctQuantity(); $output['lowstock'] = Core_CAdminHome::lowStock(); $output['totalproducts'] = Core_CAdminHome::totalProducts(); $output['enabledproducts'] = Core_CAdminHome::enabledProducts(); $output['disabledproducts'] = Core_CAdminHome::disabledProducts(); $output['pendingorders'] = (int) Core_CAdminHome::pendingOrders(); $output['processingorders'] = (int) Core_CAdminHome::processingOrders(); $output['deliveredorders'] = (int) Core_CAdminHome::deliveredOrders(); $output['messages'] = Core_CProductBulkUpload::productImagesBulkUpload(); Bin_Template::createTemplate('imagebulkupload.html', $output); } else { $output['usererr'] = 'You are Not having Privilege to view this page contact your Admin for detail'; Bin_Template::createTemplate('Errors.html', $output); } }
/** * Function uploads a tsv file into the database. * * * @return string */ function uploadTSVFile() { //$tsvfilename= $_FILES['product_file']['name']; $tsvfilename = $_FILES['product_file']['tmp_name']; $legal_extentions = array("tsv"); $file = explode(".", $_FILES['product_file']['name']); if (count($file) > 2 || $file[1] != 'tsv') { return '<div class="alert alert-error"> <button type="button" class="close" data-dismiss="alert">×</button> The file you are attempting to upload is not supported by this server</div>'; } $file_ext = strtolower(end(explode(".", $_FILES['product_file']['name']))); if (!in_array($file_ext, $legal_extentions)) { return '<div class="alert alert-error"> <button type="button" class="close" data-dismiss="alert">×</button> The file you are attempting to upload is not supported by this server</div>'; } if (file_exists($tsvfilename) > 0) { // $stpath="uploadedtsvfile/".date("YmdHis").$tsvfilename; $stpath = "uploadedtsvfile/" . date("YmdHis") . "product.tsv"; if (move_uploaded_file($tsvfilename, $stpath)) { $targetpath = $stpath; if (file_exists($targetpath)) { $fp = fopen($targetpath, 'r'); $records = array(); $rowfirst = fgets($fp); $rowfirst = str_replace("\n", "", $rowfirst); $tmpfirst = explode("\t", trim($rowfirst)); $chkfieldsarr = array('category_id', 'title', 'description', 'sku', 'brand', 'model', 'msrp', 'price', 'weight', 'dimension', 'shipping_cost', 'status', 'tag', 'meta_desc', 'meta_keywords', 'is_featured', 'soh', 'rol'); $cmp_arr = array_diff($tmpfirst, $chkfieldsarr); if (empty($cmp_arr)) { $pro_fields = implode(',', $chkfieldsarr); $pro_cnt = 0; $fail_cnt = 0; while ($row = fgets($fp)) { $row = str_replace("\n", " ", $row); $pro = $inv = explode("\t", addslashes(trim($row))); $dflt = new Core_CProductBulkUpload(); $dflt->checkIsParentCategory($pro[0]); if ($dflt->checkIsParentCategory($pro[0])) { $pro = "'" . implode("','", array_splice($pro, 0, 16)) . "'"; $inv = implode(",", array_splice($inv, 16, 2)); $sql = ' INSERT INTO products_table( category_id, title, description, sku, brand, model, msrp, price, weight, dimension, shipping_cost, status , tag, meta_desc, meta_keywords, is_featured ) VALUES (' . $pro . ')'; $obj = new Bin_Query(); if ($obj->updateQuery($sql)) { $sql = ' INSERT INTO product_inventory_table( product_id, soh, rol ) VALUES (' . $obj->insertid . ',' . $inv . ')'; if ($obj->updateQuery($sql)) { $pro_cnt++; } else { $fail_cnt++; } } else { $fail_cnt++; } } else { $fail_cnt++; } } return '<div class="alert alert-success"> <button type="button" class="close" data-dismiss="alert">×</button> ' . $pro_cnt . ' Product(s) Created Successfullly . ' . $fail_cnt . ' Product(s) Not Created </div>'; } else { return '<div class="alert alert-error"> <button type="button" class="close" data-dismiss="alert">×</button> Please Check The Format Of TSV File </div>'; } fclose($fp); } else { return '<div class="alert alert-error"> <button type="button" class="close" data-dismiss="alert">×</button> Error Uploading File</div>'; } } else { return '<div class="alert alert-error"> <button type="button" class="close" data-dismiss="alert">×</button> TSV File is not created </div>'; } } }