/* Decoded by unphp.net */

<?    include_once("inc/cDbcon.php"); 
  //include_once("inc/functions.php"); 
  include_once("inc/security.php"); 
 
  $nav = "dashboard"; 
  $subnav = ""; 
  $strAction = "Dashboard"; 
   
  if ($_SESSION["LOGON"][3] == 1) { 
  $strWhere = ""; 
  } elseif($_SESSION["LOGON"][3] == 2 || $_SESSION["LOGON"][3] == 3) { 
    $strWhere = " AND fromprovince_id = '".$_SESSION["LOGON"][1]."' AND toprovince_id = '".$_SESSION["LOGON"][1]."'"; 
  } else { 
    $strWhere = " AND user_id = '".$_SESSION["LOGON"][0]."'"; 
  } 
 
  $start = date("Y-m-d", strtotime("first day of this month")); 
  $end = date("Y-m-d", strtotime("last day of this month")); 
 
  $list = $conn->query("SELECT * FROM tbltransport WHERE FROM_UNIXTIME(date1, '%Y-%m-%d') BETWEEN '$start' AND '$end' AND 1=1$strWhere"); 
  $entrycount = $list->num_rows; 
 
  $completeToday = 0; 
  $totalcompleteToday = 0; 
  $completeThisWeek = 0; 
  $totalcompleteThisWeek = 0; 
  $completeThisMonth = 0; 
  $totalcompleteThisMonth = 0; 
  $transporting = 0; 
  $totaltransporting = 0; 
  $uncomplete = 0; 
  $totaluncomplete = 0; 
  $uncompleteThisWeek = 0; 
  $totaluncompleteThisWeek = 0; 
  $uncompleteThisMonth = 0; 
  $totaluncompleteThisMonth = 0; 
  $income = 0; 
  $totalIncome = 0; 
  $incomeThisWeek = 0; 
  $totalIncomeThisWeek = 0; 
  $incomeThisMonth = 0; 
  $totalIncomeThisMonth = 0; 
 
  while ($row = $list->fetch_assoc()) { 
    if (date("Y-m-d",$row["date4"]) == date("Y-m-d") && $row["transport_status"] == 4) { 
      $completeToday = 1; 
      $income = $row["tprice"] + $row["sprice"]; 
    } 
 
    if (date("Y-m-d",$row["date4"]) >= date("Y-m-d", strtotime("monday this week")) && date("Y-m-d",$row["date4"]) <= date("Y-m-d", strtotime("saturday this week")) && $row["transport_status"] == 4) { 
      $completeThisWeek = 1; 
      $incomeThisWeek = $row["tprice"] + $row["sprice"]; 
    } 
 
    if ($row["transport_status"] == 4) { 
      $completeThisMonth = 1; 
      $incomeThisMonth = $row["tprice"] + $row["sprice"]; 
    } 
 
    if ($row["transport_status"] == 1 || $row["transport_status"] == 3) { 
      $transporting = 1; 
    } 
 
    if (date("Y-m-d",$row["date5"]) == date("Y-m-d") && $row["transport_status"] == 5) { 
      $uncomplete = 1; 
    } 
 
    if (date("Y-m-d",$row["date5"]) >= date("Y-m-d", strtotime("monday this week")) && date("Y-m-d",$row["date5"]) <= date("Y-m-d", strtotime("saturday this week")) && $row["transport_status"] == 5) { 
      $uncompleteThisWeek = 1; 
    } 
 
    if ($row["transport_status"] == 5) { 
      $uncompleteThisMonth = 1; 
    } 
 
    $totalcompleteToday += $completeToday; 
    $totalcompleteThisWeek += $completeThisWeek; 
    $totalcompleteThisMonth += $completeThisMonth; 
    $totaltransporting += $transporting; 
    $totaluncomplete += $uncomplete; 
    $totaluncompleteThisWeek += $uncompleteThisWeek; 
    $totaluncompleteThisMonth += $uncompleteThisMonth; 
    $totalIncome += $income; 
    $totalIncomeThisWeek += $incomeThisWeek; 
    $totalIncomeThisMonth += $incomeThisMonth; 
  } ?>