Viewing file:  resellermodel.php (43.68 KB) -rw-r--r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?
class resellerModel extends Model{
function resellerModel()
{
parent::Model();
}
/**
***********************************************************************
* @Start Global Section of Reseller ***********************************
***********************************************************************
*/
function getRealIpAddr()
{
if (!empty($_SERVER['HTTP_CLIENT_IP'])) //check ip from share internet
{
$ip=$_SERVER['HTTP_CLIENT_IP'];
}
elseif (!empty($_SERVER['HTTP_X_FORWARDED_FOR'])) //to check ip is pass from proxy
{
$ip=$_SERVER['HTTP_X_FORWARDED_FOR'];
}
else
{
$ip=$_SERVER['REMOTE_ADDR'];
}
return $ip;
}
/**
* @author: Md. Golam Rabbany
* @email: mgrnahid@gmail.com
* @description: This function return unique Reseller Login Name
* @copyright 2011
*/
function checkResellerLogin($login)
{
$query = $this->db->query("select *from resellers4 where login = '$login'");
if($query->num_rows()>0)
{
return 1;
}
else
{
$query = $this->db->query("select *from resellers3 where login = '$login'");
if($query->num_rows()>0)
{
return 1;
}
else
{
$query = $this->db->query("select *from resellers2 where login = '$login'");
if($query->num_rows()>0)
{
return 1;
}
else
{
$query = $this->db->query("select *from resellers1 where login = '$login'");
if($query->num_rows()>0)
{
return 1;
}
else
{
return 0;
}
}
}
}
}
/**
* @author: Md. Golam Rabbany
* @email: mgrnahid@gmail.com
* @description: This function Reseller Payment Infomation
* @copyright 2011
*/
function resellerPaymentHistory($id_reseller,$level)
{
$query = $this->db->query("select *from resellerpayment where id_reseller = '$id_reseller' AND level = '$level' order by creationdate DESC LIMIT 100");
//echo $this->db->last_query();
if($query->num_rows()>0)
{
return $query->result();
}
else
return 0;
}
/**
* @author: Md. Golam Rabbany
* @email: mgrnahid@gmail.com
* @description: This function Add Reseller Payment
* @copyright 2011
*/
function addResellerPayment($userID,$level)
{
$idReseller = $this->input->post('id_reseller');
$postBalance = $this->input->post('amount');
$resellerLevel = $level;
$paymentType = $this->input->post('type');
$lastBalance = $this->input->post('lastBalance');
if(!is_numeric($postBalance) OR $postBalance < 0 )
$postBalance = 0;
$dataPayment['id_reseller'] = $idReseller;
$dataPayment['level'] = $resellerLevel;
$dataPayment['amount'] = $postBalance;
$dataPayment['lastbalance'] = $lastBalance;
$dataPayment['type'] = $paymentType;
$dataPayment['description'] = $this->input->post('description');
$dataPayment['user_id'] = $userID;
$dataPayment['usertype'] = ADMIN_TYPE;
$dataPayment['ipaddress'] = $this->getRealIpAddr();
$tableName = "resellers".$resellerLevel;
$sql = $this->db->insert_string('resellerpayment', $dataPayment);
$query = $this->db->query($sql);
$idInsert = $this->db->insert_id();
if($idInsert)
{
if($paymentType==1)
{
$sqlUpdate = "UPDATE $tableName set balance = balance + '$postBalance',limit_balance = limit_balance + '$postBalance' where id='$idReseller'";
$queryUpdate = $this->db->query($sqlUpdate);
}
else
{
$sqlUpdate = "UPDATE $tableName set balance = balance - '$postBalance',limit_balance = limit_balance - '$postBalance' where id='$idReseller'";
$queryUpdate = $this->db->query($sqlUpdate);
}
}
}
/**
***********************************************************************
* @Start Reseller IV Section ******************************************
***********************************************************************
*/
/**
* @author: Md. Golam Rabbany
* @email: mgrnahid@gmail.com
* @description: This function return total number of reseller
* @copyright 2011
*/
function getTotalnumResellerLeve4($login,$password,$full_name,$id_rate,$callPhone,$type,$typeValue)
{
if($login=="NULL")
$loginStr = "";
else
$loginStr = "AND login like '$login%'";
if($password=="NULL")
$passwordStr = "";
else
$passwordStr = "AND password like '$password%'";
if($full_name=="NULL")
$fullNameStr = "";
else
$fullNameStr = "AND full_name like '$full_name%'";
if($id_rate=="NULL")
$idRateStr = "";
else
$idRateStr = "AND id_rate ='$id_rate'";
if($callPhone=="NULL")
$callPhoneStr = "";
else
$callPhoneStr = "AND phone like '$callPhone%'";
if($type == -1)
$typeStr = "";
elseif($type == 0)
$typeStr = "AND balance = '$typeValue'";
elseif($type == 1)
$typeStr = "AND balance > '$typeValue'";
else
$typeStr = "AND balance < '$typeValue'";
$sql="SELECT
count(id) as totalrows
FROM resellers4 Where id != '-1' $loginStr $passwordStr $fullNameStr $idRateStr $callPhoneStr $typeStr";
$row = 0;
$query = $this->db->query($sql);
foreach($query->result() as $resultrow)
{
$row = $resultrow->totalrows;
}
return $row;
}
/**
* @author: Md. Golam Rabbany
* @email: mgrnahid@gmail.com
* @description: This function return Reseller List
* @copyright 2011
*/
function resellerLevel4List($startoffset,$limit,$login,$password,$full_name,$id_rate,$callPhone,$type,$typeValue)
{
$new_startoffset = $startoffset - 1;
if($new_startoffset <0)
$new_startoffset = 0;
$startoffset1 = $limit * $new_startoffset;
$limit_string = "LIMIT $startoffset1,$limit";
if($login=="NULL")
$loginStr = "";
else
$loginStr = "AND a.login like '$login%'";
if($password=="NULL")
$passwordStr = "";
else
$passwordStr = "AND a.password like '$password%'";
if($full_name=="NULL")
$fullNameStr = "";
else
$fullNameStr = "AND a.full_name like '$full_name%'";
if($id_rate=="NULL")
$idRateStr = "";
else
$idRateStr = "AND a.id_rate ='$id_rate'";
if($callPhone=="NULL")
$callPhoneStr = "";
else
$callPhoneStr = "AND a.phone like '$callPhone%'";
if($type == -1)
$typeStr = "";
elseif($type == 0)
$typeStr = "AND a.balance = '$typeValue'";
elseif($type == 1)
$typeStr = "AND a.balance > '$typeValue'";
else
$typeStr = "AND a.balance < '$typeValue'";
$sql = "SELECT
a.id,
a.login,
a.password,
a.balance,
a.id_rate,
a.limit_user,
a.limit_rate,
a.limit_balance,
a.sipuser,
a.aniuser,
a.limit_fnf,
a.full_name,
a.cell,
a.phone,
a.status
FROM resellers4 a
where a.id !=-1 $loginStr $passwordStr $fullNameStr $idRateStr $callPhoneStr $typeStr order by a.login ASC $limit_string";
//echo $sql;
$query = $this->db->query($sql);
if($query->num_rows()>0)
return $query->result();
else
return 0;
}
/**
* @author: Md. Golam Rabbany
* @email: mgrnahid@gmail.com
* @description: This function Add Reseller III
* @copyright 2011
*/
function addReseller4($userID)
{
//$data['id'] = $this->input->post('id');
$data['login'] = $this->input->post('login');
$data['password'] = $this->input->post('password');
$balance = $this->input->post('balance');
if(!is_numeric($balance) OR $balance<0)
$balance = 0;
$commission = $this->input->post('commission');
if(!is_numeric($commission) OR $commission<0)
$commission = 0;
$limit_balance = $this->input->post('limit_balance');
if(!is_numeric($limit_balance) OR $limit_balance<0 OR $limit_balance==0)
$limit_balance = $balance;
$limit_rate = $this->input->post('limit_rate');
if(!is_numeric($limit_rate) OR $limit_rate<0)
$limit_rate = 0;
$limit_user = $this->input->post('limit_user');
if(!is_numeric($limit_user) OR $limit_user<0)
$limit_user = 0;
$data['balance'] = $balance;
$data['id_rate'] = $this->input->post('id_rate');
$data['limit_user'] = $limit_user;
$data['limit_rate'] = $limit_rate;
$data['limit_balance'] = $limit_balance;
$data['limit_fnf'] = $this->input->post('limit_fnf');
$data['commission'] = $commission;
$data['type'] = $this->input->post('type');
$data['sipuser'] = $this->input->post('sipuser');
$data['aniuser'] = $this->input->post('aniuser');
$data['full_name'] = $this->input->post('full_name');
$data['email'] = $this->input->post('email');
$data['cell'] = $this->input->post('cell');
$data['phone'] = $this->input->post('phone');
$data['city'] = $this->input->post('city');
$data['country'] = $this->input->post('country');
$data['state'] = $this->input->post('state');
$data['address'] = $this->input->post('address');
$data['status'] = $this->input->post('status');
$data['user_id'] = $userID;
$data['usertype'] = ADMIN_TYPE;
$data['ipaddress'] = $this->getRealIpAddr();
$data['creationdate'] = date('Y-m-d H:i:s');
$sql = $this->db->insert_string('resellers4', $data);
$query = $this->db->query($sql);
$idReseller = $this->db->insert_id();
if($idReseller)
{
$dataPayment['id_reseller'] = $idReseller;
$dataPayment['level'] = 4;
$dataPayment['amount'] = $balance;
$dataPayment['type'] = PREPAID;
$dataPayment['description'] = 'Initial Balance';
$dataPayment['user_id'] = $userID;
$dataPayment['usertype'] = ADMIN_TYPE;
$sqlPayment = $this->db->insert_string('resellerpayment', $dataPayment);
$queryPayment = $this->db->query($sqlPayment);
}
}
/**
* @author: Md. Golam Rabbany
* @email: mgrnahid@gmail.com
* @description: This function Return Edit Infomation of Reseller IV
* @copyright 2011
*/
function reseller4EditInfo($id)
{
$query = $this->db->query("select *from resellers4 where id = '$id' LIMIT 1");
if($query->num_rows()>0)
{
return $query->result();
}
else
return 0;
}
/**
* @author: Md. Golam Rabbany
* @email: mgrnahid@gmail.com
* @description: This function Add Reseller IV
* @copyright 2011
*/
function editReseller4($userID)
{
$keyvalue = $this->input->post('id');
$commission = $this->input->post('commission');
if(!is_numeric($commission) OR $commission<0)
$commission = 0;
$limit_balance = $this->input->post('limit_balance');
if(!is_numeric($limit_balance) OR $limit_balance<0 OR $limit_balance==0)
$limit_balance = 0;
$limit_rate = $this->input->post('limit_rate');
if(!is_numeric($limit_rate) OR $limit_rate<0)
$limit_rate = 0;
$limit_user = $this->input->post('limit_user');
if(!is_numeric($limit_user) OR $limit_user<0)
$limit_user = 0;
//$data['login'] = $this->input->post('login');
$data['password'] = $this->input->post('password');
//$data['balance'] = $this->input->post('balance');
$data['id_rate'] = $this->input->post('id_rate');
$data['limit_user'] = $limit_user;
$data['limit_rate'] = $limit_rate;
$data['limit_balance'] = $limit_balance;
$data['limit_fnf'] = $this->input->post('limit_fnf');
$data['commission'] = $commission;
$data['type'] = $this->input->post('type');
$data['sipuser'] = $this->input->post('sipuser');
$data['aniuser'] = $this->input->post('aniuser');
$data['full_name'] = $this->input->post('full_name');
$data['email'] = $this->input->post('email');
$data['cell'] = $this->input->post('cell');
$data['phone'] = $this->input->post('phone');
$data['city'] = $this->input->post('city');
$data['country'] = $this->input->post('country');
$data['state'] = $this->input->post('state');
$data['address'] = $this->input->post('address');
$data['status'] = $this->input->post('status');
$data['user_id'] = $userID;
$data['usertype'] = ADMIN_TYPE;
$data['ipaddress'] = $this->getRealIpAddr();
$data['creationdate'] = date('Y-m-d H:i:s');
$where = "id = $keyvalue";
$sql = $this->db->update_string('resellers4', $data, $where);
$query = $this->db->query($sql);
}
/**
* @author: Md. Golam Rabbany
* @email: mgrnahid@gmail.com
* @description: Find check Child Reseller of Reseller IV
* @copyright 2011
*/
function checkChildReseller4($idReseller)
{
$query = $this->db->query("select *from resellers3 where id_reseller = '$idReseller'");
if($query->num_rows()>0)
{
return 1;
}
else
return 0;
}
/**
* @author: Md. Golam Rabbany
* @email: mgrnahid@gmail.com
* @description: Delete information of Reseller IV
* @copyright 2011
*/
function deleteReseller4($idReseller)
{
$sql = "select id_rate from ratename where id_reseller = '$idReseller' AND level = 4";
$queryRateName = $this->db->query($sql);
if($queryRateName->num_rows()>0)
{
$result = $queryRateName->result();
if(is_array($result))
{
foreach($result as $row)
{
$idRate = $row->id_rate;
$sqlDeleteRateChart = "delete from ratechart where id_rate = '$idRate'";
$queryDeleteRate = $this->db->query($sqlDeleteRateChart);
}
}
$query = $this->db->query("delete from ratename where id_reseller = '$idReseller' AND level = 4");
}
$query = $this->db->query("delete from resellerpayment where id_reseller = '$idReseller' AND level = 4");
$query = $this->db->query("delete from resellers4 where id = '$idReseller'");
}
/**
* @author: Md. Golam Rabbany
* @email: mgrnahid@gmail.com
* @description: This function Check Reseller 4 Balance Limit
* @copyright 2011
*/
function getReseller4BalanceLimit($idReseller)
{
$query = $this->obj1->db->query("SELECT limit_balance FROM bb_resellers4 WHERE id = '$idReseller'");
if ($query->num_rows() > 0)
{
$row = $query->row();
return $row->limit_balance;
}
else
return 0;
}
/**
***********************************************************************
* @end Reseller IV Section ********************************************
***********************************************************************
*/
/**
***********************************************************************
* @Start Reseller III Section *****************************************
***********************************************************************
*/
/**
* @author: Md. Golam Rabbany
* @email: mgrnahid@gmail.com
* @description: This function return total number of reseller
* @copyright 2011
*/
function getTotalnumResellerLeve3($login,$password,$full_name,$id_rate,$idReseller,$type,$typeValue)
{
if($login=="NULL")
$loginStr = "";
else
$loginStr = "AND login like '$login%'";
if($password=="NULL")
$passwordStr = "";
else
$passwordStr = "AND password like '$password%'";
if($full_name=="NULL")
$fullNameStr = "";
else
$fullNameStr = "AND full_name like '$full_name%'";
if($id_rate=="NULL")
$idRateStr = "";
else
$idRateStr = "AND id_rate ='$id_rate'";
if($idReseller=="NULL")
$idResellerStr = "";
else
$idResellerStr = "AND id_reseller ='$idReseller'";
if($type == -1)
$typeStr = "";
elseif($type == 0)
$typeStr = "AND balance = '$typeValue'";
elseif($type == 1)
$typeStr = "AND balance > '$typeValue'";
else
$typeStr = "AND balance < '$typeValue'";
$sql="SELECT
count(id) as totalrows
FROM resellers3 Where id != '-1' $loginStr $passwordStr $fullNameStr $idRateStr $idResellerStr $typeStr";
$row = 0;
$query = $this->db->query($sql);
foreach($query->result() as $resultrow)
{
$row = $resultrow->totalrows;
}
return $row;
}
/**
* @author: Md. Golam Rabbany
* @email: mgrnahid@gmail.com
* @description: This function return Reseller List
* @copyright 2011
*/
function resellerLevel3List($startoffset,$limit,$login,$password,$full_name,$id_rate,$idReseller,$type,$typeValue)
{
$new_startoffset = $startoffset - 1;
if($new_startoffset <0)
$new_startoffset = 0;
$startoffset1 = $limit * $new_startoffset;
$limit_string = "LIMIT $startoffset1,$limit";
if($login=="NULL")
$loginStr = "";
else
$loginStr = "AND a.login like '$login%'";
if($password=="NULL")
$passwordStr = "";
else
$passwordStr = "AND a.password like '$password%'";
if($full_name=="NULL")
$fullNameStr = "";
else
$fullNameStr = "AND a.full_name like '$full_name%'";
if($id_rate=="NULL")
$idRateStr = "";
else
$idRateStr = "AND a.id_rate ='$id_rate'";
if($idReseller=="NULL")
$idResellerStr = "";
else
$idResellerStr = "AND a.id_reseller ='$idReseller'";
if($type == -1)
$typeStr = "";
elseif($type == 0)
$typeStr = "AND a.balance = '$typeValue'";
elseif($type == 1)
$typeStr = "AND a.balance > '$typeValue'";
else
$typeStr = "AND a.balance < '$typeValue'";
$sql = "SELECT
a.id,
a.id_reseller,
a.login,
a.password,
a.balance,
a.id_rate,
a.limit_user,
a.limit_rate,
a.limit_balance,
a.sipuser,
a.aniuser,
a.limit_fnf,
a.full_name,
a.status
FROM resellers3 a
where a.id !=-1 $loginStr $passwordStr $fullNameStr $idRateStr $idResellerStr $typeStr order by a.login ASC $limit_string";
//echo $sql;
$query = $this->db->query($sql);
if($query->num_rows()>0)
return $query->result();
else
return 0;
}
/**
* @author: Md. Golam Rabbany
* @email: mgrnahid@gmail.com
* @description: This function Add Reseller III
* @copyright 2011
*/
function addReseller3($userID)
{
//$data['id'] = $this->input->post('id');
$id_reseller = $this->input->post('id_reseller');
if($id_reseller=='')
$id_reseller = -1;
$balance = $this->input->post('balance');
if(!is_numeric($balance) OR $balance<0)
$balance = 0;
$commission = $this->input->post('commission');
if(!is_numeric($commission) OR $commission<0)
$commission = 0;
$limit_user = $this->input->post('limit_user');
if(!is_numeric($limit_user) OR $limit_user<0)
$limit_user = 0;
$limit_rate = $this->input->post('limit_rate');
if(!is_numeric($limit_rate) OR $limit_rate<0)
$limit_rate = 0;
$limit_balance = $this->input->post('limit_balance');
if(!is_numeric($limit_balance) OR $limit_balance <= 0)
$limit_balance = $balance;
$data['id_reseller'] = $id_reseller;
$data['login'] = $this->input->post('login');
$data['password'] = $this->input->post('password');
$data['balance'] = $balance;
$data['id_rate'] = $this->input->post('id_rate');
$data['limit_user'] = $limit_user;
$data['limit_rate'] = $limit_rate;
$data['limit_balance'] = $limit_balance;
$data['limit_fnf'] = $this->input->post('limit_fnf');
$data['commission'] = $commission;
$data['type'] = $this->input->post('type');
$data['sipuser'] = $this->input->post('sipuser');
$data['aniuser'] = $this->input->post('aniuser');
$data['full_name'] = $this->input->post('full_name');
$data['email'] = $this->input->post('email');
$data['cell'] = $this->input->post('cell');
$data['phone'] = $this->input->post('phone');
$data['city'] = $this->input->post('city');
$data['country'] = $this->input->post('country');
$data['state'] = $this->input->post('state');
$data['address'] = $this->input->post('address');
$data['status'] = $this->input->post('status');
$data['user_id'] = $userID;
$data['usertype'] = ADMIN_TYPE;
$data['ipaddress'] = $this->getRealIpAddr();
$data['creationdate'] = date('Y-m-d H:i:s');
$sql = $this->db->insert_string('resellers3', $data);
$query = $this->db->query($sql);
$idReseller = $this->db->insert_id();
if($idReseller)
{
$dataPayment['id_reseller'] = $idReseller;
$dataPayment['level'] = 3;
$dataPayment['amount'] = $balance;
$dataPayment['type'] = PREPAID;
$dataPayment['description'] = 'Initial Balance';
$dataPayment['user_id'] = $userID;
$dataPayment['usertype'] = ADMIN_TYPE;
$sqlPayment = $this->db->insert_string('resellerpayment', $dataPayment);
$queryPayment = $this->db->query($sqlPayment);
if($id_reseller>0)
{
$sqlUpdate = "UPDATE resellers4 set limit_balance = limit_balance - '$balance' where id='$id_reseller'";
$queryUpdate = $this->db->query($sqlUpdate);
}
}
}
/**
* @author: Md. Golam Rabbany
* @email: mgrnahid@gmail.com
* @description: This function Return Edit Infomation of Reseller III
* @copyright 2011
*/
function reseller3EditInfo($id)
{
$query = $this->db->query("select *from resellers3 where id = '$id' LIMIT 1");
if($query->num_rows()>0)
{
return $query->result();
}
else
return 0;
}
/**
* @author: Md. Golam Rabbany
* @email: mgrnahid@gmail.com
* @description: This function Add Reseller III
* @copyright 2011
*/
function editReseller3($userID)
{
$keyvalue = $this->input->post('id');
$id_reseller = $this->input->post('id_reseller');
if($id_reseller=='')
$id_reseller = -1;
$commission = $this->input->post('commission');
if(!is_numeric($commission) OR $commission <= 0)
$commission = 0;
$limit_user = $this->input->post('limit_user');
if(!is_numeric($limit_user) OR $limit_user<0)
$limit_user = 0;
$limit_rate = $this->input->post('limit_rate');
if(!is_numeric($limit_rate) OR $limit_rate<0)
$limit_rate = 0;
$limit_balance = $this->input->post('limit_balance');
if(!is_numeric($limit_balance) OR $limit_balance <= 0)
$limit_balance = 0;
//$data['login'] = $this->input->post('login');
$data['id_reseller'] = $id_reseller;
$data['password'] = $this->input->post('password');
//$data['balance'] = $this->input->post('balance');
$data['id_rate'] = $this->input->post('id_rate');
$data['limit_user'] = $limit_user;
$data['limit_rate'] = $limit_rate;
$data['limit_balance'] = $limit_balance;
$data['limit_fnf'] = $this->input->post('limit_fnf');
$data['commission'] = $commission;
$data['type'] = $this->input->post('type');
$data['sipuser'] = $this->input->post('sipuser');
$data['aniuser'] = $this->input->post('aniuser');
$data['full_name'] = $this->input->post('full_name');
$data['email'] = $this->input->post('email');
$data['cell'] = $this->input->post('cell');
$data['phone'] = $this->input->post('phone');
$data['city'] = $this->input->post('city');
$data['country'] = $this->input->post('country');
$data['state'] = $this->input->post('state');
$data['address'] = $this->input->post('address');
$data['status'] = $this->input->post('status');
$data['user_id'] = $userID;
$data['usertype'] = ADMIN_TYPE;
$data['ipaddress'] = $this->getRealIpAddr();
$data['creationdate'] = date('Y-m-d H:i:s');
$where = "id = $keyvalue";
$sql = $this->db->update_string('resellers3', $data, $where);
$query = $this->db->query($sql);
}
/**
* @author: Md. Golam Rabbany
* @email: mgrnahid@gmail.com
* @description: Find check Child Reseller of Reseller III
* @copyright 2011
*/
function checkChildReseller3($idReseller)
{
$query = $this->db->query("select *from resellers2 where id_reseller = '$idReseller'");
if($query->num_rows()>0)
{
return 1;
}
else
return 0;
}
/**
* @author: Md. Golam Rabbany
* @email: mgrnahid@gmail.com
* @description: Delete information of Reseller III
* @copyright 2011
*/
function deleteReseller3($idReseller)
{
$sql = "select id_rate from ratename where id_reseller = '$idReseller' AND level = 3";
$queryRateName = $this->db->query($sql);
if($queryRateName->num_rows()>0)
{
$result = $queryRateName->result();
if(is_array($result))
{
foreach($result as $row)
{
$idRate = $row->id_rate;
$sqlDeleteRateChart = "delete from ratechart where id_rate = '$idRate'";
$queryDeleteRate = $this->db->query($sqlDeleteRateChart);
}
}
$query = $this->db->query("delete from ratename where id_reseller = '$idReseller' AND level = 3");
}
$query = $this->db->query("delete from resellerpayment where id_reseller = '$idReseller' AND level = 3");
$query = $this->db->query("delete from resellers3 where id = '$idReseller'");
}
/**
***********************************************************************
* @Start Reseller II Section ******************************************
***********************************************************************
*/
/**
* @author: Md. Golam Rabbany
* @email: mgrnahid@gmail.com
* @description: This function return total number of reseller
* @copyright 2011
*/
function getTotalnumResellerLeve2($login,$password,$full_name,$id_rate,$idReseller,$type, $typeValue)
{
if($login=="NULL")
$loginStr = "";
else
$loginStr = "AND login like '$login%'";
if($password=="NULL")
$passwordStr = "";
else
$passwordStr = "AND password like '$password%'";
if($idReseller=="NULL")
$idResellerStr = "";
else
$idResellerStr = "AND id_reseller = '$idReseller'";
if($full_name=="NULL")
$fullNameStr = "";
else
$fullNameStr = "AND full_name like '$full_name%'";
if($id_rate=="NULL")
$idRateStr = "";
else
$idRateStr = "AND id_rate ='$id_rate'";
if($type == -1)
$typeStr = "";
elseif($type == 0)
$typeStr = "AND balance = '$typeValue'";
elseif($type == 1)
$typeStr = "AND balance > '$typeValue'";
else
$typeStr = "AND balance < '$typeValue'";
$sql="SELECT
count(id) as totalrows
FROM resellers2 Where id != '-1' $loginStr $passwordStr $fullNameStr $idRateStr $idResellerStr $typeStr";
//echo $sql;
$row = 0;
$query = $this->db->query($sql);
foreach($query->result() as $resultrow)
{
$row = $resultrow->totalrows;
}
return $row;
}
/**
* @author: Md. Golam Rabbany
* @email: mgrnahid@gmail.com
* @description: This function return Reseller List
* @copyright 2011
*/
function resellerLevel2List($startoffset,$limit,$login,$password,$full_name,$id_rate,$idReseller, $type, $typeValue)
{
$new_startoffset = $startoffset - 1;
if($new_startoffset <0)
$new_startoffset = 0;
$startoffset1 = $limit * $new_startoffset;
$limit_string = "LIMIT $startoffset1,$limit";
if($login=="NULL")
$loginStr = "";
else
$loginStr = "AND a.login like '$login%'";
if($idReseller=="NULL")
$idResellerStr = "";
else
$idResellerStr = "AND a.id_reseller = '$idReseller'";
if($password=="NULL")
$passwordStr = "";
else
$passwordStr = "AND a.password like '$password%'";
if($full_name=="NULL")
$fullNameStr = "";
else
$fullNameStr = "AND a.full_name like '$full_name%'";
if($id_rate=="NULL")
$idRateStr = "";
else
$idRateStr = "AND a.id_rate ='$id_rate'";
if($type == -1)
$typeStr = "";
elseif($type == 0)
$typeStr = "AND a.balance = '$typeValue'";
elseif($type == 1)
$typeStr = "AND a.balance > '$typeValue'";
else
$typeStr = "AND a.balance < '$typeValue'";
$sql = "SELECT
a.id,
a.login,
a.password,
a.id_reseller,
a.balance,
a.id_rate,
a.limit_user,
a.limit_rate,
a.limit_balance,
a.limit_fnf,
a.aniuser,
a.sipuser,
a.full_name,
a.status
FROM resellers2 a
where a.id !=-1 $loginStr $passwordStr $fullNameStr $idRateStr $idResellerStr $typeStr order by a.login ASC $limit_string";
//echo $sql;
$query = $this->db->query($sql);
if($query->num_rows()>0)
return $query->result();
else
return 0;
}
/**
* @author: Md. Golam Rabbany
* @email: mgrnahid@gmail.com
* @description: This function Add Reseller II
* @copyright 2011
*/
function addReseller2($userID)
{
//$data['id'] = $this->input->post('id');
$idReseller = $this->input->post('id_reseller');
if($idReseller=="")
$idReseller = -1;
$balance = $this->input->post('balance');
if(!is_numeric($balance) OR $balance<0)
$balance = 0;
$commission = $this->input->post('commission');
if(!is_numeric($commission) OR $commission<0)
$commission = 0;
$limit_user = $this->input->post('limit_user');
if(!is_numeric($limit_user) OR $limit_user<0)
$limit_user = 0;
$limit_rate = $this->input->post('limit_rate');
if(!is_numeric($limit_rate) OR $limit_rate<0)
$limit_rate = 0;
$limit_balance = $this->input->post('limit_balance');
if(!is_numeric($limit_balance) OR $limit_balance <= 0)
$limit_balance = $balance;
$data['id_reseller'] = $idReseller;
$data['login'] = $this->input->post('login');
$data['password'] = $this->input->post('password');
$data['balance'] = $balance;
$data['id_rate'] = $this->input->post('id_rate');
$data['limit_user'] = $limit_user;
$data['limit_rate'] = $limit_rate;
$data['limit_balance'] = $limit_balance;
$data['limit_fnf'] = $this->input->post('limit_fnf');
$data['commission'] = $commission;
$data['type'] = $this->input->post('type');
$data['sipuser'] = $this->input->post('sipuser');
$data['aniuser'] = $this->input->post('aniuser');
$data['full_name'] = $this->input->post('full_name');
$data['email'] = $this->input->post('email');
$data['cell'] = $this->input->post('cell');
$data['phone'] = $this->input->post('phone');
$data['city'] = $this->input->post('city');
$data['country'] = $this->input->post('country');
$data['state'] = $this->input->post('state');
$data['address'] = $this->input->post('address');
$data['status'] = $this->input->post('status');
$data['user_id'] = $userID;
$data['usertype'] = ADMIN_TYPE;
$data['ipaddress'] = $this->getRealIpAddr();
$sql = $this->db->insert_string('resellers2', $data);
$query = $this->db->query($sql);
$idInsert = $this->db->insert_id();
if($idInsert)
{
$dataPayment['id_reseller'] = $idInsert;
$dataPayment['level'] = 2;
$dataPayment['amount'] = $data['balance'];
$dataPayment['type'] = PREPAID;
$dataPayment['description'] = 'Initial Balance';
$dataPayment['user_id'] = $userID;
$dataPayment['usertype'] = ADMIN_TYPE;
$dataPayment['ipaddress'] = $this->getRealIpAddr();;
$sqlPayment = $this->db->insert_string('resellerpayment', $dataPayment);
$queryPayment = $this->db->query($sqlPayment);
if($idReseller>0)
{
$sqlUpdate = "UPDATE resellers3 set limit_balance = limit_balance - '$balance' where id='$idReseller'";
$queryUpdate = $this->db->query($sqlUpdate);
}
}
}
/**
* @author: Md. Golam Rabbany
* @email: mgrnahid@gmail.com
* @description: This function Return Edit Infomation of Reseller III
* @copyright 2011
*/
function reseller2EditInfo($id)
{
$query = $this->db->query("select *from resellers2 where id = '$id' LIMIT 1");
if($query->num_rows()>0)
{
return $query->result();
}
else
return 0;
}
/**
* @author: Md. Golam Rabbany
* @email: mgrnahid@gmail.com
* @description: This function Add Reseller III
* @copyright 2011
*/
function editReseller2($userID)
{
$keyvalue = $this->input->post('id');
//$data['login'] = $this->input->post('login');
$idReseller = $this->input->post('id_reseller');
if($idReseller=="")
$idReseller = -1;
$limit_user = $this->input->post('limit_user');
if(!is_numeric($limit_user) OR $limit_user<0)
$limit_user = 0;
$limit_rate = $this->input->post('limit_rate');
if(!is_numeric($limit_rate) OR $limit_rate<0)
$limit_rate = 0;
$limit_balance = $this->input->post('limit_balance');
if(!is_numeric($limit_balance) OR $limit_balance <= 0)
$limit_balance = 0;
$data['password'] = $this->input->post('password');
//$data['balance'] = $this->input->post('balance');
$data['id_reseller'] = $idReseller;
$data['id_rate'] = $this->input->post('id_rate');
$data['limit_user'] = $limit_user;
$data['limit_rate'] = $limit_rate;
$data['limit_balance'] = $limit_balance;
$data['limit_fnf'] = $this->input->post('limit_fnf');
$data['type'] = $this->input->post('type');
$data['sipuser'] = $this->input->post('sipuser');
$data['aniuser'] = $this->input->post('aniuser');
$data['full_name'] = $this->input->post('full_name');
$data['email'] = $this->input->post('email');
$data['cell'] = $this->input->post('cell');
$data['phone'] = $this->input->post('phone');
$data['city'] = $this->input->post('city');
$data['country'] = $this->input->post('country');
$data['state'] = $this->input->post('state');
$data['address'] = $this->input->post('address');
$data['status'] = $this->input->post('status');
$data['user_id'] = $userID;
$data['usertype'] = ADMIN_TYPE;
$data['ipaddress'] = $this->getRealIpAddr();
$where = "id = $keyvalue";
$sql = $this->db->update_string('resellers2', $data, $where);
$query = $this->db->query($sql);
}
/**
* @author: Md. Golam Rabbany
* @email: mgrnahid@gmail.com
* @description: Find check Child Reseller of Reseller II
* @copyright 2011
*/
function checkChildReseller2($idReseller)
{
$query = $this->db->query("select *from resellers1 where id_reseller = '$idReseller'");
if($query->num_rows()>0)
{
return 1;
}
else
return 0;
}
/**
* @author: Md. Golam Rabbany
* @email: mgrnahid@gmail.com
* @description: Delete information of Reseller II
* @copyright 2011
*/
function deleteReseller2($idReseller)
{
$sql = "select id_rate from ratename where id_reseller = '$idReseller' AND level = 2";
$queryRateName = $this->db->query($sql);
if($queryRateName->num_rows()>0)
{
$result = $queryRateName->result();
if(is_array($result))
{
foreach($result as $row)
{
$idRate = $row->id_rate;
$sqlDeleteRateChart = "delete from ratechart where id_rate = '$idRate'";
$queryDeleteRate = $this->db->query($sqlDeleteRateChart);
}
}
$query = $this->db->query("delete from ratename where id_reseller = '$idReseller' AND level = 2");
}
$query = $this->db->query("delete from resellerpayment where id_reseller = '$idReseller' AND level =2");
$query = $this->db->query("delete from resellers2 where id = '$idReseller'");
}
/**
***********************************************************************
* @Start Reseller I Section *******************************************
***********************************************************************
*/
/**
* @author: Md. Golam Rabbany
* @email: mgrnahid@gmail.com
* @description: This function return total number of reseller
* @copyright 2011
*/
function getTotalnumResellerLeve1($login,$password,$full_name,$id_rate,$idReseller,$type,$typeValue)
{
if($login=="NULL")
$loginStr = "";
else
$loginStr = "AND login like '$login%'";
if($password=="NULL")
$passwordStr = "";
else
$passwordStr = "AND password like '$password%'";
if($idReseller=="NULL")
$idResellerStr = "";
else
$idResellerStr = "AND id_reseller = '$idReseller'";
if($full_name=="NULL")
$fullNameStr = "";
else
$fullNameStr = "AND full_name like '$full_name%'";
if($id_rate=="NULL")
$idRateStr = "";
else
$idRateStr = "AND id_rate ='$id_rate'";
if($type == -1)
$typeStr = "";
elseif($type == 0)
$typeStr = "AND balance = '$typeValue'";
elseif($type == 1)
$typeStr = "AND balance > '$typeValue'";
else
$typeStr = "AND balance < '$typeValue'";
$sql="SELECT
count(id) as totalrows
FROM resellers1 Where id != '-1' $loginStr $passwordStr $fullNameStr $idRateStr $idResellerStr $typeStr";
//echo $sql;
$row = 0;
$query = $this->db->query($sql);
foreach($query->result() as $resultrow)
{
$row = $resultrow->totalrows;
}
return $row;
}
/**
* @author: Md. Golam Rabbany
* @email: mgrnahid@gmail.com
* @description: This function return Reseller List
* @copyright 2011
*/
function resellerLevel1List($startoffset,$limit,$login,$password,$full_name,$id_rate,$idReseller,$type,$typeValue)
{
$new_startoffset = $startoffset - 1;
if($new_startoffset <0)
$new_startoffset = 0;
$startoffset1 = $limit * $new_startoffset;
$limit_string = "LIMIT $startoffset1,$limit";
if($login=="NULL")
$loginStr = "";
else
$loginStr = "AND a.login like '$login%'";
if($idReseller=="NULL")
$idResellerStr = "";
else
$idResellerStr = "AND a.id_reseller = '$idReseller'";
if($password=="NULL")
$passwordStr = "";
else
$passwordStr = "AND a.password like '$password%'";
if($full_name=="NULL")
$fullNameStr = "";
else
$fullNameStr = "AND a.full_name like '$full_name%'";
if($id_rate=="NULL")
$idRateStr = "";
else
$idRateStr = "AND a.id_rate ='$id_rate'";
if($type == -1)
$typeStr = "";
elseif($type == 0)
$typeStr = "AND a.balance = '$typeValue'";
elseif($type == 1)
$typeStr = "AND a.balance > '$typeValue'";
else
$typeStr = "AND a.balance < '$typeValue'";
$sql = "SELECT
a.id,
a.login,
a.password,
a.id_reseller,
a.balance,
a.id_rate,
a.limit_user,
a.limit_rate,
a.limit_balance,
a.limit_fnf,
a.commission,
a.aniuser,
a.sipuser,
a.full_name,
a.status
FROM resellers1 a
where a.id !=-1 $loginStr $passwordStr $fullNameStr $idRateStr $idResellerStr $typeStr order by a.login ASC $limit_string";
//echo $sql;
$query = $this->db->query($sql);
if($query->num_rows()>0)
return $query->result();
else
return 0;
}
/**
* @author: Md. Golam Rabbany
* @email: mgrnahid@gmail.com
* @description: This function Add Reseller I
* @copyright 2011
*/
function addReseller1($userID)
{
//$data['id'] = $this->input->post('id');
$idReseller = $this->input->post('id_reseller');
if($idReseller=="")
$idReseller = -1;
$balance = $this->input->post('balance');
if(!is_numeric($balance) OR $balance<0)
$balance = 0;
$commission = $this->input->post('commission');
if(!is_numeric($commission) OR $commission<0)
$commission = 0;
$limit_user = $this->input->post('limit_user');
if(!is_numeric($limit_user) OR $limit_user<0)
$limit_user = 0;
$limit_rate = $this->input->post('limit_rate');
if(!is_numeric($limit_rate) OR $limit_rate<0)
$limit_rate = 0;
$limit_balance = $this->input->post('limit_balance');
if(!is_numeric($limit_balance) OR $limit_balance <= 0)
$limit_balance = $balance;
$data['id_reseller'] = $idReseller;
$data['login'] = $this->input->post('login');
$data['password'] = $this->input->post('password');
$data['balance'] = $balance;
$data['id_rate'] = $this->input->post('id_rate');
$data['limit_user'] = $limit_user;
$data['limit_rate'] = $limit_rate;
$data['limit_balance'] = $limit_balance;
$data['limit_fnf'] = $this->input->post('limit_fnf');
$data['commission'] = $this->input->post('commission');
$data['type'] = $this->input->post('type');
$data['sipuser'] = $this->input->post('sipuser');
$data['aniuser'] = $this->input->post('aniuser');
$data['full_name'] = $this->input->post('full_name');
$data['email'] = $this->input->post('email');
$data['cell'] = $this->input->post('cell');
$data['phone'] = $this->input->post('phone');
$data['city'] = $this->input->post('city');
$data['country'] = $this->input->post('country');
$data['state'] = $this->input->post('state');
$data['address'] = $this->input->post('address');
$data['status'] = $this->input->post('status');
$data['user_id'] = $userID;
$data['usertype'] = ADMIN_TYPE;
$data['ipaddress'] = $this->getRealIpAddr();
$sql = $this->db->insert_string('resellers1', $data);
$query = $this->db->query($sql);
$idInsert = $this->db->insert_id();
if($idInsert)
{
$dataPayment['id_reseller'] = $idInsert;
$dataPayment['level'] = 1;
$dataPayment['amount'] = $data['balance'];
$dataPayment['type'] = PREPAID;
$dataPayment['description'] = 'Initial Balance';
$dataPayment['user_id'] = $userID;
$dataPayment['usertype'] = ADMIN_TYPE;
$dataPayment['ipaddress'] = $this->getRealIpAddr();
$sqlPayment = $this->db->insert_string('resellerpayment', $dataPayment);
$queryPayment = $this->db->query($sqlPayment);
if($idReseller>0)
{
$sqlUpdate = "UPDATE resellers2 set limit_balance = limit_balance - '$balance' where id='$idReseller'";
$queryUpdate = $this->db->query($sqlUpdate);
}
}
}
/**
* @author: Md. Golam Rabbany
* @email: mgrnahid@gmail.com
* @description: This function Return Edit Infomation of Reseller III
* @copyright 2011
*/
function reseller1EditInfo($id)
{
$query = $this->db->query("select *from resellers1 where id = '$id' LIMIT 1");
if($query->num_rows()>0)
{
return $query->result();
}
else
return 0;
}
/**
* @author: Md. Golam Rabbany
* @email: mgrnahid@gmail.com
* @description: This function Add Reseller III
* @copyright 2011
*/
function editReseller1($userID)
{
$keyvalue = $this->input->post('id');
//$data['login'] = $this->input->post('login');
$idReseller = $this->input->post('id_reseller');
if($idReseller=="")
$idReseller = -1;
$commission = $this->input->post('commission');
if(!is_numeric($commission) OR $commission<0)
$commission = 0;
$limit_user = $this->input->post('limit_user');
if(!is_numeric($limit_user) OR $limit_user<0)
$limit_user = 0;
$limit_rate = $this->input->post('limit_rate');
if(!is_numeric($limit_rate) OR $limit_rate<0)
$limit_rate = 0;
$limit_balance = $this->input->post('limit_balance');
if(!is_numeric($limit_balance) OR $limit_balance <= 0)
$limit_balance = 0;
$data['id_reseller'] = $idReseller;
$data['password'] = $this->input->post('password');
//$data['balance'] = $this->input->post('balance');
$data['id_rate'] = $this->input->post('id_rate');
$data['limit_user'] = $limit_user;
$data['limit_rate'] = $limit_rate;
$data['limit_balance'] = $limit_balance;
$data['limit_fnf'] = $this->input->post('limit_fnf');
$data['commission'] = $commission;
$data['type'] = $this->input->post('type');
$data['sipuser'] = $this->input->post('sipuser');
$data['aniuser'] = $this->input->post('aniuser');
$data['full_name'] = $this->input->post('full_name');
$data['email'] = $this->input->post('email');
$data['cell'] = $this->input->post('cell');
$data['phone'] = $this->input->post('phone');
$data['city'] = $this->input->post('city');
$data['country'] = $this->input->post('country');
$data['state'] = $this->input->post('state');
$data['address'] = $this->input->post('address');
$data['status'] = $this->input->post('status');
$data['user_id'] = $userID;
$data['usertype'] = ADMIN_TYPE;
$data['ipaddress'] = $this->getRealIpAddr();
$where = "id = $keyvalue";
$sql = $this->db->update_string('resellers1', $data, $where);
$query = $this->db->query($sql);
}
/**
* @author: Md. Golam Rabbany
* @email: mgrnahid@gmail.com
* @description: Find check Child Reseller of Reseller I
* @copyright 2011
*/
function checkChildReseller1SIP($idReseller)
{
$query = $this->db->query("select *from clientssip where id_reseller = '$idReseller'");
if($query->num_rows()>0)
{
return 1;
}
else
return 0;
}
/**
* @author: Md. Golam Rabbany
* @email: mgrnahid@gmail.com
* @description: Find check Child Reseller of Reseller I
* @copyright 2011
*/
function checkChildReseller1PIN($idReseller)
{
$query = $this->db->query("select *from clientspin where id_reseller = '$idReseller'");
if($query->num_rows()>0)
{
return 1;
}
else
return 0;
}
/**
* @author: Md. Golam Rabbany
* @email: mgrnahid@gmail.com
* @description: Find check Child Reseller of Reseller I
* @copyright 2011
*/
function checkChildReseller1IP($idReseller)
{
$query = $this->db->query("select *from clientsip where id_reseller = '$idReseller'");
if($query->num_rows()>0)
{
return 1;
}
else
return 0;
}
/**
* @author: Md. Golam Rabbany
* @email: mgrnahid@gmail.com
* @description: Delete information of Reseller I
* @copyright 2011
*/
function deleteReseller1($idReseller)
{
$sql = "select id_rate from ratename where id_reseller = '$idReseller' AND level = 1";
$queryRateName = $this->db->query($sql);
if($queryRateName->num_rows()>0)
{
$result = $queryRateName->result();
if(is_array($result))
{
foreach($result as $row)
{
$idRate = $row->id_rate;
$sqlDeleteRateChart = "delete from ratechart where id_rate = '$idRate'";
$queryDeleteRate = $this->db->query($sqlDeleteRateChart);
}
}
$query = $this->db->query("delete from ratename where id_reseller = '$idReseller' AND level = 1");
}
$query = $this->db->query("delete from resellerpayment where id_reseller = '$idReseller' AND level =1");
$query = $this->db->query("delete from resellers1 where id = '$idReseller'");
}
}
?>
|