﻿﻿﻿<?php
class office{
 
    // database connection and table name
    private $conn;
    private $table_name = "acts_branch";
	
	// object properties
    public $brch_name;
    public $brch_city;
    public $brch_add;
    public $brch_code;
  
    
    // constructor with $db as database connection
    public function __construct($db){
        $this->conn = $db;
    }
				
	/******************************************************************************/
	
	// create Office
	
	function off_create(){
	 
		// query to insert record
		$query = "INSERT INTO " . $this->table_name . " SET brch_name=:brch_name, brch_city=:brch_city, brch_add=:brch_add, brch_code=:brch_code";
		
		//echo $query;
	 
		// prepare query
		$stmt = $this->conn->prepare($query);
	 
		// sanitize
		$this->brch_name=htmlspecialchars(strip_tags($this->brch_name));
		$this->brch_city=htmlspecialchars(strip_tags($this->brch_city));
		$this->brch_add=htmlspecialchars(strip_tags($this->brch_add));
		$this->brch_code=htmlspecialchars(strip_tags($this->brch_code));
			 
		// bind values
		$stmt->bindParam(":brch_name", $this->brch_name);
		$stmt->bindParam(":brch_city", $this->brch_city);		
		$stmt->bindParam(":brch_add", $this->brch_add);
		$stmt->bindParam(":brch_code", $this->brch_code);
	 
		// execute query
		if($stmt->execute()){
			return true;
		}
	 
		return false;		 
	}
	
	/******************************************************************************/
	
	function off_read(){
					
		// set ID property of record to read		
		$query = "SELECT brch_id,brch_name,brch_city FROM " . $this->table_name . " ORDER BY brch_id";
				 
		// prepare query statement
		$stmt = $this->conn->prepare($query);
		
		//$stmt->bindParam(":ts_empid", $this->ts_empid);
				 
		// execute query
		$stmt->execute();
 
    return $stmt;
		
	}	
	
	/******************************************************************************/
	
	function off_list_read(){
					
		// set ID property of record to read		
		$query = "SELECT brch_id,brch_name FROM " . $this->table_name . " ORDER BY brch_id";
				 
		// prepare query statement
		$stmt = $this->conn->prepare($query);
		
		//$stmt->bindParam(":ts_empid", $this->ts_empid);
				 
		// execute query
		$stmt->execute();
 
    return $stmt;
		
	}	
	/******************************************************************************/
	
	function off_delete(){
						 
		$query = "select count(*) from acts_emp WHERE empbranchcode=:ts_oid";
					
		// prepare query statement
		$stmt = $this->conn->prepare($query);
		$stmt->bindParam(":ts_oid", $this->ts_oid);
				
		$stmt->execute();
		$count = $stmt->fetchColumn();
						
		if($count<=0){
					
		// Delete record
		$query = "DELETE FROM " . $this->table_name . " WHERE brch_id=:ts_oid" ;
		
		// prepare query statement
		$stmt = $this->conn->prepare($query);
		$stmt->bindParam(":ts_oid", $this->ts_oid);
						 
		// execute query
		$stmt->execute();
		
		}
    
	return $count;
		
	}
	
}

?>