493 lines
40 KiB
PHP
493 lines
40 KiB
PHP
<!--Master-->
|
|
<?php
|
|
|
|
//echo "<script>alert('".$__currentPage."')</script>";
|
|
|
|
$sql_master = "select distinct(m.menu_id),m.menu_name,m.menu_description,m.menu_url,m.parent_id from assign_menu a, menu_master m where a.menu_id= m.menu_id and parent_id=0 and a.role_id='" . $_SESSION['RoleId'] . "' and m.menu_id<=20 order by convert(m.menu_id, signed )";
|
|
|
|
//echo $sql_master;
|
|
|
|
$res_master = mysqli_query($conn,$sql_master);
|
|
|
|
$num_rows = @mysqli_num_rows($res_master);
|
|
|
|
if ($num_rows > 0) {
|
|
?>
|
|
<!--master as list-->
|
|
<li class="">
|
|
<a href="#" class="dropdown-toggle">
|
|
<i class="menu-icon fa fa-cogs"></i>
|
|
<span class="menu-text">
|
|
My Training
|
|
</span>
|
|
|
|
<b class="arrow fa fa-angle-down"></b>
|
|
</a>
|
|
|
|
<b class="arrow"></b>
|
|
<!-- master submenu-->
|
|
|
|
<ul class="submenu">
|
|
<?php
|
|
while ($transaction_rowmaster = @mysqli_fetch_array($res_master)) {
|
|
if ($transaction_rowmaster['menu_url'] <= 1) {
|
|
|
|
|
|
$sql_transactionmaster = "select distinct(m.menu_id),m.menu_name,m.menu_description,m.menu_url,m.parent_id from assign_menu a, menu_master m where a.menu_id= m.menu_id and a.role_id='" . $_SESSION['RoleId'] . "' and m.parent_id ='" . $transaction_rowmaster['menu_id'] . "' ORDER BY m.menu_id ASC";
|
|
|
|
//echo $sql_transaction1;
|
|
|
|
$res_transactionmaster = mysqli_query($conn,$sql_transactionmaster);
|
|
|
|
$num_rows2master = @mysqli_num_rows($res_transactionmaster);
|
|
|
|
|
|
if ($num_rows2master > 0) {
|
|
?>
|
|
<!--master submenu list-->
|
|
<li class="">
|
|
<a href="#" class="dropdown-toggle">
|
|
<i class="menu-icon fa fa-caret-right"></i>
|
|
<span><?php echo $transaction_rowmaster['menu_name'] ?> </span>
|
|
<b class="arrow fa fa-angle-down"></b>
|
|
</a>
|
|
<b class="arrow"></b>
|
|
|
|
<!--master submenu list submenu-->
|
|
<ul class="submenu">
|
|
<?php
|
|
while ($transaction_rowmaster = @mysqli_fetch_array($res_transactionmaster)) {
|
|
?>
|
|
<li class="">
|
|
<a href="<?php echo $transaction_rowmaster['menu_url'] ?>">
|
|
<i class="menu-icon fa fa-caret-right"></i>
|
|
<span><?php echo $transaction_rowmaster['menu_name'] ?></span>
|
|
</a>
|
|
</li>
|
|
<?php }?>
|
|
</ul>
|
|
</li>
|
|
<?php }else{
|
|
?>
|
|
<li class="">
|
|
<a href="<?php echo $transaction_rowmaster['menu_url'] ?>">
|
|
<i class="menu-icon fa fa-caret-right"></i>
|
|
<span><?php echo $transaction_rowmaster['menu_name'] ?></span>
|
|
</a>
|
|
</li>
|
|
<?php
|
|
}//end of numrows2 if?>
|
|
<?php }else{
|
|
?>
|
|
<li class="">
|
|
<a href="<?php echo $transaction_rowmaster['menu_url'] ?>">
|
|
<i class="menu-icon fa fa-caret-right"></i>
|
|
<span><?php echo $transaction_rowmaster['menu_name'] ?></span>
|
|
</a>
|
|
</li>
|
|
<?php } //end of else?>
|
|
<?php }?>
|
|
</ul>
|
|
</li>
|
|
<?php }?>
|
|
<!--End of master-- >
|
|
|
|
<!--Sales -->
|
|
<?php
|
|
$sql_transaction = "select distinct(m.menu_id),m.menu_name,m.menu_description,m.menu_url,m.parent_id from assign_menu a, menu_master m where a.menu_id= m.menu_id and parent_id=0 and a.role_id='" . $_SESSION['RoleId'] . "' and m.menu_id >20 and m.menu_id <=40 order by convert(m.menu_id, signed )";
|
|
|
|
//echo $sql_transaction;
|
|
|
|
$res_transaction = mysqli_query($conn,$sql_transaction);
|
|
|
|
$num_rows1 = @mysqli_num_rows($res_transaction);
|
|
|
|
if ($num_rows1 > 0) {
|
|
?>
|
|
|
|
<!--sales as list-->
|
|
<li class="">
|
|
<a href="#" class="dropdown-toggle">
|
|
<i class="menu-icon fa fa-leaf"></i>
|
|
<span class="menu-text">
|
|
My History
|
|
</span>
|
|
|
|
<b class="arrow fa fa-angle-down"></b>
|
|
</a>
|
|
<b class="arrow"></b>
|
|
|
|
<!--sales submenu-->
|
|
|
|
<ul class="submenu">
|
|
<?php
|
|
while ($transaction_row = @mysqli_fetch_array($res_transaction)) {
|
|
?>
|
|
|
|
|
|
<?php if ($transaction_row['menu_url'] <= 1) {
|
|
|
|
|
|
$sql_transaction1 = "select distinct(m.menu_id),m.menu_name,m.menu_description,m.menu_url,m.parent_id from assign_menu a, menu_master m where a.menu_id= m.menu_id and a.role_id='" . $_SESSION['RoleId'] . "' and m.parent_id ='" . $transaction_row['menu_id'] . "' ORDER BY m.menu_id ASC";
|
|
|
|
//echo $sql_transaction1;
|
|
|
|
$res_transaction1 = mysqli_query($conn,$sql_transaction1);
|
|
|
|
$num_rows2 = @mysqli_num_rows($res_transaction1);
|
|
|
|
if ($num_rows2 > 0) {
|
|
?>
|
|
<!--sales submenu list-->
|
|
<li class="">
|
|
<a href="<?php echo $transaction_row['menu_url']?>" class="dropdown-toggle">
|
|
<i class="menu-icon fa fa-caret-right"></i>
|
|
<span onclick="location='<?php echo $transaction_row['menu_url'] ?>'"><?php echo $transaction_row['menu_name'] ?> </span>
|
|
<b class="arrow fa fa-angle-down"></b>
|
|
</a>
|
|
<b class="arrow"></b>
|
|
<!--sales submenu list submenu-->
|
|
|
|
<ul class="submenu">
|
|
<?php
|
|
while ($transaction_row1 = @mysqli_fetch_array($res_transaction1)) {
|
|
if ($transaction_row1['menu_url'] <= 1) {
|
|
//echo $transaction_row1['menu_url'];
|
|
$sql_transaction2 = "select distinct (m.menu_id), m.menu_name, m.menu_url, m.parent_id from assign_menu a, menu_master m where a.menu_id=m.menu_id and a.role_id='" . $_SESSION['RoleId'] . "' and m.parent_id='" . $transaction_row1['menu_id'] . "' order by m.menu_id ASC";
|
|
//echo $sql_transaction2 ;
|
|
$res_transaction2 = @mysqli_query($conn,$sql_transaction2);
|
|
|
|
$num_row3 = @mysqli_num_rows($res_transaction2);
|
|
|
|
if ($num_row3 > 0) {
|
|
?>
|
|
|
|
<li class="">
|
|
<a href="<?php echo $transaction_row1['menu_url'] ?>" class="dropdown-toggle">
|
|
<i class="menu-icon fa fa-caret-right"></i>
|
|
<span onclick="location='<?php echo $transaction_row1['menu_url'] ?>'" ><?php echo $transaction_row1['menu_name'] ?>
|
|
|
|
</span>
|
|
|
|
</a>
|
|
<b class="arrow"></b>
|
|
<ul class="submenu">
|
|
<?php
|
|
while ($transaction_row2 = @mysqli_fetch_array($res_transaction2)) {
|
|
if ($transaction_row2['menu_url'] <= 1) {
|
|
?>
|
|
<li class="">
|
|
<a href="<?php echo $transaction_row2['menu_url'] ?>">
|
|
<i class="menu-icon fa fa-caret-right"></i>
|
|
<span><?php echo $transaction_row2['menu_name'] ?></span>
|
|
</a>
|
|
</li>
|
|
<?php
|
|
}
|
|
}//end of transaction_row2 while
|
|
?>
|
|
</ul>
|
|
</li>
|
|
<?php
|
|
}else{
|
|
?>
|
|
<li class="">
|
|
<a href="<?php echo $transaction_row1['menu_url'] ?>">
|
|
<i class="menu-icon fa fa-caret-right"></i>
|
|
<span onclick="location='<?php echo $transaction_row1['menu_url']?>'"><?php echo $transaction_row1['menu_name'] ?></span>
|
|
</a>
|
|
</li>
|
|
<?php
|
|
}
|
|
}else{
|
|
?>
|
|
<li class="">
|
|
<a href="<?php echo $transaction_row1['menu_url'] ?>">
|
|
<i class="menu-icon fa fa-caret-right"></i>
|
|
<span><?php echo $transaction_row1['menu_name'] ?></span>
|
|
</a>
|
|
</li>
|
|
<?php }//end of transaction_row1 blank menu url?>
|
|
<?php }//end of transaction_row1 while?>
|
|
|
|
</ul>
|
|
</li>
|
|
<?php }else{
|
|
?>
|
|
<li class="">
|
|
<a href="<?php echo $transaction_row['menu_url'] ?>">
|
|
<i class="menu-icon fa fa-caret-right"></i>
|
|
<span><?php echo $transaction_row['menu_name'] ?></span>
|
|
</a>
|
|
</li>
|
|
<?php
|
|
}//end of numrows2 if?>
|
|
<?php }else{
|
|
?>
|
|
<li class="">
|
|
<a href="<?php echo $transaction_row['menu_url'] ?>">
|
|
<i class="menu-icon fa fa-caret-right"></i>
|
|
<span><?php echo $transaction_row['menu_name'] ?></span>
|
|
</a>
|
|
</li>
|
|
<?php } //end of else?>
|
|
<?php }?>
|
|
</ul>
|
|
</li>
|
|
<?php }?>
|
|
<!--End of sale-->
|
|
|
|
<!--Purchase order-->
|
|
<?php
|
|
$sql_purchase = "select distinct(m.menu_id),m.menu_name,m.menu_description,m.menu_url,m.parent_id from assign_menu a, menu_master m where a.menu_id= m.menu_id and parent_id=0 and a.role_id='" . $_SESSION['RoleId'] . "' and m.menu_id >=60 and m.menu_id <70 order by convert(m.menu_id, signed )";
|
|
//echo $sql_purchase;
|
|
$res_purchase = mysqli_query($conn,$sql_purchase);
|
|
$num_rows = @mysqli_num_rows($res_purchase);
|
|
//echo $num_rows1;
|
|
if ($num_rows > 0) {
|
|
?>
|
|
<!--purchase as list-->
|
|
<li class="">
|
|
<a href="#" class="dropdown-toggle">
|
|
<i class="menu-icon fa fa-calendar"></i>
|
|
<span class="menu-text">
|
|
OHC Planner
|
|
</span>
|
|
|
|
<b class="arrow fa fa-angle-down"></b>
|
|
</a>
|
|
<b class="arrow"></b>
|
|
|
|
<!--purchase submenu-->
|
|
|
|
<ul class="submenu">
|
|
<?php
|
|
while ($purchase_row = @mysqli_fetch_array($res_purchase)) {
|
|
if ($purchase_row['menu_url'] <= 1) {
|
|
|
|
$sql_purchase1 = "select distinct(m.menu_id),m.menu_name,m.menu_description,m.menu_url,m.parent_id from assign_menu a, menu_master m where a.menu_id= m.menu_id and a.role_id='" . $_SESSION['RoleId'] . "' and m.parent_id ='" . $purchase_row['menu_id'] . "' ORDER BY m.menu_id ASC";
|
|
|
|
//echo $sql_transaction1;
|
|
|
|
$res_purchase1 = mysqli_query($conn,$sql_purchase1);
|
|
|
|
$num_rows1 = @mysqli_num_rows($res_purchase1);
|
|
|
|
if ($num_rows1 > 0) {
|
|
?>
|
|
<li class="">
|
|
<a href="" class="dropdown-toggle">
|
|
<i class="menu-icon fa fa-caret-right"></i>
|
|
<span><?php echo $purchase_row['menu_name'] ?> </span>
|
|
</a>
|
|
<b class="arrow"></b>
|
|
<ul class="submenu">
|
|
<?php
|
|
while ($purchase_row1 = @mysqli_fetch_array($res_purchase1)) {
|
|
if ($purchase_row1['menu_url'] <= 1) {
|
|
|
|
$sql_purchase2 = "select distinct(m.menu_id),m.menu_name,m.menu_description,m.menu_url,m.parent_id from assign_menu a, menu_master m where a.menu_id= m.menu_id and a.role_id='" . $_SESSION['RoleId'] . "' and m.parent_id ='" . $purchase_row1['menu_id'] . "' ORDER BY m.menu_id ASC";
|
|
|
|
//echo $sql_transaction1;
|
|
|
|
$res_purchase2 = mysqli_query($conn,$sql_purchase2);
|
|
|
|
$num_rows2 = @mysqli_num_rows($res_purchase2);
|
|
|
|
if ($num_rows2 > 0) {
|
|
?>
|
|
<li class="">
|
|
<a href="" class="dropdown-toggle">
|
|
<i class="menu-icon fa fa-caret-right"></i>
|
|
<span><?php echo $purchase_row1['menu_name'] ?> </span>
|
|
</a>
|
|
</li>
|
|
<?php } else {
|
|
?>
|
|
<li class="">
|
|
<a href="<?php echo $purchase_row1['menu_url'] ?>">
|
|
<i class="menu-icon fa fa-caret-right"></i>
|
|
<span><?php echo $purchase_row1['menu_name'] ?></span>
|
|
</a>
|
|
</li>
|
|
<?php
|
|
}
|
|
} else {
|
|
?>
|
|
<li class="">
|
|
<a href="<?php echo $purchase_row1['menu_url'] ?>">
|
|
<i class="menu-icon fa fa-caret-right"></i>
|
|
<span><?php echo $purchase_row1['menu_name'] ?></span>
|
|
</a>
|
|
</li>
|
|
<?php } ?>
|
|
<?php } ?>
|
|
</ul>
|
|
<?php } else { ?>
|
|
<li class="">
|
|
<a href="<?php echo $purchase_row['menu_url'] ?>">
|
|
<i class="menu-icon fa fa-caret-right"></i>
|
|
<span><?php echo $purchase_row['menu_name'] ?></span>
|
|
</a>
|
|
</li>
|
|
<?php
|
|
}
|
|
} else {
|
|
?>
|
|
<li class="">
|
|
<a href="<?php echo $purchase_row['menu_url'] ?>">
|
|
<i class="menu-icon fa fa-caret-right"></i>
|
|
<span><?php echo $purchase_row['menu_name'] ?></span>
|
|
</a>
|
|
</li>
|
|
<?php } ?>
|
|
<?php } ?>
|
|
</ul>
|
|
</li>
|
|
<?php } ?>
|
|
<!--End of Purchase order-->
|
|
|
|
|
|
<!--Account-->
|
|
<?php
|
|
$sql_account = "select distinct(m.menu_id),m.menu_name,m.menu_description,m.menu_url,m.parent_id from assign_menu a, menu_master m where a.menu_id= m.menu_id and parent_id=0 and a.role_id='" . $_SESSION['RoleId'] . "' and m.menu_id >100 and m.menu_id <=150 order by m.menu_id asc";
|
|
|
|
//echo $sql_transaction;
|
|
|
|
$res_account = mysqli_query($conn,$sql_account);
|
|
|
|
$num_rows = @mysqli_num_rows($res_account);
|
|
|
|
if ($num_rows > 0) {
|
|
?>
|
|
<!--Account as list-->
|
|
<li class="">
|
|
<a href="#" class="dropdown-toggle">
|
|
<i class="menu-icon fa fa-book"></i>
|
|
<span class="menu-text">
|
|
Inventory Mgmt
|
|
</span>
|
|
|
|
<b class="arrow fa fa-angle-down"></b>
|
|
</a>
|
|
<b class="arrow"></b>
|
|
<ul class="submenu">
|
|
<?php
|
|
while ($account_row = @mysqli_fetch_array($res_account)) {
|
|
if ($account_row['menu_url'] <= 1) {
|
|
|
|
$sql_account1 = "select distinct(m.menu_id),m.menu_name,m.menu_description,m.menu_url,m.parent_id from assign_menu a, menu_master m where a.menu_id= m.menu_id and a.role_id='" . $_SESSION['RoleId'] . "' and m.parent_id ='" . $account_row['menu_id'] . "' order by m.menu_id asc";
|
|
|
|
//echo $sql_transaction1;
|
|
|
|
$res_account1 = mysqli_query($conn,$sql_account1);
|
|
|
|
$num_rows1 = @mysqli_num_rows($res_account1);
|
|
|
|
if ($num_rows1 > 0) {
|
|
?>
|
|
<li class="">
|
|
<a href="" class="dropdown-toggle">
|
|
<i class="menu-icon fa fa-caret-right"></i>
|
|
<span onclick="location='<?php echo $account_row['menu_url'] ?>'"><?php echo $account_row['menu_name'] ?> </span>
|
|
</a>
|
|
<b class="arrow"></b>
|
|
<ul class="submenu">
|
|
<?php
|
|
while ($account_row1 = @mysqli_fetch_array($res_account1)) {
|
|
if ($account_row1['menu_url'] <= 1) {
|
|
|
|
$sql_account2 = "select distinct(m.menu_id),m.menu_name,m.menu_description,m.menu_url,m.parent_id from assign_menu a, menu_master m where a.menu_id= m.menu_id and a.role_id='" . $_SESSION['RoleId'] . "' and m.parent_id ='" . $account_row1['menu_id'] . "' order by m.menu_id asc";
|
|
|
|
//echo $sql_transaction1;
|
|
|
|
$res_account2 = mysqli_query($conn,$sql_account2);
|
|
|
|
$num_rows2 = @mysqli_num_rows($res_account2);
|
|
|
|
if ($num_rows2 > 0) {
|
|
?>
|
|
<li class="">
|
|
<a href="" class="dropdown-toggle">
|
|
<i class="menu-icon fa fa-caret-right"></i>
|
|
<span onclick="location='<?php echo $account_row1['menu_url'] ?>?p=<?php echo $_SESSION['user_id']?>&pagekey=<?php echo $account_row1['menu_id']?>'"><?php echo $account_row1['menu_name'] ?> </span>
|
|
</a>
|
|
<b class="arrow"></b>
|
|
<ul class="submenu">
|
|
<?php
|
|
while ($account_row2 = @mysqli_fetch_array($res_account2)) {
|
|
if ($account_row2['menu_url'] <= 1) {
|
|
|
|
$sql_account3 = "select distinct(m.menu_id),m.menu_name,m.menu_description,m.menu_url,m.parent_id from assign_menu a, menu_master m where a.menu_id= m.menu_id and a.role_id='" . $_SESSION['RoleId'] . "' and m.parent_id ='" . $account_row2['menu_id'] . "' order by m.menu_id asc";
|
|
$res_account3 = mysqli_query($conn,$sql_account2);
|
|
$num_rows3 = @mysqli_num_rows($res_account3);
|
|
if ($num_rows3 > 0) {
|
|
?>
|
|
<li class="">
|
|
<a href="<?php echo $account_row2['menu_url']?>?p=<?php echo $_SESSION['user_id']?>&pagekey=<?php echo $account_row2['menu_id']?>">
|
|
<i class="menu-icon fa fa-caret-right"></i>
|
|
<span><?php echo $account_row2['menu_name'] ?></span>
|
|
</a>
|
|
</li>
|
|
<?php } else { ?>
|
|
<li class="">
|
|
<a href="<?php echo $account_row2['menu_url'] ?>?p=<?php echo $_SESSION['user_id']?>&pagekey=<?php echo $account_row2['menu_id']?>">
|
|
<i class="menu-icon fa fa-caret-right"></i>
|
|
<span><?php echo $account_row2['menu_name'] ?></span>
|
|
</a>
|
|
</li>
|
|
<?php } ?>
|
|
<?php } else { ?>
|
|
<li class="">
|
|
<a href="<?php echo $account_row2['menu_url']?>?p=<?php echo $_SESSION['user_id']?>&pagekey=<?php echo $account_row2['menu_id']?>">
|
|
<i class="menu-icon fa fa-caret-right"></i>
|
|
<span><?php echo $account_row2['menu_name'] ?></span>
|
|
</a>
|
|
</li>
|
|
<?php } ?>
|
|
<?php } ?>
|
|
</ul>
|
|
</li>
|
|
<?php } else { ?>
|
|
<li class="">
|
|
<a href="<?php echo $account_row1['menu_url'] ?>?p=<?php echo $_SESSION['user_id']?>&pagekey=<?php echo $account_row1['menu_id']?>">
|
|
<i class="menu-icon fa fa-caret-right"></i>
|
|
<span><?php echo $account_row1['menu_name'] ?></span>
|
|
</a>
|
|
</li>
|
|
<?php } ?>
|
|
<?php } else { ?>
|
|
<li class="">
|
|
<a href="<?php echo $account_row1['menu_url'] ?>?p=<?php echo $_SESSION['user_id']?>&pagekey=<?php echo $account_row1['menu_id']?>">
|
|
<i class="menu-icon fa fa-caret-right"></i>
|
|
<span><?php echo $account_row1['menu_name'] ?></span>
|
|
</a>
|
|
</li>
|
|
<?php } ?>
|
|
<?php } ?>
|
|
</ul>
|
|
</li>
|
|
<?php } else { ?>
|
|
<li class="">
|
|
<a href="<?php echo $account_row['menu_url'] ?>?p=<?php echo $_SESSION['user_id']?>&pagekey=<?php echo $account_row['menu_id']?>">
|
|
<i class="menu-icon fa fa-caret-right"></i>
|
|
<span onclick="location='<?php echo $account_row['menu_url'] ?>'"><?php echo $account_row['menu_name'] ?></span>
|
|
</a>
|
|
</li>
|
|
<?php } ?>
|
|
<?php } else { ?>
|
|
<li class="">
|
|
<a href="<?php echo $account_row['menu_url'] ?>?p=<?php echo $_SESSION['user_id']?>&pagekey=<?php echo $account_row['menu_id']?>">
|
|
<i class="menu-icon fa fa-caret-right"></i>
|
|
<span><?php echo $account_row['menu_name'] ?></span>
|
|
</a>
|
|
</li>
|
|
<?php } ?>
|
|
<?php } ?>
|
|
</ul>
|
|
</li>
|
|
<?php } ?>
|
|
<!--End of account-->
|
|
<!--Training Module-->
|
|
|
|
<!--End of Reports-->
|