server = "localhost"; $dbC->db = "fenipourashava_cms"; // "fani_cms"; // "fenipour_cms"; $dbC->user = "fenipourashava_admin"; // "root"; // "fenipour_admin"; $dbC->pass = "yi9yips7OMew";// ""; //"aerFmDA57dwF"; $dbC->db_connect(); ?>server = "localhost"; $dbC->db = "fenipourashava_cms"; // "fani_cms"; // "fenipour_cms"; $dbC->user = "fenipourashava_admin"; // "root"; // "fenipour_admin"; $dbC->pass = "yi9yips7OMew";// ""; //"aerFmDA57dwF"; $dbC->db_connect(); ?> ..::নির্মাণ কাজ অনুমোদন ও ম্যানেজমেন্ট সিস্টেম ::..- Session started for <? echo $sessMemberLogin;?>
স্বাগতম: []
  ";?> পাসওর্য়াড পরিবর্তন";?>     সাইন আউট  
[অ্যাডমিন নিয়মাবলী] 'Hide' order by page_title ASC"; $rs_v1 = mysql_query("SET CHARACTER SET utf8"); $rs_v2 = mysql_query("SET SESSION collation_connection =’utf8_general_ci’"); $rs_view=mysql_query($sql_view); $norec_view=mysql_num_rows($rs_view); for($i=0;$i<$norec_view;$i++) { $row_view=mysql_fetch_array($rs_view); $page_id=$row_view["page_id"]; $page_name=$row_view["page_name"]; $page_title=$row_view["page_title"]; $page_is_admin=$row_view["page_is_admin"]; $page_desc=$row_view["page_desc"]; if($norec_view > 0) { echo ""; } else { echo ""; } }?>
$page_title
No Link to view
[সাধারন নিয়মাবলী] 'Hide' order by page_title ASC"; //echo "
".$sql_view; $rs_v1 = mysql_query("SET CHARACTER SET utf8"); $rs_v2 = mysql_query("SET SESSION collation_connection =’utf8_general_ci’"); $rs_view=mysql_query($sql_view); $norec_view=mysql_num_rows($rs_view); for($i=0;$i<$norec_view;$i++) { $row_view=mysql_fetch_array($rs_view); $page_id=$row_view["page_id"]; $page_name=$row_view["page_name"]; $page_title=$row_view["page_title"]; $page_is_admin=$row_view["page_is_admin"]; $page_desc=$row_view["page_desc"]; if( $norec_view > 0 ) { if( $page_is_admin == "0") echo ""; } else { echo ""; } ?>
$page_title
No Link to view"; } echo"
[বর্তমান অবস্হা]] "; $sqlPer="SELECT count(app_code) as tot_app FROM tbl_application GROUP by post_flag, aprv_status HAVING post_flag='0' and aprv_status='1'"; $rsPer=mysql_query($sqlPer); $rowPer=mysql_fetch_array($rsPer); $total_apprv = $rowPer['tot_app']; echo ""; $pending_qty = ($total_app * 1) - ($total_apprv * 1); echo ""; $sqlPer="SELECT sum(fees_amt) as tot_bill FROM tbl_application GROUP by post_flag HAVING post_flag='0'"; $rsPer=mysql_query($sqlPer); $rowPer=mysql_fetch_array($rsPer); $total_bill = $rowPer['tot_bill']; $sqlPer="SELECT sum(bill_amt) as tot_bill FROM tbl_bill GROUP by post_flag HAVING post_flag='0'"; $rsPer=mysql_query($sqlPer); $rowPer=mysql_fetch_array($rsPer); $total_bill = ($total_bill * 1) + ($rowPer['tot_bill'] * 1); echo ""; $due_amt = '0'; echo ""; $sqlPer="SELECT count( t.app_code ) AS tot_r FROM (SELECT DISTINCT app_code FROM `tbl_file_upload` WHERE post_flag =0) AS t"; $rsPer=mysql_query($sqlPer); $rowPer=mysql_fetch_array($rsPer); $total_found = ($total_app * 1) - ($rowPer['tot_r'] * 1); echo ""; ?>
মোট আবেদনকারীর সংখ্যা: $total_app
মোট অনুমোদিত আবেদনকারীর সংখ্যা: $total_apprv
মোট অন-অনুমোদিত আবেদনকারীর সংখ্যা: $pending_qty
মোট আদায়কৃত টাকার পরিমান: $total_bill
মোট বকেয়া টাকার পরিমান: $due_amt
মোট অসম্পূর্ন আবেদনকারীর সংখ্যা: $total_found
[প্রাত্যহিক তথ্য এন্ট্রি/হালনাগাদ] 'Hide' order by page_title ASC"; $rs_v1 = mysql_query("SET CHARACTER SET utf8"); $rs_v2 = mysql_query("SET SESSION collation_connection =’utf8_general_ci’"); $rs_view=mysql_query($sql_view); $norec_view=mysql_num_rows($rs_view); for($i=0;$i<$norec_view;$i++) { $row_view=mysql_fetch_array($rs_view); $page_id=$row_view["page_id"]; $page_name=$row_view["page_name"]; $page_title=$row_view["page_title"]; $page_is_admin=$row_view["page_is_admin"]; $page_desc=$row_view["page_desc"]; if( $norec_view > 0 ) { // echo ""; if( $page_is_admin == "0") echo ""; } else { echo ""; } ?>
$page_title No Link to view"; } echo"
[এম আই এস রিপোর্ট/প্রতিবেদন] 'Hide' order by page_title ASC"; $rs_v1 = mysql_query("SET CHARACTER SET utf8"); $rs_v2 = mysql_query("SET SESSION collation_connection =’utf8_general_ci’"); $rs_view=mysql_query($sql_view); $norec_view=mysql_num_rows($rs_view); if( $norec_view > 0 ) { for($i=0;$i<$norec_view;$i++) { $row_view=mysql_fetch_array($rs_view); $page_id=$row_view["page_id"]; $page_name=$row_view["page_name"]; $page_title=$row_view["page_title"]; $page_is_admin=$row_view["page_is_admin"]; $page_desc=$row_view["page_desc"]; // $tot_req if ($page_id == 224) //--- for Demand List Approve { echo ""; } else echo ""; } } else { echo ""; } ?>
$page_title
$page_title
No Link to view
[General Policy] 'Hide' order by page_title ASC"; $rs_view=mysql_query($sql_view); $norec_view=mysql_num_rows($rs_view); if($norec_view > 0) { for($i=0;$i<$norec_view;$i++) { $row_view=mysql_fetch_array($rs_view); $page_id=$row_view["page_id"]; $page_name=$row_view["page_name"]; $page_title=$row_view["page_title"]; $page_is_admin=$row_view["page_is_admin"]; $page_desc=$row_view["page_desc"]; echo ""; } } else { echo ""; } ?>
  $page_title 
No Link to Access
[Store Policy] 'Hide' order by page_title ASC"; $rs_view=mysql_query($sql_view); $norec_view=mysql_num_rows($rs_view); if( $norec_view > 0 ) { for($i=0;$i<$norec_view;$i++) { $row_view=mysql_fetch_array($rs_view); $page_id=$row_view["page_id"]; $page_name=$row_view["page_name"]; $page_title=$row_view["page_title"]; $page_is_admin=$row_view["page_is_admin"]; $page_desc=$row_view["page_desc"]; echo ""; } } else { echo ""; } ?>
  $page_title 
No Link to Access
[Records] 'Hide' order by page_title ASC"; //echo "
".$sql_view; $rs_view=mysql_query($sql_view); $norec_view=mysql_num_rows($rs_view); if( $norec_view > 0 ) { for($i=0;$i<$norec_view;$i++) { $row_view=mysql_fetch_array($rs_view); $page_id=$row_view["page_id"]; $page_name=$row_view["page_name"]; $page_title=$row_view["page_title"]; $page_is_admin=$row_view["page_is_admin"]; $page_desc=$row_view["page_desc"]; echo ""; } } else { echo ""; } ?>
  $page_title 
No Link to Access
[Requisition Mgt] 'Hide' order by page_title ASC"; //echo "
".$sql_view; $rs_view=mysql_query($sql_view); $norec_view=mysql_num_rows($rs_view); if( $norec_view > 0 ) { for($i=0;$i<$norec_view;$i++) { $row_view=mysql_fetch_array($rs_view); $page_id=$row_view["page_id"]; $page_name=$row_view["page_name"]; $page_title=$row_view["page_title"]; $page_is_admin=$row_view["page_is_admin"]; $page_desc=$row_view["page_desc"]; echo ""; } } else { echo ""; } ?>
  $page_title 
No Link to Access
[Approval Mgt] 'Hide' order by page_title ASC"; //echo "
".$sql_view; $rs_view=mysql_query($sql_view); $norec_view=mysql_num_rows($rs_view); if( $norec_view > 0 ) { for($i=0;$i<$norec_view;$i++) { $row_view=mysql_fetch_array($rs_view); $page_id=$row_view["page_id"]; $page_name=$row_view["page_name"]; $page_title=$row_view["page_title"]; $page_is_admin=$row_view["page_is_admin"]; $page_desc=$row_view["page_desc"]; echo ""; } } else { echo ""; } ?>
  $page_title 
No Link to Access
[Purchase Mgt] 'Hide' order by page_title ASC"; //echo "
".$sql_view; $rs_view=mysql_query($sql_view); $norec_view=mysql_num_rows($rs_view); if( $norec_view > 0 ) { for($i=0;$i<$norec_view;$i++) { $row_view=mysql_fetch_array($rs_view); $page_id=$row_view["page_id"]; $page_name=$row_view["page_name"]; $page_title=$row_view["page_title"]; $page_is_admin=$row_view["page_is_admin"]; $page_desc=$row_view["page_desc"]; echo ""; } } else { echo ""; } ?>
  $page_title 
No Link to Access
[Store Mgt] 'Hide' order by page_title ASC"; //echo "
".$sql_view; $rs_view=mysql_query($sql_view); $norec_view=mysql_num_rows($rs_view); if( $norec_view > 0 ) { for($i=0;$i<$norec_view;$i++) { $row_view=mysql_fetch_array($rs_view); $page_id=$row_view["page_id"]; $page_name=$row_view["page_name"]; $page_title=$row_view["page_title"]; $page_is_admin=$row_view["page_is_admin"]; $page_desc=$row_view["page_desc"]; echo ""; } } else { echo ""; } ?>
  $page_title 
No Link to Access
[Reports] 'Hide' order by page_title ASC"; //echo "
".$sql_view; $rs_view=mysql_query($sql_view); $norec_view=mysql_num_rows($rs_view); if( $norec_view > 0 ) { for($i=0;$i<$norec_view;$i++) { $row_view=mysql_fetch_array($rs_view); $page_id=$row_view["page_id"]; $page_name=$row_view["page_name"]; $page_title=$row_view["page_title"]; $page_is_admin=$row_view["page_is_admin"]; $page_desc=$row_view["page_desc"]; echo ""; } } else { echo ""; } ?>
  $page_title 
No Link to Access