public function search_ar()
{
$this->load->model('accounts_receivable_model');
$ar = $this->input->post('ar');
$data = $this->accounts_receivable_model->search_ar($ar['ar_customer']);
$data_total = $this->accounts_receivable_model->search_ar_tot($ar['ar_customer']);
// print_r($this->db->last_query());
$html = "";
$err = validates(array($ar), array());
if ($err < 1) {
echo jcode(array('success' => 3, 'err' => $err));
} else {
if (!$data->num_rows()) {
echo jcode(array('success' => 2));
} else {
foreach ($data->result() as $key) {
$html .= "\n\t\t\t\t\t<tr>\n\t\t\t\t\t\t<td>" . $key->sj_si_no . "</td>\n\t\t\t\t\t\t<td>" . $key->sj_si_date . "</td>\n\t\t\t\t\t\t<td>" . $key->sj_particulars . "</td>\n\t\t\t\t\t\t<td style='text-align:right;'>" . number_format($key->total_debit, 2) . "</td>\n\t\t\t\t\t\t<td style='text-align:right;'>" . number_format($key->total_credit, 2) . "</td>\n\t\t\t\t\t\t<td><a href='#' data-id='" . $key->sj_id . "' class='btn-style-1 animate-4 pull-right ar-report-print'><i class='fa fa-print'></i></a></td>\n\t\t\t\t\t\t<td><a href='#' data-id='" . $key->sj_id . "' class='btn-style-1 animate-4 pull-left ar-report-edit'><i class='fa fa-edit'></i></a></td>\n\t\t\t\t\t</tr>\n\t\t\t\t\t";
}
foreach ($data_total->result() as $key) {
$html .= "\n\t\t\t\t\t<tr>\n\t\t\t\t\t\t<td></td>\n\t\t\t\t\t\t<td></td>\n\t\t\t\t\t\t<td></td>\n\t\t\t\t\t\t<td style='text-align:right;'>" . number_format($key->tot_debit, 2) . "</td>\n\t\t\t\t\t\t<td style='text-align:right;'>" . number_format($key->tot_credit, 2) . "</td>\n\t\t\t\t\t</tr>\n\t\t\t\t\t";
}
echo jcode(array('success' => 1, 'response' => $html));
}
}
}
public function search_records()
{
$this->load->model('audit_trail_model');
$a_search = $this->input->post('searchAudit');
$date_frm = $a_search['searchAudit_dateFRM'];
$date_to = $a_search['searchAudit_dateTO'];
$date_frm_format = date_format(new DateTime($date_frm), "Y/m/d");
$date_to_format = date_format(new DateTime($date_to), "Y/m/d");
$data = $this->audit_trail_model->search($a_search['searchAudit_user'], $date_frm_format, $date_to_format);
$html = "";
$err = validates(array($a_search), array());
if ($err < 1) {
echo jcode(array('success' => 3, 'err' => $err));
} else {
if (!$data->num_rows()) {
echo jcode(array('success' => 2));
} else {
foreach ($data->result() as $key) {
$html .= "\n\t\t\t\t\t<tr>\n\t\t\t\t\t\t<td class=''>" . $key->full_name . "</td>\n\t\t\t\t\t\t<td class=''>" . $key->user_type . "</td>\n\t\t\t\t\t\t<td class=''>" . $key->a_action . "</td>\n\t\t\t\t\t\t<td class=''>" . $key->a_date . "</td>\n\t\t\t\t\t</tr>\n\t\t\t\t\t";
}
auditrecord("Searched Records in Audit Trail.");
echo jcode(array('success' => 1, 'response' => $html));
}
}
}
public function search_cr()
{
$this->load->model('journal_cr_model');
$account_search = $this->input->post('searchCR');
$data = $this->journal_cr_model->journal_cr_get($account_search['searchCR_orNo'], $account_search['searchCR_date_frm'], $account_search['searchCR_date_to']);
$data_total = $this->journal_cr_model->journal_cr_get_total($account_search['searchCR_orNo'], $account_search['searchCR_date_frm'], $account_search['searchCR_date_to']);
$html = "";
$err = validates(array($account_search), array());
if ($err < 1) {
echo jcode(array('success' => 3, 'err' => $err));
} else {
if (!$data->num_rows()) {
echo jcode(array('success' => 2));
} else {
foreach ($data->result() as $key) {
$html .= "\n\t\t\t\t\t<tr>\n\t\t\t\t\t\t<td class='col-md-1'>" . $key->cr_or_no . "</td>\n\t\t\t\t\t\t<td class='col-md-1'>" . $key->cr_or_date . "</td>\n\t\t\t\t\t\t<td class='col-md-3'>" . $key->cr_master_name_customer . "</td>\n\t\t\t\t\t\t<td class='col-md-3'>" . $key->cr_particulars . "</td>\n\t\t\t\t\t\t<td class='col-md-1'>" . number_format($key->cr_or_amount, 2) . "</td>\n\t\t\t\t\t\t<td class='col-md-1'><a href='#' data-id='{$key->cr_id}' data-cr='{$key->cr_or_no}' class='btn-style-1 account-report-print animate-4 pull-right'><i class='fa fa-print'></i></a></td>\n\t\t\t\t\t\t<td class='col-md-1'><a href='#' data-id='{$key->cr_id}' class='btn-style-1 animate-4 pull-left account-report-edit'><i class='fa fa-edit'></i></a></td>\n\t\t\t\t\t</tr>\n\t\t\t\t\t";
}
foreach ($data_total->result() as $key) {
$html .= "\n\t\t\t\t\t<tr>\n\t\t\t\t\t\t<td class='col-md-1'>TOTAL</td>\n\t\t\t\t\t\t<td class='col-md-1'></td>\n\t\t\t\t\t\t<td class='col-md-3'></td>\n\t\t\t\t\t\t<td class='col-md-3'></td>\n\t\t\t\t\t\t<td class='col-md-1'>" . number_format($key->tot_amt, 2) . "</td>\n\t\t\t\t\t</tr>\n\t\t\t\t\t";
}
auditrecord("Searched Records in Cash Receipts.");
echo jcode(array('success' => 1, 'response' => $html));
}
}
}
public function search_bank()
{
$this->load->model("bank_recon_model");
$account_search = $this->input->post('searchBank');
$data = $this->bank_recon_model->bank_recon_get($account_search['searchBank_name']);
// print_r($this->db->last_query());
$html = "";
$err = validates(array($account_search), array());
if (count($err)) {
if ($err < 1) {
echo jcode(array('success' => 3, 'err' => $err));
} else {
echo jcode(array('success' => 2));
}
} else {
if (!$data->num_rows()) {
echo jcode(array('success' => 2));
} else {
foreach ($data->result() as $key) {
$html .= "\n\t\t\t\t\t<tr>\n\t\t\t\t\t\t<td><input type='checkbox'></td>\n\t\t\t\t\t\t<td>" . $key->bank_name . "</td>\n\t\t\t\t\t\t<td>" . $key->bank_month . "</td>\n\t\t\t\t\t\t<td>" . $key->bank_year . "</td>\n\t\t\t\t\t\t<td>" . $key->bank_balance . "</td>\n\t\t\t\t\t</tr>\n\t\t\t\t\t";
}
echo jcode(array('success' => 1, 'response' => $html));
}
}
}
public function update_user_access()
{
$this->load->model("user_access_model");
$user_access_data = $this->input->post('user');
$err = validates(array($user_access_data), array());
if (count($err)) {
echo jcode(array('success' => 3, 'err' => $err));
} else {
$this->user_access_model->update_user($user_access_data['utype'], $user_access_data['fname'], $user_access_data['lname'], $user_access_data['uname'], $user_access_data['pass'], $user_access_data['user_id'], $user_access_data['tab_transaction'], $user_access_data['tab_ledger'], $user_access_data['tab_report'], $user_access_data['tab_admin'], $user_access_data['tab_setup']);
auditrecord("Updated User Access for User " . $user_access_data['fname'] . "");
echo jcode(array('success' => 1));
}
}
public function save_copyrights()
{
$this->load->model("system_settings_model");
$copyrights_data = $this->input->post('copyrights');
if ($this->system_settings_model->copyrights_exist()) {
} else {
$validation = array($copyrights_data);
$exemption = array();
$err = validates($validation, $exemption);
}
if (count($err)) {
echo jcode(array('success' => 3, 'err' => $err));
} else {
$this->system_settings_model->copyrights_add($copyrights_data);
echo jcode(array('success' => 1));
}
}
public function save_user_access()
{
$this->load->model("user_access_model");
$user_access_data = $this->input->post('ua');
$err = validates(array($user_access_data), array());
if (count($err)) {
echo jcode(array('success' => 3, 'err' => $err));
} else {
$fname = isset($user_access_data['fname']) ? $user_access_data['fname'] : '';
$check_id = $this->user_access_model->user_exist($fname);
if ($check_id) {
echo jcode(array('success' => 2));
} else {
$id = $this->user_access_model->add_user_access($user_access_data);
$html = "\n\t\t\t\t\t<tr>\n\t\t\t\t\t\t<td>" . $user_access_data['fname'] . "</td>\n\t\t\t\t\t\t<td>" . $user_access_data['lname'] . "</td>\n\t\t\t\t\t\t<td>" . $user_access_data['uname'] . "</td>\n\t\t\t\t\t\t<td>" . $user_access_data['pwd'] . "</td>\n\t\t\t\t\t\t<td>" . $user_access_data['user_type'] . "</td>\n\t\t\t\t\t\t<td>\n\t\t\t\t\t\t\t<span class='action'><a href='#' class='' id='alert' data-toggle='modal' data-target='.userAccess'><i class='fa fa-edit' data-item='" . $id . "'></i> Update</a></span> |\n\t\t\t\t\t\t <span class='action'><i class='fa fa-trash-o' data-item='" . $id . "'></i> <a href='#' class='' id='alert' data-toggle='modal' data-target='.deleteAccess'>Delete</a></span>\n\t\t\t\t\t\t</td>\n\t\t\t\t\t</tr>\n\t\t\t\t\t";
echo jcode(array('success' => 1, 'response' => $html));
}
}
}
public function search_ap()
{
$this->load->model('journal_ap_model');
$account_search = $this->input->post('searchAP');
$data = $this->journal_ap_model->journal_ap_get($account_search['searchAP_invNo'], $account_search['searchAP_date'], $account_search['searchAP_suppName'], $account_search['searchAP_po']);
$html = "";
$err = validates(array($account_search), array());
if ($err < 1) {
echo jcode(array('success' => 3, 'err' => $err));
} else {
if (!$data->num_rows()) {
echo jcode(array('success' => 2));
} else {
foreach ($data->result() as $key) {
$html .= "\n\t\t\t\t\t<tr>\n\t\t\t\t\t\t<td>" . $key->ap_invoice_no . "</td>\n\t\t\t\t\t\t<td>" . $key->ap_invoice_date . "</td>\n\t\t\t\t\t\t<td>" . $key->ap_master_name . "</td>\n\t\t\t\t\t\t<td>" . $key->ap_particulars . "</td>\n\t\t\t\t\t\t<td>" . $key->ap_invoice_amount . "</td>\n\t\t\t\t\t\t<td><a href='#' data-id='{$key->ap_id}' class='btn-style-1 animate-4 pull-left account-report-print'><i class='fa fa-print'></i></a></td>\n\t\t\t\t\t</tr>\n\t\t\t\t\t";
}
echo jcode(array('success' => 1, 'response' => $html));
}
}
}
public function search_chartaccount()
{
$this->load->model('site_model');
$chart_search = $this->input->post('chart');
$data = $this->site_model->search_chartaccount($chart_search['account_code'], $chart_search['account_title'], $chart_search['sub_code'], $chart_search['sub_name']);
$html = "";
$err = validates(array($chart_search), array());
if (count($err)) {
if ($err < 1) {
echo jcode(array('success' => 3, 'err' => $err));
} else {
if (!$data->num_rows()) {
echo jcode(array('success' => 2));
} else {
foreach ($data->result() as $key) {
$html .= "\n\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t<td><label><input type='checkbox' value='' class=''><label>\t</td>\n\t\t\t\t\t\t\t<td>" . $key->account_code . "</td>\n\t\t\t\t\t\t\t<td>" . $key->account_title . "</td>\n\t\t\t\t\t\t\t<td>" . $key->sub_code . "</td>\n\t\t\t\t\t\t\t<td>" . $key->sub_name . "</td>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t";
}
echo jcode(array('success' => 1, 'response' => $html));
}
}
}
}
public function search_accountcode()
{
$this->load->model("main_account_model");
$account_search = $this->input->post('search_account');
$data = $this->main_account_model->main_account_get($account_search['searchaccount_code'], $account_search['searchaccount_title'], $account_search['search_accountgroup']);
$html = "";
$err = validates(array($account_search), array());
if (count($err)) {
if ($err < 1) {
echo jcode(array('success' => 3, 'err' => $err));
} else {
if (!$data->num_rows()) {
echo jcode(array('success' => 2));
} else {
foreach ($data->result() as $key) {
$html .= "\n\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t<td>" . $key->account_type . "</td>\n\t\t\t\t\t\t\t<td>" . $key->account_code . "</td>\n\t\t\t\t\t\t\t<td>" . $key->account_title . "</td>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t";
}
echo jcode(array('success' => 1, 'response' => $html));
}
}
}
}
public function search_master()
{
$this->load->model("master_account_model");
$account_search = $this->input->post('searchMaster');
$data = $this->master_account_model->master_account_get($account_search['searchMaster_name'], $account_search['searchMaster_type']);
$html = "";
$err = validates(array($account_search), array());
if (count($err)) {
if ($err < 1) {
echo jcode(array('success' => 3, 'err' => $err));
} else {
if (!$data->num_rows()) {
echo jcode(array('success' => 2));
} else {
foreach ($data->result() as $key) {
$html .= "\n\t\t\t\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t\t\t\t<td>" . $key->master_name . "</td>\n\t\t\t\t\t\t\t\t\t\t<td>" . $key->master_add . "</td>\n\t\t\t\t\t\t\t\t\t\t<td>" . $key->master_contact_person . "</td>\n\t\t\t\t\t\t\t\t\t\t<td>" . $key->master_tel_no . "</td>\n\t\t\t\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t\t\t";
}
echo jcode(array('success' => 1, 'response' => $html));
}
}
}
}
public function search_master()
{
$this->load->model("master_account_model");
$account_search = $this->input->post('searchMaster');
$data = $this->master_account_model->master_account_get($account_search['searchMaster_name'], $account_search['searchMaster_type']);
$html = "";
$err = validates(array($account_search), array());
if (count($err)) {
if ($err < 1) {
echo jcode(array('success' => 3, 'err' => $err));
} else {
if (!$data->num_rows()) {
echo jcode(array('success' => 2));
} else {
foreach ($data->result() as $key) {
$html .= "\n\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t<td>" . $key->master_name . "</td>\n\t\t\t\t\t\t\t<td>" . $key->master_add . "</td>\n\t\t\t\t\t\t\t<td>" . $key->master_contact_person . "</td>\n\t\t\t\t\t\t\t<td>" . $key->master_tel_no . "</td>\n\t\t\t\t\t\t\t<td><i class='fa fa-eye btn btn-style-1 showModal' data-mastercode='" . $key->master_code . "' data-date='" . $key->master_date . "' data-name='" . $key->master_name . "' data-type='" . $key->master_type . "' data-add='" . $key->master_add . "' data-term='" . $key->master_terms_payment . "' data-person='" . $key->master_contact_person . "' data-tel='" . $key->master_tel_no . "' data-email='" . $key->master_email . "' data-position='" . $key->master_position . "' data-fax='" . $key->master_fax_no . "' style='font-size:16px;margin-left:38px;'></i></td>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t";
}
auditrecord("Searched Records in Master Accounts");
echo jcode(array('success' => 1, 'response' => $html));
}
}
}
}
public function search_subsidiary()
{
$this->load->model("subsidiary_account_model");
$account_search = $this->input->post('searchAccount');
$data = $this->subsidiary_account_model->sub_account_get($account_search['searchAccount_code'], $account_search['searchAccount_name'], $account_search['searchAccount_type']);
$html = "";
$err = validates(array($account_search), array());
if (count($err)) {
if ($err < 1) {
echo jcode(array('success' => 3, 'err' => $err));
} else {
if (!$data->num_rows()) {
echo jcode(array('success' => 2));
} else {
foreach ($data->result() as $key) {
$btn_delete = $this->subsidiary_account_model->if_used($key->sub_code) > 0 ? "<td><i class='fa fa-eye btn btn-style-1' data-toggle='modal' data-target='.subsummary' data-subid='" . $key->sub_code . "' style='font-size:16px;margin-left:38px;'></i></td>" : "<td><i class='fa fa-trash-o btn btn-style-2' data-toggle='modal' data-target='.deleteConfirmation' data-subid='" . $key->sub_code . "' data-name='" . $key->sub_name . "'></i><i class='fa fa-eye btn btn-style-1' data-toggle='modal' data-target='.subsummary' data-subid='" . $key->sub_code . "' style='font-size:16px;padding:-5px;margin-left:5px'></i></td>";
$html .= "\n\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t<td>" . $key->account_type . "</td>\n\t\t\t\t\t\t\t<td>" . $key->sub_code . "</td>\n\t\t\t\t\t\t\t<td>" . $key->sub_name . "</td>\n\t\t\t\t\t\t\t<td>" . $btn_delete . "</td>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t";
}
auditrecord("Search Records in Subsidiary.");
echo jcode(array('success' => 1, 'response' => $html));
}
}
}
}
public function update_cd_trans()
{
$this->load->model('journal_cd_model');
$u_cd = $this->input->post('u_cd');
$err = validates(array($u_cd), array());
if (count($err)) {
echo jcode(array('success' => 3, 'err' => $err));
} else {
$this->journal_cd_model->update_cd($u_cd['vdate'], $u_cd['vnum'], $u_cd['payee'], $u_cd['chcknum'], $u_cd['master'], $u_cd['chckamt'], $u_cd['part'], $u_cd['cd_id']);
// print_r($this->db->last_query());
echo jcode(array('success' => 1));
}
}
<?php
function validates($username)
{
// for helping on the example, let's simply compare a string
return $username == 'admin';
}
if (empty($_POST) || empty($_POST['username']) || !validates('username', $_POST['username'])) {
header('location: post_form.php?error=true');
} else {
// only show the dashboard if all necessary requirements are correc
header('location: post_dashboard.php');
}
<?php
validates('body', array('format' => array('/\\S/', 'message' => 'has no content')));
belongs_to('post');
belongs_to('user');
after('save', 'update_last_commented_at');
// after('create', 'update_last_commented_at');
// after_save('update_fragments');
after('destroy', 'update_last_commented_at');
class Comment extends ActiveRecord
{
static function generate_sql($params)
{
$params = (array) $params;
// because of comment/index
if (empty($params['post_id'])) {
return array();
}
return array('conditions' => 'post_id = ?', array($params['post_id']));
// return Nagato::Builder.new do |builder, cond|
// cond.add_unless_blank "post_id = ?", params[:post_id]
// end.to_hash
}
function pretty_author()
{
return str_replace("_", " ", $this->user->name);
}
function api_attributes()
{
return array('id' => $this->id, 'created_at' => $this->created_at, 'post_id' => $this->post_id, 'creator' => $this->user->name, 'creator_id' => $this->user_id, 'body' => $this->body);
}
<?php
include_model('ban, tag, user_blacklisted_tag');
has_one('ban', array('foreign_key' => 'user_id'));
has_one('user_blacklisted_tag');
belongs_to('avatar_post', array('model_name' => "Post", 'foreign_key' => 'avatar_post_id'));
before('validation', 'commit_secondary_languages');
before('create', 'can_signup, set_role');
before('save', 'encrypt_password');
after('create', 'set_default_blacklisted_tags, increment_count');
after('save', 'commit_blacklists');
after('destroy', 'decrement_count');
validates(array('name' => array('length' => '2..20', 'format' => array('/\\A[^\\s;,]+\\Z/', 'on' => 'create', 'message' => 'cannot have whitespace, commas, or semicolons'), 'uniqueness' => array(true, 'on' => 'create')), 'password' => array('length' => array('>=5', 'if' => array('property_exists' => 'password')), 'confirmation' => true)));
// # validates_format_of :name, :with => /^(Anonymous|[Aa]dministrator)/, :on => :create, :message => "this is a disallowed username"
// m.after_save :update_cached_name if CONFIG["enable_caching"]
// m.has_many :tag_subscriptions, :dependent => :delete_all, :order => "name"
// m.validates_format_of :language, :with => /^([a-z\-]+)|$/
// m.validates_format_of :secondary_languages, :with => /^([a-z\-]+(,[a-z\0]+)*)?$/
class User extends ActiveRecord
{
static $current;
function _construct()
{
if (isset($this->is_anonymous)) {
return;
} elseif (isset($this->id)) {
$this->is_anonymous = false;
}
// if(CONFIG::show_samples)
// $this->show_samples = false;
}
public function update_sj_trans()
{
$this->load->model('journal_sj_model');
$u_sj = $this->input->post('u_sj');
$err = validates(array($u_sj), array());
if (count($err)) {
echo jcode(array('success' => 3, 'err' => $err));
} else {
$this->journal_sj_model->update_sj($u_sj['sjdate'], $u_sj['sjnum'], $u_sj['sjcust'], $u_sj['sjterms'], $u_sj['sjamt'], $u_sj['sjpart'], $u_sj['sj_id']);
// print_r($this->db->last_query());
echo jcode(array('success' => 1));
}
}
<?php
belongs_to('creator', array('model_name' => "User", 'foreign_key' => 'creator_id'));
after('create', 'initialize_last_updated_by, update_parent_on_create');
before('validation', 'validate_title, validate_lock');
validates(array('body' => array('length' => array('>1', 'message' => "You need to enter a body"))));
before('destroy', 'update_parent_on_destroy');
has_many('children', array('model_name' => "ForumPost", 'foreign_key' => 'parent_id', 'order' => "id"));
belongs_to('parent_post', array('model_name' => "ForumPost", 'foreign_key' => 'parent_id'));
class ForumPost extends ActiveRecord
{
static function lock($id)
{
# Run raw SQL to skip the lock check
db::update("forum_posts SET is_locked = TRUE WHERE id = ?", $id);
}
static function unlock($id)
{
# Run raw SQL to skip the lock check
db::update("forum_posts SET is_locked = FALSE WHERE id = ?", $id);
}
function validate_lock()
{
if ($this->root && $this->root->is_locked) {
$this->record_errors->add_to_base("Thread is locked");
return false;
}
return true;
}
static function stick($id)
{
public function update_ap_trans()
{
$this->load->model('journal_ap_model');
$u_ap = $this->input->post('u_ap');
$err = validates(array($u_ap), array());
if (count($err)) {
echo jcode(array('success' => 3, 'err' => $err));
} else {
$this->journal_ap_model->update_ap($u_ap['invnum'], $u_ap['invdate'], $u_ap['pono'], $u_ap['terms'], $u_ap['master'], $u_ap['invamt'], $u_ap['part'], $u_ap['ap_id']);
// print_r($this->db->last_query());
echo jcode(array('success' => 1));
}
}
public function search_list()
{
$this->load->model('general_ledger_model');
if ($this->session->userdata('islogged')) {
$search = $this->input->post('gl-search');
$search_type = $this->input->post('gl-search[journal]');
$subs = $search['sub_account'];
if ($search_type == 1) {
//Search Journal: ALL Journals
$search = $this->input->post('gl-search');
$data = $this->general_ledger_model->search_gl_all($search['main_account'], $search['from_date'], $search['to_date']);
// print_r($this->db->last_query());
// $tot_data = $this->general_ledger_model->sglall_total($search['main_account'],$search['from_date'],$search['to_date']);
$html = "";
$err = validates(array($search), array());
if ($err) {
echo jcode(array('success' => 3, 'err' => $err));
} else {
if (!$data->num_rows()) {
echo jcode(array('success' => 2));
} else {
foreach ($data->result() as $key) {
$html .= "\n\t\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t\t<td>" . $key->date . "</td>\n\t\t\t\t\t\t\t\t<td>" . $key->masterm . "</td>\n\t\t\t\t\t\t\t\t<td>" . $key->particulars . "</td>\n\t\t\t\t\t\t\t\t<td>" . $key->transcode . "</td>\n\t\t\t\t\t\t\t\t<td class='text-right'>0</td>\n\t\t\t\t\t\t\t\t<td class='text-right'>" . $key->tot_amount . "</td>\n\t\t\t\t\t\t\t</tr>";
}
// foreach ($tot_data->result() as $key) {
// $html.="
// <tr>
// <td class=''>TOTAL</td>
// <td></td>
// <td></td>
// <td></td>
// <td class='text-right '>".$key->totdr."</td>
// <td class='text-right '>".$key->totcr."</td>
// </tr>
// ";
// }
echo jcode(array('success' => 1, 'data' => $html));
}
}
} elseif ($search_type == 2) {
//Search Journal: Cash Receipts
$search = $this->input->post('gl-search');
$new_mainaccount = substr($search['main_account'], 8);
$data = $this->general_ledger_model->search_gl_cash($subs, $search['from_date'], $search['to_date']);
$tot_data = $this->general_ledger_model->sglc_total($subs, $search['from_date'], $search['to_date']);
$html = "";
$err = validates(array($search), array());
if ($err) {
echo jcode(array('success' => 3, 'err' => $err));
} else {
if (!$data->num_rows()) {
echo jcode(array('success' => 2));
} else {
foreach ($data->result() as $key) {
$html .= "\n\t\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t\t<td>" . $key->date . "</td>\n\t\t\t\t\t\t\t\t<td>" . $key->description . "</td>\n\t\t\t\t\t\t\t\t<td>" . $key->particulars . "</td>\n\t\t\t\t\t\t\t\t<td>" . $key->transcode . "</td>\n\t\t\t\t\t\t\t\t<td class='text-right'>" . $key->tot_amount . "</td>\n\t\t\t\t\t\t\t\t<td class='text-right'>0.00</td>\n\t\t\t\t\t\t\t</tr>";
}
foreach ($tot_data->result() as $key) {
$html .= "\n\t\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t\t<td class=''>TOTAL</td>\n\t\t\t\t\t\t\t\t<td></td>\n\t\t\t\t\t\t\t\t<td></td>\n\t\t\t\t\t\t\t\t<td></td>\n\t\t\t\t\t\t\t\t<td class='text-right '>" . $key->tot_amount . "</td>\n\t\t\t\t\t\t\t\t<td class='text-right '>0.00</td>\n\t\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t\t";
}
echo jcode(array('success' => 1, 'data' => $html));
}
}
} elseif ($search_type == 3) {
// Search Journal: Acconts Payable
$search = $this->input->post('gl-search');
$new_mainaccount = substr($search['main_account'], 8);
$data = $this->general_ledger_model->search_gl_ap($subs, $search['from_date'], $search['to_date']);
$tot_data = $this->general_ledger_model->sglap_total($subs, $search['from_date'], $search['to_date']);
// print_r($this->db->last_query());
$html = "";
$err = validates(array($search), array());
if ($err) {
echo jcode(array('success' => 3, 'err' => $err));
} else {
if (!$data->num_rows()) {
echo jcode(array('success' => 2));
} else {
foreach ($data->result() as $key) {
$html .= "\n\t\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t\t<td>" . $key->invDate . "</td>\n\t\t\t\t\t\t\t\t<td>" . $key->mastername . "</td>\n\t\t\t\t\t\t\t\t<td>" . $key->particulars . "</td>\n\t\t\t\t\t\t\t\t<td>" . $key->transcode . "</td>\n\t\t\t\t\t\t\t\t<td class='text-right'>0</td>\n\t\t\t\t\t\t\t\t<td class='text-right'>" . $key->tot_amount . "</td>\n\t\t\t\t\t\t\t\t<td><a href=# class='btn btn-style-1'><i class='fa fa-file-text'></i></a></td>\n\t\t\t\t\t\t\t</tr>";
}
foreach ($tot_data->result() as $key) {
$html .= "\n\t\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t\t<td class=''>TOTAL</td>\n\t\t\t\t\t\t\t\t<td></td>\n\t\t\t\t\t\t\t\t<td></td>\n\t\t\t\t\t\t\t\t<td></td>\n\t\t\t\t\t\t\t\t<td class='text-right '>0</td>\n\t\t\t\t\t\t\t\t<td class='text-right '>" . $key->tot_amount . "</td>\n\t\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t\t";
}
echo jcode(array('success' => 1, 'data' => $html));
}
}
} elseif ($search_type == 4) {
//Search Journal:Check Disbursement
$search = $this->input->post('gl-search');
$new_mainaccount = substr($search['main_account'], 8);
$data = $this->general_ledger_model->search_gl_cd($subs, $search['from_date'], $search['to_date']);
// print_r($this->db->last_query());
$tot_data = $this->general_ledger_model->sglcd_total($subs, $search['from_date'], $search['to_date']);
$html = "";
$err = validates(array($search), array());
if ($err) {
echo jcode(array('success' => 3, 'err' => $err));
} else {
if (!$data->num_rows()) {
echo jcode(array('success' => 2));
} else {
foreach ($data->result() as $key) {
$html .= "\n\t\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t\t<td>" . $key->date . "</td>\n\t\t\t\t\t\t\t\t<td>" . $key->mastername . "</td>\n\t\t\t\t\t\t\t\t<td>" . $key->particulars . "</td>\n\t\t\t\t\t\t\t\t<td>" . $key->transcode . "</td>\n\t\t\t\t\t\t\t\t<td class='text-right'>" . $key->dr . "</td>\n\t\t\t\t\t\t\t\t<td class='text-right'>" . $key->cr . "</td>\n\t\t\t\t\t\t\t</tr>";
}
foreach ($tot_data->result() as $key) {
$html .= "\n\t\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t\t<td class=''>TOTAL</td>\n\t\t\t\t\t\t\t\t<td></td>\n\t\t\t\t\t\t\t\t<td></td>\n\t\t\t\t\t\t\t\t<td></td>\n\t\t\t\t\t\t\t\t<td class='text-right '>" . $key->totdr . "</td>\n\t\t\t\t\t\t\t\t<td class='text-right '>" . $key->totcr . "</td>\n\t\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t\t";
}
echo jcode(array('success' => 1, 'data' => $html));
}
}
} elseif ($search_type == 5) {
//Search Journal:Sales Journal
$search = $this->input->post('gl-search');
$new_mainaccount = substr($search['main_account'], 8);
$data = $this->general_ledger_model->search_gl_sj($subs, $search['from_date'], $search['to_date']);
$tot_data = $this->general_ledger_model->sglsj_total($search['main_account'], $subs, $search['from_date'], $search['to_date']);
$html = "";
$err = validates(array($search), array());
if ($err) {
echo jcode(array('success' => 3, 'err' => $err));
} else {
if (!$data->num_rows()) {
echo jcode(array('success' => 2));
} else {
foreach ($data->result() as $key) {
$html .= "\n\t\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t\t<td>" . $key->date . "</td>\n\t\t\t\t\t\t\t\t<td>" . $key->masterm . "</td>\n\t\t\t\t\t\t\t\t<td>" . $key->particulars . "</td>\n\t\t\t\t\t\t\t\t<td>" . $key->transcode . "</td>\n\t\t\t\t\t\t\t\t<td class='text-right'>" . $key->dr . "</td>\n\t\t\t\t\t\t\t\t<td class='text-right'>" . $key->cr . "</td>\n\t\t\t\t\t\t\t</tr>";
}
foreach ($tot_data->result() as $key) {
$html .= "\n\t\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t\t<td class=''>TOTAL</td>\n\t\t\t\t\t\t\t\t<td></td>\n\t\t\t\t\t\t\t\t<td></td>\n\t\t\t\t\t\t\t\t<td></td>\n\t\t\t\t\t\t\t\t<td class='text-right '>" . $key->totdr . "</td>\n\t\t\t\t\t\t\t\t<td class='text-right '>" . $key->totcr . "</td>\n\t\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t\t";
}
echo jcode(array('success' => 1, 'data' => $html));
}
}
} elseif ($search_type == 6) {
//Search Journal:General Journal
$search = $this->input->post('gl-search');
$new_mainaccount = substr($search['main_account'], 8);
$data = $this->general_ledger_model->search_gl_gj($subs, $search['from_date'], $search['to_date']);
$tot_data = $this->general_ledger_model->sglgj_total($search['main_account'], $subs, $search['from_date'], $search['to_date']);
$html = "";
$err = validates(array($search), array());
if ($err) {
echo jcode(array('success' => 3, 'err' => $err));
} else {
if (!$data->num_rows()) {
echo jcode(array('success' => 2));
} else {
foreach ($data->result() as $key) {
$html .= "\n\t\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t\t<td>" . $key->date . "</td>\n\t\t\t\t\t\t\t\t<td></td>\n\t\t\t\t\t\t\t\t<td>" . $key->particulars . "</td>\n\t\t\t\t\t\t\t\t<td>" . $key->transcode . "</td>\n\t\t\t\t\t\t\t\t<td class='text-right'>" . $key->dr . "</td>\n\t\t\t\t\t\t\t\t<td class='text-right'>" . $key->cr . "</td>\n\t\t\t\t\t\t\t</tr>";
}
foreach ($tot_data->result() as $key) {
$html .= "\n\t\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t\t<td class=''>TOTAL</td>\n\t\t\t\t\t\t\t\t<td></td>\n\t\t\t\t\t\t\t\t<td></td>\n\t\t\t\t\t\t\t\t<td></td>\n\t\t\t\t\t\t\t\t<td class='text-right '>" . $key->totdr . "</td>\n\t\t\t\t\t\t\t\t<td class='text-right '>" . $key->totcr . "</td>\n\t\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t\t";
}
echo jcode(array('success' => 1, 'data' => $html));
}
}
}
} else {
redirect('login');
}
}
public function search_list()
{
$this->load->model('general_ledger_model');
if ($this->session->userdata('islogged')) {
$search = $this->input->post('gl-search');
$search_type = $this->input->post('gl-search[journal]');
$subs = $search['sub_account'];
$main = $search['account'];
if ($search_type == 1) {
//Search Journal: ALL Journals
$search = $this->input->post('gl-search');
$data = $this->general_ledger_model->search_gl_all($main, $subs, $search['from_date'], $search['to_date']);
// print_r($this->db->last_query());
$html = "";
$err = validates(array($search), array());
if ($err) {
echo jcode(array('success' => 3, 'err' => $err));
} else {
if (!$data->num_rows()) {
echo jcode(array('success' => 2));
} else {
foreach ($data->result() as $key) {
$data_ap = $this->general_ledger_model->get_in_ap($key->trans_id);
if ($key->trans_journal == 'ap') {
foreach ($data_ap->result() as $key_ap) {
$html .= "\n\t\t\t\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t\t\t\t<td>" . $key_ap->ap_invoice_date . "</td>\n\t\t\t\t\t\t\t\t\t\t<td>" . $key->account_name . "</td>\n\t\t\t\t\t\t\t\t\t\t<td>" . $key_ap->ap_particulars . "</td>\n\t\t\t\t\t\t\t\t\t\t<td>" . $key_ap->ap_invoice_no . "</td>\n\t\t\t\t\t\t\t\t\t\t<td class='text-right'>" . number_format($key_ap->trans_dr, 2) . "</td>\n\t\t\t\t\t\t\t\t\t\t<td class='text-right'>" . number_format($key_ap->trans_cr, 2) . "</td>\n\t\t\t\t\t\t\t\t\t\t<td><a href='#' class='btn-style-1'><i class='fa fa-eye'></i></a></td>\n\t\t\t\t\t\t\t\t\t</tr>";
}
} elseif ($key->trans_journal == 'cd') {
$data_cd = $this->general_ledger_model->get_in_cd($key->trans_id);
foreach ($data_cd->result() as $key_cd) {
$html .= "\n\t\t\t\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t\t\t\t<td>" . $key_cd->cd_date . "</td>\n\t\t\t\t\t\t\t\t\t\t<td>" . $key->account_name . "</td>\n\t\t\t\t\t\t\t\t\t\t<td>" . $key_cd->cd_particulars . "</td>\n\t\t\t\t\t\t\t\t\t\t<td>" . $key_cd->cd_voucher_no . "</td>\n\t\t\t\t\t\t\t\t\t\t<td class='text-right'>" . number_format($key_cd->trans_dr, 2) . "</td>\n\t\t\t\t\t\t\t\t\t\t<td class='text-right'>" . number_format($key_cd->trans_cr, 2) . "</td>\n\t\t\t\t\t\t\t\t\t\t<td><a href='#' class='btn-style-1'><i class='fa fa-eye'></i></a></td>\n\t\t\t\t\t\t\t\t\t</tr>";
}
} elseif ($key->trans_journal == 'cr') {
$data_cr = $this->general_ledger_model->get_in_cr($key->trans_id);
foreach ($data_cr->result() as $key_cr) {
$html .= "\n\t\t\t\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t\t\t\t<td>" . $key_cr->cr_or_date . "</td>\n\t\t\t\t\t\t\t\t\t\t<td>" . $key->account_name . "</td>\n\t\t\t\t\t\t\t\t\t\t<td>" . $key_cr->cr_particulars . "</td>\n\t\t\t\t\t\t\t\t\t\t<td>" . $key_cr->cr_or_no . "</td>\n\t\t\t\t\t\t\t\t\t\t<td class='text-right'>" . number_format($key_cr->trans_dr, 2) . "</td>\n\t\t\t\t\t\t\t\t\t\t<td class='text-right'>" . number_format($key_cr->trans_cr, 2) . "</td>\n\t\t\t\t\t\t\t\t\t\t<td><a href='#' class='btn-style-1'><i class='fa fa-eye'></i></a></td>\n\t\t\t\t\t\t\t\t\t</tr>";
}
} elseif ($key->trans_journal == 'cr') {
$data_cr = $this->general_ledger_model->get_in_cr($key->trans_id);
foreach ($data_cr->result() as $key_cr) {
$html .= "\n\t\t\t\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t\t\t\t<td>" . $key_cr->cr_or_date . "</td>\n\t\t\t\t\t\t\t\t\t\t<td>" . $key->account_name . "</td>\n\t\t\t\t\t\t\t\t\t\t<td>" . $key_cr->cr_particulars . "</td>\n\t\t\t\t\t\t\t\t\t\t<td>" . $key_cr->cr_or_no . "</td>\n\t\t\t\t\t\t\t\t\t\t<td class='text-right'>" . number_format($key_cr->trans_dr, 2) . "</td>\n\t\t\t\t\t\t\t\t\t\t<td class='text-right'>" . number_format($key_cr->trans_cr, 2) . "</td>\n\t\t\t\t\t\t\t\t\t\t<td><a href='#' class='btn-style-1'><i class='fa fa-eye'></i></a></td>\n\t\t\t\t\t\t\t\t\t</tr>";
}
} elseif ($key->trans_journal == 'gj') {
$data_gj = $this->general_ledger_model->get_in_gj($key->trans_id);
foreach ($data_gj->result() as $key_gj) {
$html .= "\n\t\t\t\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t\t\t\t<td>" . $key_gj->gj_date . "</td>\n\t\t\t\t\t\t\t\t\t\t<td>" . $key->account_name . "</td>\n\t\t\t\t\t\t\t\t\t\t<td>" . $key_gj->gj_particulars . "</td>\n\t\t\t\t\t\t\t\t\t\t<td>" . $key_gj->gj_code . "</td>\n\t\t\t\t\t\t\t\t\t\t<td class='text-right'>" . number_format($key_gj->trans_dr, 2) . "</td>\n\t\t\t\t\t\t\t\t\t\t<td class='text-right'>" . number_format($key_gj->trans_cr, 2) . "</td>\n\t\t\t\t\t\t\t\t\t\t<td><a href='#' class='btn-style-1'><i class='fa fa-eye'></i></a></td>\n\t\t\t\t\t\t\t\t\t</tr>";
}
} elseif ($key->trans_journal == 'sj') {
$data_sj = $this->general_ledger_model->get_in_sj($key->trans_id);
foreach ($data_sj->result() as $key_sj) {
$html .= "\n\t\t\t\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t\t\t\t<td>" . $key_sj->sj_si_date . "</td>\n\t\t\t\t\t\t\t\t\t\t<td>" . $key->account_name . "</td>\n\t\t\t\t\t\t\t\t\t\t<td>" . $key_sj->sj_particulars . "</td>\n\t\t\t\t\t\t\t\t\t\t<td>" . $key_sj->sj_si_no . "</td>\n\t\t\t\t\t\t\t\t\t\t<td class='text-right'>" . number_format($key_sj->trans_dr, 2) . "</td>\n\t\t\t\t\t\t\t\t\t\t<td class='text-right'>" . number_format($key_sj->trans_cr, 2) . "</td>\n\t\t\t\t\t\t\t\t\t\t<td><a href='#' class='btn-style-1'><i class='fa fa-eye'></i></a></td>\n\t\t\t\t\t\t\t\t\t</tr>";
}
}
}
echo jcode(array('success' => 1, 'data' => $html));
}
}
} elseif ($search_type == 2) {
//Search Journal: Cash Receipts
$search = $this->input->post('gl-search');
$new_mainaccount = substr($search['main_account'], 8);
$data = $this->general_ledger_model->search_gl_cash($search['account'], $search['sub_account'], $search['from_date'], $search['to_date']);
// print_r($this->db->last_query());
$tot_data = $this->general_ledger_model->gl_cash_total($search['account'], $search['sub_account'], $search['from_date'], $search['to_date']);
$html = "";
$err = validates(array($search), array());
if ($err) {
echo jcode(array('success' => 3, 'err' => $err));
} else {
if (!$data->num_rows()) {
echo jcode(array('success' => 2));
} else {
foreach ($data->result() as $key) {
$html .= "\n\t\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t\t<td>" . $key->cr_or_date . "</td>\n\t\t\t\t\t\t\t\t<td>" . $key->cr_master_name_bank . "</td>\n\t\t\t\t\t\t\t\t<td>" . $key->cr_particulars . "</td>\n\t\t\t\t\t\t\t\t<td>" . $key->cr_or_no . "</td>\n\t\t\t\t\t\t\t\t<td class='text-right'>" . $key->trans_dr . "</td>\n\t\t\t\t\t\t\t\t<td class='text-right'>" . $key->trans_cr . "</td>\n\t\t\t\t\t\t\t\t<td><a href=# data-id='" . $key->cr_id . "' data-journal='" . $search['journal'] . "' class='btn btn-style-1 view_account'><i class='fa fa-eye'></i></a></td>\n\t\t\t\t\t\t\t</tr>";
}
foreach ($tot_data->result() as $key) {
$html .= "\n\t\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t\t<td>TOTAL</td>\n\t\t\t\t\t\t\t\t<td></td>\n\t\t\t\t\t\t\t\t<td></td>\n\t\t\t\t\t\t\t\t<td></td>\n\t\t\t\t\t\t\t\t<td class='text-right'>" . $key->tot_dr . "</td>\n\t\t\t\t\t\t\t\t<td class='text-right'>" . $key->tot_cr . "</td>\n\t\t\t\t\t\t\t</tr>";
}
echo jcode(array('success' => 1, 'data' => $html));
}
}
} elseif ($search_type == 3) {
// Search Journal: Acconts Payable
$search = $this->input->post('gl-search');
$new_mainaccount = substr($search['main_account'], 8);
$data = $this->general_ledger_model->search_gl_ap($search['account'], $search['sub_account'], $search['from_date'], $search['to_date']);
// print_r($this->db->last_query());
$tot_data = $this->general_ledger_model->gl_ap_total($search['account'], $search['sub_account'], $search['from_date'], $search['to_date']);
$html = "";
$err = validates(array($search), array());
if ($err) {
echo jcode(array('success' => 3, 'err' => $err));
} else {
if (!$data->num_rows()) {
echo jcode(array('success' => 2));
} else {
foreach ($data->result() as $key) {
$html .= "\n\t\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t\t<td>" . $key->ap_invoice_date . "</td>\n\t\t\t\t\t\t\t\t<td>" . $key->ap_master_name . "</td>\n\t\t\t\t\t\t\t\t<td>" . $key->ap_particulars . "</td>\n\t\t\t\t\t\t\t\t<td>" . $key->ap_invoice_no . "</td>\n\t\t\t\t\t\t\t\t<td class='text-right'>" . $key->trans_dr . "</td>\n\t\t\t\t\t\t\t\t<td class='text-right'>" . $key->trans_cr . "</td>\n\t\t\t\t\t\t\t\t<td><a href=# data-id='" . $key->ap_id . "' data-journal='" . $search['journal'] . "' class='btn btn-style-1 view_account'><i class='fa fa-eye'></i></a></td>\n\t\t\t\t\t\t\t</tr>";
}
foreach ($tot_data->result() as $key) {
$html .= "\n\t\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t\t<td>TOTAL</td>\n\t\t\t\t\t\t\t\t<td></td>\n\t\t\t\t\t\t\t\t<td></td>\n\t\t\t\t\t\t\t\t<td></td>\n\t\t\t\t\t\t\t\t<td class='text-right'>" . $key->tot_dr . "</td>\n\t\t\t\t\t\t\t\t<td class='text-right'>" . $key->tot_cr . "</td>\n\t\t\t\t\t\t\t</tr>";
}
echo jcode(array('success' => 1, 'data' => $html));
}
}
} elseif ($search_type == 4) {
//Search Journal:Check Disbursement
$search = $this->input->post('gl-search');
$new_mainaccount = substr($search['main_account'], 8);
$data = $this->general_ledger_model->search_gl_cd($search['account'], $search['sub_account'], $search['from_date'], $search['to_date']);
$tot_data = $this->general_ledger_model->gl_cd_total($search['account'], $search['sub_account'], $search['from_date'], $search['to_date']);
$html = "";
$err = validates(array($search), array());
if ($err) {
echo jcode(array('success' => 3, 'err' => $err));
} else {
if (!$data->num_rows()) {
echo jcode(array('success' => 2));
} else {
foreach ($data->result() as $key) {
$html .= "\n\t\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t\t<td>" . $key->cd_date . "</td>\n\t\t\t\t\t\t\t\t<td>" . $key->cd_master_name . "</td>\n\t\t\t\t\t\t\t\t<td>" . $key->cd_particulars . "</td>\n\t\t\t\t\t\t\t\t<td>" . $key->cd_voucher_no . "</td>\n\t\t\t\t\t\t\t\t<td class='text-right'>" . $key->trans_dr . "</td>\n\t\t\t\t\t\t\t\t<td class='text-right'>" . $key->trans_cr . "</td>\n\t\t\t\t\t\t\t\t<td><a href=# data-id='" . $key->cd_id . "' data-journal='" . $search['journal'] . "' class='btn btn-style-1 view_account'><i class='fa fa-eye'></i></a></td>\n\t\t\t\t\t\t\t</tr>";
}
foreach ($tot_data->result() as $key) {
$html .= "\n\t\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t\t<td>TOTAL</td>\n\t\t\t\t\t\t\t\t<td></td>\n\t\t\t\t\t\t\t\t<td></td>\n\t\t\t\t\t\t\t\t<td></td>\n\t\t\t\t\t\t\t\t<td class='text-right'>" . $key->tot_dr . "</td>\n\t\t\t\t\t\t\t\t<td class='text-right'>" . $key->tot_cr . "</td>\n\t\t\t\t\t\t\t</tr>";
}
echo jcode(array('success' => 1, 'data' => $html));
}
}
} elseif ($search_type == 5) {
//Search Journal:Sales Journal
$search = $this->input->post('gl-search');
$new_mainaccount = substr($search['main_account'], 8);
$data = $this->general_ledger_model->search_gl_sj($search['account'], $search['sub_account'], $search['from_date'], $search['to_date']);
$tot_data = $this->general_ledger_model->gl_sj_total($search['account'], $search['sub_account'], $search['from_date'], $search['to_date']);
$html = "";
$err = validates(array($search), array());
if ($err) {
echo jcode(array('success' => 3, 'err' => $err));
} else {
if (!$data->num_rows()) {
echo jcode(array('success' => 2));
} else {
foreach ($data->result() as $key) {
$html .= "\n\t\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t\t<td>" . $key->sj_si_date . "</td>\n\t\t\t\t\t\t\t\t<td>" . $key->sj_master_name . "</td>\n\t\t\t\t\t\t\t\t<td>" . $key->sj_particulars . "</td>\n\t\t\t\t\t\t\t\t<td>" . $key->sj_si_no . "</td>\n\t\t\t\t\t\t\t\t<td class='text-right'>" . $key->trans_dr . "</td>\n\t\t\t\t\t\t\t\t<td class='text-right'>" . $key->trans_cr . "</td>\n\t\t\t\t\t\t\t\t<td><a href=# data-id='" . $key->sj_id . "' data-journal='" . $search['journal'] . "' class='btn btn-style-1 view_account'><i class='fa fa-eye'></i></a></td>\n\t\t\t\t\t\t\t</tr>";
}
foreach ($tot_data->result() as $key) {
$html .= "\n\t\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t\t<td>TOTAL</td>\n\t\t\t\t\t\t\t\t<td></td>\n\t\t\t\t\t\t\t\t<td></td>\n\t\t\t\t\t\t\t\t<td></td>\n\t\t\t\t\t\t\t\t<td class='text-right'>" . $key->tot_dr . "</td>\n\t\t\t\t\t\t\t\t<td class='text-right'>" . $key->tot_cr . "</td>\n\t\t\t\t\t\t\t</tr>";
}
echo jcode(array('success' => 1, 'data' => $html));
}
}
} elseif ($search_type == 6) {
//Search Journal:General Journal
$search = $this->input->post('gl-search');
$new_mainaccount = substr($search['main_account'], 8);
$data = $this->general_ledger_model->search_gl_gj($search['account'], $search['sub_account'], $search['from_date'], $search['to_date']);
$tot_data = $this->general_ledger_model->gl_gj_total($search['account'], $search['sub_account'], $search['from_date'], $search['to_date']);
// print_r($this->db->last_query());
$html = "";
$err = validates(array($search), array());
if ($err) {
echo jcode(array('success' => 3, 'err' => $err));
} else {
if (!$data->num_rows()) {
echo jcode(array('success' => 2));
} else {
foreach ($data->result() as $key) {
$html .= "\n\t\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t\t<td>" . $key->gj_date . "</td>\n\t\t\t\t\t\t\t\t<td></td>\n\t\t\t\t\t\t\t\t<td>" . $key->gj_particulars . "</td>\n\t\t\t\t\t\t\t\t<td>" . $key->gj_code . "</td>\n\t\t\t\t\t\t\t\t<td class='text-right'>" . $key->trans_dr . "</td>\n\t\t\t\t\t\t\t\t<td class='text-right'>" . $key->trans_cr . "</td>\n\t\t\t\t\t\t\t\t<td><a href=# data-id='" . $key->gj_id . "' data-journal='" . $search['journal'] . "' class='btn btn-style-1 view_account'><i class='fa fa-eye'></i></a></td>\n\t\t\t\t\t\t\t</tr>";
}
foreach ($tot_data->result() as $key) {
$html .= "\n\t\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t\t<td>TOTAL</td>\n\t\t\t\t\t\t\t\t<td></td>\n\t\t\t\t\t\t\t\t<td></td>\n\t\t\t\t\t\t\t\t<td></td>\n\t\t\t\t\t\t\t\t<td class='text-right'>" . $key->tot_dr . "</td>\n\t\t\t\t\t\t\t\t<td class='text-right'>" . $key->tot_cr . "</td>\n\t\t\t\t\t\t\t</tr>";
}
echo jcode(array('success' => 1, 'data' => $html));
}
}
}
} else {
echo jcode(array('success' => 1));
}
}
<?php
belongs_to('user');
before('validation', 'normalize_name');
validates('name', array('uniqueness' => true));
# TODO: conditions.
has_many('pool_posts', array('model_name' => 'PoolPost', 'order' => 'CAST(sequence AS UNSIGNED), post_id'));
// , 'conditions' => "pools_posts.active"
has_many('all_pool_posts', array('model_name' => 'PoolPost', 'order' => 'CAST(sequence AS UNSIGNED), post_id'));
// m.versioned :name
// m.versioned :description, :default => ""
// m.versioned :is_public, :default => true
// m.versioned :is_active, :default => true
// m.after_undo :update_pool_links
// m.after_save :expire_cache
class Pool extends ActiveRecord
{
function _construct()
{
$this->is_public = !empty($this->is_public);
$this->is_active = !empty($this->is_active);
}
function can_be_updated_by($user)
{
return (bool) $this->is_public || $user->has_permission($this);
}
static function get_pool_posts_from_posts($posts)
{
// post_ids = posts.map { |post| post.id }
$post_ids = array();
foreach ($posts as $post) {
