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;
}
