class user pegawai

class user pegawai

<?php

class UserPegawai extends User {

	public function get_toko_bunga()
	{
		$q = "SELECT
				a.id_tokobunga,
				b.nama,
				b.alamat,
				b.email,
				b.website,
				b.telp,
				b.logo,
				b.kota,
				b.longitude,
				b.latitude,
				b.id_user AS id_pemilik,
				a.id_user,
				c.nama AS nama_pemilik,
				c.email AS email_pemilik,
				c.foto AS foto_pemilik
				FROM
				tb_user_toko AS a
				INNER JOIN tb_tokobunga AS b ON b.id_tokobunga = a.id_tokobunga
				INNER JOIN tb_user AS c ON b.id_user = c.id_user
				WHERE a.id_user = '{$this->id_user}'";
		$r = mysql_query($q);

		$result_array = array();
		while($row = mysql_fetch_array($r))
		{
			$toko = new TokoBunga();

			foreach ($row as $key => $value) {
				$toko->{$key} = $value;
			}

			array_push($result_array, $toko);
		}
		return $result_array;
	}

	public static function insert()
	{
		$nama = $_POST[nama];
		$username = $_POST[username];
		$password = $_POST[password];
		print_r($_POST);

		$q = "INSERT INTO tb_user (nama, username, password)
				VALUES('$nama', '$username', '$password')";
		$r = mysql_query($q);

		$id = mysql_insert_id();
		$query = "INSERT INTO tb_user_toko (id_user, id_tokobunga)
					VALUES('$id', '". TokoBunga::get_session() ."')";
		$r = mysql_query($query);
		return $r;

	}

	public static function get_all_user()
	{
		$q = "SELECT DISTINCT
				a.id_user,
				a.nama,
				a.alamat,
				a.kota,
				a.telp,
				a.no_ktp_sim,
				a.email,
				a.tempat_lahir,
				a.tgl_lahir,
				a.username,
				a. PASSWORD,
				a.jenis_kelamin,
				a.foto,
				b.id_tokobunga
			FROM
				tb_user AS a
			LEFT JOIN tb_user_toko AS b ON a.id_user = b.id_user
			WHERE
				a.id_user <> '".User::get_session()."'
			GROUP BY
			a.id_user";
		$r = mysql_query($q);

		$result_array = array();
		while($row = mysql_fetch_assoc($r)){
			$user = new UserPegawai();

			if($row['id_tokobunga'] != TokoBunga::get_session())
			{
				foreach ($row as $key => $value) {
					$user->{$key} = $value;
				}
				array_push($result_array, $user);
			}
		}
		return $result_array;
	}

	public function foto()
	{
		if(file_exists($this->foto)) {
			return "<img src='". $this->foto ."' class='img img-circle' width='75px'>";
		}else{
			return "<img src='assets/images/gallery/user/avatar5.png' class='img img-circle' width='75px'>";
		}
	}

	public static function is_owner()
	{
		$q = "SELECT id_user FROM tb_tokobunga WHERE id_tokobunga = '". TokoBunga::get_session() ."'";
		$r = mysql_query($q);
		$r = mysql_fetch_array($r);

		if($r[0] == User::get_session()) {
			return true;
		}else{
			return false;
		}
	}

	public static function cek_hak($id_kegiatan) {
		$q = "SELECT * FROM user_kegiatan 
				WHERE id_tokobunga = '". TokoBunga::get_session() ."' 
				AND id_user = '". User::get_session() ."' 
				AND id_kegiatan = '".$id_kegiatan."'";
		$r = mysql_query($q);
		$num_rows = mysql_num_rows($r);

		if($num_rows > 0) {
			return true;
		}else{
			return false;
		}
	}

}

?>