Untitled

<?php
  /**
   * @author Matt Reid
   * @copyright Copyright (c) 2009 Matt Reid
   */

if (!defined('BASEPATH')) exit('No direct script access allowed');

class Model_main extends Model
{

  function __construct()
  {
    $this->Model_main();
  }

  function Model_main()
  {
    parent::Model();
  }

  function delete_data($id) {
    log_message('debug', "model_main: delete_data called");
    log_message('debug', "model_main: id: $id");
    $id = $this->db->escape_str($id);

    $dbr = $this->load->database('default', TRUE);
    $sql0="DELETE from `data` WHERE id = '$id' LIMIT 1;";
    log_message('debug', "$sql0");

    $this->db->trans_start();
    $this->db->query($sql0);
    $this->db->trans_complete();
    if ($this->db->trans_status() === FALSE) {
      log_message('debug', "model_main delete_data transaction failed");
      $this->db->trans_off();
      return 1;
    }
    else {
      log_message('debug', "model_main delete_data transaction success");
      $this->db->trans_off();
      return 0;
    }
  }


  function update_data(
                       $id,
                       $field,
                       $value) {

    log_message('debug', "model_main: update_data called");
    log_message('debug', "model_main: id: $id, field: $field, value: $value");
    $id = $this->db->escape_str($id);
    $field = $this->db->escape_str($field);
    $value = $this->db->escape_str($value);

    $dbr = $this->load->database('default', TRUE);
    $sql0="UPDATE `monarch_data`.`data` SET $field = '$value' where id = '$id'";
    log_message('debug', "$sql0");

    $this->db->trans_start();
    $this->db->query($sql0);
    $this->db->trans_complete();
    if ($this->db->trans_status() === FALSE) {
      log_message('debug', "model_main updated_data transaction failed");
      $this->db->trans_off();
      return 1;
    }
    else {
      log_message('debug', "model_main updated_data transaction success");
      $this->db->trans_off();
      return 0;
    }
  }

  function add_data() {
    $dbr = $this->load->database('default', TRUE);
    $sql0="INSERT INTO `monarch_data`.`data` (
`id` ,
`data_observer_id` ,
`data_quantity` ,
`data_latitude` ,
`data_longitude` ,
`data_reference_city` ,
`data_reference_county` ,
`data_reference_state` ,
`data_reference_description` ,
`data_creation_date`
)
VALUES (
NULL,
'',
'',
'',
'',
'',
'',
'',
'',
NOW());";

    $this->db->trans_start();
    $this->db->query($sql0);
    $this->db->trans_complete();
    if ($this->db->trans_status() === FALSE) {
      show_error('Could not add new row. Transaction failed.');
      $this->db->trans_off();
      return 1;
    }
    else {
      $this->db->trans_off();
      return 0;
    }
  }

  function get_data() {
    $dbr = $this->load->database('default', TRUE);
    $sql = "select * from data order by id,data_observer_id";
    $query = $dbr->query($sql);
    if($query->num_rows() > 0) {
      return $query->result_array();
    }
  }
}
?>