query("update tbl_store_zip set zip='$zipcode[0]',storeid='$storeid',zone='$zone',city='$city',state='$state',url='$url',zone_status='$zonestatus',store_status='$storestatus',zip_area='$ziparea',hike='$hike',pickup='$pickup',delivery='$delivery',minimum='$minimum',delivery_fee='$deliveryfee',commission='$commission',minimum_fee='$minimumorderfee',ups='$upsstatus',sectionid='$sectionname',short_description='$short_desc',mini_description='$mini_desc',estd_delivery='$estd_delivery',open_time='$open_time',close_time='$close_time',wholesale_delevery_partner='$wholesalepartner',grocery_delivery_partner='$grocerypartner',food_delivery_partner='$foodpartner',alocohol_delivery_partner ='$alcoholpartner', food_delivery_slots = '$food_delivery_slots' where id='".$_REQUEST['id']."'"); $_SESSION['sess_msg']='Record updated sucessfully'; }else{ for($x=0; $x < count($zipcode); $x++){ $obj->query("insert into tbl_store_zip set zip='$zipcode[$x]',storeid='$storeid',zone='$zone',city='$city',state='$state',url='$url',zone_status='$zonestatus',store_status='$storestatus',zip_area='$ziparea',hike='$hike',pickup='$pickup',delivery='$delivery',minimum='$minimum',delivery_fee='$deliveryfee',commission='$commission',minimum_fee='$minimumorderfee',ups='$upsstatus',sectionid='$sectionname',short_description='$short_desc',mini_description='$mini_desc',estd_delivery='$estd_delivery',open_time='$open_time',close_time='$close_time',wholesale_delevery_partner='$wholesalepartner',grocery_delivery_partner='$grocerypartner',food_delivery_partner='$foodpartner',alocohol_delivery_partner ='$alcoholpartner',food_delivery_slots ='$food_delivery_slots',status=1"); } $_SESSION['sess_msg']='Record added sucessfully'; } header("location:zip-list.php"); exit(); } if($_REQUEST['id']!=''){ $sql=$obj->query("select *,s.storeid,z.zip,z.zip_area,z.city,z.status,z.sectionid from stores s inner join tbl_store_zip z on s.storeid=z.storeid where id=".$_REQUEST['id']); $result=$obj->fetchNextObject($sql); } ?> <?php echo SITE_TITLE; ?>
Admin: Add Zipcode

Zipcode Details


food_delivery_partner=='myvalue365'){ $display_slots = "display: table-cell"; } $foodDeliverySlots = (!empty($result->food_delivery_slots) ? explode(',', $result->food_delivery_slots) : array()); $sqlSlot = $obj->query("select * from tbl_bookingslot"); ?>
Zip Code:
Store Name:
Zone: " />
City:
State:
URL:
Zone Status: " />
Store Status: " />
Zip Area:
Price Hike ( % ):
Pickup: " />
Delivery: " />
Minimum: " />
Delivery Fee: " />
Commission ( % ):
Minimum Order Fee: " />
UPS Status: " />
Section Name: query("select id,section_name from tbl_section where status=1 order by section_name"); while($record=$obj->fetchNextObject($sql)){ $sectionids=explode(',',$result->sectionid); ?> id, $sectionids)) { echo 'checked'; }?> /> section_name;?>
Short Description:
Mini Description:
Estimated Delivery:
Opening Time: eg. 12:00:00
Closing Time: eg. 12:00:00
Wholesale Delivery Partner:
Grocery Delivery Partner:
Food Delivery Partner:
Booking Slots: fetchNextObject($sqlSlot)){ ?> id, $foodDeliverySlots)) { echo 'checked'; }?> /> bookingslot;?>
Alcohol Delivery Partner: