';
$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++) {
