<?php 
include ('connection.php') ;

date_default_timezone_set('Asia/Calcutta');
$today = date("d/m/Y");
$today_dash = date("d-m-Y");

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

//$today3 = strtotime(date("Y-m-d", strtotime("-5 day")));
$today1 = date("d/m");
$currentmonth = date(m);


?>
<?php 
$queryhead = "select * from users where username = '". $_SESSION["LOGIN_NAME"]."' AND password = '".$_SESSION["EMPLOYEE_PASSWORD"]."' AND department_name ='".$_SESSION["LOGIN_TYPE"]."'";
$resulthead = mysql_query($queryhead,$conn);
while($row=mysql_fetch_array($resulthead))
	                                              	{
													
													  $staff_name = $row['full_name'];
													  $full_name = $row['full_name'];
													  $avatar = $row['avatar'];
													  $department_name = $row['department_name'];
													  $staff_id  = $row['id'];
													  $username = $row['username'];
													  $our_company = $row['our_company'];
													  $designation = $row['designation'];
													  $sales_group = $row['sales_group'];
													  $head = $row['head'];
													  $region = $row['region'];
													  $district = $row['district'];
													  $email = $row['email'];
													  $mobile_no = $row['mobile_no'];
													  $staff_id_self  = $row['id'];
													  $our_company = $row['our_company'];
													  
													  //echo $Branch;
													  }	
													   ?>	
<header class="main-header">

    <!-- Logo -->
    <a href="index2.html" class="logo">
      <!-- mini logo for sidebar mini 50x50 pixels -->
      <span class="logo-mini"><img src="http://shigmoda.com/PWS_LLP/logo_small.jpg"></span>
      <!-- logo for regular state and mobile devices -->
      <span class="logo-lg"><img src="http://shigmoda.com/PWS_LLP/logo.jpg"></span>
    </a>
    <!-- Header Navbar: style can be found in header.less -->
    <nav class="navbar navbar-static-top">
      <!-- Sidebar toggle button-->
      <a href="#" class="sidebar-toggle" data-toggle="offcanvas" role="button">
        <span class="sr-only">Toggle navigation</span>
        <span class="icon-bar"></span>
        <span class="icon-bar"></span>
        <span class="icon-bar"></span>
      </a>

      <div class="navbar-custom-menu">
        <ul class="nav navbar-nav">
		
		  
		  
		  
		  
		  
		  
		  
		  
		  
		  
		  
          <!-- Messages: style can be found in dropdown.less-->
          
<?php 	
$sqlnot= "SELECT * FROM quotation_follow_up where  sstatus !='Closed' AND sstatus != 'Completed' AND next_remainder_date ='$today' AND quot_follow_id IN (SELECT MAX(quot_follow_id) FROM quotation_follow_up GROUP BY call_follow_up_id) ORDER BY STR_TO_DATE(next_remainder_date,'%d/%m/%Y') DESC";	
$resultnot = mysql_query($sqlnot);
$num_rownot = mysql_num_rows($resultnot);

		  
		  ?>
          <!-- Notifications: style can be found in dropdown.less -->
          
          <!-- Tasks: style can be found in dropdown.less -->
          
          <!-- User Account: style can be found in dropdown.less -->
          <li class="dropdown user user-menu">
            <a href="#" class="dropdown-toggle" data-toggle="dropdown">
            
              <span class="hidden-xs"> <?php echo $full_name; ?></span>
            </a>
            <ul class="dropdown-menu">
              <!-- User image -->
             
            
              <li class="user-footer">
               
                  <a href="http://shigmoda.com/PWS_LLP/logout.php" class="btn btn-default btn-flat">Sign out</a>
               
              </li>
            </ul>
          </li>
          <!-- Control Sidebar Toggle Button -->
          
        </ul>
      </div>
    </nav>
  </header>
  <!-- Left side column. contains the logo and sidebar -->
  <aside class="main-sidebar">
  
    <!-- sidebar: style can be found in sidebar.less -->
    <section class="sidebar">
      <!-- Sidebar user panel -->
      
    
      <ul class="sidebar-menu">
        <li class="header">MAIN NAVIGATION</li>
        <li class="treeview">
          <a href="http://shigmoda.com/PWS_LLP/index.php">
            <i class="fa fa-dashboard"></i> <span>Dashboard</span>
            
          </a>
		
          
        </li>
		
		
		
		
		<li class="treeview">
          <a href="#">
            <i class="fa fa-file-pdf-o"></i> <span>Customer Master </span>
            <span class="pull-right-container">
              <i class="fa fa-angle-left pull-right"></i>
            </span>
          </a>
		 <ul class="treeview-menu">
            <li><a href="http://shigmoda.com/PWS_LLP/accounts.php"><i class="fa fa-circle-o"></i>New Accounts</a></li>
         <li><a href="http://shigmoda.com/PWS_LLP/view_all_accounts.php"><i class="fa fa-circle-o"></i>View All Accounts</a></li>
         
			  <li><a href="http://shigmoda.com/PWS_LLP/contact_cust01.php"><i class="fa fa-circle-o"></i>New Contacts</a></li>
         <li><a href="http://shigmoda.com/PWS_LLP/view_all_contacts.php"><i class="fa fa-circle-o"></i>View All Contacts</a></li>
         
			 
          </ul>
		  </li>	
    
		
		  
		<li class="treeview">
          <a href="http://shigmoda.com/PWS_LLP/vendor_transport_master.php">
            <i class="fa fa-dashboard"></i> <span>Transport Name Master</span>
            
          </a></li>
		  <!--<li class="treeview">
          <a href="http://shigmoda.com/PWS_LLP/make_direct_trans_step1.php">
            <i class="fa fa-dashboard"></i> <span>Make Direct Transport </span>
            
          </a></li>-->
		  
		  
		 <li class="treeview">
          <a href="http://shigmoda.com/PWS_LLP/view_all_dircttransinv.php">
            <i class="fa fa-dashboard"></i> <span>View all Transport Invoice</span>
            
          </a></li>
		  
		  
		  <li class="treeview">
          <a href="http://shigmoda.com/PWS_LLP/make_job.php">
            <i class="fa fa-dashboard"></i> <span>JOB Entry </span>
            
          </a></li>
		  
		   <li class="treeview">
          <a href="http://shigmoda.com/PWS_LLP/view_all_jobs.php">
            <i class="fa fa-dashboard"></i> <span>View all Jobs</span>
            
          </a></li>
		<!-- <li class="treeview">
          <a href="http://shigmoda.com/PWS_LLP/make_challan_master.php">
            <i class="fa fa-dashboard"></i> <span>Make Challan</span>
            
          </a></li>-->
           <li class="treeview">
          <a href="http://shigmoda.com/PWS_LLP/view_all_challan_master.php">
            <i class="fa fa-dashboard"></i> <span>View all Challan</span>
            
          </a></li>
		  <li class="treeview">
          <a href="http://shigmoda.com/PWS_LLP/view_all_credit_note.php">
            <i class="fa fa-dashboard"></i> <span>View all Credit Note</span>
            
          </a></li>
		
		
		
		  
		  
      </ul>
    </section>
    <!-- /.sidebar -->
  </aside>