public function indexAction()
{
$storage = new Zend_Auth_Storage_Session();
$data = $storage->read();
if (!$data) {
$this->_redirect('index/login');
}
$this->view->title = "Group meeting";
$searchForm = new Meeting_Form_Search();
$this->view->form = $searchForm;
$days = $this->view->adm->viewRecord("ourbank_master_weekdays", "id", "ASC");
foreach ($days as $days) {
$searchForm->search_weekdays->addMultiOption($days['id'], $days['name']);
}
$meeting = new Meeting_Model_Meeting();
$result = $meeting->fetchAllmeetingdetails();
$page = $this->_getParam('page', 1);
$paginator = Zend_Paginator::factory($result);
$paginator->setItemCountPerPage(5);
$paginator->setCurrentPageNumber($page);
$this->view->paginator = $paginator;
if ($this->_request->isPost() && $this->_request->getPost('Search')) {
$formData = $this->_request->getPost();
if ($searchForm->isValid($formData)) {
$meeting = new Meeting_Model_Meeting();
$result = $meeting->SearchMeeting($formData);
$page = $this->_getParam('page', 1);
$paginator = Zend_Paginator::factory($result);
$paginator->setItemCountPerPage(5);
$paginator->setCurrentPageNumber($page);
$this->view->paginator = $paginator;
}
}
}
public function indexAction()
{
$searchForm = new Attendance_Form_Search();
$this->view->form = $searchForm;
$meeting = new Meeting_Model_Meeting();
$result = $meeting->fetchAllmeetingdetails();
foreach ($result as $result) {
$searchForm->search_meeting_name_att->addMultiOption($result['id'], $result['name']);
}
$attendance = new Attendance_Model_Attendance();
$result = $attendance->fetchAllattendancedetailsview();
$page = $this->_getParam('page', 1);
$paginator = Zend_Paginator::factory($result);
$paginator->setItemCountPerPage(5);
$paginator->setCurrentPageNumber($page);
$this->view->paginator = $paginator;
if ($this->_request->isPost() && $this->_request->getPost('Search')) {
$formData = $this->_request->getPost();
if ($this->_request->isPost()) {
$formData = $this->_request->getPost();
if ($searchForm->isValid($formData)) {
$result = $attendance->SearchAttendance($formData);
$page = $this->_getParam('page', 1);
$paginator = Zend_Paginator::factory($result);
$paginator->setItemCountPerPage(5);
$paginator->setCurrentPageNumber($page);
//print_r($paginator);
$this->view->paginator = $paginator;
}
}
}
}
public function indexAction()
{
$this->view->title = "Group meeting";
//Acl
// $access = new App_Model_Access();
// $checkaccess = $access->accessRights('Activity',$this->view->globalvalue[0]['name'],'activityeditAction');
// if (($checkaccess != NULL)) {
//view
$this->view->meeting_id = $meeting_id = $this->_request->getParam('meeting_id');
$meeting = new Meeting_Model_Meeting();
$this->view->fetchmeeting = $meeting->fetchMeetingdetailsForID($meeting_id);
// } else {
// $this->_redirect('index/index');
// }
}
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');
// }
}
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 headnameAction()
{
$this->_helper->layout->disableLayout();
$path = $this->view->baseUrl();
$meetingForm = new Meeting_Form_Meeting($path);
$this->view->meetingForm = $meetingForm;
$group_id = $this->_request->getParam('group_id');
$meeting = new Meeting_Model_Meeting();
$headname = $meeting->fetchHeadName($group_id);
foreach ($headname as $headname1) {
$meetingForm->group_head->setValue($headname1['headname']);
}
}
