<?php
class listgateway {
public function setsql($sql){
$this->sqlList = $sql;
}
public function totalrecord(){
return mysql_num_rows( mysql_query( $this->sqlList ) );
}
public function listview(){
$sql = $this->sqlList." limit ".$this->start.",".$this->limit;
$res = mysql_query( $sql );
return $res;
}
public function numpage($rowPage){
return floor( totalrecord( ) / $rowPage );
}
public function deleterecord($adid){
mysql_query( "update payment_gateway set pg_status=0 where id='".$adid."'" );
}
public function activerecord($adid){
mysql_query( "update payment_gateway set pg_status=1 where id='".$adid."'" );
}
public function deletelink($id){
return ($_SERVER['QUERY_STRING'] == "") ? "?action=del&aid=".$id : "gateway-view.php?".$_SERVER['QUERY_STRING']."&action=del&aid=".$id;
}
public function activelink($id){
return ($_SERVER['QUERY_STRING'] == "") ? "?action=act&aid=".$id : "gateway-view.php?".$_SERVER['QUERY_STRING']."&action=act&aid=".$id;
}
}
function splitdeptid($id){
$id_list = split( ",", $id);
$return = "";
foreach($id_list as $id_out ){
$query_dep_id = "select * from department where dept_id='".$id_out."'";
$dep_id = mysql_query($query_dep_id);
$obj_dep_id = mysql_fetch_object($dep_id);
$return .= $obj_dep_id->dept_short_name.", ";
}
$return = substr( $return, 0, strlen($return) - 2 );
return $return;
}
function designame($id){
$query_id_desig = "select * from designation where desig_id='".$id."'";
$desig_id = mysql_query($query_id_desig);
$obj_desig_id = mysql_fetch_object($desig_id);
$return = $obj_desig_id->desig_name;
return $return;
}