home/abhiramc/public_html/acts.service/objects/office.php 0000644 00000006013 15021217671 0017534 0 ustar 00 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;
}
}
?>