public function getParamArray($param_name, $condition ,$order_clause, $group_clause, $having_clause) { $db = new dbclass(); $conn =$db->connector(); $sql = "SELECT DISTINCT PValue as ".$param_name." FROM system_parameters WHERE PName = '".$param_name."';"; if ($condition!='') $sql .=' AND '.$condition; if ($order_clause!='') $sql .=' ORDER BY '.$order_clause; if ($group_clause!='') $sql .=' GROUP BY '.$grouop_clause; if ($having_clause!='' )$sql .= ' HAVING '.$having_clause; $result = mysql_query($sql); while($row=mysql_fetch_array($result)) { $param_arr[] = $row; } mysql_close($conn); return $this->paramArray = $param_arr; }
public static function getInstance($conf_db_host, $conf_db_user, $conf_db_pass, $conf_db_name) { if (empty(self::$instance)) { try { self::$instance = new dbclass($conf_db_host, $conf_db_user, $conf_db_pass, $conf_db_name); } catch (PDOException $e) { echo 'Connection Failed: ' . $e->getMessage(); } } return self::$instance; }
<?php require_once "config.php"; require_once "class/db.php"; require_once "class/users.php"; require_once "class/rooms.php"; require_once "class/chat.php"; require_once "class/playlist.php"; require_once "class/log.php"; require_once "class/youtube.php"; require_once 'class/db.class.php'; try { $conn = dbclass::getInstance($conf_db_host, $conf_db_user, $conf_db_pass, $conf_db_name); $db = new mydb($conf_db_host, $conf_db_user, $conf_db_pass, $conf_db_name) or die("cant connect to db."); $Users = new Users($db); $Rooms = new Rooms($db); $Chat = new Chat($conn); $Playlist = new Playlist($db); $youtube_api = new Youtube(array('key' => 'AIzaSyAU20ONcngOuwge_V4CrAAUJPtCjmxPv-E')); } catch (Exception $e) { echo 'Caught exception: ', $e->getMessage(), "\n"; die; } session_start();
$pays['title'] = array(); $gets['title'] = array(); $pays['param3'] = array(); $gets['loan_remainder'] = array(); $gets['frac_remainder'] = array(); $pay_sum = 0; $get_sum = 0; $pay_diff_sum = 0; $get_diff_sum = 0; $stf_sql = dbclass::getInstance(); $stf_res = $stf_sql->Execute("select PersonID,person_type from hrmstotal.staff where staff_id=" . $_GET['staff_id']); $stf_res = $stf_res->GetRows(); if ($stf_res[0]['PersonID'] != $_SESSION["PersonID"]) { echo "<center>" . "<b>" . "شما به این فرم دسترسی ندارید" . "</b>" . "</center>"; } else { $sly_sql = dbclass::getInstance(); $sly_query = " SELECT sit.print_order,ps.pfname,\r\n ps.plname,\r\n sit.effect_type,\r\n sit.print_title salary_item_title,\r\n c.cost_center_id,\r\n c.title cost_center_title,\r\n pai.pay_value,\r\n pai.get_value,\r\n (pai.diff_pay_value * diff_value_coef) diff_pay_value,\r\n (pai.diff_get_value * diff_value_coef) diff_get_value,\r\n pai.salary_item_type_id,\r\n pai.param3,\r\n pai.param2,\r\n pa.account_no,\r\n s.tafsili_id,\r\n s.staff_id,\r\n b.bank_id,\r\n b.name,\r\n pa.message,\r\n pa.pay_year,\r\n pa.pay_month,\r\n pai.param1 ,\r\n\t\t\t\t\t CASE pai.param1\r\n\t\t\t\t\t \tWHEN 'LOAN' THEN pai.param4\r\n\t\t\t\t\t END loan_remainder,\r\n\t\t\t\t\t CASE pai.param1\r\n\t\t\t\t\t \tWHEN 'FRACTION' THEN pai.param4\r\n\t\t\t\t\t END frac_remainder\r\n\t\t\t\t\t \r\n\t\t\t\t FROM hrmstotal.payment_items pai\r\n INNER JOIN hrmstotal.payments pa\r\n ON (pa.pay_year = pai.pay_year AND\r\n pa.pay_month = pai.pay_month AND\r\n pa.staff_id = pai.staff_id AND\r\n pa.payment_type = pai.payment_type AND\r\n pai.payment_type = " . $_GET['payment_type'] . ")\r\n INNER JOIN hrmstotal.salary_item_types sit\r\n ON (pai.salary_item_type_id = sit.salary_item_type_id)\r\n INNER JOIN hrmstotal.writs w\r\n ON ((pa.writ_id = w.writ_id) AND (pa.writ_ver = w.writ_ver) AND (w.staff_id=pa.staff_id))\r\n INNER JOIN hrmstotal.staff s\r\n ON (pa.staff_id = s.staff_id)\r\n INNER JOIN hrmstotal.persons ps\r\n ON (s.PersonID = ps.PersonID)\r\n INNER JOIN hrmstotal.cost_centers c\r\n ON (pai.cost_center_id = c.cost_center_id)\r\n LEFT OUTER JOIN hrmstotal.banks b\r\n ON (s.bank_id = b.bank_id)\r\n \r\n WHERE (pa.staff_id=" . $_GET['staff_id'] . " AND pa.payment_type =" . $_GET['payment_type'] . " AND\r\n pa.pay_month=" . $_GET['pay_month'] . " AND pa.pay_year=" . $_GET['pay_year'] . ") AND if(pa.pay_year=1393 ,pa.pay_month < 13 , (1=1))\r\n ORDER BY c.cost_center_id,\r\n\t\t\t\t\t\t\t pa.pay_year,\r\n\t\t\t\t\t\t\t pa.pay_month,\r\n\t\t\t\t\t\t\t ps.plname,\r\n\t\t\t\t\t\t\t ps.pfname,\r\n\t\t\t\t\t\t\t sit.print_order"; /* if($_SESSION['UserID'] == 'bmahdipour') echo $sly_query ; */ $sly_result = $sly_sql->Execute($sly_query); $sly_result = $sly_result->GetRows(); echo "<table width=97% align=center cellspacing=0 >"; echo "<tr >"; echo "<td class=info width=15% >" . "نام خانوادگي : " . "</td>"; echo "<td class=info width=20% >" . $sly_result[0]['plname'] . "</td>"; echo "<td class=info width=15% >" . "شماره حساب : " . "</td>"; echo "<td class=info width=15% >" . $sly_result[0]['account_no'] . "</td>"; echo "<td class=info width=17% >" . "كد شناسايي : " . "</td>"; echo "<td class=info width=15% >" . $sly_result[0]['staff_id'] . "</td>"; echo "</tr>"; echo "<tr >";
function getLast() { $db = new dbclass(); $data = $db->select("select pubKey,amount from donations order by dateadded desc limit 20"); $db->close(); return $data; }