电梯合同管理系统：添加、修改、删除、查询电梯合同信息

/**

添加电梯合同信息
@param array $param
$param['community_id'] 小区id
$param['elevator_contract_number'] 电梯合同编号
$param['elevator_device_number'] 电梯设备编号
$param['maintenance_company_id'] 维保公司
$param['maintenance_service_type'] 维保服务类型
$param['contract_start_date'] 合同起始日期
$param['contract_end_date'] 合同结束日期
$param['month'] 月份
$param['contract_amount'] 合同金额
$param['elevator_number'] 电梯数量
$param['elevator_location'] 电梯位置
$param['remark'] 备注
$param['last_operator_id'] 最后操作者
$param['create_time'] 创建时间
$param['update_time'] 最后操作时间
$param['is_delete'] 是否删除
@return bool / public function add($param) { //小区id $data['community_id'] = $param['community_id']; //电梯合同编号 $data['elevator_contract_number'] = $param['elevator_contract_number']; //电梯设备编号 $data['elevator_device_number'] = $param['elevator_device_number']; //维保公司 $data['maintenance_company_id'] = $param['maintenance_company_id']; //维保服务类型 $data['maintenance_service_type'] = $param['maintenance_service_type']; //合同起始日期 $data['contract_start_date'] = $param['contract_start_date']; //合同结束日期 $data['contract_end_date'] = $param['contract_end_date']; //月份 $data['month'] = $param['month']; //合同金额 $data['contract_amount'] = $param['contract_amount']; //电梯数量 $data['elevator_number'] = $param['elevator_number']; //电梯位置 $data['elevator_location'] = $param['elevator_location']; //备注 $data['remark'] = $param['remark']; //最后操作者 $data['last_operator_id'] = $param['last_operator_id']; //创建时间 $data['create_time'] = $param['create_time']; //最后操作时间 $data['update_time'] = $param['update_time']; //是否删除 $data['is_delete'] = $param['is_delete']; $result = $this->db->insert('con_elevator_contract', $data); if ($result) { return true; } else { return false; } } /*
修改电梯合同信息
@param array $param
$param['contract_id'] 电梯合同id
$param['community_id'] 小区id
$param['elevator_contract_number'] 电梯合同编号
$param['elevator_device_number'] 电梯设备编号
$param['maintenance_company_id'] 维保公司
$param['maintenance_service_type'] 维保服务类型
$param['contract_start_date'] 合同起始日期
$param['contract_end_date'] 合同结束日期
$param['contract_amount'] 合同金额
$param['elevator_number'] 电梯数量
$param['elevator_location'] 电梯位置
$param['remark'] 备注
$param['last_operator_id'] 最后操作者
@return bool / public function update($param) { //小区id $data['community_id'] = $param['community_id']; //电梯合同编号 $data['elevator_contract_number'] = $param['elevator_contract_number']; //电梯设备编号 $data['elevator_device_number'] = $param['elevator_device_number']; //维保公司 $data['maintenance_company_id'] = $param['maintenance_company_id']; //维保服务类型 $data['maintenance_service_type'] = $param['maintenance_service_type']; //合同起始日期 $data['contract_start_date'] = $param['contract_start_date']; //合同结束日期 $data['contract_end_date'] = $param['contract_end_date']; //月份 $data['month'] = $param['month']; //合同金额 $data['contract_amount'] = $param['contract_amount']; //电梯数量 $data['elevator_number'] = $param['elevator_number']; //电梯位置 $data['elevator_location'] = $param['elevator_location']; //备注 $data['remark'] = $param['remark']; //最后操作者 $data['last_operator_id'] = $param['last_operator_id']; //最后操作时间 $data['update_time'] = $param['update_time']; //是否删除 $data['is_delete'] = $param['is_delete']; $where['contract_id'] = $param['contract_id']; $result = $this->db->update('con_elevator_contract', $data, $where); if ($result) { return true; } else { return false; } } /*
删除电梯合同信息
@param array $param
@return bool / public function delete($param) { $where['contract_id'] = $param['contract_id']; $data['is_delete'] = $param['is_delete']; $result = $this->db->update('con_elevator_contract', $data, $where); if ($result) { return true; } else { return false; } } /*
根据id获取电梯合同信息
@param int $id
@return array / public function get_by_id($id) { $sql = "SELECT * FROM con_elevator_contract WHERE contract_id=$id"; $query = $this->db->query($sql); return $query->row_array(); } /*
获取电梯合同列表
@param array $param
@param int $page
@param int $page_size
@return array / public function get_list($param, $page, $page_size) { $where = ' WHERE 1=1 '; if (isset($param['community_id']) && $param['community_id'] != '') { $where .= " AND community_id={$param['community_id']}"; } if (isset($param['keyword']) && $param['keyword'] != '') { $where .= " AND (elevator_contract_number like '%{$param['keyword']}%' OR elevator_device_number like '%{$param['keyword']}%')"; } $sql = "SELECT * FROM con_elevator_contract $where ORDER BY contract_id DESC limit " . ($page - 1) * $page_size . ",$page_size"; $query = $this->db->query($sql); return $query->result_array(); } /*