PHP PROJECT

PHP 7 ECOMMERCE PROJECT (SHOPWAP)

(SHOPWAP)

=>assest

1.<div class="container-fluid bg-white border-top py-3" style="margin-top:100px">

</span>

</div>

<button class="btn btn-dark">FOLLOW US</button><button class="btn border px-3"><a href="<?php echo $branding_result['facebook_url'];?>"><i class="fa fa-facebook"></i></a></button>

</div>

<h5 class="text-light">CATEGORY</h5>

<?php

$get_menu="SELECT category_name FROM category";

$get_menu_response=$db->query($get_menu);

if($get_menu_response)

{

while($nav=$get_menu_response->fetch_assoc())

{

echo "<a href='#' class='d-block py-2 text-capitalize'>".$nav['category_name']."</a>";

}

</div>

<h5 class="text-light">POLICIES</h5>

<a href="privacy.php" class="d-block py-2">Privacy policy</a>

<a href="cookies.php" class="d-block py-2">Cookies policy</a>

<a href="terms.php" class="d-block py-2">Terms $ conditions</a>

</div>

<h5 class="text-light">CONTACTS</h5>

<p class="text-light">Venue : <?php echo $branding_result['address'];?></p>

<p class="text-light">Email : <?php echo $branding_result['email'];?></p>

<p class="text-light">Website : <?php echo $branding_result['domain_name'];?></p>

</div>

2.<?php

session_start();

$cart_count="";

$branding_result="";

$get_branding_data="SELECT * FROM branding";

$branding_response=$db->query($get_branding_data);

if($branding_response)

{

$branding_result=$branding_response->fetch_assoc();

}

$menu="";

if(empty($_COOKIE['_au_']))

{

$menu='<a href="signup.php" class="dropdown-item"><i class="fa fa-user">Sign up</i></a>

<a href="signin.php" class="dropdown-item"><i class="fa fa-sign-in">Sign in</i></a>';

}

else{

$fullname="";

$username=base64_decode($_COOKIE['_au_']);

$get_data="SELECT * FROM users WHERE email='$username'";

$response=$db->query($get_data);

if($response)

{

$data=$response->fetch_assoc();

$fullname=$data['firstname']." ".$data['lastname'];

$_SESSION['fullname'] =$fullname;

$_SESSION['mobile']=$data['mobile'];

$_SESSION['pincode']=$data['pincode'];

}

$menu='<a href="http://localhost/shop/profile" class="dropdown-item text-capitalize"><i class="fa fa-user"></i> '.$fullname.'</a><a href="http://localhost/shop/pages/php/signout.php" class="dropdown-item"><i class="fa fa-sign-out"></i> Sign out</a>';

$get_cart="SELECT COUNT(id) AS result FROM cart WHERE username='$username'";

$response=$db->query($get_cart);

if($response->num_rows !=0)

{

$data=$response->fetch_assoc();

if($data['result'] !=0)

{$cart_count= '<div style="position:absolute;width:25px;height:25px;background-color:red;color:white;font-weight:bold;border-radius:50%;z-index:1000;left:25px;top:-10px" class="cart-notification">

<span>'.

$data["result"].'

</span>

</div>';

}

<?php

$logo_string=base64_encode($branding_result['brand_logo']);

$complete_src="data:image/png;base64,".$logo_string;

echo "<img src='".$complete_src."' width='20'>";

echo "&nbsp";

echo "<small>".$branding_result['brand_name']."</small>";

</a>

<?php

$get_menu="SELECT category_name FROM category";

$get_menu_response=$db->query($get_menu);

if($get_menu_response)

{

while($nav=$get_menu_response->fetch_assoc())

{

echo "<li class='nav-item'><a href='http://localhost/shop/products/".$nav['category_name']."' class='nav-link text-uppercase text-dark'>".$nav['category_name']."</a>";

}

</ul>

</div>

<?php echo $cart_count;?>

</a>

</button>

</button>

</button>

<?php echo $menu;?>

</div>

</button>

</div>

</nav>

</div>

=>common_files

1.database.php

<?php

$db=new mysqli("localhost","root","","shopwap");

=>employee_panel

->dynamic_pages

1.branding_design

<?php

echo '<div class="row animated fadeIn">

<label for="brand-name" class="brand-name" class="font-weight-bold">Enter brand name

<i class="fa fa-edit branding-edit" style="cursor:pointer;">Edit details</i>

</label>

</div>

<label for="brand-logo" class="brand-logo" class="font-weight-bold">Upload brand logo</label>

</div>

<label for="domain-name" class="domain-name" class="font-weight-bold">Enter domain name</label>

</div>

<label for="email" class="email-name" class="font-weight-bold">Email</label>

</div>

<label for="facebook-url" class="facebook-url" class="font-weight-bold">Social handlers</label>

</div>

</div>

<label for="address" class="address" class="font-weight-bold">Address</label>

</div>

<label for="phone" class="brand-name" class="font-weight-bold">Phone</label>

</div>

<label for="about-us" class="about-us" class="font-weight-bold">About us <small class="about-us-count">0</small><small>/5000</small></label>

</div>

<label class="privacy-policy" class="font-weight-bold">Privacy policy <small class="privacy-count">0</small><small>/5000</small></label>

</div>

<label for="cookies-policy" class="font-weight-bold">Cookies policy <small class="cookies-count">0</small><small>/5000</small></label>

</div>

<label class="terms" class="font-weight-bold">Terms and conditions <small class="terms-count">0</small><small>/5000</small></label>

</div>

<button type="submit" class="branding-submit-btn btn btn-primary py-2">Submit your information</button>

</form></div>

</div>';

2.category_showcase_design

<?php

require("../../common_files/php/database.php");

echo '<div class="row">';

$dir=['top-left','bottom-left','center','top-right','bottom-right'];

$top_left_image="../common_files/images/small_sample.jpg";

$top_left_label="";

$bottom_left_image="../common_files/images/small_sample.jpg";

$bottom_left_label="";

$center_image="../common_files/images/large_sample.jpg";

$center_label="";

$top_right_image="../common_files/images/small_sample.jpg";

$top_right_label="";

$bottom_right_image="../common_files/images/small_sample.jpg";

$bottom_right_label="";

for($i=0;$i<count($dir);$i++)

{

$get_data="SELECT * FROM category_showcase WHERE direction='$dir[$i]'";

$response=$db->query($get_data);

if($response)

{

$data=$response->fetch_assoc();

if($dir[$i] == "top-left")

{

if($response->num_rows !=0)

{$top_left_image="data:image/png;base64,".base64_encode($data['image']);

$top_left_label=$data['label'];}

}

else if($dir[$i] == "bottom-left")

{

if($response->num_rows !=0)

{$bottom_left_image="data:image/png;base64,".base64_encode($data['image']);

$bottom_left_label=$data['label'];}

}

else if($dir[$i] == "center")

{

if($response->num_rows !=0)

{

$center_image="data:image/png;base64,".base64_encode($data['image']);

$center_label=$data['label'];}

}

else if($dir[$i] == "top-right")

{

if($response->num_rows !=0)

{

$top_right_image="data:image/png;base64,".base64_encode($data['image']);

$top_right_label=$data['label'];}

}

else if($dir[$i] == "bottom-right")

{

if($response->num_rows !=0)

{

$bottom_right_image="data:image/png;base64,".base64_encode($data['image']);

$bottom_right_label=$data['label'];}

}

<?php echo '<div class="col-md-4">

</button>

</button>

SET

</button>

</div>

</div>

</button>

</button>

SET

</button>

</div>

</div>

</button>

</button>

SET

</button>

</div>

<img src="';?><?php echo $center_image;?>" alt="large sample" class="w-100 mb-3">

</div>

</button>

</button>

SET

</button>

</div>

</div>

</button>

</button>

SET

</button>

</div>

</div>

</div>';?>

3.create_brands_design

<?php

require("../../common_files/php/database.php");

$get_category_name="SELECT * FROM category";

$response=$db->query($get_category_name);

$multi_result=[];

if($response)

{

while($data=$response->fetch_assoc())

{

array_push($multi_result,$data["category_name"]);

}

echo '<div class="row slideInDown">

<h5 class="my-3">CREATE BRANDS<i class="fa fa-circle-o-notch fa-spin close brand-loader d-none" style="font-size:18px"></i></h5>

<option>Choose category</option>';

for($i=0;$i<count($multi_result);$i++)

{

echo "<option>".$multi_result[$i]."</option>";

}

echo '</select>

</div>

<button class="btn btn-primary mb-3 add-brand-btn" type="button"><i class="fa fa-plus"></i> Add fields</button>

<button class="btn btn-danger mb-3 create-brand-btn" type="submit">CREATE</button>

</div>

</form>

</div>

</div>

<option>Choose category</option>';

for($i=0;$i<count($multi_result);$i++)

{

echo "<option>".$multi_result[$i]."</option>";

}

echo '</select>

<h5 class="my-3">BRANDS LIST <i class="fa fa-circle-o-notch fa-spin display-brand-loader d-none close"></i></h5>

<hr>

</div>

</div>';

4.create_category_design

<?php

echo '

<h5 class="my-3">CREATE CATEGORY

</h5>

</div>

Add field

</button>

Create

</button>

</div>

</form>

</div>

<h5 class="my-3">CATEGORY LIST</h5>

<hr>

</div>

5.create_products_design

<?php

require_once("../../common_files/php/database.php");

echo '<div class="row slideInDown">

<h5 class="my-3">CREATE PRODUCTS</h5>

</div>

</div>

<option>Choose brands</option>';

$get_data="SELECT * FROM brands";

$response=$db->query($get_data);

if($response)

{

while($data=$response->fetch_assoc())

{

echo "<option c-name='".$data['category_name']."'>".$data['brands']."</option>";

}

echo '</select>

</div>

<label for="description">DESCRIPTION</label>

</textarea>

</div>

<label for="price">PRICE</label>

</div>

<label for="price">QUANTITY</label>

</div>

<span>THUMB</span>

</button>

</div>

<span>FRONT</span>

</button>

</div>

</button>

</div>

</button>

</div>

<span>RIGHT</span>

</button>

</div>

</div>

</button>

</div>

<button type="submit" class="create-products-form btn btn-danger w-100 py-2">SUBMIT</button>

</div>';

6.delivery_area_design

<?php

require("../../common_files/php/database.php");

echo '<div class="row">

<h4>SET DELIVERY LOCATION</h4>

<option>Choose country</option>';?>

<?php

$get_countries="SELECT * FROM countries";

$response=$db->query($get_countries);

if($response)

{

while($data=$response->fetch_assoc())

{

echo "<option country-id='".$data['id']."'>".$data['name']."</option>";

}

<?php

echo '</select>

<option>Choose state</option>

</select>

<option>Choose city</option>

</select>

<input type="number" class="form-control pincode mb-3"

placeholder="pincode" name="pincode">

<option>Choose payment mode</option>

<option>Online</option>

</select>

</form>

</div>

</div>';

7.header_showcase_design

<?php

require_once("../../common_files/php/database.php");

echo '<div class="row">

<label for="title-image">Title image <span>200kb (1920*978)</span></label>

<label for="title-text">Title text <span class="title-limit">0</span><span>/40</span></label>

</div>

<label for="subtitle-text">Subtitle text<span class="subtitle-limit">0</span><span>/100</span></label>

</div>

<label for="create-button">Create buttons</label>

</div>

<span class="input-group-text">BG COLOR</span>

</div>

<span class="input-group-text">TEXT COLOR</span>

</div>

</div>

</div>

<option value="16px">small</option>

<option value="20px">medium</option>

<option value="24px">large</option>

</select>

</div>

<button class="btn btn-primary py-2 add-showcase-btn showcase-form" type="submit">Add showcase</button>

<button class="btn btn-primary py-2 real-preview-btn" type="button">Real preview</button>

</div>

<label for="edit-title">Edit title</label>

<option>Choose title</option>';?>

<?php

$get_data="SELECT * FROM header_showcase";

$response=$db->query($get_data);

$count=0;

if($response)

{

while($data=$response->fetch_assoc())

{

$count+=1;

echo "<option value=".$data['id'].">".$count."</option>";

}

<?php

echo '</select>

</div>

</form>

</div>

<h1 class="showcase-title target">TITLE</h1>

<h4 class="showcase-subtitle target">SUBTITLE</h4>

</div>

<button class="btn btn-light">Color</button>

</button>

</div>

</button>

</div>

<button class="btn btn-light dropdown-toggle" data-toggle="dropdown"><span>Alignment</span>

<span class="dropdown-item alignment" align-position="h" align-value="center">CENTER</span>

<span class="dropdown-item alignment" align-position="h" align-value="flex-end">RIGHT</span>

<span class="dropdown-item alignment" align-position="v" align-value="center">V-CENTER</span>

<span class="dropdown-item alignment" align-position="v" align-value="flex-end">BOTTOM</span>

</div>

</button>

</div>

</div>';

8.keyword_design

<?php

require_once("../../common_files/databases/database.php");

echo '<div class="row">

<h4>KEYWORD PLANNER FOR CATEGORY</h4>

<label for="p-keyword">Primary keyword</label>

<option>Choose primary keyword</option>';?>

<?php

$get_data="SELECT * FROM category";

$response=$db->query($get_data);

if($response)

{

while($data=$response->fetch_assoc())

{

echo "<option>".$data['category_name']."</option>";

}

<?php

echo '</select>

</div>

<label for="s-keyword">Secondary keyword</label>

</div>

<button class="btn btn-primary">UPDATE</button>

</div>

</form>

</div>

<h4>FAILED KEYWORDS :  </h4>

<?php

$get_data="SELECT * FROM failed_keywords";

$count=0;

$failed_keywords=[];

$response=$db->query($get_data);

if($response)

{

while($data=$response->fetch_assoc())

{

$count++;

array_push($failed_keywords, $data['keyword']);

}

echo $count;

}

else{

echo "0";

}

<?php echo '</h5>

</div>

<?php

$i;

for($i=0;$i<count($failed_keywords);$i++)

{

echo "<div class='alert alert-danger p-2 mr-2 tags'>".$failed_keywords[$i]." <i class='fa fa-times-circle' data-dismiss='alert'></i> </div>";

}

<?php echo '</div>

<button class="btn btn-primary copy-btn-category mb-3 w-100">COPY TO CATEGORY CLIPBOARD</button>

<button class="btn btn-primary copy-btn-brands mb-3 w-100">COPY TO BRANDS CLIPBOARD</button>

<button class="btn btn-primary copy-btn-products mb-3 w-100">COPY TO PRODUCTS CLIPBOARD</button>

<button class="btn btn-danger delete-keyword w-100">DELETE UPDATED KEYWORD</button>

</div>

<h4>KEYWORD PLANNER FOR BRANDS</h4>

<label for="brands-category">Category</label>

<option>Choose</option>';?>

<?php

$get_data="SELECT * FROM category";

$response=$db->query($get_data);

if($response)

{

while($data=$response->fetch_assoc())

{

echo "<option>".$data['category_name']."</option>";

}

<?php echo '</select>

</div>

<label for="brands-p-keyword">Primary key</label>

<option>Choose primary key</option>

</select>

</div>

<label for="brands-s-keyword">Secondary keyword</label>

</div>

<button class="btn btn-primary">UPDATE</button>

</div>

</form>

</div>

</div>

<h4>KEYWORD PLANNER FOR PRODUCT</h4>

<label for="products-c-list">Category</label>

<option>Choose</option>';?>

<?php

$get_data="SELECT * FROM category";

$response=$db->query($get_data);

if($response)

{

while($data=$response->fetch_assoc())

{

echo "<option>".$data['category_name']."</option>";

}

<?php echo '</select>

</div>

<label for="products-brands">Brands</label>

<option>Choose</option>

</select>

</div>

<label for="products">Primary keyword</label>

<option>Choose primary keyword</option>

</select>

</div>

<label for="products-s-keyword">Secondary keyword</label>

</div>

<button class="btn btn-primary">UPDATE</button>

</div>

</form>

</div>

</div>';?>

9.sales_report_design

<?php

require_once("../../common_files/databases/database.php");

echo '<div class="row">

<option value="todays-sales">Todays Sales</option>

<option value="new-sales">New Sales</option>

<option value="old-sales">Old Sales</option>

<option value="processing">Not Dispatched</option>

<option value="dispatched">Dispatched Products</option>

<option value="returned">Returned Products</option>

</select>

</button>

DISPATCH ALL

</button>

</div>

<button class="btn bg-white">EXPORT TO</button>

<option>Choose format</option>

</select>

</button>

</div>

<tr>

<th>PRODUCT_ID</th>

<th>TITLE</th>

<th>QUANTITY</th>

<th>PRICE</th>

<th>ADDRESS</th>

<th>STATE</th>

<th>COUNTRY</th>

<th>PINCODE</th>

<th>PURCHASE DATE</th>

<th>CUSTOMER NAME</th>

<th>USERNAME</th>

<th>MOBILE</th>

<th>STATUS</th>

<th>ACTION</th>

</tr>';?>

<?php

$get_data="SELECT * FROM purchase";

$response=$db->query($get_data);

if($response)

{

while($data=$response->fetch_assoc())

{

echo "<tr>";

echo "<td class='s-no'>";

echo $data['id'];

echo "</td>";

echo "<td>";

echo $data['product_id'];

echo "</td>";

echo "<td>";

echo $data['title'];

echo "</td>";

echo "<td>";

echo $data['qnt'];

echo "</td>";

echo "<td>";

echo $data['amount'];

echo "</td>";

echo "<td>";

echo $data['address'];

echo "</td>";

echo "<td>";

echo $data['state'];

echo "</td>";

echo "<td>";

echo $data['country'];

echo "</td>";

echo "<td>";

echo $data['pincode'];

echo "</td>";

echo "<td>";

echo $data['purchase_date'];

echo "</td>";

echo "<td>";

echo $data['fullname'];

echo "</td>";

echo "<td>";

echo $data['email'];

echo "</td>";

echo "<td>";

echo $data['mobile'];

echo "</td>";

echo "<td class='status'>";

echo $data['status'];

echo "</td>";

$dispatched_date=date_create($data['dispatched_date']);

$final_date=$dispatched_date->format('d-m-Y');

echo "<td>";

if($data['status'] == "processing")

{echo "<button class='dispatch-btn btn btn-primary' order-id='".$data['id']."' fullname='".$data['fullname']."' email='".$data['email']."' address='".$data['address']."' qnt='".$data['qnt']."' title='".$data['title']."' amount='".$data['amount']."' mobile='".$data['mobile']."'>DISPATCH</button>";}

else if($data['status'] == "dispatched")

{

echo "<button class='btn btn-danger' order-id='".$data['id']."' fullname='".$data['fullname']."' email='".$data['email']."' address='".$data['address']."' qnt='".$data['qnt']."' title='".$data['title']."' amount='".$data['amount']."' mobile='".$data['mobile']."'>ALREADY DISPATCHED ON ".$final_date."</button>";

}

echo "</td>";

echo "</tr>";

}

<?php echo '

</table>

</div>

</div>'?>

=>js

->index.js

$(document).ready(function(){

$(".stock-update-btn").click(function(){

$(".stock-update-btn-menu").collapse('toggle');

});

$(".homepage-design-btn").click(function(){

$(".homepage-design-collapse").collapse('toggle');

});

//dynamic request

$(document).ready(function(){

var active_link=$(".active").attr("access-link");

dynamic_request(active_link);

$(".collapse-item").each(function(){

$(this).click(function(){

var request_link=$(this).attr("access-link");

dynamic_request(request_link);

});

//active tab

$(document).ready(function(){

var i;

$(".collapse-item").each(function(){

$(this).click(function(){

for(i=0;i<$(".collapse-item").length;i++)

{

$(".collapse-item").removeClass("active");

}

$(this).addClass("active");

});

function dynamic_request(request_link){

$.ajax({

type:"POST",

url:"dynamic_pages/"+request_link,

xhr:function(){

var request=new XMLHttpRequest();

request.onprogress=function(e)

{

var percentage=Math.floor((e.loaded*100)/e.total);

var loader='<center><button class="btn btn-danger" style="font-size:30px"><i class="fa fa-circle-o-notch fa-spin"></i> Loading '+percentage+'</button></center>';

$(".page").html(loader);

}

return request;

beforeSend:function(){

var loader='<center><button class="btn btn-danger" style="font-size:30px"><i class="fa fa-circle-o-notch fa-spin"></i></button></center>';

$(".page").html(loader);

success:function(response)

{

$(".page").html(response);

if(request_link == "delivery_area_design.php")

{

delivery_area();

}

if(request_link == "header_showcase_design.php")

{

header_showcase();

}

if(request_link == "category_showcase_design.php")

{

category_showcase();

}

if(request_link == "branding_design.php")

{

branding_information();

}

if(request_link == "sales_report_design.php")

{

sales_report();

}

if(request_link == "keyword_design.php")

{

keyword();

}

//create products

$(".create-products-form").submit(function(e){

var option=$(".brands-name option");

var i;

var c_name="";

for(i=0;i<option.length;i++)

{

if(option[i].innerHTML == $(".brands-name").val())

{

c_name=$(option[i]).attr("c-name");

}

e.preventDefault();

if($(".brands-name").val() != "Choose brand")

{

$.ajax({

type:"POST",

url:"php/create_products.php?c_name="+c_name,

data:new FormData(this),

processData:false,

contentType:false,

cache:false,

xhr:function(){

var request=new XMLHttpRequest();

request.upload.onprogress=function(e){

var percentage=Math.floor((e.loaded*100)/e.total);

$(".create-products-progress .progress-bar").css({

width:percentage+"%"

});

$(".create-products-progress .progress-bar").html(percentage+"%");

}

return request;

beforeSend:function(){

$(".create-products-progress").removeClass("d-none");

success:function(response)

{

if(response.trim() == "success")

{

$(".create-products-progress").addClass("d-none");

$(".create-products-progress .progress-bar").css({width:'0%'});

$(".create-products-form").trigger('reset');

setTimeout(function(){

$("#sub-modal").modal();

//send notification

$(".send-btn").click(function(){

$.ajax({

type:"POST",

url:"php/send_notification.php",

beforeSend:function(){

$(".send-btn").html("SENDING...");

success:function(response){

if(response.trim() == "success")

{

$(".send-btn").html("SUCCESS");

setTimeout(function(){

$("#sub-modal").modal({

show:false

});

},2000);

}

else{

$(".send-btn").html(response.trim());

}

});

},1000);

}

else{

alert(response);

}

});

}

else{

alert("Please choose a brand");

}

});

if(request_link == "create_category_design.php")

{

category_list();

}

$(".add-field-btn").click(function(){

var placeholder=$(".input:first").attr("placeholder");

var input=document.createElement("INPUT");

input.type="text";

input.className="form-control input mb-3";

input.placeholder=placeholder;

input.required="required";

input.style.background="#f9f9f9";

input.style.border="none";

$(".add-field-area").append(input);

});

$(".create-btn").click(function(e){

e.preventDefault();

var input=[];

var input_length=$(".input").length;

var i;

for(i=0;i<input_length;i++)

{

input[i]=document.getElementsByClassName("input")[i].value;

}

var object=JSON.stringify(input);

$.ajax({

type:"POST",

url:"php/create_category.php",

data:{

json_data:object

beforeSend:function(){

$(".create-category-loader").removeClass("d-none");

success:function(response)

{

$(".create-category-loader").addClass("d-none");

if(response.trim() == "Done")

{

category_list();

var notice=document.createElement("DIV");

notice.className="alert alert-success";

notice.innerHTML="<b>Success !</b>";

$(".create-category-notice").html(notice);

setTimeout(function(){

$(".create-category-notice").html("");

$(".create-category-form").trigger('reset');

},3000);

}

else{

var notice=document.createElement("DIV");

notice.className="alert alert-warning";

notice.innerHTML="<b>"+response+"</b>";

$(".create-category-notice").html(notice);

setTimeout(function(){

$(".create-category-notice").html("");

$(".create-category-form").trigger('reset');

},3000);

}

});

//add brand field

$(".add-brand-btn").click(function(){

var placeholder=$(".brand-input:first").attr("placeholder");

var input=document.createElement("INPUT");

input.type="text";

input.className="form-control brand-input mb-3";

input.placeholder=placeholder;

input.required="required";

input.style.background="#f9f9f9";

input.style.border="none";

$(".brand-field-area").append(input);

});

//create brands

$(".create-brand-btn").click(function(e){

e.preventDefault();

var category=$(".brand-category").val();

if(category == "Choose category")

{

var notice=document.createElement("DIV");

notice.className="alert alert-warning";

notice.innerHTML="<b>Please choose a category</b>";

$(".brand-field-notice").html(notice);

setTimeout(function(){

$(".brand-field-notice").html("");

},3000);

}

else{

var input=[];

var input_length=$(".brand-input").length;

var i;

for(i=0;i<input_length;i++)

{

input[i]=document.getElementsByClassName("brand-input")[i].value;

}

var object=JSON.stringify(input);

$.ajax({

type:"POST",

url:"php/create_brands.php",

data:{

json_data:object,

category:category

beforeSend:function(){

$(".brand-loader").removeClass("d-none");

success:function(response)

{

$(".brand-loader").addClass("d-none");

if(response.trim() == "Done")

{

var notice=document.createElement("DIV");

notice.className="alert alert-success";

notice.innerHTML="<b>Success !</b>";

$(".brand-field-notice").html(notice);

setTimeout(function(){

$(".brand-field-notice").html("");

$(".brand-form").trigger('reset');

},3000);

}

else{

var notice=document.createElement("DIV");

notice.className="alert alert-warning";

notice.innerHTML="<b>"+response+"</b>";

$(".brand-field-notice").html(notice);

setTimeout(function(){

$(".brand-field-notice").html("");

$(".brand-form").trigger('reset');

},3000);

}

});

}

});

//display brands name

$(document).ready(function(){

$(".display-brand").on("change",function(){

var selected_cat_name=$(this).val();

var all_option=$(this).html().replace("<option>Choose category</option>").replace("<option>"+selected_cat_name+"</option>");

$.ajax({

type:"POST",

url:"php/display_brands.php",

data:{

category_name:selected_cat_name

beforeSend:function(){

$(".display-brand-loader").removeClass("d-none");

success:function(response)

{

if(response.trim() != "<b>No brands has been created yet in this category</b>")

{var table=document.createElement("table");

table.width="100%";

table.border="1";

table.className="text-center";

var top_tr=document.createElement("tr");

var th_cat=document.createElement("th");

th_cat.height="40";

th_cat.innerHTML="CATEGORY";

th_cat.className="bg-danger text-light";

var th_brands=document.createElement("th");

th_brands.height="40";

th_brands.innerHTML="BRANDS NAME";

th_brands.className="bg-danger text-light";

var th_edit=document.createElement("th");

th_edit.height="40";

th_edit.innerHTML="EDIT";

th_edit.className="bg-danger text-light";

var th_delete=document.createElement("th");

th_delete.height="40";

th_delete.innerHTML="DELETE";

th_delete.className="bg-danger text-light";

top_tr.append(th_cat);

top_tr.append(th_brands);

top_tr.append(th_edit);

top_tr.append(th_delete);

table.append(top_tr);

$(".display-brand-loader").addClass("d-none");

var json_data=JSON.parse(response);

var i;

for(i=0;i<json_data.length;i++)

{

var tr=document.createElement("tr");

var td_cat=document.createElement("td");

var td_brands=document.createElement("td");

td_cat.innerHTML="<select disabled='disabled' class='border p-2 w-75 dynamic-c-name'><option>"+json_data[i].category_name+"</option>"+all_option+"</select>";

td_brands.innerHTML=json_data[i].brands;

var td_edit=document.createElement("td");

td_edit.innerHTML= "<i class='fa fa-edit brand-edit' b-name='"+json_data[i].brands+"' c-name='"+json_data[i].category_name+"'></i><i class='fa fa-save brand-save d-none' b-name='"+json_data[i].brands+"' c-name='"+json_data[i].category_name+"'></i>";

var td_delete=document.createElement("td");

td_delete.innerHTML= "<i class='fa fa-trash brand-delete' b-name='"+json_data[i].brands+"' c-name='"+json_data[i].category_name+"'></i>";

table.append(tr);

tr.append(td_cat);

tr.append(td_brands);

tr.append(td_edit);

tr.append(td_delete);

$(".brand-list-area").html(table);

//delete brand

$(".brand-delete").each(function(){

$(this).click(function(){

var delete_icon=this;

var c_name=$(this).attr("c-name");

var b_name=$(this).attr("b-name");

$.ajax({

type:"POST",

url:"php/delete_brands.php",

data:{

c_name:c_name,

b_name:b_name

success:function(response)

{

if(response.trim() == "<b>Delete success</b>")

{

var row=delete_icon.parentElement.parentElement;

row.remove();

}

else{

alert(response);

}

});

//brand edit

$(".brand-edit").each(function(){

$(this).click(function(){

var edit_icon=this;

$(this).addClass("d-none");

var c_name=$(this).attr("c-name");

var b_name=$(this).attr("b-name");

var row=this.parentElement.parentElement;

var td=row.getElementsByTagName("TD");

var select_tag=td[0].getElementsByClassName("dynamic-c-name")[0];

select_tag.disabled=false;

td[1].contentEditable=true;

td[1].focus();

var delete_icon=td[3].getElementsByClassName("brand-delete")[0];

var save_icon=td[2].getElementsByClassName("brand-save")[0];

$(save_icon).removeClass("d-none");

save_icon.onclick=function(){

$.ajax({

type:"POST",

url:"php/edit_brands.php",

data:{

previous_c_name:c_name,

previous_b_name:b_name,

c_name:select_tag.value,

b_name:td[1].innerHTML

success:function(response)

{

if(response.trim() == "<b>Success</b>")

{

$(save_icon).addClass("d-none");

$(edit_icon).removeClass("d-none");

td[1].contentEditable=false;

select_tag.disabled=true;

$(edit_icon).attr("c-name",select_tag.value);

$(edit_icon).attr("b-name",td[1].innerHTML);

$(save_icon).attr("c-name",select_tag.value);

$(save_icon).attr("b-name",td[1].innerHTML);

$(delete_icon).attr("c-name",select_tag.value);

$(delete_icon).attr("b-name",td[1].innerHTML);

}

});

}

});

}

else{

$(".display-brand-loader").addClass("d-none");

$(".brand-list-area").html(response);

}

});

}

});

}

//category list request

$(document).ready(function(){

category_list();

});

function category_list(){

$.ajax({

type:"POST",

url:"php/category_list.php",

success:function(response)

{

var category_list=JSON.parse(response);

var i;

for(i=0;i<category_list.length;i++)

{

var id=category_list[i].id;

var name=category_list[i].category_name;

var ul=document.createElement("UL");

ul.className="list-group";

var li=document.createElement("LI");

li.className="list-group-item mb-3 border-0";

ul.append(li);

var div=document.createElement("DIV");

div.className="btn-group";

li.append(div);

var id_btn=document.createElement("BUTTON");

id_btn.innerHTML=id;

id_btn.className="btn btn-danger id";

div.append(id_btn);

var name_btn=document.createElement("BUTTON");

name_btn.innerHTML=name;

name_btn.className="btn btn-dark name";

div.append(name_btn);

var edit_btn=document.createElement("BUTTON");

edit_btn.innerHTML="<i class='fa fa-edit edit-icon'></i><i class='fa fa-save save-icon d-none'></i>";

edit_btn.className="btn btn-info";

div.append(edit_btn);

var delete_btn=document.createElement("BUTTON");

delete_btn.innerHTML="<i class='fa fa-trash delete-icon'></i>";

delete_btn.className="btn btn-danger";

div.append(delete_btn);

$(".category-area").append(ul);

//edit category name

edit_btn.onclick=function(){

var parent=this.parentElement;

var id=parent.getElementsByClassName("id")[0];

var cat_name=parent.getElementsByClassName("name")[0];

var save_icon=parent.getElementsByClassName("save-icon")[0];

var edit_icon=parent.getElementsByClassName("edit-icon")[0];

cat_name.contentEditable=true;

cat_name.focus();

$(save_icon).removeClass("d-none");

$(edit_icon).addClass("d-none");

$(save_icon).click(function(){

var changed_name=cat_name.innerHTML.trim();

$.ajax({

type:"POST",

url:"php/edit_category_name.php",

data:{

id:id.innerHTML.trim(),

changed_name:changed_name

cache:false,

success:function(response)

{

if(response.trim() == "success")

{

cat_name.contentEditable=false;

$(save_icon).addClass("d-none");

$(edit_icon).removeClass("d-none");

}

else{

alert(response);

}

});

}

//dlete category

delete_btn.onclick=function(){

var parent=this.parentElement;

var id=parent.getElementsByClassName("id")[0].innerHTML.trim();

$.ajax({

type:"POST",

url:"php/delete_category_name.php",

data:{

id:id

cache:false,

success:function(response)

{

if(response.trim() == "success")

{

parent.parentElement.parentElement.remove();

}

else{

alert(response);

}

});

}

});

}

//branding information

function branding_information(){

$(document).ready(function(){

$("#about-us").on("input",function(){

var length=$(this).val().length;

$(".about-us-count").html(length);

});

$(document).ready(function(){

$("#privacy-policy").on("input",function(){

var length=$(this).val().length;

$(".privacy-count").html(length);

});

$(document).ready(function(){

$("#cookies-policy").on("input",function(){

var length=$(this).val().length;

$(".cookies-count").html(length);

});

$(document).ready(function(){

$("#terms").on("input",function(){

var length=$(this).val().length;

$(".terms-count").html(length);

});

//branding details

$(document).ready(function(){

$(".branding-form").submit(function(e){

e.preventDefault();

var file=document.querySelector("#brand-logo");

var file_size;

if(file.value == "")

{

file_size=0;

}

else{

file_size=file.files[0].size;

}

if(200000>file_size)

{

$.ajax({

type:"POST",

url:"php/branding.php",

data:new FormData(this),

processData:false,

contentType:false,

cache:false,

success:function(response)

{

document.write(response);

}

});

}

else{

alert("Please upload less than 200kb brand logo");

}

});

//branding details controls

$(document).ready(function(){

$.ajax({

type:"POST",

url:"php/check_branding_table.php",

success:function(response)

{

var all_data=JSON.parse(response.trim());

$("#brand-name").val(all_data[0].brand_name);

$("#domain-name").val(all_data[0].domain_name);

$("#email").val(all_data[0].email);

$("#twitter-url").val(all_data[0].twitter_url);

$("#facebook-url").val(all_data[0].facebook_url);

$("#address").val(all_data[0].address);

$("#phone").val(all_data[0].phone);

$("#about-us").val(all_data[0].about_us);

$("#privacy-policy").val(all_data[0].privacy_policy);

$("#cookies-policy").val(all_data[0].cookies_policy);

$("#terms").val(all_data[0].terms_policy);

$(".branding-form input,.branding-form textarea,.branding-form button").prop("disabled",true);

$(".branding-edit").click(function(){

$(".branding-form input,.branding-form textarea,.branding-form button").prop("disabled",false);

$("#brand-logo").removeAttr("required");

});

}

});

}

//header showcase

function header_showcase(){

$(document).ready(function(){

$(".target").each(function(){

$(this).click(function(){

var element=event.target;

var in_number=$(element).index();

sessionStorage.setItem("color_in_number",in_number);

var i;

for(i=0;i<$(".target").length;i++)

{

$(".target").css({

border:"",

boxshadow:"",

padding:"",

width:""

});

}

$(this).css({

border:"5px solid red",

boxshadow:"0px 0px 3px grey",

padding:"2px",

width:"fit-content"

});

$(this).on("dblclick",function(){

var i;

for(i=0;i<$(".target").length;i++)

{

$(".target").css({

border:"",

boxshadow:"",

padding:"",

width:""

});

}

});

$(".color-selector").on("change",function(){

var color=this.value;

var in_number=Number(sessionStorage.getItem("color_in_number"));

var element=document.getElementsByClassName("target")[in_number];

element.style.color=color;

});

$(".font-size").on("input",function(){

var size=this.value;

var in_number=Number(sessionStorage.getItem("color_in_number"));

var element=document.getElementsByClassName("target")[in_number];

element.style.fontSize=size+"%";

});

//title image upload

$(document).ready(function(){

$("#title-image").on("change",function(){

var file=this.files[0];

if(file.size < 500000)

{

var url=URL.createObjectURL(file);

var image=new Image();

image.src=url;

image.onload=function(){

var o_width=image.width;

var o_height=image.height;

if(o_width == 1920 && o_height == 978)

{

image.style.width="100%";

image.style.position="absolute";

image.style.top="0";

image.style.left="0";

$(".showcase-preview").append(image);

}

else{

alert("please upload 1920*978px image");

}

else{

alert("please upload less than 200kb");

}

});

//textarea max length

$(document).ready(function(){

$("#title-text").on("input",function(){

var length=this.value.length;

$(".showcase-title").html(this.value);

$(".title-limit").html(length);

});

$(document).ready(function(){

$("#subtitle-text").on("input",function(){

var length=this.value.length;

$(".showcase-subtitle").html(this.value);

$(".subtitle-limit").html(length);

});

//add showcase

$(document).ready(function(){

$(".header-showcase-form").submit(function(e){

e.preventDefault();

var title=document.querySelector(".showcase-title");

var subtitle=document.querySelector(".showcase-subtitle");

var file=document.querySelector("#title-image").files[0];

var title_size="";

var title_color="";

if(title.style.fontSize=="")

{

title_size="300%";

}

else{

title_size=title.style.fontSize;

}

if(title.style.color=="")

{

title_color="black";

}

else{

title_color=title.style.color;

}

var subtitle_size="";

var subtitle_color="";

if(subtitle.style.fontSize=="")

{

subtitle_size="200%";

}

else{

subtitle_size=subtitle.style.fontSize;

}

if(subtitle.style.color=="")

{

subtitle_color="black";

}

else{

subtitle_color=subtitle.style.color;

}

var flex_box=document.querySelector(".showcase-preview");

var h_align="";

var v_align="";

if(flex_box.style.justifyContent=="")

{

h_align="flex-start";

}

else{

h_align=flex_box.style.justifyContent;

}

if(flex_box.style.alignItems=="")

{

v_align="flex-start";

}

else{

v_align=flex_box.style.alignItems;

}

var css_data={

title_size:title_size,

title_color:title_color,

subtitle_size:subtitle_size,

subtitle_color:subtitle_color,

h_align:h_align,

v_align:v_align,

title_text:title.innerHTML,

subtitle_text:subtitle.innerHTML,

buttons:$(".title-buttons").html().trim(),

options:$("#edit-title").val().trim()

}

var formdata=new FormData();

formdata.append("file_data",file);

formdata.append("css_data",JSON.stringify(css_data));

$.ajax({

type:"POST",

url:"php/header_showcase.php",

data:formdata,

processData:false,

contentType:false,

cache:false,

success:function(response)

{

alert(response);

}

});

//alignment

$(document).ready(function(){

$(".alignment").each(function(){

$(this).click(function(){

var align_position=$(this).attr("align-position");

var align_value=$(this).attr("align-value");

if(align_position == "h")

{

$(".showcase-preview").css({

justifyContent:align_value

});

}

else if(align_position == "v")

{

$(".showcase-preview").css({

alignItems:align_value

});

}

});

//add btn

$(document).ready(function(){

$(".add-btn").click(function(){

var button=document.createElement("BUTTON");

button.className="btn mr-2 title-btn";

var a=document.createElement("A");

a.href=$(".btn-url").val();

a.innerHTML=$(".btn-name").val();

a.style.color=$(".btn-textcolor").val();

a.style.fontSize=$(".btn-size").val();

button.style.backgroundColor=$(".btn-bgcolor").val();

button.append(a);

var title_buttons=document.querySelector(".title-buttons");

var title_child=title_buttons.getElementsByTagName("BUTTON");

var button_length=title_child.length;

if(button_length == 0 || button_length == 1)

{

$(".title-buttons").append(button);

}

else{

alert("only two buttons are allowed");

}

});

$(document).ready(function(){

$(".real-preview-btn").click(function(e){

e.preventDefault();

var file=document.querySelector("#title-image").files[0];

var formdata=new FormData();

formdata.append("photo",file);

var flex_box=document.querySelector(".showcase-preview");

var h_align="";

var v_align="";

if(flex_box.style.justifyContent=="")

{

h_align="flex-start";

}

else{

h_align=flex_box.style.justifyContent;

}

if(flex_box.style.alignItems=="")

{

v_align="flex-start";

}

else{

v_align=flex_box.style.alignItems;

}

var array=[$(".title-box").html().trim(),h_align,v_align];

formdata.append("data",JSON.stringify(array));

$.ajax({

type:"POST",

url:"php/preview.php",

data:formdata,

processData:false,

contentType:false,

cache:false,

success:function(response)

{

var page=window.open("about:blank");

page.document.open();

page.document.write(response);

page.document.close();

}

});

//edit title

$(document).ready(function(){

var showcase_preview=$(".showcase-preview").html();

$("#edit-title").on("change",function(){

if($(this).val()!= "Choose title")

{

$.ajax({

type:"POST",

url:"php/edit_title.php",

data:{

id:$(this).val()

success:function(response)

{

$("#title-image").removeAttr("required");

var selected_value=$("#edit-title").val();

$(".add-showcase-btn").html("Save-edit");

$(".add-showcase-btn").removeClass("bg-primary");

$(".add-showcase-btn").addClass("bg-danger");

$(".delete-title").removeClass("d-none");

$(".delete-title").click(function(){

$.ajax({

type:"POST",

url:"php/delete_title.php",

data:{

id:$("#edit-title").val()

success:function(response)

{

if(response.trim() == "success")

{

$(".add-showcase-btn").html("Add showcase");

$(".add-showcase-btn").removeClass("bg-danger");

$(".add-showcase-btn").addClass("bg-primary");

$(".header-showcase-form").trigger('reset');

$(".showcase-preview").html(showcase_preview);

$(".delete-title").addClass("d-none");

var op=$("#edit-title option");

op[0].selected="selected";

var i;

for(i=0;i<op.length;i++)

{

if(op[i].value == selected_value)

{

op[i].remove();

}

else{

alert(response);

}

});

var all_data=JSON.parse(response.trim());

var image=document.createElement("img");

image.src=all_data[0];

image.style.width="100%";

image.style.position="absolute";

image.style.top="0";

image.style.left="0";

$(".showcase-preview").append(image);

$(".showcase-title").html(all_data[1]);

$(".showcase-title").css({

color:all_data[2],

fontSize:all_data[3]

});

$(".showcase-subtitle").html(all_data[4]);

$(".showcase-subtitle").css({

color:all_data[5],

fontSize:all_data[6]

});

$(".title-buttons").html(all_data[9]);

$("#title-text").val(all_data[1]);

$("#subtitle-text").val(all_data[4]);

//edit btn

$(".title-btn").each(function(){

$(this).click(function(){

sessionStorage.setItem("btn_key",$(this).index());

$(".delete-btn").removeClass("d-none");

var url=$(this).children().attr("href");

$(".btn-url").val(url);

var name=$(this).children().html();

$(".btn-name").val(name);

var color=$(this).css("backgroundColor").replace("rgb(",'').replace(')','');

var rgb=color.split(",");

var i;

var color_code="";

for(i=0;i<rgb.length;i++)

{

var hex_code=Number(rgb[i]).toString(16);

color_code+=hex_code.length == 1 ? "0"+hex_code : hex_code;

}

$(".btn-bgcolor").val("#"+color_code);

var text_color=$(this).children().css("color").replace("rgb(",'').replace(')','');

var text_rgb=text_color.split(",");

var i;

var text_color_code="";

for(i=0;i<text_rgb.length;i++)

{

var text_hex_code=Number(text_rgb[i]).toString(16);

text_color_code+=text_hex_code.length == 1 ? "0"+text_hex_code : text_hex_code;

}

$(".btn-textcolor").val("#"+text_color_code);

var btn_size=$(this).children().css('fontSize');

for(i=0;i<$(".btn-size").children().length;i++)

{

var option=$(".btn-size").children();

if(option[i].value == btn_size)

{

option[i].selected="selected";

}

});

$(".btn-name").on("input",function(){

var i_no=Number(sessionStorage.getItem("btn_key"));

var selected_btn=document.getElementsByClassName("title-btn")[i_no];

selected_btn.getElementsByTagName("A")[0].innerHTML=this.value;

});

$(".btn-bgcolor").on("change",function(){

var i_no=Number(sessionStorage.getItem("btn_key"));

var selected_btn=document.getElementsByClassName("title-btn")[i_no];

selected_btn.style.backgroundColor=this.value;

});

$(".btn-textcolor").on("change",function(){

var i_no=Number(sessionStorage.getItem("btn_key"));

var selected_btn=document.getElementsByClassName("title-btn")[i_no];

selected_btn.getElementsByTagName("A")[0].style.color=this.value;

});

$(".btn-size").on("change",function(){

var i_no=Number(sessionStorage.getItem("btn_key"));

var selected_btn=document.getElementsByClassName("title-btn")[i_no];

selected_btn.getElementsByTagName("A")[0].style.fontSize=this.value;

});

$(".delete-btn").on("click",function(){

var i_no=Number(sessionStorage.getItem("btn_key"));

var selected_btn=document.getElementsByClassName("title-btn")[i_no];

selected_btn.remove();

$(".btn-url,.btn-name").val("");

$(".btn-bgcolor,.btn-textcolor").val("#000000");

var op=$(".btn-size option");

op[0].selected="selected";

$(".delete-btn").addClass("d-none");

});

}

});

}

else{

$("#title-image").attr("required");

$(".add-showcase-btn").html("Add showcase");

$(".add-showcase-btn").removeClass("bg-danger");

$(".add-showcase-btn").addClass("bg-primary");

$(".header-showcase-form").trigger('reset');

$(".showcase-preview").html(showcase_preview);

$(".delete-title").addClass("d-none");

}

});

}

//category showcase

function category_showcase(){

$(document).ready(function(){

$(".upload-icon").each(function(){

$(this).on("change",function(){

var upload_icon=this;

var dummy_pic=upload_icon.parentElement.parentElement.parentElement.getElementsByTagName("img")[0];

var input=upload_icon.parentElement.parentElement.getElementsByTagName("INPUT")[1];

var set_btn=upload_icon.parentElement.parentElement.getElementsByClassName("set-btn")[0];

var dummy_pic_width=dummy_pic.naturalWidth;

var dummy_pic_height=dummy_pic.naturalHeight;

var file=upload_icon.files[0];

var url=URL.createObjectURL(file);

var image=new Image();

image.src=url;

var uploaded_width="";

var uploaded_height="";

image.onload=function(){

uploaded_width=image.width;

uploaded_height=image.height;

if(dummy_pic_width == uploaded_width && dummy_pic_height == uploaded_height)

{

input.oninput=function(){

if(this.value.length >= 1)

{

set_btn.disabled=false;

set_btn.onclick=function(){

var formdata=new FormData();

formdata.append("photo",file);

formdata.append("text",input.value);

formdata.append("direction",$(set_btn).attr("img-dir"));

$.ajax({

type:"POST",

url:"php/category_showcase.php",

data:formdata,

processData:false,

contentType:false,

cache:false,

beforeSend:function(){

set_btn.innerHTML="Please wait..."

success:function(response)

{

if(response.trim() == "success")

{

dummy_pic.src=url;

set_btn.innerHTML="SET";

$(upload_icon.parentElement.parentElement).addClass("d-none");

dummy_pic.ondblclick=function(){

$(upload_icon.parentElement.parentElement).removeClass("d-none");

}

});

}

else{

set_btn.disabled=true;

}

else{

alert("Please upload"+dummy_pic_width+"/"+dummy_pic_height);

}

});

$(document).ready(function(){

var img=$("img");

var i;

for(i=0;i<img.length;i++)

{

if(img[i].src.indexOf("base64") !=-1)

{

var set_btn=img[i].parentElement.getElementsByClassName("set-btn")[0];

set_btn.disabled=false;

$(".set-btn").each(function(){

$(this).click(function(){

set_btn=this;

var input=this.parentElement.getElementsByTagName("INPUT");

var file=input[0].files[0];

var text=input[1].value;

var dummy_pic=this.parentElement.parentElement.getElementsByTagName("img")[0];

var url=dummy_pic.src;

if(input[0].value !="")

{

url=URL.createObjectURL(input[0].files[0]);

}

var formdata=new FormData();

formdata.append("photo",file);

formdata.append("text",text);

formdata.append("direction",$(set_btn).attr("img-dir"));

$.ajax({

type:"POST",

url:"php/category_showcase.php",

data:formdata,

processData:false,

contentType:false,

cache:false,

beforeSend:function(){

set_btn.innerHTML="Please wait..."

success:function(response)

{

if(response.trim() == "success")

{

dummy_pic.src=url;

set_btn.innerHTML="SET";

$(set_btn.parentElement).addClass("d-none");

dummy_pic.ondblclick=function(){

$(set_btn.parentElement).removeClass("d-none");

}

});

}

});

}

//delivery area

function delivery_area()

{

//get states

$(document).ready(function(){

$(".country").on("change",function(){

$(".state").html('');

var option=$(".country option");

var i;

for(i=0;i<option.length;i++)

{

if(option[i].innerHTML==$(".country").val())

{

var country_id=$(option[i]).attr("country-id");

$.ajax({

type:"POST",

url:"php/get_states.php",

data:{

country_id:country_id,

success:function(response)

{

var states=JSON.parse(response.trim());

for(j=0;j<states.length;j++)

{

var options="<option state-id='"+states[j].id+"'>"+states[j].name+"</option>";

$(".state").append(options);

}

});

}

});

//get city

$(document).ready(function(){

$(".state").on("change",function(){

$(".city").html('');

var option=$(".state option");

var i;

for(i=0;i<option.length;i++)

{

if(option[i].innerHTML==$(".state").val())

{

var state_id=$(option[i]).attr("state-id");

$.ajax({

type:"POST",

url:"php/get_city.php",

data:{

state_id:state_id,

success:function(response)

{

var city=JSON.parse(response.trim());

for(j=0;j<city.length;j++)

{

var options="<option>"+city[j].name+"</option>";

$(".city").append(options);

}

});

}

});

//get pincode

$(document).ready(function(){

$(".city").on("change",function(){

var city=$(this).val();

$.ajax({

type:"GET",

url:"https://api.postalpincode.in/postoffice/"+city,

success:function(response)

{

var length=response[0].PostOffice.length-1;

$(".pincode").val(response[0].PostOffice[length].Pincode);

}

});

//set area

$(document).ready(function(){

$(".set-area-form").submit(function(e){

e.preventDefault();

$.ajax({

type:"POST",

url:"php/set_area.php",

data:new FormData(this),

processData:false,

contentType:false,

cache:false,

success:function(response)

{

alert(response);

}

});

}

//sales report

function sales_report()

{

$(document).ready(function(){

$(".dispatch-btn").each(function(){

$(this).click(function(){

var clicked_btn=this;

var order_id=$(this).attr("order-id");

var email=$(this).attr("email");

var address=$(this).attr("address");

var mobile=$(this).attr("mobile");

var title=$(this).attr("title");

var qnt=$(this).attr("qnt");

var amount=$(this).attr("amount");

var fullname=$(this).attr("fullname");

$.ajax({

type:"POST",

url:"php/dispatch.php",

data:{

order_id:order_id,

email:email,

address:address,

mobile:mobile,

title:title,

qnt:qnt,

amount:amount,

fullname:fullname

beforeSend:function(){

$(clicked_btn).html("Wait...");

success:function(response)

{

$(clicked_btn).html("ORDER DISPATCHED");

//show dispatched item

var item_no=Number(sessionStorage.getItem("count"))+1;

sessionStorage.setItem("count",item_no);

$(".d-all").html(item_no+" ITEM DISPATCHED");

//show complete

var all_item_count=Number($(".s-no").length);

if(all_item_count == item_no)

{

$(".d-all").html("COMPLETE");

sessionStorage.removeItem("count");

setTimeout(function(){

$(".d-all").html("DISPATCH ALL");

},2000);

}

});

//dispatch all

$(document).ready(function(){

$(".d-all").click(function(){

var status=$(".status");

var i,message="DISPATCH ALL";

for(i=0;i<status.length;i++)

{

if(status[i].innerHTML == "processing")

{

$(".d-all").html("WAIT...");

var btn=$(".dispatch-btn");

for(i=0;i<btn.length;i++)

{

btn[i].click();

}

else{

message="No item";

}

$(".d-all").html(message);

});

//export to xls

$(document).ready(function(){

$(".export-to").on("change",function(){

if($(this).val() == "xls")

{

window.location="php/export_to_xls.php";

}

else if($(this).val() == "pdf")

{

window.location="php/dompdf.php";

}

});

//sort by

$(document).ready(function(){

$(".sort-by").on("change",function(){

if($(this).val() != "All data")

{

var option=$(this).val();

$.ajax({

type:"POST",

url:"php/sort_by.php",

data:{

option:option

success:function(response)

{

if(response.trim() != "Sales not available")

{

var table=document.createElement("table");

table.className="w-100 purchase-table text-center table table-bordered bg-white";

table.innerHTML="<tr><th>S/NO</th><th>PRODUCT_ID</th><th>TITLE</th><th>QUANTITY</th><th>PRICE</th><th>ADDRESS</th><th>STATE</th><th>COUNTRY</th><th>PINCODE</th><th>PURCHASE DATE</th><th>CUSTOMER NAME</th><th>USERNAME</TH><th>MOBILE</th><th>STATUS</th><th>ACTION</th></tr>";

$(".table-responsive").html(table);

var all_data=JSON.parse(response.trim());

var i;

for(i=0;i<all_data.length;i++)

{

var tr=document.createElement("tr");

var id_td=document.createElement("td");

id_td.innerHTML=all_data[i].id;

tr.append(id_td);

var product_id_td=document.createElement("td");

product_id_td.innerHTML=all_data[i].product_id;

tr.append(product_id_td);

var title_td=document.createElement("td");

title_td.innerHTML=all_data[i].title;

tr.append(title_td);

var qnt_td=document.createElement("td");

qnt_td.innerHTML=all_data[i].qnt;

tr.append(qnt_td);

var amount_td=document.createElement("td");

amount_td.innerHTML=all_data[i].amount;

tr.append(amount_td);

var address_td=document.createElement("td");

address_td.innerHTML=all_data[i].address;

tr.append(address_td);

var state_td=document.createElement("td");

state_td.innerHTML=all_data[i].state;

tr.append(state_td);

var country_td=document.createElement("td");

country_td.innerHTML=all_data[i].country;

tr.append(country_td);

var pincode_td=document.createElement("td");

pincode_td.innerHTML=all_data[i].pincode;

tr.append(pincode_td);

var purchase_date_td=document.createElement("td");

purchase_date_td.innerHTML=all_data[i].purchase_date;

tr.append(purchase_date_td);

var fullname_td=document.createElement("td");

fullname_td.innerHTML=all_data[i].fullname;

tr.append(fullname_td);

var email_td=document.createElement("td");

email_td.innerHTML=all_data[i].email;

tr.append(email_td);

var mobile_td=document.createElement("td");

mobile_td.innerHTML=all_data[i].mobile;

tr.append(mobile_td);

var status_td=document.createElement("td");

status_td.innerHTML=all_data[i].status;

tr.append(status_td);

if(all_data[i].status == "processing")

{

var button=document.createElement("button");

button.className="dispatch-btn btn btn-primary";

$(button).attr("order-id",all_data[i].id);

$(button).attr("title",all_data[i].title);

$(button).attr("qnt",all_data[i].qnt);

$(button).attr("amount",all_data[i].amount);

$(button).attr("fullname",all_data[i].fullname);

$(button).attr("email",all_data[i].email);

$(button).attr("address",all_data[i].address);

$(button).attr("mobile",all_data[i].mobile);

button.innerHTML="Dispatch";

var action_td=document.createElement("td");

action_td.append(button);

tr.append(action_td);

button.onclick=function(){

var clicked_btn=this;

var order_id=$(this).attr("order-id");

var email=$(this).attr("email");

var address=$(this).attr("address");

var mobile=$(this).attr("mobile");

var title=$(this).attr("title");

var qnt=$(this).attr("qnt");

var amount=$(this).attr("amount");

var fullname=$(this).attr("fullname");

$.ajax({

type:"POST",

url:"php/dispatch.php",

data:{

order_id:order_id,

email:email,

address:address,

mobile:mobile,

title:title,

qnt:qnt,

amount:amount,

fullname:fullname

beforeSend:function(){

$(clicked_btn).html("Wait...");

success:function(response)

{

$(clicked_btn).html("ORDER DISPATCHED");

//show dispatched item

var item_no=Number(sessionStorage.getItem("count"))+1;

sessionStorage.setItem("count",item_no);

$(".d-all").html(item_no+" ITEM DISPATCHED");

//show complete

var all_item_count=Number($(".s-no").length);

if(all_item_count == item_no)

{

$(".d-all").html("COMPLETE");

sessionStorage.removeItem("count");

setTimeout(function(){

$(".d-all").html("DISPATCH ALL");

},2000);

}

});

}

else if(all_data[i].status == "dispatched")

{

var button=document.createElement("button");

button.className="btn btn-danger";

$(button).attr("order-id",all_data[i].id);

$(button).attr("title",all_data[i].title);

$(button).attr("qnt",all_data[i].qnt);

$(button).attr("amount",all_data[i].amount);

$(button).attr("fullname",all_data[i].fullname);

$(button).attr("email",all_data[i].email);

$(button).attr("address",all_data[i].address);

$(button).attr("mobile",all_data[i].mobile);

button.innerHTML="ALREADY DISPATCHED ON "+all_data[i].dispatched_date;

var action_td=document.createElement("td");

action_td.append(button);

tr.append(action_td);

}

table.append(tr);

}

else{

alert(response.trim());

}

});

}

});

}

function keyword()

{

$(document).ready(function(){

$(".keyword-form").submit(function(e){

e.preventDefault();

if($("#p-keyword").val() != "Choose primary keyword")

{

$.ajax({

type:"POST",

url:"php/keyword.php",

data:new FormData(this),

processData:false,

contentType:false,

cache:false,

success:function(response)

{

alert(response);

}

});

}

else{

alert("Please choose a category");

}

});

//appear s_key

$(document).ready(function(){

$("#p-keyword").on("change",function(){

if($(this).val() != "Choose primary keyword")

{

var p_key=$(this).val();

$.ajax({

type:"POST",

url:"php/apper_s_key.php",

data:{

p_key:p_key

success:function(response)

{

$("#s-keyword").val(response.trim());

}

});

}

});

$(document).ready(function(){

$("#brands-p-keyword").on("change",function(){

if($(this).val() != "Choose primary keyword")

{

var p_key=$(this).val();

$.ajax({

type:"POST",

url:"php/apper_s_key.php",

data:{

p_key:p_key

success:function(response)

{

$(".s-brands-keyword").val(response.trim());

}

});

}

});

$(document).ready(function(){

$("#products").on("change",function(){

if($(this).val() != "Choose primary keyword")

{

var p_key=$(this).val();

$.ajax({

type:"POST",

url:"php/apper_s_key.php",

data:{

p_key:p_key

success:function(response)

{

$(".s-products-keyword").val(response.trim());

}

});

}

});

//copy to clipboard

$(document).ready(function(){

$(".copy-btn-category").click(function(){

var tags="";

$(".tags").each(function(){

tags +=$(this).text()+", ";

$(".s-category-keyword").val(tags);

});

$(document).ready(function(){

$(".copy-btn-brands").click(function(){

var tags="";

$(".tags").each(function(){

tags +=$(this).text()+", ";

$(".s-brands-keyword").val(tags);

});

$(document).ready(function(){

$(".copy-btn-products").click(function(){

var tags="";

$(".tags").each(function(){

tags +=$(this).text()+", ";

$(".s-products-keyword").val(tags);

});

//appear brands

$(document).ready(function(){

$(".brands-category").on("change",function(){

if($(this).val() !="Choose")

{

var cat_name=$(this).val();

$.ajax({

type:"POST",

url:"php/show_brands.php",

data:{

cat_name:cat_name

success:function(response)

{

$("#brands-p-keyword").html(response);

}

});

}

});

$(document).ready(function(){

$(".brands-form").submit(function(e){

e.preventDefault();

if($("#brands-p-keyword").val() != "Choose primary keyword")

{

$.ajax({

type:"POST",

url:"php/keyword.php",

data:new FormData(this),

processData:false,

contentType:false,

cache:false,

success:function(response)

{

alert(response);

}

});

}

else{

alert("Please choose a category");

}

});

//appear brands

$(document).ready(function(){

$("#products-c-list").on("change",function(){

if($(this).val() !="Choose")

{

var cat_name=$(this).val();

$.ajax({

type:"POST",

url:"php/show_brands.php",

data:{

cat_name:cat_name

success:function(response)

{

$("#products-brands").html(response);

}

});

}

});

//appear products

$(document).ready(function(){

$("#products-brands").on("change",function(){

if($(this).val() !="Choose")

{

var brands_name=$(this).val();

$.ajax({

type:"POST",

url:"php/show_products.php",

data:{

brands_name:brands_name

success:function(response)

{

$("#products").html(response);

}

});

}

});

$(document).ready(function(){

$(".products-form").submit(function(e){

e.preventDefault();

if($("#products").val() != "Choose primary keyword")

{

$.ajax({

type:"POST",

url:"php/keyword.php",

data:new FormData(this),

processData:false,

contentType:false,

cache:false,

success:function(response)

{

alert(response);

}

});

}

else{

alert("Please choose a category");

}

});

//delete keyword

$(document).ready(function(){

$(".delete-keyword").click(function(){

var tags=[];

$(".tags").each(function(i){

tags[i]=$(this).text().trim();

});

$.ajax({

type:"POST",

url:"php/delete_keyword.php",

data:{

tags:JSON.stringify(tags)

success:function(response)

{

if(response.trim() == "success")

{

window.location=location.href;

}

});

}

=>php

1.apper_s_key

<?php

require_once("../../common_files/databases/database.php");

$p_key=$_POST['p_key'];

$get_data="SELECT * FROM keywords WHERE p_key='$p_key'";

$response=$db->query($get_data);

if($response->num_rows != 0)

{

$data=$response->fetch_assoc();

echo $data['s_key'];

}

2.branding

<?php

require_once("../../common_files/databases/database.php");

$file=$_FILES['brand-logo'];

$logo="";

$location="";

if($file['name'] == "")

{

$logo="";

$location="";

}

else{

$location=$file['tmp_name'];

$logo=addslashes(file_get_contents($location));

}

$brand_name=$_POST['brand-name'];

$domain_name=$_POST['domain-name'];

$email=$_POST['email'];

$facebook_url=$_POST['facebook-url'];

$twitter_url=$_POST['twitter-url'];

$address=$_POST['address'];

$phone=$_POST['phone'];

$about_us=addslashes($_POST['about-us']);

$privacy_policy=addslashes($_POST['privacy-policy']);

$cookies_policy=addslashes($_POST['cookies-policy']);

$terms=addslashes($_POST['terms']);

$check_branding_table="SELECT * FROM branding";

$response=$db->query($check_branding_table);

if($response)

{

if($logo == "")

{

$update_data="UPDATE branding SET brand_name='$brand_name',email='$email',domain_name='$domain_name',facebook_url='$facebook_url',twitter_url='$twitter_url',address='$address',phone='$phone',about_us='$about_us',privacy_policy='$privacy_policy',cookies_policy='$cookies_policy',terms_policy='$terms'";

$response=$db->query($update_data);

if($response)

{

echo "Edit success";

}

else{

echo "Edit failed";

}

else{

$update_data="UPDATE branding SET brand_name='$brand_name',brand_logo='$logo',email='$email',domain_name='$domain_name',facebook_url='$facebook_url',twitter_url='$twitter_url',address='$address',phone='$phone',about_us='$about_us',privacy_policy='$privacy_policy',cookies_policy='$cookies_policy',terms_policy='$terms'";

$response=$db->query($update_data);

if($response)

{

echo "Edit success";

}

else{

echo "Edit failed";

}

else{

$create_table="CREATE TABLE branding(

id INT(11) NOT NULL AUTO_INCREMENT,

brand_name VARCHAR(50),

brand_logo MEDIUMBLOB,

email VARCHAR(100),

domain_name VARCHAR(100),

facebook_url VARCHAR(255),

twitter_url VARCHAR(255),

address VARCHAR(100),

phone INT(12),

about_us MEDIUMTEXT,

privacy_policy MEDIUMTEXT,

cookies_policy MEDIUMTEXT,

terms_policy MEDIUMTEXT,

PRIMARY KEY(id)

)";

$response=$db->query($create_table);

if($response)

{

$store_data="INSERT INTO branding(brand_name,brand_logo,email,domain_name,facebook_url,twitter_url,address,phone,about_us,privacy_policy,cookies_policy,terms_policy)VALUES('$brand_name','$logo','$email','$domain_name','$facebook_url','$twitter_url','$address','$phone','$about_us','$privacy_policy','$cookies_policy','$terms')";

$response=$db->query($store_data);

if($response)

{

echo "success";

}

else{

echo "unable to store data";

}

else{

echo "Unable to create table";

}

3.category_list

Wednesday, 15 April 2020

PHP PROJECT

No comments:

Post a Comment