Update Product Prices – Step 2

[insert_php]
global $wpdb;

if (empty($_REQUEST[“admid”])) {
$admid = 0;
} else {
$admid = $_REQUEST[“admid”];
}
if (empty($_REQUEST[“hpass”])) {
$hpass = ”;
} else {
$hpass = $_REQUEST[“hpass”];
}
if (empty($_REQUEST[“subBTN”])) {
$subBTN = ”;
} else {
$subBTN = $_REQUEST[“subBTN”];
}
if (empty($_REQUEST[“tablename”])) {
$tablename = ”;
} else {
$tablename = $_REQUEST[“tablename”];
}
if (empty($_REQUEST[“csvfile”])) {
$csvfile = ”;
} else {
$csvfile = $_REQUEST[“csvfile”];
}
$response = ”;

/**check admin **/
$result = $wpdb->get_results(“SELECT `adm-id`, `adm-name`, `adm-password` FROM wp_sc_admin where `adm-id` = ‘$admid’ and `adm-password` = ‘$hpass'”);

if (! $result) {
$admid = 0;
}

if ($admid != 0) {

if ($subBTN == ‘Update Prices’) {
if ($tablename == ”) {
$response = $response . “Please choose a Group to update.
“;
$subBTN = ”;
}
if ($csvfile == ”) {
$response = $response . “Please type the name of the loaded update file.
“;
$subBTN = ”;
}

// todo: change site url to production
$url = ‘https://saundersproduce.com/wp-content/uploads/’ . $csvfile;
//$url = ‘http://saunders.loc/wp-content/uploads/’ . $csvfile;

$handle = fopen($url, “rb”) or die(“Cannot find the file to load.”);

$sql = “DELETE from ” . $tablename;

$result = $wpdb->get_results($sql);

$lineadd = 0;
$lineupd = 0;

if ($handle) {
while (($data = fgetcsv($handle, 1000, “,”)) !== FALSE) {
$num = count($data);
$row++;

if ($data[1] == ”) {
$data[1] = 0;
}
if ($data[2] == ”) {
$data[2] = 0;
}
if ($data[3] == ”) {
$data[3] = 0;
}
if ($data[4] == ”) {
$data[4] = 0;
}
if ($data[5] == ”) {
$data[5] = 0;
}
if ($data[6] == ”) {
$data[6] = 0;
}

if (intval($data[0]) != 0) {
$sql = “INSERT into ” . $tablename . ” (`prp-prd-number`,`prp-case`,`prp-each`,`prp-lbs`,`prp-half`) VALUES (” . $data[0] . “,” . $data[2] . “,” . $data[3] . “,” . $data[4] . “,” . $data[5] . “)”;

$num_rows = $wpdb->query($sql);

if ($num_rows > 0) {
$lineupd = $lineupd + $num_rows;
}
}
}

fclose($handle);

if ($lineupd > 0) {
$dt = date(“m/d/Y”);
$dhr = date(“h”) – 4;
if ($dhr < 0) { $dhr = $dhr + 12; } $dmn = date("i:s"); $dt = $dt . " " . $dhr . ":" . $dmn; $sql = "UPDATE sc_grp_table_updates SET `sc_last_update` = '" . $dt . "', `sc_last_updateby` = '" . $admid . "' where `sc_grp_table` = '" . $tablename . "'"; $result = $wpdb->query($sql);
}

}

$response = $lineupd . ” product price updates complete.”;
$subBTN = ”;
}

if ($subBTN == ”) {
if ($response != ”) {
echo $response;
}

echo “

Group File Statistics:

    “;

    $sql = “SELECT `sc_grp_id`, `sc_last_update` FROM sc_grp_table_updates ORDER by `sc_grp_id`”;
    $result = $wpdb->get_results($sql, ARRAY_A);

    foreach ($result as $row) {
    echo “

  • Group ” . $row[‘sc_grp_id’] . ” last updated on ” . $row[‘sc_last_update’] . “

    • “;
    }

    echo “

“;

echo “

Step 2: Upload Product Prices

“;
echo “
“;
echo “

Instructions:”;
echo “
“;
echo “1. Choose the price list you are uploading to from the drop down menu,”;
echo “
“;
echo “2. Type in your uploaded file name (for example 120.csv) into the \”Uploaded File Name\” Box,”;
echo “
“;
echo “3. Click on \”Update Prices\”,”;
echo “
“;
echo “4. The number of product prices updated will show at the top,”;
echo “
“;
echo “5. Check to see that the last update for the price list is today’s date,”;
echo “
“;
echo “6. Repeat with other uploaded files.”;
echo “

“;

// todo: change url to WP
echo “

“;
//echo “
“;

echo ““;
echo ““;
echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo “

Prices for Group: “;
echo “
Uploaded File Name: “;

echo “

“;
echo “

“;
}

echo “

“;
echo ““;
echo ““;
echo ““;
echo “

“;

} else {
echo “Login cannot be verified. Please login again.”;
echo “

“;
echo “

“;
}
[/insert_php]