/**
* 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>';
}
}
}
