function delete()
{
$db = new Database();
$sql = sprintf("delete from laminates where id = %d", $this->id);
$db->executeSQL($sql, __FILE__, __LINE__, false);
$db->close();
}
function save()
{
$db = new Database();
$sql = sprintf("update siteconfig set config_value = '%s' where config_keyword = '%s'", $this->config_value, $this->config_keyword);
$db->executeSQL($sql, __FILE__, __LINE__, false);
$db->close();
}
function save() {
$db = new Database();
if ($this->id > 0) {
$sql = sprintf("insert into audit_log (id, user_id, trans_date, order_id, table_name, field_name, old_value, new_value) " .
"values (%d, %d, '%s', %d, '%s', '%s', '%s', '%s') " .
"on duplicate key update user_id = %d, trans_date = '%s', order_id = %d, table_name = '%s', field_name = '%s', " .
"old_value = '%s', new_value = '%s'",
$this->id,
$this->user_id,
date("Y-m-d H:i:s"),
$this->order_id,
mysql_real_escape_string(strip_tags($this->table_name)),
mysql_real_escape_string(strip_tags($this->field_name)),
mysql_real_escape_string(strip_tags($this->old_value)),
mysql_real_escape_string(strip_tags($this->new_value)),
$this->user_id,
date("Y-m-d H:i:s"),
$this->order_id,
mysql_real_escape_string(strip_tags($this->table_name)),
mysql_real_escape_string(strip_tags($this->field_name)),
mysql_real_escape_string(strip_tags($this->old_value)),
mysql_real_escape_string(strip_tags($this->new_value)));
} else {
$sql = sprintf("insert into audit_log (user_id, trans_date, order_id, table_name, field_name, old_value, new_value) " .
"values (%d, '%s', %d, '%s', '%s', '%s', '%s')",
$this->user_id,
date("Y-m-d H:i:s"),
$this->order_id,
mysql_real_escape_string(strip_tags($this->table_name)),
mysql_real_escape_string(strip_tags($this->field_name)),
mysql_real_escape_string(strip_tags($this->old_value)),
mysql_real_escape_string(strip_tags($this->new_value)));
}
$db->executeSQL($sql, __FILE__, __LINE__, false);
$this->id = $db->last_id;
}
function save()
{
$db = new Database();
if ($this->id > 0) {
$sql = sprintf("insert into schedule (id, order_id, pickup_date, pickup_asap, earliest_time, latest_time, call_flag," .
"phone_number, status) " .
"values (%d, %d, '%s', %d, '%s', '%s', %d, '%s', %d) " .
"on duplicate key update order_id = %d, pickup_date = '%s', pickup_asap = %d, earliest_time = '%s'," .
"latest_time = '%s', call_flag = %d, phone_number = '%s', status = %d",
intval($this->id),
intval($this->order_id),
date("Y-m-d", strtotime($this->pickup_date)),
($this->pickup_asap ? 1 : 0),
date("H:i:s", strtotime($this->earliest_time)),
date("H:i:s", strtotime($this->latest_time)),
($this->call_flag ? 1 : 0),
$this->phonef,
intval($this->status),
intval($this->order_id),
date("Y-m-d", strtotime($this->pickup_date)),
($this->pickup_asap ? 1 : 0),
date("H:i:s", strtotime($this->earliest_time)),
date("H:i:s", strtotime($this->latest_time)),
($this->call_flag ? 1 : 0),
$this->phonef,
intval($this->status));
} else {
$sql = sprintf("insert into schedule (order_id, pickup_date, pickup_asap, earliest_time, latest_time, call_flag," .
"phone_number, status) " .
"values (%d, '%s', %d, '%s', '%s', %d, '%s', %d)",
intval($this->order_id),
date("Y-m-d", strtotime($this->pickup_date)),
($this->pickup_asap ? 1 : 0),
date("H:i:s", strtotime($this->earliest_time)),
date("H:i:s", strtotime($this->latest_time)),
($this->call_flag ? 1 : 0),
$this->phonef,
intval($this->status));
}
$db->executeSQL($sql, __FILE__, __LINE__, false);
$db->close();
}
function add_user($user_id)
{
//$this->users = array();
$db = new Database();
$sql = sprintf("insert into company_members (company_id, user_id) values (%d, %d)", $this->id, $user_id);
$db->executeSQL($sql);
$db->close();
}
function delete()
{
$db = new Database();
$sql = sprintf("delete from users where id = %d", $this->id);
$db->executeSQL($sql, __FILE__, __LINE__, false);
$sql = sprintf("delete from company_members where user_id = %d", $this->id);
$db->executeSQL($sql, __FILE__, __LINE__, false);
$db->close();
}
