'; $pdf->WriteHTML($styles, 1); /* * Set our font size * This is not in pixels but in millimeters * A 0.5 change in the font size is close to a 1px font size change. */ $pdf->SetFontSize(10); /** * Print the pdf pages single or multiple client */ $fundName = substr($form_data['field']['Fund Name'], 0, 153); for ($i = 1; $i < 5; $i++) { $fullName = substr($form_data['field']['Trustees or Directors Name ' . $i], 0, 75); if (!empty($fullName)) { print_pdf($fundName, $fullName, $pdf, $template); } } } /* close the foreach loop */ /** * Print pdf content * @param $fundName * @param $fullName * @param $pdf * @param $template */ function print_pdf($fundName, $fullName, $pdf, $template) { for ($i = 1; $i < 5; $i++) { if ($i == 3) {
function downloadPDF($jp) { $data['jenis_perizinan'] = $jp; $data['tgl_awal'] = convert_tgl($this->input->get('tgl_awal')); $data['tgl_akhir'] = convert_tgl($this->input->get('tgl_akhir')); $data['tgl_bulan'] = $this->input->get('tgl_bulan'); $data['per_type'] = $this->input->get('per_type'); $data['per_kec'] = $this->input->get('per_kecamatan'); $data['filter_type'] = $this->input->get('filter_type'); //$data['results'] = $this->m_jenisizin->getData($data['jenis_perizinan'], $data['tgl_awal'], $data['tgl_akhir'], $data['tgl_bulan'],$data['filter_type']); $data['typeIzin'] = getTypeIzin($data['jenis_perizinan']); $data['nameIzin'] = getTabelJenisPerizinan()[$data['jenis_perizinan']]; $data['listKecamatan'] = $this->m_global->getKecamatan(); //debugy($data); $columns = array(); $columns[KEY_COLUMN_ID] = getColumnNameID($data['jenis_perizinan']); $columns[KEY_COLUMN_TYPE] = getColumnNameType($data['jenis_perizinan']); $data['type'] = ''; $data['results'] = $this->m_jenisizin->getAllData($data['jenis_perizinan'], $columns, $data['tgl_awal'], $data['tgl_akhir'], $data['tgl_bulan'], $data['filter_type'], $data['per_type'], $data['per_kec']); $data['row_total'] = count($data['results']); $data['row_start'] = 1; $data = mergeReportData($data, $columns, '_pdf'); $filename = strtoupper($jp) . '_' . date('Y-m-d'); $data['filename'] = $filename; $html = $this->load->view('report_usaha/' . $data['view'], $data, true); // $html = $this->load->view('report_usaha/v_jenisizinusaha_pdf',$data,TRUE); print_pdf($filename, $html, FALSE, 'A4', 'landscape'); }
function save_new_application() { if (isset($_POST['num_leaves']) and intval(trim($_POST['num_leaves'])) > 0) { //Αν ο αριθμός ημερών δεν είναι κενός και το αριθμός είναι μεγαλύτερος του 0 global $db, $user, $message_list; // Check if the number of days requested is available (remaining days) if (trim($_POST['leave_type']) == 2) { $afm = trim($_POST['user_tel']); if (intval(trim($_POST['num_leaves'])) > get_remaining_leaves_for_user(afm_to_id($afm))) { $message_list[] = array('type' => 'danger', 'message' => 'Σφάλμα! Το υπόλοιπο των ημερών αδείας του υπαλλήλου σας δεν επαρκεί.'); return; } } else { if (intval(trim($_POST['num_leaves'])) > get_remaining_leaves()) { $message_list[] = array('type' => 'danger', 'message' => 'Σφάλμα! Το υπόλοιπο των ημερών αδείας σας δεν επαρκεί.'); return; } } $query = $db->prepare('INSERT INTO leaves_submissions (leave_id, employee_afm, type_id, date_submitted, submitted_by, date_starts, date_ends, num_leaves, ip_submitted, remaining_leaves, filename) VALUES(NULL, :employee_afm, :type_id, :date_submitted, :submitted_by, :date_starts, :date_ends, :num_leaves, :ip_submitted, :remaining_leaves, :filename)'); $afm = $user->afm; $submitted_by = ''; if (trim($_POST['leave_type']) == 2) { // This is request via telephone $afm = trim($_POST['user_tel']); $submitted_by = $user->afm; } $submission_date = date("Y-m-d H:i:s"); $filename = date("Y-m-d_H_i_s") . '_' . get_rand_id(5) . '.pdf'; $query->bindValue(':employee_afm', $afm, PDO::PARAM_STR); $query->bindValue(':type_id', trim($_POST['leave_type']), PDO::PARAM_INT); $query->bindValue(':date_submitted', $submission_date, PDO::PARAM_STR); $query->bindValue(':submitted_by', $submitted_by, PDO::PARAM_STR); $query->bindValue(':date_starts', trim($_POST['date_starts']), PDO::PARAM_STR); $query->bindValue(':date_ends', trim($_POST['date_ends']), PDO::PARAM_STR); $query->bindValue(':num_leaves', trim($_POST['num_leaves']), PDO::PARAM_INT); $query->bindValue(':ip_submitted', $_SERVER['REMOTE_ADDR'], PDO::PARAM_STR); $query->bindValue(':remaining_leaves', get_remaining_leaves(), PDO::PARAM_STR); $query->bindValue(':filename', $filename, PDO::PARAM_STR); $query->execute(); $id = $db->lastInsertId(); if ($id != 0) { // Prepare the pdf body $leave_user = get_user_details_by_afm($afm); $pdf_body = '<h4>Αίτηση Άδειας</h4>'; $pdf_body .= '<p>Όνομα: ' . $leave_user->first_name . '</p>'; $pdf_body .= '<p>Επίθετο: ' . $leave_user->last_name . '</p>'; $pdf_body .= '<p>Ημερομηνία Έναρξης Άδειας: ' . printDate(trim($_POST['date_starts'])) . '</p>'; $pdf_body .= '<p>Ημερομηνία Λήξης Άδειας: ' . printDate(trim($_POST['date_ends'])) . '</p>'; $pdf_body .= '<p>Ημέρες Άδειας: ' . trim($_POST['num_leaves']) . '</p>'; $pdf_body .= '<p>Ημέρομηνία Υποβολής: ' . printDate($submission_date) . '</p>'; // Also print the pdf $full_path_filename = getcwd() . '/apps/leaves/files/' . $filename; print_pdf($full_path_filename, $pdf_body); if (DEBUG) { // This is in development mode.. $address = LEAVES_DEBUG_USER_EMAIL; $receiver = LEAVES_DEBUG_USER_NAME; } else { // Send email to the employer $address = $leave_user->email; $receiver = $leave_user->first_name . ' ' . $leave_user->last_name; } $subject = 'Η Αίτηση Αδείας σας υποβλήθηκε επιτυχώς'; $body = '<p>Η Αίτηση Αδείας σας υποβλήθηκε επιτυχώς</p>'; $body .= '<p>Επισυνάπτεται αντίγραφο της αίτησή σας.</p>'; $body .= '<p>Θα ενημερωθείτε με νεώτερο email μετά το πέρας της επεξεργασίας της αίτησής σας.</p>'; email_send($address, $receiver, $subject, $body, $full_path_filename); if (trim($_POST['leave_type']) != 2) { // If it is by telephone no need to alert the supervisors // Maybe send this no matter what..? $supervisors = get_user_supervisors($leave_user); foreach ($supervisors as $supervisor) { if (DEBUG) { // This is in development mode.. $address = LEAVES_DEBUG_USER_EMAIL; $receiver = LEAVES_DEBUG_USER_NAME; } else { // Send email to the supervisor $address = $supervisor['email']; $receiver = $supervisor['first_name'] . ' ' . $supervisor['last_name']; } if (DEBUG) { $message_list[] = array('type' => 'message', 'message' => 'Ενημερώθηκε ηλεκτρονικά ο ' . $supervisor['first_name'] . ' ' . $supervisor['last_name']); } $subject = 'Νέα Αίτηση Αδείας απο τον ' . $leave_user->first_name . ' ' . $leave_user->last_name; $body = '<p>O ' . $leave_user->first_name . ' ' . $leave_user->last_name . ' υπέβαλλε νέα αίτηση αδείας.</p>'; $body .= '<p>Συνδεθείτε για να επεξεργαστείτε την αίτηση.</p>'; $body .= '<p><a href="' . URL . '?p=leaves|applications">' . URL . '</a></p>'; email_send($address, $receiver, $subject, $body); } } $message_list[] = array('type' => 'success', 'message' => 'Η Αίτηση καταχωρήθηκε επιτυχώς..'); } else { $message_list[] = array('type' => 'danger', 'message' => 'Σφάλμα! Η Αίτηση δεν καταχωρήθηκε επιτυχώς..'); } //echo $query->getSQL(); //For debug } }
$lisavarattu = ""; } $liitostunnus_query = "SELECT DISTINCT lasku.liitostunnus FROM tilausrivi\n JOIN lasku ON (lasku.yhtio = tilausrivi.yhtio AND lasku.tunnus = tilausrivi.otunnus AND lasku.yhtio_toimipaikka = {$toimrow['tunnus']})\n WHERE tilausrivi.yhtio = '{$yhtiorow['yhtio']}'\n AND tilausrivi.tyyppi = 'L'\n AND tilausrivi.var = 'J'\n AND tilausrivi.keratty = ''\n AND tilausrivi.uusiotunnus = 0\n AND tilausrivi.kpl = 0\n AND tilausrivi.jt {$lisavarattu} > 0"; $liitostunnus_result = pupe_query($liitostunnus_query); while ($liitostunnus_row = mysql_fetch_array($liitostunnus_result)) { $asiakasquery = "SELECT nimi, osoite, postino, postitp, maa, ytunnus, email, kieli, tunnus FROM asiakas WHERE yhtio='{$yhtiorow['yhtio']}' AND tunnus={$liitostunnus_row['liitostunnus']}"; $asiakasresult = pupe_query($asiakasquery); $asiakasrow = mysql_fetch_array($asiakasresult); if ($asiakasrow["email"] != "") { $jtquery = "SELECT tilausrivi.nimitys, tilausrivi.otunnus, tilausrivi.tuoteno, tilausrivi.laadittu, tilausrivi.tilkpl\n FROM tilausrivi USE INDEX (yhtio_tyyppi_var_keratty_kerattyaika_uusiotunnus)\n JOIN lasku USE INDEX (PRIMARY) ON (lasku.yhtio = tilausrivi.yhtio and lasku.yhtio_toimipaikka = {$toimrow['tunnus']} and lasku.tunnus = tilausrivi.otunnus and lasku.osatoimitus = '' AND lasku.liitostunnus = '{$asiakasrow['tunnus']}')\n WHERE tilausrivi.yhtio = '{$yhtiorow['yhtio']}'\n AND tilausrivi.tyyppi = 'L'\n AND tilausrivi.var = 'J'\n AND tilausrivi.keratty = ''\n AND tilausrivi.uusiotunnus = 0\n AND tilausrivi.kpl = 0\n AND tilausrivi.jt {$lisavarattu} > 0\n ORDER BY tilausrivi.otunnus"; $jtresult = pupe_query($jtquery); if (mysql_num_rows($jtresult) > 0) { require_once '../pdflib/phppdflib.class.php'; require "jt-raportti_pdf.inc"; $pdf = new pdffile(); $pdf->set_default('margin-top', 0); $pdf->set_default('margin-bottom', 0); $pdf->set_default('margin-left', 0); $pdf->set_default('margin-right', 0); list($page[$sivu], $kalakorkeus) = alku($pdf); while ($jtrow = mysql_fetch_array($jtresult)) { list($page[$sivu], $kalakorkeus) = rivi($pdf, $page[$sivu], $kalakorkeus, $jtrow); } // echo "$laskuri "; print_pdf($pdf, 1); // $laskuri++; } } } } }
$CompanyDirectorGivenName = $form_data['field']['Director 2 - Given Names']; $CompanyDirectorFamilyName = $form_data['field']['Director 2 - Family Name']; for ($i = 1; $i < $totalMember; $i++) { $fundName = substr($form_data['field']['Fund Name'], 0, 153); $fullName = substr($form_data['field']['Given Names ' . $i] . ' ' . $form_data['field']['Family Name ' . $i], 0, 75); print_pdf($fundName, $fullName, $pdf, $template); } /** * $totalMember = 2 meaning its only 1 member of the fund */ if ($totalMember == 2) { if ($trusteeType == 'Individuals') { print_pdf($fundName, $individualTrusteeGivenName . ' ' . $individualTrusteeFamilyName, $pdf, $template); } else { if ($trusteeType == 'Company - Already Registered' and $companyWithDirector == 'Yes') { print_pdf($fundName, $CompanyDirectorGivenName . ' ' . $CompanyDirectorFamilyName, $pdf, $template); } } } } /* close the foreach loop */ /** * Print pdf content * @param $fundName * @param $fullName * @param $pdf * @param $template */ function print_pdf($fundName, $fullName, $pdf, $template) { for ($i = 1; $i < 5; $i++) {