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 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 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 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'); }