public function indexAction() { $searchForm = new Receiptpayment_Form_Search(); $this->view->form = $searchForm; $this->view->title = "Receipts and payments"; if ($this->_request->isPost() && $this->_request->getPost('Search')) { $formData = $this->_request->getPost(); $dateconvertor = new App_Model_dateConvertor(); $fromDate = $dateconvertor->mysqlformat($this->_request->getParam('field1')); $toDate = $dateconvertor->mysqlformat($this->_request->getParam('field2')); $this->view->field1 = $this->_request->getParam('field1'); $this->view->field2 = $this->_request->getParam('field2'); $this->view->pageTitle = "Receipt and Payment"; $formData = $this->_request->getPost(); if ($searchForm->isValid($formData)) { $this->view->savings = 10; $transaction = new Receiptpayment_Model_Receiptpayment(); //Saving Account Credit and Debit $this->view->savingsCredit = $transaction->totalSavingsCredit($fromDate, $toDate); $this->view->savingsDebit = $transaction->totalSavingsDebit($fromDate, $toDate); //Opening and Closing Balace Calculation //Opening Balance Saving Account Credit and Debit $this->view->openingsavingsCredit = $transaction->openingBalance($fromDate, $toDate); $this->view->openingsavingsDebit = $transaction->closingBalance($fromDate, $toDate); $this->view->field1 = $this->_request->getParam('field1'); $this->view->field2 = $this->_request->getParam('field2'); } } }
public function searchRoles($post) { $convertdate = new App_Model_dateConvertor(); if ($post['granteddate']) { $searchdate = $convertdate->mysqlformat($post['granteddate']); } else { $searchdate = $post['granteddate']; } $select = $this->select()->setIntegrityCheck(false)->from('ourbank_grant')->where('name like "%" ? "%" ', $post['grantname'])->where('created_date like "%" ? "%" ', $searchdate); $result = $this->fetchAll($select); return $result->toArray(); // return searched grant details }
public function SearchAttendance($post) { $convertdate = new App_Model_dateConvertor(); if ($post['search_meeting_date']) { $search_meeting_date = $convertdate->phpmysqlformat($post['search_meeting_date']); } else { $search_meeting_date = $post['search_meeting_date']; } $select = $this->select()->setIntegrityCheck(false)->join(array('a' => 'ourbank_attendance'), array('a.id'), array('a.id as attid', 'a.meeting_date', 'week_no'))->where('a.meeting_id like "%" ? "%"', $post['search_meeting_name_att'])->where('a.meeting_date like "%" ? "%"', $search_meeting_date)->group('a.id')->join(array('b' => 'ourbank_meeting'), 'a.meeting_id = b.id'); //die($select->__toString($select)); $result = $this->fetchAll($select); return $result->toArray(); }
public function deposit($acc, $amount, $date, $type, $transactionMode, $description, $paymenttype_details, $createdby) { $cl = new App_Model_dateConvertor(); $db = Zend_Db_Table::getDefaultAdapter(); $db->setFetchMode(Zend_Db::FETCH_OBJ); $accData = $this->search($acc); foreach ($accData as $accData) { $accId = $accData->accId; $gl = $accData->gl; $officeid = $accData->officeid; } // Transaction entry $input = array('account_id' => $accId, 'glsubcode_id_to' => $gl, 'transaction_date' => $cl->phpmysqlformat($date), 'amount_from_bank' => $amount, 'transactiontype_id' => 2, 'recordstatus_id' => 3, 'paymenttype_id' => $transactionMode, 'paymenttype_details' => $paymenttype_details, 'transaction_description' => $description, 'balance' => $amount, 'confirmation_flag' => 0, 'created_by' => $createdby); $db->insert("ourbank_transaction", $input); $tranId = $db->lastInsertId('ourbank_transaction'); // Saving transaction entry $saving = array('transaction_id' => $tranId, 'account_id' => $accId, 'transaction_date' => $cl->phpmysqlformat($date), 'transactiontype_id' => 2, 'glsubcode_id_to' => $gl, 'amount_from_bank' => $amount, 'paymenttype_id' => $transactionMode, 'paymenttype_details' => $paymenttype_details, 'transaction_description' => $description, 'transaction_by' => $createdby); $db->insert('ourbank_savings_transaction', $saving); if ((substr($acc, 4, 1) == 2 || substr($acc, 4, 1) == 3) && $type == 2) { $group = $this->getMember($acc); $count = count($group); foreach ($group as $group) { $Accid = $this->getAccountid($group->id); $groupsaving = array('transaction_id' => $tranId, 'account_id' => $Accid, 'member_id' => $group->id, 'transaction_date' => $cl->phpmysqlformat($date), 'transaction_type' => 2, 'transaction_amount' => $amount / $count, 'transacted_by' => $createdby); $db->insert('ourbank_group_savingstransaction', $groupsaving); } } // Insertion into Liabilities $liabilities = array('office_id' => $officeid, 'glsubcode_id_from' => '', 'glsubcode_id_to' => $gl, 'transaction_id' => $tranId, 'debit' => $amount, 'record_status' => 3); $db->insert('ourbank_Liabilities', $liabilities); $glresult = $this->getGlcode($officeid); if ($glresult) { foreach ($glresult as $glresult) { $cashglsubocde = $glresult->id; } } else { $cashglsubocde = 0; } // Insertion into Assets ourbank_Assets $assets = array('office_id' => $officeid, 'glsubcode_id_from' => '', 'glsubcode_id_to' => $cashglsubocde, 'transaction_id' => $tranId, 'debit' => $amount, 'record_status' => 3); $db->insert('ourbank_Assets', $assets); return $tranId; }
public function SearchAttendance($post) { $keyvalue = array_filter($post); $searchcounter = count($keyvalue); if ($searchcounter > 0) { $convertdate = new App_Model_dateConvertor(); if ($post['s2']) { $search_meeting_date = $convertdate->phpmysqlformat($post['s2']); } else { $search_meeting_date = $post['s2']; } $select = $this->select()->setIntegrityCheck(false)->join(array('a' => 'ourbank_attendance'), array('id'), array('a.id as attid', 'a.meeting_date', 'a.week_no', 'a.transaction_id'))->where('a.meeting_id like "%" ? "%"', $post['s1'])->where('a.meeting_date like "%" ? "%"', $search_meeting_date)->group('a.id')->join(array('b' => 'ourbank_group'), 'a.meeting_id = b.id'); $result = $this->fetchAll($select); return $result->toArray(); } else { $select = $this->select()->setIntegrityCheck(false)->join(array('a' => 'ourbank_attendance'), array('id'), array('a.id as attid', 'a.meeting_date', 'a.week_no', 'a.transaction_id'))->group('a.id')->join(array('b' => 'ourbank_group'), 'a.meeting_id = b.id'); $result = $this->fetchAll($select); return $result->toArray(); } }
function indexAction() { $path = $this->view->baseUrl(); $this->view->form = $searchForm = new Ledgerbalancebook_Form_Search($path); $dateconvertor = new App_Model_dateConvertor(); $GeneralList = new Ledgerbalancebook_Model_Ledgerbookbalance(); $officename = $GeneralList->getHier(); foreach ($officename as $officename) { $searchForm->hierarchy->addMultiOption($officename['id'], $officename['type']); } if ($this->_request->isPost() && $this->_request->getPost('Search')) { $formData = $this->_request->getPost(); if ($searchForm->isValid($formData)) { $this->view->date1 = $this->_request->getParam('date1'); $fromDate = $dateconvertor->mysqlformat($this->view->date1); $hierarchy = $this->_request->getParam('hierarchy'); $branch = $this->_request->getParam('branch'); $this->view->ledegerList = $GeneralList->generalLedger($fromDate, $hierarchy, $branch); $this->view->ledegerListAssets = $GeneralList->generalLedgerAssets($fromDate, $hierarchy, $branch); } } }
public function editassetAction() { $this->view->title = $this->view->translate('Edit Livingasset details'); //Base line data $familycommon = new Familycommonview_Model_familycommonview(); $this->view->memberid = $this->_getParam('id'); $this->view->membername = $familycommon->getfamily($this->_getParam('id')); // // // // $revvillageid = $this->view->membername[0]['rev_village_id']; // // // // if ($revvillageid) { // // // // $revvillagename = $this->view->adm->editRecord("ourbank_master_villagelist",$revvillageid); // // // // $this->view->revvillagename=$revvillagename[0]['name']; // // // // } //getting module id and submodule id $module = $familycommon->getmodule('Family'); foreach ($module as $module_id) { } $this->view->mod_id = $module_id['parent']; $this->view->sub_id = $module_id['module_id']; $this->view->insurance = $familycommon->getinsurance($this->_getParam('id')); //edit assets $this->view->memberid = $member_id = $this->_getParam('id'); //load form for living assets $this->view->submoduleid = $this->_getParam('subId'); //dynamically change the path name //get all type of living assets $this->view->liveasset_details = $this->view->adm->viewRecord("ourbank_master_liveassets", "id", "DESC"); //update contact details if ($this->_request->isPost() && $this->_request->getPost('Submit')) { $id = $this->_getParam('id'); $submoduleid = $this->_getParam('subid'); $asset_db = new Livingassets_Model_livingassets(); $editAsset = $asset_db->getAssetdetails($id); for ($j = 0; $j < count($editAsset); $j++) { $this->view->adm->addRecord("ourbank_liveassetdetails_log", $editAsset[$j]); } $asset_db->deleteasset($id); $number = $this->_getParam('number'); $value = $this->_getParam('value'); $date = $this->_getParam('date'); $dateconvert = new App_Model_dateConvertor(); $i = 0; foreach ($this->_getParam('assettype') as $val) { if ($date[$i]) { if ($date[$i] == "00/00/0000" or $date[$i] == NULL) { $dates = date("y/m/d H:i:s"); } else { $dates = $dateconvert->mysqlformat($date[$i]); } } else { $dates = date("y/m/d H:i:s"); } if ($value[$i]) { $values = $value[$i]; } else { $values = 0; } $assettype = array('submodule_id' => $submoduleid, 'family_id' => $id, 'liveasset_id' => $val, 'number' => $number[$i], 'date_of_value' => $dates, 'value' => $values); $i++; $this->view->adm->addRecord("ourbank_liveassetdetails", $assettype); } $this->_redirect('/familycommonview/index/commonview/id/' . $id); } else { //set the contact details in the contact form... $sub_id = $this->_getParam('subId'); $id = $this->_getParam('id'); $individualcommon = new Familycommonview_Model_familycommonview(); $this->view->editAsset = $individualcommon->getlivingassetsdetails($id); //$form->populate($editContact[0]); } }
public function withdrawalAction() { $accNum = $this->view->accNum = base64_decode($this->_request->getParam('accNum')); $fixedSavings = new Fixedtransaction_Model_fixedSavings(); $validaccno = $fixedSavings->savingsAccountsSearch($accNum); $MinBalance = $this->view->savingsModel->getminimumbal($accNum); $Balance = $this->view->savingsModel->getbalance($accNum); foreach ($Balance as $balances) { $this->view->balance = $balance = $balances['Balance']; } foreach ($MinBalance as $MinBalan) { $minimumbalance = $MinBalan['minmumdeposit']; } $this->view->limitamount = $balance - $minimumbalance; $this->view->details = $this->view->savingsModel->search($accNum); $this->view->tran = $this->view->savingsModel->transaction($accNum); $form = new Savingswithdrawal_Form_Withdrawal($this->view->accNum, $balance, $minimumbalance); $this->view->form = $form; $mode = $this->view->adm->viewRecord("ourbank_master_paymenttypes", "id", "DESC"); foreach ($mode as $mode) { $form->transactionMode->addMultiOption($mode['id'], $mode['name']); $form->transactionMode1->addMultiOption($mode['id'], $mode['name']); } //if group members if (substr($accNum, 4, 1) == 2 || substr($accNum, 4, 1) == 3) { $this->view->group = $this->view->savingsModel->getMember($accNum); } if ($this->_request->isPost() && $this->_request->getPost('Submit')) { if ($this->_request->getParam('date1')) { $form->transactionMode->setRequired(false); // $form->amount->setRequired(false); $form->description->setRequired(false); $form->date->setRequired(false); $givendate = $this->_request->getParam('date1'); $transactionMode = $this->_request->getParam('transactionMode1'); if ($transactionMode == 1) { $this->view->form->othertext->setRequired(false); $this->view->form->othertext1->setRequired(false); } if ($transactionMode != 1) { $this->view->form->othertext->setRequired(false); $chequeno = $this->_request->getParam('othertext1'); $paymenttype_details = $chequeno; } else { $paymenttype_details = 0; } } else { $form->transactionMode1->setRequired(false); $form->description1->setRequired(false); $form->date1->setRequired(false); $givendate = $this->_request->getParam('date'); $transactionMode = $this->_request->getParam('transactionMode'); if ($transactionMode == 1) { $this->view->form->othertext->setRequired(false); $this->view->form->othertext1->setRequired(false); } if ($transactionMode != 1) { $this->view->form->othertext1->setRequired(false); $chequeno = $this->_request->getParam('othertext'); $paymenttype_details = $chequeno; } else { $paymenttype_details = 0; } } $flag = false; $formData = $this->_request->getPost(); if ($givendate) { $gdate = $this->view->dc->phpmysqlformat($givendate); /* if ( $gdate != date('Y-m-d') ) { $this->view->maxdate= "Date should be current date" ; } else { */ //date validation if ($form->isValid($formData)) { $fixedSavings = new Fixedtransaction_Model_fixedSavings(); if ($transactionMode == '5') { $savingsAccountsSearch = $fixedSavings->savingsAccountsSearch($chequeno); $validaccno = $fixedSavings->savingsAccountsSearchwithid($chequeno); if (!$validaccno) { $this->view->noaccount = "Enter valid saving account number"; $flag = true; } if (!$savingsAccountsSearch) { $form->othertext->setValue(''); $form->othertext1->setValue(''); $flag = true; $this->view->noaccount = "This account number does not exist"; } } if ($flag == false) { $description = $this->_request->getParam('description'); if ($this->_request->getParam('date1')) { $cl = new App_Model_dateConvertor(); $type = 1; $amount = $this->_request->getParam('amount1'); $date = $this->_request->getParam('date1'); $accNum = base64_decode($this->_request->getParam('accNum')); $tranId = $this->view->savingsModel->deposit($this->view->accNum, $amount, $date, $type, $transactionMode, $description, $paymenttype_details, $this->view->createdby); $group = $this->view->savingsModel->getMember($accNum); foreach ($this->view->details as $details) { $accID = $details->accId; } foreach ($group as $Group) { $Accid = $this->view->savingsModel->getAccountid($Group->id); if ($this->_request->getParam($Group->id) != 0) { $trandata = array('transaction_id' => $tranId, 'account_id' => $Accid, 'transaction_date' => $cl->phpmysqlformat($date), 'transaction_type' => 2, 'transaction_amount' => $this->_request->getParam($Group->id), 'member_id' => $Group->id, 'transacted_by' => 1); $this->view->savingsModel->groupWithdrawal($trandata); } } } else { $type = 2; $amount = $this->_request->getParam('amount'); $date = $this->_request->getParam('date'); $accNum = base64_decode($this->_request->getParam('accNum')); $tranId = $this->view->savingsModel->deposit($this->view->accNum, $amount, $date, $type, $transactionMode, $description, $paymenttype_details, $this->view->createdby); } $this->_redirect("/savingswithdrawal/index/message/amt/" . base64_encode($amount) . "/accNum/" . base64_encode($this->view->accNum)); } } // } //date validation } } }
public function editgroupAction() { // check group head , and members are correct if ($this->_request->getParam('error')) { // display error message for wrong head selection $error = $this->_request->getParam('error'); if ($error == 1) { $this->view->error = "Improper Group head selection ! "; } if ($error == 2) { $this->view->error = "Chose single member in a family ! "; } if ($error == 3) { $this->view->error = "Improper Group representatives selection ! "; } if ($error == 4) { $this->view->error = "Maximum 3 members can be a representative in a single group ! "; } if ($error == 5) { $this->view->error = "Chose Bank branch name"; } } $app = $this->view->baseUrl(); $group_id = $this->_getParam('id'); $this->view->groupid = $group_id; $this->view->title = "Edit Group Details"; // create instance for form page with baseurl $addForm = new Groupmdefault_Form_groupdefault($app); $days = $this->view->adm->viewRecord("ourbank_master_weekdays", "id", "ASC"); foreach ($days as $day) { $addForm->day->addMultiOption($day['id'], $day['name']); } $bank = $this->view->adm->viewRecord("ourbank_master_bank", "id", "ASC"); /* foreach($bank as $banks) { $addForm->bank->addMultiOption($banks['id'],$banks['name']); }*/ $branch = $this->view->adm->viewRecord("ourbank_master_branch", "id", "ASC"); foreach ($branch as $branch) { $addForm->branch->addMultiOption($branch['id'], $branch['name']); } $addForm->Submit->setLabel('Update'); $this->view->form = $addForm; $dbobject = new Groupmdefault_Model_Groupdefault(); $hierarchy = $dbobject->getofficehierarchy(); foreach ($hierarchy as $hiearchyids) { $hiearchyid = $hiearchyids['hierarchyid']; } // load office id $officedetails = $this->view->adm->getRecord('ourbank_office', 'officetype_id', $hiearchyid); foreach ($officedetails as $officeiddetails) { $addForm->office->addMultiOption($officeiddetails['id'], $officeiddetails['name']); } $dbobj = new Groupcommonview_Model_groupcommon(); $result = $dbobj->getgroup($group_id); $convertdate = new App_Model_dateConvertor(); // assign values with respective form fields foreach ($result as $group) { $this->view->grouptype = $grouptype = substr($group['groupcode'], 4, 1); $this->view->officeid = $group['officeid']; $addForm->offedit->setValue($group['officename']); $addForm->offeditv->setValue($group['officeid']); $addForm->groupname->setValue($group['groupname']); $addForm->bank->setValue($group['bank_id']); $addForm->branch->setValue($group['branch_id']); $addForm->savingamt->setValue($group['saving_perweek']); $addForm->penaltylate->setValue($group['penalty_latecoming']); $addForm->penaltyabsence->setValue($group['penalty_notcoming']); $addForm->interest->setValue($group['rateinterest']); $addForm->place->setValue($group['place']); $addForm->times->setValue($group['time']); $addForm->day->setValue($group['days']); $addForm->Created_Date->setValue($convertdate->phpnormalformat($group['group_created_date'])); } $dbobj = new Groupmdefault_Model_Groupdefault(); $officeid = $group['officeid']; $banks = $dbobj->Getbank($officeid); // load applicable to values foreach ($banks as $banks) { $addForm->bank->addMultiOption($banks['id'], $banks['name']); } // enable javascript function to load groupmembers echo "<script>getMember('" . $group['officeid'] . "','" . $app . "','" . $group['groupid'] . "','" . $grouptype . "');</script>"; $gacc = array(); $gmembersacc = array(); if ($this->_request->isPost() && $this->_request->getPost('Submit')) { $mem = $this->_request->getPost('member_id'); // get selected members $groupmembersid = $this->view->adm->getRecord('ourbank_groupmembers', 'group_id', $this->view->groupid); // Fetch group members foreach ($groupmembersid as $groupmembers) { $macc = $dbobject->Getaccdetails($groupmembers['member_id']); // Get account id from accounts table foreach ($macc as $memberaccount) { $acc = $memberaccount['id']; // get account id $gacc[] = $acc; $savingdetails = $dbobject->getsavings($acc); // get savings details foreach ($savingdetails as $saving) { if ($saving['Amount'] > 0) { $gmembersacc[] = $groupmembers['member_id']; } } } } if ($gmembersacc) { foreach ($gmembersacc as $gmacc) { $meminfor = $this->view->adm->getRecord('ourbank_familymember', 'id', $gmacc); foreach ($meminfor as $membersinfo) { echo "<font color = 'green' ><b>" . $membersinfo['name'] . "</b> <br> </font>"; } } echo "<font color ='red'> <b>These group members are having valid accounts. you cannot edit the group members.. </b></font>"; } else { $group_head = $_POST['memberhead']; // get group head $representative_id = $_POST['representatives']; $countreps = count($representative_id); $result = ""; $memberids = array(); $famid = array(); $memid = array(); $countvalues = array(); foreach ($mem as $memberid) { $memberids[] = explode('_', $memberid); } foreach ($memberids as $Memberids) { $famid[] = $Memberids[0]; $memid[] = $Memberids[1]; } $result = array_diff($representative_id, $memid); $error = 0; if (in_array($group_head, $memid)) { $results = "ok"; if ($result) { $results = "not ok"; $error = "3"; } if ($countreps > 3) { $results = "not ok"; $error = "4"; } if (!$branch) { $error = "5"; $results = "not ok"; } else { $countvalues[] = array_count_values($famid); foreach ($countvalues[0] as $key => $value) { if ($value > 1) { $results = "not ok"; $error = "2"; } } } } else { $error = "1"; } if ($results == "ok" && $error == 0) { // if ok then get all input values $office_id = $this->_request->getParam('offeditv'); $groupname = $this->_request->getParam('groupname'); $bank = $this->_request->getParam('bank'); $branch = $this->_request->getParam('branch'); $createddate = $this->_request->getParam('Created_Date'); // $latitude = $this->_request->getParam('latitude'); // $longitude = $this->_request->getParam('longitude'); $savingamt = $this->_request->getParam('savingamt'); $penaltyabsence = $this->_request->getParam('penaltyabsence'); $penaltylate = $this->_request->getParam('penaltylate'); $interest = $this->_request->getParam('interest'); $place = $this->_request->getParam('place'); $times = $this->_request->getParam('times'); $day = $this->_request->getParam('day'); $convertdate = new App_Model_dateConvertor(); $createddate = $convertdate->phpmysqlformat($createddate); $date = date("y/m/d H:i:s"); // updation and insertion in Accounts table foreach ($gacc as $gaccountid) { } //get the account id $tagacc = $this->view->adm->getsingleRecord('ourbank_accounts', 'tag_account', 'id', $gaccountid); $data = array('tag_account' => 0, 'status_id' => 0); foreach ($gacc as $gaccountid) { //get the account id $where = array('id = ' . $gaccountid, 'membertype_id = 1'); $dbobject->updateaccount('ourbank_accounts', $data, $where); // make tag account and status id as zero } $individualtypeid = $this->view->adm->getsingleRecord('ourbank_master_membertypes', 'id', 'type', 'Individual'); // get individual type id $productid = $dbobject->getProductid(); $productcode = $productid . 'S'; // // insert accounts value for group members foreach ($memid as $Memid) { $account_ids = $this->view->adm->addRecord("ourbank_accounts", array('id' => '', 'membertype_id' => $individualtypeid, 'begin_date' => $date, 'tag_account' => $tagacc, 'accountcreated_date' => $date, 'created_date' => $createddate, 'created_by' => $this->view->createdby, 'status_id' => 1)); // insert some value to accounts table // // create account number <!--(3)office id--(2)individualtype--(3)productoffer with saving code(6)accountid!> $accountNumber = str_pad($office_id, 3, "0", STR_PAD_LEFT) . str_pad($individualtypeid, 2, "0", STR_PAD_LEFT) . str_pad($productcode, 3, "0", STR_PAD_LEFT) . str_pad($account_ids, 6, "0", STR_PAD_LEFT); $this->view->adm->updateRecord("ourbank_accounts", $account_ids, array('account_number' => $accountNumber, 'member_id' => $Memid, 'product_id' => $productid)); } $groupdetails = $dbobject->getgroupdetails($group_id); // get group details for particular id $this->view->adm->addRecord("ourbank_group_log", $groupdetails[0]); // add group details to log table $glidforabsense = $this->view->adm->getsingleRecord('ourbank_glsubcode', 'id', 'header', 'Absense'); $glidforlate = $this->view->adm->getsingleRecord('ourbank_glsubcode', 'id', 'header', 'Late'); $this->view->adm->updateRecord("ourbank_group", $group_id, array('village_id' => $office_id, 'bank_id' => $bank, 'branch_id' => $branch, 'name' => $groupname, 'saving_perweek' => $savingamt, 'penalty_notcoming' => $penaltyabsence, 'penalty_latecoming' => $penaltylate, 'late_subglcode' => $glidforlate, 'absent_subglcode' => $glidforabsense, 'rateinterest' => $interest, 'place' => $place, 'time' => $times, 'days' => $day, 'head' => $group_head, 'group_created_date' => $date, 'created_by' => $this->view->createdby, 'created_date' => $createddate)); // update group details $groupmemberdetails = $this->view->adm->getRecord('ourbank_groupmembers', 'group_id', $group_id); // get groupmembers details for particular id foreach ($groupmemberdetails as $groupmemberDetails) { $this->view->adm->addRecord("ourbank_groupmembers_log", array('record_id' => '', 'id' => $groupmemberDetails['id'], 'group_id' => $groupmemberDetails['group_id'], 'member_id' => $groupmemberDetails['member_id'], 'groupmember_status' => $groupmemberDetails['groupmember_status'])); } // add group members details to log table $dbobject->UpdateGroupdetails($group_id); // insert group members foreach ($memid as $memberid) { $this->view->adm->addRecord("ourbank_groupmembers", array('id' => '', 'group_id' => $group_id, 'member_id' => $memberid, 'groupmember_status' => 3)); } $grouprepdetails = $this->view->adm->getRecord('ourbank_group_representatives', 'group_id', $group_id); // get groupmembers details for particular id foreach ($grouprepdetails as $grouprepmemDetails) { $this->view->adm->addRecord("ourbank_group_representatives_log", array('record_id' => '', 'id' => $grouprepmemDetails['id'], 'group_id' => $grouprepmemDetails['group_id'], 'representative_id' => $grouprepmemDetails['representative_id'])); } // add group Representative members details to log table $dbobject->UpdateGroupreps($group_id); foreach ($representative_id as $representatives) { $this->view->adm->addRecord("ourbank_group_representatives", array('id' => '', 'group_id' => $group_id, 'representative_id' => $representatives)); ////add representatives with its group id ->($groupid) } $this->_redirect('groupcommonview/index/commonview/id/' . $group_id); } else { // display error message for wrong group head selection $this->_redirect('groupmdefault/index/editgroup/id/' . $group_id . '/error/' . $error); } } } }
public function pdftransactionAction() { //rupees right alignment function position($amt, $posValue) { $len = strlen($amt); $pos = $posValue - 35 - $len * 4; return $pos; } $fromDate = $this->_request->getParam('date'); $branchid = $this->_request->getParam('office'); $this->view->field1 = $fromDate; $this->view->branchid = $branchid; // $fromDate = $this->_request->getParam('field1'); // $this->view->field1 = $fromDate; //date format instance $dateconvertor = new App_Model_dateConvertor(); $cfromDate = $dateconvertor->mysqlformat($fromDate); $pdf = new Zend_Pdf(); $page = $pdf->newPage(Zend_Pdf_Page::SIZE_A4); $pdf->pages[] = $page; //Path $app = $this->view->baseUrl(); $word = explode('/', $app); $projname = $word[1]; // Image $image_name = "/var/www/" . $projname . "/public/images/logo.jpg"; $image = Zend_Pdf_Image::imageWithPath($image_name); $page->drawImage($image, 30, 770, 130, 820); $page->setLineWidth(1)->drawLine(25, 25, 570, 25); //bottom horizontal $page->setLineWidth(1)->drawLine(25, 25, 25, 820); //left vertical $page->setLineWidth(1)->drawLine(570, 25, 570, 820); //right vertical $page->setLineWidth(1)->drawLine(570, 820, 25, 820); //top horizontal $page->setFont(Zend_Pdf_Font::fontWithName(Zend_Pdf_Font::FONT_HELVETICA), 9); $page->drawText("Cash Scroll", 270, 780); $page->drawText("Cash Scroll", 270, 780); //set the font $page->setFont(Zend_Pdf_Font::fontWithName(Zend_Pdf_Font::FONT_HELVETICA), 8); $y1 = 745; $page->drawText("Credit", 50, $y1); $page->drawText("Debit", 310, $y1); $y1 = 745; $y2 = 740; $page->drawText("As of From " . $fromDate, 465, $y1); //For Top Header $text = array("", "SL No.", "Particulars", "Amount", "Total", "Particulars", "Opening Cash", "Closing Cash"); $this->view->savings = 10; $page->drawText("Date : " . date('d-m-Y'), 500, 800); //date('Y-m-d') // $page->drawText("Date : ".date('d-m-Y'),500, 800); $page->drawText($text[0], 240, 780); $page->drawText($text[0], 240, 780); $x1 = 60; $x2 = 120; $x3 = 310; $x4 = 315; $x5 = 390; $x6 = 570; $page->drawLine(50, 740, 550, 740); $page->drawLine(50, 720, 550, 720); $page->drawText($text[1], $x1, 725); $page->drawText($text[2], $x2, 725); $page->drawText($text[3], 250, 725); $page->drawText($text[1], $x4, 725); $page->drawText($text[5], $x5, 725); $page->drawText($text[3], 510, 725); $y1 = 710; $y2 = 710; $transaction = new Cashscroll_Model_Cashscroll(); $this->view->savings = 10; $this->view->savingsCredit = $transaction->totalSavingsCredit($cfromDate, $branchid); $this->view->savingsDebit = $transaction->totalSavingsDebit($cfromDate, $branchid); //Credit and Debit $savingsCredit = $transaction->totalSavingsCredit($cfromDate, $branchid); $savingsDebit = $transaction->totalSavingsDebit($cfromDate, $branchid); // Opening Cash $openingBalance = 0; $osc = $transaction->openingBalance($cfromDate, $branchid); foreach ($osc as $osc1) { $openingBalance = $osc1->openingBalance; } $this->view->openingBalance = $openingBalance; $amountCredit = "0"; $amountDebit = "0"; $i = 0; $j = 0; foreach ($savingsCredit as $savingsCredit) { $i++; $page->drawText($i, $x1, $y1); $page->drawText($savingsCredit->account_number, $x2, $y1); // $page->drawText($savingsCredit->amount_to_bank,$x3, $y1); $pos = position(sprintf("%4.2f", $savingsCredit->amount_to_bank), $x3); $page->drawText(sprintf("%4.2f", $savingsCredit->amount_to_bank), $pos + 2, $y1); $amountCredit = $amountCredit + $savingsCredit->amount_to_bank; $y1 = $y1 - 15; } foreach ($savingsDebit as $savingsDebit) { $j++; $page->drawText($j, $x4, $y2); $page->drawText($savingsDebit->account_number, $x5, $y2); // $page->drawText($savingsDebit->amount_from_bank,$x6, $y2); $pos = position(sprintf("%4.2f", $savingsDebit->amount_from_bank), $x6); $page->drawText(sprintf("%4.2f", $savingsDebit->amount_from_bank), $pos + 2, $y2); $amountDebit = $amountDebit + $savingsDebit->amount_from_bank; $y2 = $y2 - 15; } $page->drawLine(50, $y1, 550, $y1); //opening balnce $page->drawText($text[6], $x1, $y1 - 10); // $page->drawText(sprintf("%4.2f", $openingBalance), $x3, $y1 -10); $pos = position(sprintf("%4.2f", $openingBalance), $x3); $page->drawText(sprintf("%4.2f", $openingBalance), $pos + 2, $y1 - 10); //closing Balance $page->drawText($text[7], $x4, $y1 - 10); // $page->drawText(sprintf("%4.2f", ( $sum = ($amountCredit + $openingBalance) - $amountDebit)), $x6, $y1 -10); $pos = position(sprintf("%4.2f", $sum = $amountCredit + $openingBalance - $amountDebit), $x6); $page->drawText(sprintf("%4.2f", $sum = $amountCredit + $openingBalance - $amountDebit), $pos + 2, $y1 - 10); $page->drawLine(50, $y1 = $y1 - 20, 550, $y1); $page->drawLine(50, $y1 - 20, 550, $y1 - 20); $page->drawText($text[4], $x1, $y1 - 15); $page->drawText($text[4], $x1, $y1 - 15); $pos = position(sprintf("%4.2f", $amountCredit + $openingBalance), $x3); $page->drawText(sprintf("%4.2f", $amountCredit + $openingBalance), $pos + 2, $y1 - 15); // $page->drawText(sprintf("%4.2f", ($amountCredit + $openingBalance)), $x3, $y1 -15); // $page->drawText(sprintf("%4.2f", ($amountCredit + $openingBalance)), $x3, $y1 -15); $page->drawText($text[4], $x4, $y1 - 15); $page->drawText($text[4], $x4, $y1 - 15); // $page->drawText(sprintf("%4.2f", $amountDebit + $sum), $x6, $y1 -15); // $page->drawText(sprintf("%4.2f", $amountDebit + $sum), $x6, $y1 -15); $pos = position(sprintf("%4.2f", $amountDebit + $sum), $x6); $page->drawText(sprintf("%4.2f", $amountDebit + $sum), $pos + 2, $y1 - 15); // Virtual table $page->setLineWidth(1)->drawLine(50, $y1 - 20, 50, 740); //Table left vertical $page->setLineWidth(1)->drawLine(300, $y1 - 20, 300, 740); //Table center vertical $page->setLineWidth(1)->drawLine(550, $y1 - 20, 550, 740); //table rigth vertical //$page->drawText("ಭಾವನಾ. ಕೆ. ಎಸ್ ",$x6 + 30, $y1 -15, 'UTF-8'); $pdfData = $pdf->render(); $pdf->save('/var/www/' . $projname . '/reports/cashscroll.pdf'); $path = '/var/www/' . $projname . '/reports/cashscroll.pdf'; chmod($path, 0777); }
public function insertTran($data, $int, $totalAmt, $intType, $currentinstallment) { $db = Zend_Db_Table::getDefaultAdapter(); $acc = $this->searchaccounts($data["accNum"]); foreach ($acc as $acc) { $accId = $acc->accId; $gl = $acc->gl; $officeid = $acc->officeid; $interest = $acc->interest; $intGl = $acc->intGl; } $cl = new App_Model_dateConvertor(); $tranData = array('account_id' => $accId, 'glsubcode_id_to' => $gl, 'transaction_date' => $cl->phpmysqlformat($data["date"]), 'amount_to_bank' => $data["amount"], 'paymenttype_details' => $data["paymenttype_details"], 'paymenttype_id' => $data["paymentMode"], 'recordstatus_id' => 3, 'transactiontype_id' => 1, 'transaction_description' => "(Repayment) " . $data["description"], 'created_by' => 1); $db->insert("ourbank_transaction", $tranData); $tranId = $db->lastInsertId('id'); // Installment update $sql = "select installment_id from ourbank_installmentdetails where account_id='" . $accId . "' AND installment_status = 4 limit 1"; $idData = $db->fetchAll($sql); foreach ($idData as $idData) { $pram = $idData->installment_id; } //insert into loan repayment if ($intType == 3) { $currentinstallid = $currentinstallment; } else { $currentinstallid = $pram - 1; } $repayData = array('account_id' => $accId, 'transaction_id' => $tranId, 'paid_date' => $cl->phpmysqlformat($data["date"]), 'paid_amount' => $data["amount"], 'paid_principal' => $data["amount"] - $int, 'paid_interest' => $int, 'balanceamount' => $totalAmt - $data["amount"], 'installment_id' => $currentinstallid, 'recordstatus_id' => 3); $db->insert("ourbank_loan_repayment", $repayData); // Insertion into Assets ourbank_Assets Cash Cr entry $glbank = $this->getGlcode($officeid, 'cash' . $officeid); // Insertion into Assets ourbank_Assets cash Cr entry if ($intType != 3) { $assetamount = $data["amount"] - $interest; } else { $assetamount = $data["amount"]; } $assets = array('office_id' => $officeid, 'glsubcode_id_from' => $glbank[0]['id'], 'glsubcode_id_to' => '', 'transaction_id' => $tranId, 'credit' => $assetamount, 'record_status' => 3); $db->insert('ourbank_Assets', $assets); // Insertion into Assets ourbank_Assets productgl Cr entry // $glassets = array('office_id' => $officeid, // 'glsubcode_id_from' => $gl, // 'glsubcode_id_to' => '', // 'transaction_id' => $tranId, // 'credit' => $assetamount, // 'record_status' => 3); // $db->insert('ourbank_Assets',$glassets); if ($intType != 3) { // Insertion into Assets ourbank_Income interest Cr entry $interestledger = $this->getGlcode($officeid, 'interest' . $officeid); $interest = array('office_id' => $officeid, 'glsubcode_id_from' => $interestledger[0]['id'], 'glsubcode_id_to' => '', 'transaction_id' => $tranId, 'credit' => $interest, 'recordstatus_id' => 3); $db->insert('ourbank_Income', $interest); } $monthinterest = $this->findmonthinterest($accId); if ($monthinterest) { $interestledger = $this->getGlcode($officeid, 'interest' . $officeid); $interest = array('office_id' => $officeid, 'glsubcode_id_from' => $interestledger[0]['id'], 'glsubcode_id_to' => '', 'transaction_id' => $tranId, 'credit' => $monthinterest[0]['monthinterest'], 'recordstatus_id' => 3); $db->insert('ourbank_Income', $interest); $input = array('monthend_tag' => 1); $this->accUpdate('ourbank_loan_repayment', 2, $accId, $input, 'monthend_tag'); } //Retuns some variables return array('transaction_id' => $tranId, 'account_id' => $accId, 'paymentMode' => $data["paymentMode"], 'installment_id' => $accId); }
public function attendanceeditAction() { function array_search_values($m_needle, $a_haystack, $b_strict = false) { return array_intersect_key($a_haystack, array_flip(array_keys($a_haystack, $m_needle, $b_strict))); } //Acl // $acl = new App_Model_Acl(); // $access = new App_Model_Access(); // $role = $access->getRole($this->view->id); // // $accessid = $access->accessRights('Attendance',$role,"attendanceeditAction"); // $checkaccess = $acl->isAllowed($role,'Attendance',$accessid); // if(($role) && ($checkaccess != NULL)) { //edit $path = $this->view->baseUrl(); $attendanceform = new Meetingbook_Form_Attendance($path); $this->view->attendanceform = $attendanceform; $this->view->attendance_id = $attendance_id = $this->_request->getParam('attendance_id'); $meeting = new Meeting_Model_Meeting(); $result = $meeting->fetchAllmeetingdetails(); $convertdate = new App_Model_dateConvertor(); //Object for date convertor $fetchattendance = new Meetingbook_Model_Meetingbook(); //listing discussion dropdown $this->view->discussionlist = $fetchattendance->discussionlist(); $this->view->decissionlist = $fetchattendance->decissionlist(); $this->view->editdiscussion = $fetchattendance->getdiscussion($attendance_id); $this->view->editdecision = $fetchattendance->getdecision($attendance_id); $memberattendance = $fetchattendance->fetchmemberttendance($attendance_id); if ($memberattendance) { $fetchattendance1 = $fetchattendance->fetchattendancedetailsforID($attendance_id); } else { $fetchattendance1 = $fetchattendance->fetchattendancedetailsforID1($attendance_id); } // // Zend_Debug::dump($fetchattendance1); $meeting = $this->view->adm->viewRecord("ourbank_group", "id", "DESC"); foreach ($meeting as $meeting1) { $attendanceform->meeting_name->addMultiOption($meeting1['id'], $meeting1['name']); } foreach ($fetchattendance1 as $fetchattendance1) { foreach ($result as $result) { if ($result['id'] == $fetchattendance1['meeting_id']) { $attendanceform->meeting_name->addMultiOption($result['id'], $result['name']); } } //attendance details $this->view->attendanceform->resolution->setValue($fetchattendance1['resolution']); $this->view->groupid = $fetchattendance1['meeting_id']; $this->view->attendanceform->meeting_name->setValue($fetchattendance1['meeting_id']); $this->view->weekno = $fetchattendance1['meetimg']; $this->view->vNo = $vNo = $fetchattendance1['transaction_id']; $this->view->attendanceform->meeting_time->setValue($fetchattendance1['attendancetime']); $this->view->attendanceform->meeting_date->setValue($convertdate->phpnormalformat($fetchattendance1['meeting_date'])); $this->view->attendanceform->notes->setValue($fetchattendance1['notes']); } //Fetches all the memberes in that group of particular meeting ID $transId = $this->view->vNo; echo "<script>getMembers(" . $fetchattendance1['meeting_id'] . ",'" . $path . "'," . $attendance_id . "," . $transId . ");</script>"; echo "<script>getMeeting(" . $fetchattendance1['meeting_id'] . ",'" . $path . "'," . $attendance_id . ");</script>"; //fetch savings details // $this->view->savingsdetails=$this->view->savings->fetchsavingsdetails($vNo); // echo '<pre>'; print_r($this->view->savingsdetails); //update if ($this->_request->isPost() && $this->_request->getPost('Update')) { $attendance_id = $this->_request->getParam('attendance_id'); $member_id = array(); $formData = $this->_request->getPost(); $member_id = $this->_request->getPost('member_id'); $convertdate = new App_Model_dateConvertor(); $meeting_date = $convertdate->phpmysqlformat($formData['meeting_date']); $date = $meeting_date; $accNum = $this->_request->getPost('accNum'); if ($attendanceform->isValid($formData)) { if ($accNum) { $insertattendance = new Meetingbook_Model_Meetingbook(); $member_id = array(); $formData = $this->_request->getPost(); $member_id = $this->_request->getPost('member_id'); $convertdate = new App_Model_dateConvertor(); $meeting_date = $convertdate->phpmysqlformat($formData['meeting_date']); $date = $meeting_date; $amount = $this->_request->getPost('savingspaid'); //insert attendance details $maxid1 = $insertattendance->fetchmaxid($formData['meeting_name']); if ($maxid1[0]['meetingno'] == "") { $maxid = '1'; } else { $maxid = $maxid1[0]['meetingno']; } //savings details insertion $this->view->details = $this->view->savings->search($this->_request->getParam('accNum')); $totsavings = $this->_request->getPost('totsavingspaid'); $description = $this->_request->getPost('notes'); $type = 1; $transactionMode = 1; //update existing transaction id as inactive $this->view->savings->updateRecord("ourbank_transaction", $vNo, array('recordstatus_id' => 2)); $this->view->savings->updateRecord("ourbank_Assets", $vNo, array('record_status' => 2)); $this->view->savings->updateRecord("ourbank_Liabilities", $vNo, array('record_status' => 2)); $this->view->savings->updateRecord1("ourbank_Income", $vNo, array('recordstatus_id' => 2)); //for getting common transaction id $totsavings = $formData['overallpaid']; $groupaccID = $formData['groupaccID']; $tranId = $this->view->savings->getTransactionID($groupaccID, $totsavings, $date, $type, $transactionMode, $description); $this->view->savings->deposit($accNum, $totsavings, $date, $type, $transactionMode, $description, $tranId); foreach ($this->view->details as $details) { $accID = $details->accId; } $group = $this->view->savings->getMember($accNum); $amount = $this->_request->getPost('savingspaid'); //inserting individual members savings $id = 0; foreach ($group as $group) { //echo $group->id; if ($group->id != 0) { $this->_request->getParam($group->id); $this->view->adm->addRecord("ourbank_group_savingstransaction", array('transaction_id' => $tranId, 'account_id' => $accID, 'transaction_date' => $date, 'transaction_type' => 1, 'transaction_amount' => $amount[$id], 'member_id' => $group->id, 'transacted_by' => 1)); $id++; } } //end of savings details insertion //start loan repayment $loanaccNum = $this->_request->getParam('loanaccNum'); //print_r($accNum[0]); $loanamount = $this->_request->getParam('loanpaid'); $this->view->details = $this->view->loanModel->searchaccounts($loanaccNum); $this->view->paid = $this->view->loanModel->paid($loanaccNum); $this->view->unpaid = $this->view->loanModel->unpaid($loanaccNum); $instalments = $this->view->loanModel->loanInstalments($loanaccNum); $increment = 0; foreach ($loanaccNum as $loanaccNum) { if ($loanaccNum) { $data = array('date' => $date, 'amount' => $loanamount[$increment], 'paymentMode' => 1, 'description' => $description, 'accNum' => $loanaccNum, 'transID' => $tranId); $this->view->details = $this->view->loanModel->searchaccounts($loanaccNum); foreach ($this->view->details as $details) { $intType = $details->interesttype; // Intereset type } switch ($intType) { case 1: $int = $this->view->loanModel->declain($data); break; case 2: $int = $this->view->loanModel->emi($data); break; case 3: break; } $array = $this->view->loanModel->insertTran($data); } $increment++; } //end of the loan repayment // for attendance log details $attendancelog = $this->view->adm->getRecord('ourbank_attendance', 'id', $attendance_id); for ($j = 0; $j < count($attendancelog); $j++) { $this->view->adm->addRecord("ourbank_attendance_log", $attendancelog[$j]); } // for member log details $memberlog = $fetchattendance->fetchmemberlog($attendance_id); for ($j = 0; $j < count($memberlog); $j++) { $this->view->adm->addRecord("ourbank_memberattendance_log", $memberlog[$j]); } // for discussion log details $discussionlog = $fetchattendance->fetchdiscussionlog($attendance_id); for ($j = 0; $j < count($discussionlog); $j++) { $this->view->adm->addRecord("ourbank_discussion_log", $discussionlog[$j]); } // for decision log details $decisionlog = $fetchattendance->fetchdecisionlog($attendance_id); for ($j = 0; $j < count($decisionlog); $j++) { $this->view->adm->addRecord("ourbank_decision_log", $decisionlog[$j]); } //update record $fetchattendance->attendance($attendance_id); $updateAttendance = new Meetingbook_Model_Meetingbook(); $member_id = array(); $formData = $this->_request->getPost(); $member_id = $this->_request->getPost('member_id'); $this->view->adm->updateRecord("ourbank_attendance", $attendance_id, array('id' => $attendance_id, 'transaction_id' => $tranId, 'week_no' => $this->view->weekno, 'meeting_id' => $formData['meeting_name'], 'meeting_date' => $meeting_date, 'notes' => $formData['notes'], 'time' => $formData['meeting_time'], 'resolution' => $formData['resolution'], 'created_date' => date("y/m/d H:i:s"), 'created_by' => $this->view->createdby)); $loop = $formData['length']; //-------for absent fee and income --------- for ($i = 0; $i < $loop; $i++) { if (array_search_values('absent_' . $i, $formData)) { $absentees_id[] = array_search_values('absent_' . $i, $formData); } } for ($i = 0; $i < count($absentees_id); $i++) { foreach ($absentees_id[$i] as $key => $value) { //echo $key."<br>"; } } $abs1 = $i * $formData['absentfee']; if ($abs1) { $this->view->adm->addRecord("ourbank_Income", array('Income_id' => '', 'office_id' => $formData['officeid'], 'glsubcode_id_from' => $formData['absentglsubcode'], 'transaction_id' => 1, 'credit' => $abs1, 'recordstatus_id' => 3)); } for ($i = 0; $i < count($absentees_id); $i++) { foreach ($absentees_id[$i] as $key => $value) { if ($key) { $this->view->adm->addRecord("ourbank_memberattendance", array('id' => '', 'attendance_id' => $attendance_id, 'member_id' => $key, 'attendance_type' => 1, 'created_date' => date("y/m/d H:i:s"))); } } } //-------for late fee and income --------- for ($j = 0; $j < $loop; $j++) { if (array_search_values('late_' . $j, $formData)) { $latemember_id[] = array_search_values('late_' . $j, $formData); } } for ($j = 0; $j < count($latemember_id); $j++) { foreach ($latemember_id[$j] as $key => $value) { //echo $key."<br>"; } } $abs2 = $j * $formData['latefee']; if ($abs2) { $this->view->adm->addRecord("ourbank_Income", array('Income_id' => '', 'office_id' => $formData['officeid'], 'glsubcode_id_from' => $formData['lateglsubcode'], 'transaction_id' => 1, 'credit' => $abs2, 'recordstatus_id' => 3)); } for ($j = 0; $j < count($latemember_id); $j++) { foreach ($latemember_id[$j] as $key => $value) { if ($key) { $this->view->adm->addRecord("ourbank_memberattendance", array('id' => '', 'attendance_id' => $attendance_id, 'member_id' => $key, 'attendance_type' => 2, 'created_date' => date("y/m/d H:i:s"))); } } } //insert discussion table $discussion = $this->_request->getPost('discussionlist'); if ($discussion) { foreach ($discussion as $discussion1) { $this->view->adm->addRecord("ourbank_discussion", array('id' => '', 'attendance_id' => $attendance_id, 'discussion_id' => $discussion1, 'created_date' => date("y/m/d H:i:s"))); } } //insert decision table $decision = $this->_request->getPost('decisionlist'); if ($decision) { foreach ($decision as $decision1) { $this->view->adm->addRecord("ourbank_decision", array('id' => '', 'attendance_id' => $attendance_id, 'decision_id' => $decision1, 'created_date' => date("y/m/d H:i:s"))); } } $this->_redirect('meetingbookindex/index'); } } else { $this->view->result = "<p style='color:red'>This Group Savings Account is closed<p>"; } } // } else { // $this->_redirect('index/index'); // } }
public function savingseditAction() { $this->view->title = "Edit Savings"; $offerproduct_id = base64_decode($this->_getParam('id')); $this->view->offerid = $offerproduct_id; $systemDate = date('Y-m-d'); $savingsForm = new Savings_Form_Savings(); $this->view->form = $savingsForm; $offerproduct = new Savings_Model_Savings(); $convertdate = new App_Model_dateConvertor(); $this->view->offerproduct_id = $offerproduct_id; $this->view->currentdates = $systemDate; $savingsForm->Submit->setName('Update'); $savingsForm->offerproductname->removeValidator('Db_NoRecordExists'); $offerProductshortname = $offerproduct->offerProductshortname($offerproduct_id); foreach ($offerProductshortname as $shortname) { $offerproduct_shortname = $shortname['shortname']; $this->view->shortname = $offerproduct_shortname; $this->view->productshortname = $offerproduct_shortname; $savingsForm->offerproductname->setValue($shortname['name']); $this->view->FDproductid = $shortname['product_id']; } // load applicable to values $applicableto = $offerproduct->fetchAllMemberType(); foreach ($applicableto as $applicableto) { $savingsForm->applicableto->addMultiOption($applicableto['id'], $applicableto['type']); } // // load glsubcode id values // $glsubcode = $offerproduct->fetchAllglsubcode('Liabilities'); // foreach($glsubcode as $glsubcode) { // $savingsForm->glsubcode_id->addMultiOption($glsubcode->id,$glsubcode->header." -[".$glsubcode->glsubcode."]"); // } // load frequency of deposit values $select = $offerproduct->fetchAllTimeFrequencyType(); foreach ($select as $timefrequencytype) { $savingsForm->frequencyofdeposit->addMultiOption($timefrequencytype['id'], $timefrequencytype['name']); $savingsForm->Int_timefrequency_id->addMultiOption($timefrequencytype['id'], $timefrequencytype['name']); } // set all form field values $result = $offerproduct->viewofferProduct($offerproduct_id, $this->view->shortname); foreach ($result as $saving) { $this->view->form->savingproductname->setValue($saving['productname']); $this->view->form->offerproductname->setValue($saving['pname']); $this->view->form->offerproductshortname->setValue($saving['psname']); $this->view->form->offerproduct_description->setValue($saving['description']); $bdate = $convertdate->phpnormalformat($saving['begindate']); $this->view->form->begindate->setValue($bdate); $cdate = $convertdate->phpnormalformat($saving['closedate']); $this->view->form->closedate->setValue($cdate); $this->view->form->applicableto->setValue($saving['applicableto']); // $this->view->form->glsubcode_id->setValue($saving['glsubcode_id']); } if ($this->view->shortname == 'ps') { $this->view->form->minmumdeposit->setValue($saving['minmumdeposit']); $this->view->form->frequencyofdeposit->setValue($saving['frequencyofdeposit']); $this->view->form->Int_timefrequency_id->setValue($saving['Int_timefrequency_id']); $this->view->form->frequencyofinterestupdating->setValue($saving['frequencyofinterestupdating']); $this->view->form->minimumbalanceforinterest->setValue($saving['minimumbalanceforinterest']); } if ($this->view->shortname == 'fd' || $this->view->shortname == 'rd') { $this->view->form->minimum_deposit_amount->setValue($saving['minimum_deposit_amount']); $this->view->form->maximum_deposit_amount->setValue($saving['maximum_deposit_amount']); $this->view->form->frequency_of_deposit->setValue($saving['frequency_of_deposit']); $this->view->form->penal_Interest->setValue($saving['penal_Interest']); $frequency_of_deposit = $offerproduct->fetchAllTimeFrequencyType(); foreach ($frequency_of_deposit as $frequencyofdeposit) { $savingsForm->frequency_of_deposit->addMultiOption($frequencyofdeposit['id'], $frequencyofdeposit['name']); } } $interestperiods = $offerproduct->viewinterest($this->view->offerproduct_id); $this->view->viewinterest = $interestperiods; if ($this->_request->isPost() && $this->_request->getPost('Update')) { $formData = $this->_request->getPost(); $interestperiods = new Savings_Model_Savings(); // // // // if ($this->_request->isPost()) { $productshortname = $this->_request->getParam('shortname'); $offerproductid = $this->_request->getParam('offerproduct_id'); $Count = $this->_request->getParam('count'); $memberCount = $this->_request->getParam('memberCount'); $month = 'months'; $closeddate = $this->_request->getParam('closedate'); if ($productshortname == 'ps') { //make it as non mandatory fields $savingsForm->closedate->setRequired(false); $savingsForm->minimum_deposit_amount->setRequired(false); $savingsForm->maximum_deposit_amount->setRequired(false); $savingsForm->frequency_of_deposit->setRequired(false); $savingsForm->penal_Interest->setRequired(false); } else { //make it as non mandatory fields $savingsForm->minmumdeposit->setRequired(false); $savingsForm->frequencyofdeposit->setRequired(false); $savingsForm->Int_timefrequency_id->setRequired(false); $savingsForm->frequencyofinterestupdating->setRequired(false); $savingsForm->minimumbalanceforinterest->setRequired(false); } $existintid = array(); $interestForProduct = $this->view->adm->getRecord("ourbank_interest_periods", 'offerproduct_id', $offerproductid); foreach ($interestForProduct as $interestids) { $existintid[] = $interestids['id']; } // // // if ($savingsForm->isValid($this->_request->getPost())) { // // // // // Zend_Debug::dump($formData); $previousdata = $this->view->adm->editRecord("ourbank_productsoffer", $offerproductid); // get products offer details $result = $offerproduct->addofferproduct1($previousdata[0], $offerproductid); // insert into products offer details to log table $glcodes = $this->view->adm->getsingleRecord('ourbank_productsoffer', 'glsubcode_id', 'id', $offerproductid); $offerproduct->updateRecordpoffer($offerproductid, $formData, $this->view->shortname, $glcodes); // //if the record is belongs to personal savings if ($productshortname == 'ps') { $previousdataps = $this->view->adm->getRecord("ourbank_productssaving", 'productsoffer_id', $offerproductid); // get products saving details $result = $offerproduct->addofferproductsavingslog($previousdataps[0], $offerproductid); //Insert Products saving details to log table $offerproduct->updateRecordps($offerproductid, $formData); } else { $previousdatafd = $this->view->adm->getRecord("ourbank_product_fixedrecurring", 'productsoffer_id', $offerproductid); // get products saving details $result = $offerproduct->fixedrecurringlog($previousdatafd[0], $offerproductid); //Insert Products // saving details to log table $offerproduct->updateRecordfd($offerproductid, $formData); } $interestrecord = $offerproduct->getRecord($offerproductid); //get interest details foreach ($interestrecord as $intrecord) { $interestdata = array('record_id' => '', 'id' => $intrecord['id'], 'period_ofrange_monthfrom' => $intrecord['period_ofrange_monthfrom'], 'period_ofrange_monthto' => $intrecord['period_ofrange_monthto'], 'period_ofrange_description' => $intrecord['period_ofrange_description'], 'offerproduct_id' => $intrecord['offerproduct_id'], 'Interest' => $intrecord['Interest'], 'intereststatus_id' => 3); $result = $offerproduct->addinterestlog('ourbank_interest_periods_log', $interestdata); } // // // insert interest values if ($Count != 0) { $i = 0; foreach ($existintid as $existintids) { $i++; if ($i <= $Count) { $From = $this->_request->getParam('ifrom' . $i); $To = $this->_request->getParam('iTo' . $i); $Rate = $this->_request->getParam('iRate' . $i); $month = 'months'; $period_ofrange_description = $From . -$To . $month; $interestvalue = array('period_ofrange_monthfrom' => $From, 'period_ofrange_monthto' => $To, 'period_ofrange_description' => $period_ofrange_description, 'offerproduct_id' => $offerproductid, 'Interest' => $Rate, 'intereststatus_id' => 3); $offerproduct->updateinterest($interestvalue, $existintids); } } } if ($memberCount != 0) { for ($i = 1; $i <= $memberCount; $i++) { $From = $this->_request->getParam('memberName' . $i); $To = $this->_request->getParam('To' . $i); $Rate = $this->_request->getParam('Rate' . $i); $month = 'months'; $period_ofrange_description = $From . -$To . $month; if ($From) { $interestperiod = $this->view->adm->addRecord('ourbank_interest_periods', array('id' => '', 'period_ofrange_monthfrom' => $From, 'period_ofrange_monthto' => $To, 'period_ofrange_description' => $period_ofrange_description, 'offerproduct_id' => $offerproductid, 'Interest' => $Rate, 'intereststatus_id' => 3)); } } } $this->_redirect('savings/index'); } }
public function pdftransactionAction() { $app = $this->view->baseUrl(); $word = explode('/', $app); $projname = $word[1]; $Date = $this->_request->getParam('field1'); $branch = $this->_request->getParam('field2'); $officer = $this->_request->getParam('field3'); $resulttitle = $this->_request->getParam('result'); $branchname = new Overduelist_Model_Overduelist(); $dateconvertor = new App_Model_dateConvertor(); $this->view->date1 = $dateconvertor->normalformat($Date); $this->view->field1 = $Date; $result = $branchname->getbanknames($branch); $this->view->val = 10; $bankname = $branchname->getbanknames($branch); foreach ($bankname as $bankname1) { $this->view->bankname = $bankname1['name']; } $officename = $branchname->getofficername($officer); foreach ($officename as $officename1) { $this->view->officername = $officename1['name']; } $pdf = new Zend_Pdf(); $page = $pdf->newPage(Zend_Pdf_Page::SIZE_A4); $pdf->pages[] = $page; // Image $image_name = "/var/www/" . $projname . "/public/images/logo.jpg"; $image = Zend_Pdf_Image::imageWithPath($image_name); //$page->drawImage($image, 25, 770, 570, 820); $page->drawImage($image, 30, 770, 130, 820); $page->setLineWidth(1)->drawLine(25, 25, 570, 25); //bottom horizontal $page->setLineWidth(1)->drawLine(25, 25, 25, 820); //left vertical $page->setLineWidth(1)->drawLine(570, 25, 570, 820); //right vertical $page->setLineWidth(1)->drawLine(570, 820, 25, 820); //top horizontal //set the font $page->setFont(Zend_Pdf_Font::fontWithName(Zend_Pdf_Font::FONT_HELVETICA), 8); $text = array("Over due list", "Account Number", "Number of overdue", "Age(in days)", "OverDue Amount", "Total", "Outstanding Balance", "From Date:", "To Date:", "There is not Outstanding Balance in between two dates"); $x1 = 80; $x2 = 250; $x3 = 220; $x4 = 320; $x6 = 450; $y1 = 700; $page->drawLine(50, 740, 550, 740); $page->drawLine(50, 720, 550, 720); $page->drawText($text[0], $x2, 770); $page->drawText($text[1], $x1, 725); $page->drawText($text[2], $x3, 725); $page->drawText($text[3], $x4, 725); if ($this->view->officername) { $page->drawText("Loan officer: " . $this->view->officername, $x6, 745); } if ($this->view->bankname) { $page->drawText("Bank: " . $this->view->bankname, $x6, 755); } $page->drawText("As of " . $this->view->date1, $x6, 765); $page->drawText("Amount in Rs", $x1, 745); $page->drawText($text[4], $x6, 725); $arrayLoan = $branchname->search($Date, $branch, $officer); $this->view->loanView = $arrayLoan; $outstanding_amount = "0"; foreach ($arrayLoan as $loanduelist) { $outstanding_amount += $loanduelist['overdue']; $page->drawText($loanduelist['account_number'], $x1, $y1); $pos = $dateconvertor->position($loanduelist['totalinstallments'], $x4 - 20); $page->drawText($loanduelist['totalinstallments'], $pos + 2, $y1); $pos = $dateconvertor->position($dateconvertor->dateDiff($loanduelist['installment_date'], $Date), $x6 - 70); $page->drawText($dateconvertor->dateDiff($loanduelist['installment_date'], $Date), $pos + 2, $y1); $pos = $dateconvertor->position(sprintf("%4.2f", $loanduelist['overdue']), 540); $page->drawText(sprintf("%4.2f", $loanduelist['overdue']), $pos + 2, $y1); //$page->drawText($loanduelist['overdue'],$x6, $y1); $y1 -= 15; } $page->drawLine(50, $y1, 550, $y1); $y2 = $y1 - 10; $page->drawText($text[5], $x1, $y2); $pos = $dateconvertor->position(sprintf("%4.2f", $outstanding_amount), 540); $page->drawText(sprintf("%4.2f", $outstanding_amount), $pos + 2, $y1 - 10); // $page->drawText($outstanding_amount, $x6, $y2); $y3 = $y2 - 5; $page->drawLine(50, $y3, 550, $y3); $pdfData = $pdf->render(); $pdf->save('/var/www/' . $projname . '/reports/overduelist.pdf'); $path = '/var/www/' . $projname . '/reports/overduelist.pdf'; chmod($path, 0777); //$this->_redirect('/reports/loandue'); }
function pdftransactionAction() { $app = $this->view->baseUrl(); $word = explode('/', $app); $projname = ''; for ($i = 0; $i < count($word); $i++) { if ($i > 0 && $i < count($word) - 1) { $projname .= '/' . $word[$i]; } } $Dispdate = $this->_request->getParam('field1'); $this->view->field1 = $Dispdate; $dateconvertor = new App_Model_dateConvertor(); $Date = $dateconvertor->mysqlformat($Dispdate); $title1 = $this->view->translate('Loan Supplementary'); $this->view->pageTitle = $title1; $pdf = new Zend_Pdf(); $page = $pdf->newPage(Zend_Pdf_Page::SIZE_A4); $pdf->pages[] = $page; // Image $image_name = "/var/www/" . $projname . "/public/images/logo.jpg"; $image = Zend_Pdf_Image::imageWithPath($image_name); //$page->drawImage($image, 25, 770, 570, 820); $page->drawImage($image, 20, 780, 120, 830); $page->setLineWidth(1)->drawLine(20, 20, 580, 20); //bottom horizontal $page->setLineWidth(1)->drawLine(20, 20, 20, 830); //left vertical $page->setLineWidth(1)->drawLine(580, 25, 580, 830); //right vertical $page->setLineWidth(1)->drawLine(20, 830, 580, 830); //top horizontal //set the font $page->setFont(Zend_Pdf_Font::fontWithName(Zend_Pdf_Font::FONT_HELVETICA), 8); $text = array($this->view->translate('Loan Supplementary'), $this->view->translate('Sl'), $this->view->translate('Particulars'), $this->view->translate('A/C No.'), $this->view->translate('Cash'), $this->view->translate('Transfer'), $this->view->translate('Total')); $criteria = $this->view->translate('As of') . $Dispdate; $currency = "* " . $this->view->translate('Amount in Rs'); $this->view->savings = 10; // $page->drawText("Date : ".date('d/m/Y'),500, 800); //date('Y-m-d') // $page->drawText("Date : ".date('d/m/Y'),500, 800); $page->drawText($text[0], 200, 780); $page->drawText($text[0], 200, 780); $page->drawText($criteria, 500, 780); //Search criteria $page->drawText($criteria, 500, 780); $page->drawText($currency, 500, 770); //Currency $page->drawText($currency, 500, 770); $my = 735; $x1 = 33; $x2 = 45; $x3 = 135; $x4 = 170; $x5 = 210; $x6 = 260; $x7 = 300; $x8 = 312; $x9 = 402; $x10 = 437; $x11 = 477; $x12 = 530; $page->drawLine(30, 750, 570, 750); $page->drawLine(30, 730, 570, 730); $page->drawText($text[1], $x1, $my); $page->drawText($text[2], $x2, $my); $page->drawText($text[3], $x3, $my); $page->drawText($text[4], $x4, $my); $page->drawText($text[5], $x5, $my); $page->drawText($text[6], $x6, $my); $page->drawText($text[1], $x7, $my); $page->drawText($text[2], $x8, $my); $page->drawText($text[3], $x9, $my); $page->drawText($text[4], $x10, $my); $page->drawText($text[5], $x11, $my); $page->drawText($text[6], $x12, $my); $y1 = 710; $y2 = 710; $this->view->loan = 10; $transaction = new Loansupplementary_Model_Loansupplementary(); // //Loan Account Credit and Debit $loanCredit = $transaction->totalloanCredit($Date); $this->view->loanCredit = $loanCredit; $loanDebit = $transaction->totalloanDebit($Date); $this->view->loanDedit = $loanDebit; $totalCredit = "0"; $totalTransferCredit = "0"; $totalDebit = "0"; $totalTransferDebit = "0"; $i = 0; $columntotal1 = 0; $columntotal = 0; $columntotald = 0; $columntotald1 = 0; foreach ($loanCredit as $loansCredit) { $i++; $columntotal = 0; if ($loansCredit->paymenttype_id == 1 or $loansCredit->paymenttype_id == 5) { $page->drawText($i, $x1, $y1); $productname = "To " . $loansCredit->account_number; $page->drawText($productname, $x2, $y1); $page->drawText($loansCredit->account_id, $x3, $y1); if ($loansCredit->paymenttype_id == 1) { $page->drawText($loansCredit->amount_to_bank, $x4, $y1); $totalCredit = $totalCredit + $loansCredit->amount_to_bank; $columntotal += $loansCredit->amount_to_bank; } elseif ($loansCredit->paymenttype_id == 5) { $page->drawText($loansCredit->amount_to_bank, $x5, $y1); $totalTransferCredit = $totalTransferCredit + $loansCredit->amount_to_bank; $columntotal += $loansCredit->amount_to_bank; } $page->drawText(sprintf("%4.2f", $columntotal), $x6, $y1); $page->drawText(sprintf("%4.2f", $columntotal), $x6, $y1); $columntotal1 += $columntotal; $y1 = $y1 - 15; } } $i = 0; foreach ($loanDebit as $loansDebit) { $i++; $columntotald = 0; if ($loansDebit->paymenttype_id == 1 or $loansDebit->paymenttype_id == 5) { $page->drawText($i, $x7, $y2); $productnamed = "By " . $loansDebit->account_number; $page->drawText($productnamed, $x8, $y2); $page->drawText($loansDebit->account_id, $x9, $y2); if ($loansDebit->paymenttype_id == 1) { $page->drawText($loansDebit->amount_from_bank, $x10, $y2); $totalDebit = $totalCredit + $loansDebit->amount_from_bank; $columntotald += $loansDebit->amount_from_bank; } elseif ($loansDebit->paymenttype_id == 5) { $page->drawText($loansDebit->amount_from_bank, $x11, $y2); $totalTransferDebit = $totalTransferDebit + $loansDebit->amount_from_bank; $columntotald += $loansDebit->amount_from_bank; } $page->drawText(sprintf("%4.2f", $columntotald), $x12, $y2); $page->drawText(sprintf("%4.2f", $columntotald), $x12, $y2); $columntotald1 += $columntotald; $y2 = $y2 - 15; } } $page->drawLine(30, $y1, 570, $y1); $page->drawLine(30, $y1 - 20, 570, $y1 - 20); $page->drawText($text[6], $x1, $y1 - 15); $page->drawText($text[6], $x1, $y1 - 15); if ($totalCredit != "0") { $page->drawText(sprintf("%4.2f", $totalCredit), $x4, $y1 - 15); $page->drawText(sprintf("%4.2f", $totalCredit), $x4, $y1 - 15); } else { $page->drawText("----", $x4, $y1 - 15); $page->drawText("----", $x4, $y1 - 15); } if ($totalTransferCredit != "0") { $page->drawText(sprintf("%4.2f", $totalTransferCredit), $x5, $y1 - 15); $page->drawText(sprintf("%4.2f", $totalTransferCredit), $x5, $y1 - 15); } else { $page->drawText("----", $x5, $y1 - 15); $page->drawText("----", $x5, $y1 - 15); } if ($columntotal1 != "0") { $page->drawText(sprintf("%4.2f", $columntotal1), $x6, $y1 - 15); $page->drawText(sprintf("%4.2f", $columntotal1), $x6, $y1 - 15); } else { $page->drawText("----", $x6, $y1 - 15); $page->drawText("----", $x6, $y1 - 15); } if ($totalDebit != "0") { $page->drawText(sprintf("%4.2f", $totalDebit), $x10, $y1 - 15); $page->drawText(sprintf("%4.2f", $totalDebit), $x10, $y1 - 15); } else { $page->drawText("----", $x10, $y1 - 15); $page->drawText("----", $x10, $y1 - 15); } if ($totalTransferDebit != "0") { $page->drawText(sprintf("%4.2f", $totalTransferDebit), $x11, $y1 - 15); $page->drawText(sprintf("%4.2f", $totalTransferDebit), $x11, $y1 - 15); } else { $page->drawText("----", $x11, $y1 - 15); $page->drawText("----", $x11, $y1 - 15); } if ($columntotald1 != "0") { $page->drawText(sprintf("%4.2f", $columntotald1), $x12, $y1 - 15); $page->drawText(sprintf("%4.2f", $columntotald1), $x12, $y1 - 15); } else { $page->drawText("----", $x12, $y1 - 15); $page->drawText("----", $x12, $y1 - 15); } // Virtual table $page->setLineWidth(1)->drawLine(30, $y1 - 20, 30, 750); //Table left vertical $page->setLineWidth(1)->drawLine(298, $y1 - 20, 298, 750); //Table center vertical $page->setLineWidth(1)->drawLine(570, $y1 - 20, 570, 750); //table rigth vertical $pdfData = $pdf->render(); $pdf->save('/var/www/' . $projname . '/reports/loansupplementary.pdf'); $path = '/var/www/' . $projname . '/reports/loansupplementary.pdf'; chmod($path, 0777); }
public function editcropAction() { $this->view->title = $this->view->translate('Edit Contact'); $this->view->title = $this->view->translate('Add Crop'); //Base line data $familycommon = new Familycommonview_Model_familycommonview(); $this->view->memberid = $this->_getParam('id'); $this->view->membername = $familycommon->getfamily($this->_getParam('id')); //agriculture view $this->view->agriculture = $edit_agriculture = $familycommon->getagriculturedetails($this->_getParam('id')); $this->view->acretotal = $familycommon->getacretotal($this->_getParam('id')); $this->view->guntatotal = $familycommon->getguntatotal($this->_getParam('id')); $revvillageid = $this->view->membername[0]['rev_village_id']; if ($revvillageid) { $revvillagename = $this->view->adm->editRecord("ourbank_master_villagelist", $revvillageid); } //getting module id and submodule id $module = $familycommon->getmodule('Family'); foreach ($module as $module_id) { } $this->view->mod_id = $module_id['parent']; $this->view->sub_id = $module_id['module_id']; $this->view->insurance = $familycommon->getinsurance($this->_getParam('id')); //load crop details form with two arguments ... $form = new Crop_Form_Crop($this->_getParam('id'), $this->_getParam('subId')); $this->view->form = $form; $this->view->id = $this->_getParam('id'); $this->view->submitform = new Crop_Form_Submit(); //dynamically change the path name $addressmodel = new Address_Model_addressInformation(); $module_name = $addressmodel->getmodule($this->view->subId); foreach ($module_name as $module_view) { $path1 = $module_view['module_description'] . 'commonview'; } $path1 = $this->view->path1 = strtolower($path1); $crop = new Crop_Model_Crop(); $this->view->cropdetails = $crop->getCrop(); $this->view->seasondetails = $crop->getSeason(); $this->view->units = $crop->getUnits(); //update contact details if ($this->_request->getPost('submit')) { $formdata = $this->_request->getPost(); // echo '<pre>'; print_r($formdata); // if($formdata['enteredacre']>=$formdata['availableacre']){ // $this->view->errormsg="<p style='color:red;'>The Entered acres should be less than or equal to ".$formdata['availableacre']; // } else { $id = $this->_getParam('id'); $crop = new Crop_Model_Crop(); $editCrop = $crop->getCropdetails($id); for ($j = 0; $j < count($editCrop); $j++) { $this->view->adm->addRecord("ourbank_cropdetails_log", $editCrop[$j]); } $crop->deletecrop($id); $tenant = $this->_getParam('tenant'); $acer = $this->_getParam('acre'); $gunta = $this->_getParam('gunta'); $season = $this->_getParam('season'); $unit = $this->_getParam('unit'); $quantity = $this->_getParam('quantity'); $marketed = $this->_getParam('marketed'); $price = $this->_getParam('price'); $realised = $this->_getParam('realised'); $soldDate = $this->_getParam('date'); $dateconvert = new App_Model_dateConvertor(); $i = 0; foreach ($this->_getParam('crop_id') as $val) { if ($soldDate[$i]) { if ($soldDate[$i] == "00/00/0000" or $soldDate[$i] == NULL) { $date = date("y/m/d H:i:s"); } else { $date = $dateconvert->mysqlformat($soldDate[$i]); } } else { echo $date = date("y/m/d H:i:s"); } $crop = array('family_id' => $id, 'crop_id' => $val, 'land_id' => $tenant[$i], 'season_id' => $season[$i], 'acre' => $acer[$i], 'gunta' => $gunta[$i], 'unit' => $unit[$i], 'quantity' => $quantity[$i], 'marketed' => $marketed[$i], 'price' => $price[$i], 'realised' => $realised[$i], 'sold_date' => $date); $i++; $this->view->adm->addRecord("ourbank_cropdetails", $crop); } $this->_redirect('/familycommonview/index/commonview/id/' . $id); // } } else { //set the contact details in the contact form... $sub_id = $this->_getParam('subId'); $id = $this->_getParam('id'); $individualcommon = new Familycommonview_Model_familycommonview(); $this->view->editCrop = $individualcommon->getcrop($this->_getParam('id')); } }
public function addofferproduct($post, $product_id, $closeddate, $glsubcodeid) { // instance to convert date $convertdate = new App_Model_dateConvertor(); // $user_id = $sessionName->primaryuserid; if ($closeddate == "") { $CLOSEDDATE = "0000-00-00"; } else { $CLOSEDDATE = $convertdate->phpmysqlformat($closeddate); } // if($post['feeglcode'] == "") { // $feesubcode = ''; // } else { // $feesubcode = $post['feeglcode']; // } $data = array('id' => '', 'name' => $post['offerproductname'], 'shortname' => $post['offerproductshortname'], 'product_id' => $product_id, 'description' => $post['offerproduct_description'], 'begindate' => $convertdate->phpmysqlformat($post['begindate']), 'closedate' => $CLOSEDDATE, 'applicableto' => $post['applicableto'], 'glsubcode_id' => $glsubcodeid, 'capital_glsubcode_id' => '', 'Interest_glsubcode_id' => ''); // 'fee_glsubcode_id'=>$feesubcode); $this->insert($data); //insert pffer details }
public function attendanceeditAction() { //Acl // $acl = new App_Model_Acl(); // $access = new App_Model_Access(); // $role = $access->getRole($this->view->id); // // $accessid = $access->accessRights('Attendance',$role,"attendanceeditAction"); // $checkaccess = $acl->isAllowed($role,'Attendance',$accessid); // if(($role) && ($checkaccess != NULL)) { //edit $path = $this->view->baseUrl(); $attendanceform = new Attendance_Form_Attendance($path); $this->view->attendanceform = $attendanceform; $this->view->attendance_id = $attendance_id = $this->_request->getParam('attendance_id'); $meeting = new Meeting_Model_Meeting(); $result = $meeting->fetchAllmeetingdetails(); $convertdate = new App_Model_dateConvertor(); //Object for date convertor $fetchattendance = new Attendance_Model_Attendance(); //listing discussion dropdown $this->view->discussionlist = $fetchattendance->discussionlist(); $this->view->decissionlist = $fetchattendance->decissionlist(); //dropdown //$this->view->editdiscussion=$this->view->adm->viewRecord("ourbank_discussion",$attendance_id,'asc'); $this->view->editdiscussion = $fetchattendance->getdiscussion($attendance_id); $this->view->editdecision = $fetchattendance->getdecision($attendance_id); $memberattendance = $fetchattendance->fetchmemberttendance($attendance_id); //print_r($memberattendance); if ($memberattendance) { $fetchattendance1 = $fetchattendance->fetchattendancedetailsforID($attendance_id); //echo '<pre>'; print_r($fetchattendance1); } else { $fetchattendance1 = $fetchattendance->fetchattendancedetailsforID1($attendance_id); //echo '<pre>'; } //foreach($fetchattendance1 as $fetchattendance2) { $getMemberID[]=$fetchattendance2['member_id'];} $meeting = $this->view->adm->viewRecord("ourbank_meeting", "id", "DESC"); //echo '<pre>'; print_r($meeting); foreach ($meeting as $meeting1) { $attendanceform->meeting_name->addMultiOption($meeting1['id'], $meeting1['name']); } foreach ($fetchattendance1 as $fetchattendance1) { foreach ($result as $result) { if ($result['id'] == $fetchattendance1['meeting_id']) { $attendanceform->meeting_name->addMultiOption($result['id'], $result['name']); } } //dropdown weekdays // $days = $this->view->adm->viewRecord("ourbank_master_weekdays","id","ASC"); // foreach($days as $days) { // $attendanceform->meeting_day->addMultiOption($days['id'],$days['name']); // } //attendance details $this->view->attendanceform->resolution->setValue($fetchattendance1['resolution']); $this->view->attendanceform->meeting_name->setValue($fetchattendance1['meeting_id']); $this->view->attendanceform->meeting_time->setValue($fetchattendance1['attendancetime']); //echo $fetchattendance1['day']; $this->view->attendanceform->meeting_date->setValue($convertdate->phpnormalformat($fetchattendance1['meeting_date'])); $this->view->attendanceform->notes->setValue($fetchattendance1['notes']); } //Fetches all the memberes in that group of particular meeting ID echo "<script>getMembers(" . $fetchattendance1['meeting_id'] . ",'" . $path . "'," . $attendance_id . ");</script>"; echo "<script>getMeeting(" . $fetchattendance1['meeting_id'] . ",'" . $path . "'," . $attendance_id . ");</script>"; //update if ($this->_request->isPost() && $this->_request->getPost('Update')) { $attendance_id = $this->_request->getParam('attendance_id'); $member_id = array(); $formData = $this->_request->getPost(); $member_id = $this->_request->getPost('member_id'); $convertdate = new App_Model_dateConvertor(); $meeting_date = $convertdate->phpmysqlformat($formData['meeting_date']); // for attendance log details $attendancelog = $this->view->adm->getRecord('ourbank_attendance', 'id', $attendance_id); for ($j = 0; $j < count($attendancelog); $j++) { $this->view->adm->addRecord("ourbank_attendance_log", $attendancelog[$j]); } // for member log details $memberlog = $fetchattendance->fetchmemberlog($attendance_id); for ($j = 0; $j < count($memberlog); $j++) { //echo '<pre>'; print_r($memberlog[$j]); $this->view->adm->addRecord("ourbank_memberattendance_log", $memberlog[$j]); } // for discussion log details $discussionlog = $fetchattendance->fetchdiscussionlog($attendance_id); for ($j = 0; $j < count($discussionlog); $j++) { $this->view->adm->addRecord("ourbank_discussion_log", $discussionlog[$j]); } // for decision log details $decisionlog = $fetchattendance->fetchdecisionlog($attendance_id); for ($j = 0; $j < count($decisionlog); $j++) { $this->view->adm->addRecord("ourbank_decision_log", $decisionlog[$j]); } //update record $fetchattendance->attendance($attendance_id); $updateAttendance = new Attendance_Model_Attendance(); $member_id = array(); $formData = $this->_request->getPost(); $member_id = $this->_request->getPost('member_id'); //echo '<pre>'; print_r($formData); /* if($member_id) { for($aa=0;$aa<sizeof($member_id);$aa++) { $updateAttendance->insertattendance($formData,$member_id[$aa],$attendance_id,$this->view->createdby); } } else { $updateAttendance->insertattendance($formData,'0',$attendance_id,$this->view->createdby); } */ $maxid1 = $updateAttendance->fetchmaxid($formData['meeting_name']); if ($maxid1[0]['meetingno'] == "") { $maxid = '1'; } else { $maxid = $maxid1[0]['meetingno']; } //insert attendance details $attendance_id = $this->view->adm->addRecord("ourbank_attendance", array('id' => '', 'meeting_id' => $formData['meeting_name'], 'week_no' => $maxid, 'meeting_date' => $meeting_date, 'notes' => $formData['notes'], 'time' => $formData['meeting_time'], 'resolution' => $formData['resolution'], 'created_date' => date("y/m/d H:i:s"), 'created_by' => $this->view->createdby)); $memberid = $this->_request->getPost('member_id'); if ($memberid) { foreach ($memberid as $memberid1) { $this->view->adm->addRecord("ourbank_memberattendance", array('id' => '', 'attendance_id' => $attendance_id, 'member_id' => $memberid1, 'created_date' => date("y/m/d H:i:s"))); } } //insert discussion table $discussion = $this->_request->getPost('discussionlist'); if ($discussion) { foreach ($discussion as $discussion1) { $this->view->adm->addRecord("ourbank_discussion", array('id' => '', 'attendance_id' => $attendance_id, 'discussion_id' => $discussion1, 'created_date' => date("y/m/d H:i:s"))); } } //insert decision table $decision = $this->_request->getPost('decisionlist'); if ($decision) { foreach ($decision as $decision1) { $this->view->adm->addRecord("ourbank_decision", array('id' => '', 'attendance_id' => $attendance_id, 'decision_id' => $decision1, 'created_date' => date("y/m/d H:i:s"))); } } $this->_redirect('attendanceindex/index'); } // } else { // $this->_redirect('index/index'); // } }
function pdfgenerationAction() { $declarationform = new Declaration_Form_Account(); $this->view->form = $declarationform; $this->view->membercode = $memcode = $this->_request->getParam('membercode'); if (substr($memcode, 4, 1) == 2 or substr($memcode, 4, 1) == 3) { $this->view->groupresult = $result = $this->view->dbobj->getmembers($memcode); // if ($result) { $declarationform->populate($result[0]); $this->view->groupcode = $groupcode = $result[0]['groupcode']; $this->view->relation = $result = $this->view->dbobj->getrelations($groupcode); } } else { $this->view->result = $result = $this->view->dbobj->getmember($memcode); // if ($result) { $declarationform->populate($result[0]); $this->view->membercode1 = $familyid = $result[0]['family_id']; $this->view->relation = $result = $this->view->dbobj->getrelation($familyid); $dbobj = new Declaration_Model_Dec(); $app = $this->view->baseUrl(); $word = explode('/', $app); $projname = $word[1]; $title1 = "declaration"; $this->view->pageTitle = $title1; $pdf = new Zend_Pdf(); $page = new Zend_Pdf_Page(Zend_Pdf_Page::SIZE_A4); $pdf->pages[] = $page; // Image $image_name = "/var/www/" . $projname . "/public/images/logo.jpg"; $image = Zend_Pdf_Image::imageWithPath($image_name); //$page->drawImage($image, 25, 770, 570, 820); $page->drawImage($image, 30, 770, 130, 820); $page->setLineWidth(1)->drawLine(25, 25, 570, 25); //bottom horizontal $page->setLineWidth(1)->drawLine(25, 25, 25, 820); //left vertical $page->setLineWidth(1)->drawLine(570, 25, 570, 820); //right vertical $page->setLineWidth(1)->drawLine(570, 820, 25, 820); //top horizonta // define font resource $font = Zend_Pdf_Font::fontWithName(Zend_Pdf_Font::FONT_HELVETICA); // Image $image_name = "/var/www/" . $projname . "/public/images/logo.jpg"; $image = Zend_Pdf_Image::imageWithPath($image_name); $Declaration = new Declaration_Model_Dec(); $memcode = $this->_request->getParam('membercode'); $familyid = $this->_request->getParam('membercode1'); $showgetmember = $Declaration->getmember($memcode); $showgetrelation = $Declaration->getrelation($familyid); $dateconvert = new App_Model_dateConvertor(); foreach ($this->view->result as $result) { } // write text to page $page->setFont($font, 12)->drawText('DECLARATION', 240, 720); // $page->setLineWidth(1)->drawLine(0, 800, 820, 250); $page->setFont($font, 10)->drawText('(TO BE SUBMITTED BY THE BORROWER UNDER SBI JOINT LIABILITY GROUP)', 72, 700); $page->setFont($font, 9)->drawText('I,' . $result['name'] . ' (Name of the borrower), Son of ' . $this->view->relation[0]['fathername'] . '', 72, 670); $page->setFont($font, 9)->drawText('Aged around ' . $result['age'] . ' years,presently residing at ' . $result['street'] . ' do here by', 72, 655); $page->setFont($font, 9)->drawText('Solemnly affirm and sincerely state on Oath as follows:', 72, 625); $page->setFont($font, 9)->drawText('i) I propose to avail a crop loan under SBI JLG scheme against hypothecation of the crop which the loan is to be sanctioned.', 72, 605); $page->setFont($font, 9)->drawText('ii) In this connection, I confirm that and declare that I am land less labourer / share cropper /tenant farmer /oral lessee', 72, 585); $page->setFont($font, 9)->drawText('( Stricke out which ever not applicable ).', 80, 575); $page->setFont($font, 9)->drawText('iii) I hereby declare and confirm furture that the properties mentioned in the schedule to the affidavit is the property which', 72, 555); $page->setFont($font, 9)->drawText('is the subject matter of lease (Oral /written) in my favour for year to year or for period of ' . $dateconvert->normalformat($result['created_date']) . '', 80, 545); $page->setFont($font, 9)->drawText('year as mentioned in the document and the lease is presently in force and Sri ' . $result['landowner_name'] . ' is the lesser and ', 80, 535); $page->setFont($font, 9)->drawText('the owner of the property (a copy of the lease deed is enclosed).', 80, 525); $page->setFont($font, 9)->drawText('iv)I hereby declare and confirm further that I have not committed any default in paying the lease amount to the lesser and', 72, 505); $page->setFont($font, 9)->drawText('have not committed any breach of the terms and conditions of the lease.Moreover,I declare further that there are no', 80, 495); $page->setFont($font, 9)->drawText('arrears of any lease amount.', 80, 485); $page->setFont($font, 9)->drawText('v) I have also not resorted to outside borrowing against security of the present crop which is the subject matter of the bank', 72, 465); $page->setFont($font, 9)->drawText('finance.The crop to be raised is free from the charge/encumbrances.', 80, 455); // add page to document $pdf->pages[] = $page; $pdfData = $pdf->render(); $pdfData = $pdf->render(); $pdf->save('/var/www/' . $projname . '/reports/declaration.pdf'); $path = '/var/www/' . $projname . '/reports/declaration.pdf'; chmod($path, 0777); // $this->_redirect('/declaration/index'); } } }
public function holidayeditAction() { //calling the holiday form $holidayForm = new Holiday_Form_Holiday(); $this->view->form = $holidayForm; //getting id $id = $this->_getParam('id'); $this->view->id = $id; // calling holiday model $holiday = new Holiday_Model_Holiday(); //listing office names $officename = $this->view->adm->viewRecord("ourbank_officehierarchy", "id", "DESC"); foreach ($officename as $officename) { $holidayForm->office_id->addMultiOption($officename['id'], $officename['type']); } //displaying the values to edit $result = $holiday->getHoliday($id); $dateconvert = new App_Model_dateConvertor(); foreach ($result as $holidaydetails) { $this->view->form->name->setValue($holidaydetails['name']); $this->view->form->office_id->setValue($holidaydetails['office_id']); $this->view->form->holiday_from->setValue($dateconvert->normalformat($holidaydetails['holiday_from'])); $this->view->form->holiday_upto->setValue($dateconvert->normalformat($holidaydetails['holiday_upto'])); $this->view->form->repayment_date->setValue($dateconvert->normalformat($holidaydetails['repayment_date'])); } //update action if ($this->_request->isPost() && $this->_request->getPost('Update')) { if ($this->_request->isPost()) { $formData = $this->_request->getPost(); if ($holidayForm->isValid($formData)) { //update and edit $formdata1 = array('name' => $formData['name'], 'office_id' => $formData['office_id'], 'holiday_from' => $dateconvert->mysqlformat($formData['holiday_from']), 'holiday_upto' => $dateconvert->mysqlformat($formData['holiday_upto']), 'repayment_date' => $dateconvert->mysqlformat($formData['repayment_date']), 'created_by' => $this->view->createdby); $previousdata = $this->view->adm->editRecord("ourbank_holiday", $id); $this->view->adm->updateLog("ourbank_holiday_log", $previousdata[0], $this->view->createdby); //update $this->view->adm->updateRecord("ourbank_holiday", $id, $formdata1); $this->_redirect("/holiday"); } } } }
function pdftransactionAction() { $fromdate = $this->_request->getParam('fdate'); $dateconvertor = new App_Model_dateConvertor(); $Date = $dateconvertor->mysqlformat($fromdate); $this->view->fdate = $Date; $asofDate = $dateconvertor->normalformat($fromdate); $this->view->asofdate = $asofDate; $incomeexpenditure = new Incomeexpenditure_Model_Incomeexpenditure(); $this->view->income = $income = $incomeexpenditure->incomedetails($Date); $this->view->expenditure = $expenditure = $incomeexpenditure->expendituredetails($Date); $app = $this->view->baseUrl(); $word = explode('/', $app); $projname = ''; for ($i = 0; $i < count($word); $i++) { if ($i > 0 && $i < count($word) - 1) { $projname .= '/' . $word[$i]; } } $pdf = new Zend_Pdf(); $page = $pdf->newPage(Zend_Pdf_Page::SIZE_A4); $pdf->pages[] = $page; // Image $image_name = "/var/www/" . $projname . "/public/images/logo.jpg"; $image = Zend_Pdf_Image::imageWithPath($image_name); //$page->drawImage($image, 25, 770, 570, 820); $page->drawImage($image, 20, 780, 120, 830); $page->setLineWidth(1)->drawLine(20, 20, 580, 20); //bottom horizontal $page->setLineWidth(1)->drawLine(20, 20, 20, 830); //left vertical $page->setLineWidth(1)->drawLine(580, 25, 580, 830); //right vertical $page->setLineWidth(1)->drawLine(20, 830, 580, 830); //top horizontal $x1 = 45; $x2 = 250; $x3 = 330; $x4 = 500; $my = 735; $y1 = 710; $y2 = 710; $totalincome = 0; $totalexpe = 0; //set the font $page->setFont(Zend_Pdf_Font::fontWithName(Zend_Pdf_Font::FONT_HELVETICA), 8); $text = array($this->view->translate('Income and Expenditure'), $this->view->translate('Income'), $this->view->translate('Amount'), $this->view->translate('Expenditure'), $this->view->translate('Amount'), $this->view->translate('Grand total')); $criteria = $this->view->translate('As of') . " " . $asofDate; $currency = "* " . $this->view->translate('Amount in Rs'); // // // file:///var/www/IDF/application/modules/incomeexpenditure/controllers/IndexController.php /*$page->drawText("Date : ".date('d/m/Y'),500, 800); //date('Y-m-d') $page->drawText("Date : ".date('d/m/Y'),500, 800);*/ $page->drawText($text[0], 185, 780); $page->drawText($text[0], 185, 780); $page->drawText($criteria, 500, 780); //Search criteria $page->drawText($criteria, 500, 780); $page->drawText($currency, 500, 770); //Currency $page->drawText($currency, 500, 770); $page->drawText($text[1], $x1, $my); $page->drawText($text[2], $x2, $my); $page->drawText($text[3], $x3, $my); $page->drawText($text[4], $x4, $my); $page->drawLine(30, 750, 570, 750); $page->drawLine(30, 730, 570, 730); foreach ($income as $income) { $page->drawText($income['header'], $x1, $y1); $page->drawText($income['credit'], $x2, $y1); $totalincome += $income['credit']; $y1 = $y1 - 15; } foreach ($expenditure as $expe) { $page->drawText($expe['header'], $x3, $y2); $page->drawText($expe['credit'], $x4, $y2); $totalexpe += $expe['credit']; $y2 = $y2 - 15; } $page->drawLine(30, $y1, 570, $y1); $page->drawLine(30, $y1 - 20, 570, $y1 - 20); $page->drawText($text[5], $x1, $y1 - 15); $page->drawText(sprintf("%4.2f", $totalincome), $x2, $y1 - 15); $page->drawText($text[5], $x3, $y1 - 15); $page->drawText(sprintf("%4.2f", $totalexpe), $x4, $y1 - 15); // Virtual table $page->setLineWidth(1)->drawLine(30, $y1 - 20, 30, 750); //Table left vertical $page->setLineWidth(1)->drawLine(300, $y1 - 20, 300, 750); //Table center vertical $page->setLineWidth(1)->drawLine(570, $y1 - 20, 570, 750); //table rigth vertical $pdfData = $pdf->render(); $account_number = $Date; // $pdf->save('/var/www/ourbank/reports/incomeexpenditure.pdf'); //$path = '/var/www/ourbank/reports/incomeexpenditure.pdf'; $pdf->save('/var/www/' . $projname . '/reports/' . $account_number . 'incomeexpenditure.pdf'); $path = '/var/www/' . $projname . '/reports/' . $account_number . 'incomeexpenditure.pdf'; chmod($path, 0777); }
public function mainSearch($input, $fieldname, $table, $condition) { $dateconvert = new App_Model_dateConvertor(); function checkingDate($value) { return preg_match('`^\\d{1,2}/\\d{1,2}/\\d{4}$`', $value); } $keyvalue = array_filter($input); $searchcounter = count($keyvalue); if ($searchcounter > 0) { for ($i = 1; $i <= count($fieldname); $i++) { $inputA = $fieldname['input' . $i]; $inputB = $input['s' . $i]; $checkdate = checkingDate($inputB); if ($checkdate == 1) { $inputB = $dateconvert->mysqlformat($inputB); $where[] = "a." . $inputA . " like '%" . $inputB . "%'"; } else { $where[] = "a." . $inputA . " like '%" . $inputB . "%'"; } } $condwhere = implode(" AND ", $where); if ($condition) { $wherecond = 'AND (' . $condition . ')'; } else { $wherecond = ''; } $this->db = Zend_Db_Table::getDefaultAdapter(); $sql = "SELECT * FROM " . $table . " as a WHERE " . $condwhere . " {$wherecond} ORDER BY a.DateofEntry Desc"; $result = $this->db->fetchAll($sql); // echo $sql; return $result; } else { if ($condition) { $select = $this->select()->setIntegrityCheck(false)->join(array('a' => $table), array('id'))->order(array('a.id DESC'))->where($condition); $result = $this->fetchAll($select); } else { $select = $this->select()->setIntegrityCheck(false)->join(array('a' => $table), array('id'))->order(array('a.id DESC')); $result = $this->fetchAll($select); } return $result->toArray(); } }