PHP Decode

?><?php
	include('../connect.php');
	include("../php/iceredsoft.php");
	if(1==2){

	}
	else if($_POST['what']=="find_date_today"){
		$q="SELECT LEFT( NOW( ) , 10 )'today'";
		$result=mysql_query($q);
				$r=mysql_fetch_array($result);
					echo $r['today'];
	}
	else if($_POST['what']=="find_user"){
		$q="SELECT u_username,u_firstname,u_lastname,t_name FROM tb_user LEFT JOIN tb_title ON u_title=t_id";
		echo encode_json($q);
	}
	else if($_POST['what']=="find_bill_date"){
		$date=$_POST['date'];
		$date_start=$date." 00:00:00";
		$date_end=$date." 23:59:59";
		$check=$_POST['check'];
		$user=$_POST['user'];
		if($check=="all"){
			$q="SELECT sum(pl_qty) 'qty',sum(pl_price*pl_qty)'price',sum(pl_discount*pl_qty)'discount',sum(pl_price*pl_qty-pl_discount*pl_qty)'total',m_firstname,m_lastname,t_name,m_id,b_id,b_date,sum(bl_cost*pl_qty)'cost'
			FROM tb_bill
			INNER JOIN tb_bill_list
			ON b_id=bl_bill_id
			LEFT JOIN tb_member
			ON b_member=m_id
			LEFT JOIN tb_title
			ON m_title=t_id
			WHERE b_date BETWEEN '$date_start' and '$date_end'
			GROUP BY b_id
			ORDER BY b_date DESC";
		}
		else{
			$q="SELECT sum(pl_qty) 'qty',sum(pl_price*pl_qty)'price',sum(pl_discount*pl_qty)'discount',sum(pl_price*pl_qty-pl_discount*pl_qty)'total',m_firstname,m_lastname,t_name,m_id,b_id,b_date,sum(bl_cost*pl_qty)'cost'
			FROM tb_bill
			INNER JOIN tb_bill_list
			ON b_id=bl_bill_id
			LEFT JOIN tb_member
			ON b_member=m_id
			LEFT JOIN tb_title
			ON m_title=t_id
			WHERE b_username='$user'
			and ( b_date BETWEEN '$date_start' and '$date_end')
			GROUP BY b_id
			ORDER BY b_date DESC";
		}
		
		echo encode_json($q);
	}
	else if($_POST['what']=="find_detail"){
		$id_bill=$_POST['id_bill'];
		$q="SELECT p_name,pl_price,pl_discount,pl_qty,pl_price-bl_cost-pl_discount'margin',b_get_money FROM tb_bill INNER JOIN  tb_bill_list ON  b_id=bl_bill_id  INNER JOIN tb_product ON bl_product_barcode = p_barcode WHERE  bl_bill_id ='$id_bill'";
		echo encode_json($q);
	}
	else if($_POST['what']=="find_bill_month"){
		$date=$_POST['date'];
		$date_start=$date."01"." 00:00:00";
		$date_end=$date."31"." 23:59:59";
		$check=$_POST['check'];
		$user=$_POST['user'];
		if($check=="all"){
			$q="SELECT sum(pl_qty) 'qty',sum(pl_price*pl_qty)'price',sum(pl_discount*pl_qty)'discount',sum(pl_price*pl_qty-pl_discount*pl_qty)'total',m_firstname,m_lastname,t_name,m_id,b_id,b_date,sum(bl_cost*pl_qty)'cost'
			FROM tb_bill
			INNER JOIN tb_bill_list
			ON b_id=bl_bill_id
			LEFT JOIN tb_member
			ON b_member=m_id
			LEFT JOIN tb_title
			ON m_title=t_id
			WHERE b_date BETWEEN '$date_start' and '$date_end'
			GROUP BY b_id
			ORDER BY b_date DESC";
			
		}
		else{
			$q="SELECT sum(pl_qty) 'qty',sum(pl_price*pl_qty)'price',sum(pl_discount*pl_qty)'discount',sum(pl_price*pl_qty-pl_discount*pl_qty)'total',m_firstname,m_lastname,t_name,m_id,b_id,b_date,sum(bl_cost*pl_qty)'cost'
			FROM tb_bill
			INNER JOIN tb_bill_list
			ON b_id=bl_bill_id
			LEFT JOIN tb_member
			ON b_member=m_id
			LEFT JOIN tb_title
			ON m_title=t_id
			WHERE b_username='$user'
			and ( b_date BETWEEN '$date_start' and '$date_end')
			GROUP BY b_id
			ORDER BY b_date DESC";
		}
		
		echo encode_json($q);
	}
	else if($_POST['what']=="find_bill_year"){
		$date=$_POST['date'];
		$date_start=$date."01-01"." 00:00:00";
		$date_end=$date."12-31"." 23:59:59";
		$check=$_POST['check'];
		$user=$_POST['user'];
		if($check=="all"){
			$q="SELECT sum(pl_qty) 'qty',sum(pl_price*pl_qty)'price',sum(pl_discount*pl_qty)'discount',sum(pl_price*pl_qty-pl_discount*pl_qty)'total',m_firstname,m_lastname,t_name,m_id,b_id,b_date,sum(bl_cost*pl_qty)'cost'
			FROM tb_bill
			INNER JOIN tb_bill_list
			ON b_id=bl_bill_id
			LEFT JOIN tb_member
			ON b_member=m_id
			LEFT JOIN tb_title
			ON m_title=t_id
			WHERE b_date BETWEEN '$date_start' and '$date_end'
			GROUP BY b_id
			ORDER BY b_date DESC";
			
		}
		else{
			$q="SELECT sum(pl_qty) 'qty',sum(pl_price*pl_qty)'price',sum(pl_discount*pl_qty)'discount',sum(pl_price*pl_qty-pl_discount*pl_qty)'total',m_firstname,m_lastname,t_name,m_id,b_id,b_date,sum(bl_cost*pl_qty)'cost'
			FROM tb_bill
			INNER JOIN tb_bill_list
			ON b_id=bl_bill_id
			LEFT JOIN tb_member
			ON b_member=m_id
			LEFT JOIN tb_title
			ON m_title=t_id
			WHERE b_username='$user'
			and ( b_date BETWEEN '$date_start' and '$date_end')
			GROUP BY b_id
			ORDER BY b_date DESC";
		}
		
		echo encode_json($q);
	}
?>