$arrayCount = count($allDataInSheet); $column_name = $allDataInSheet[1]["A"]; $extension = pathinfo($file_location, PATHINFO_EXTENSION); if ($extension === "xlsx" || $extension === "xls") { if (strtolower($column_name) === "pincode") { $query = sprintf("SELECT * FROM pos_attributes WHERE attribute_code='%s' LIMIT 1", strtolower($column_name)); $result = mysql_query($query); $action = "create"; $entity_id = $shop_id; while ($row = mysql_fetch_assoc($result)) { if ($row['backend_type'] === "int") { for ($i = 2; $i <= $arrayCount; $i++) { $pincode = trim($allDataInSheet[$i]["A"]); //$c1 = trim($allDataInSheet[$i]["A"]); //$c2 = trim($allDataInSheet[$i]["B"]); pos_shop_entity_int($entity_id, $row['attribute_id'], $pincode, $action); } } } } //unlink($file_location); echo $file_id; } else { echo 'system_error'; } } else { echo 'system_error'; } } } else { echo 'system_error';
$query = sprintf("SELECT * FROM pos_attributes WHERE attribute_code='%s' LIMIT 1", mysql_real_escape_string($key)); $result = mysql_query($query); $action = "create"; while ($row = mysql_fetch_assoc($result)) { switch ($row['backend_type']) { case "varchar": pos_shop_entity_varchar($entity_id, $row['attribute_id'], $value, $action); break; case "text": pos_shop_entity_text($entity_id, $row['attribute_id'], $value, $action); break; case "decimal": pos_shop_entity_decimal($entity_id, $row['attribute_id'], $value, $action); break; case "int": pos_shop_entity_int($entity_id, $row['attribute_id'], $value, $action); break; case "datetime": pos_shop_entity_datetime($entity_id, $row['attribute_id'], $value, $action); break; } } // while end here } // foreach end hete } } } } else { // To edit or Update shop information. parse_str($_SERVER["QUERY_STRING"], $query);
if ($is_dcharge_config) { $pin = $data['shop_delivery_pincode']; $pincodes = explode(',', $pin); $attribute_code = array('pincode', 'delivery_pin_config'); foreach ($attribute_code as $key) { $query = sprintf("SELECT * FROM pos_attributes WHERE attribute_code='%s' LIMIT 1", $key); $result = mysql_query($query); $action = "create"; while ($row = mysql_fetch_assoc($result)) { if ($key == 'pincode' && $row['backend_type'] === "int") { foreach ($pincodes as $pincode) { pos_shop_entity_int($shop_id, $row['attribute_id'], $pincode, $action); } } if ($key == 'delivery_pin_config' && $row['backend_type'] === "int") { pos_shop_entity_int($shop_id, $row['attribute_id'], 1, $action); } } } } // To test pincode configured or not $is_pincode_config = 0; $query = sprintf("SELECT * FROM pos_attributes WHERE attribute_code='delivery_pin_config' LIMIT 1"); $result = mysql_query($query); if (mysql_num_rows($result)) { while ($row = mysql_fetch_assoc($result)) { if ($row['backend_type'] == 'int') { $id = $row['attribute_id']; $query = "SELECT * FROM pos_shop_entity_int where entity_id = {$shop_id} AND attribute_id = {$id}"; $result = mysql_query($query); if (mysql_num_rows($result)) {