} $query = "INSERT INTO job_extensions \n SELECT 0, id, created_on, expire_on, for_replacement, invoiced FROM jobs WHERE id = " . $_POST['id']; if (!$mysqli->execute($query)) { echo "ko"; exit; } $query = "SELECT expire_on \n FROM jobs \n WHERE id = " . $_POST['id'] . " LIMIT 1"; $result = $mysqli->query($query); $is_expired = sql_date_diff($result[0]['expire_on'], now()) <= 0 ? true : false; $expire_on = $result[0]['expire_on']; if ($is_expired) { $expire_on = now(); } $data = array(); $data['created_on'] = $expire_on; $data['expire_on'] = sql_date_add($data['created_on'], 30, 'day'); $data['closed'] = 'N'; $job = new Job($_POST['id']); if ($job->update($data) == false) { echo "ko"; exit; } echo "ok"; exit; } if ($_POST['action'] == 'get_currency') { $employer = new Employer($_POST['id']); $branch = $employer->get_branch(); echo Currency::getSymbolFromCountryCode($branch[0]['country']); exit; }
$data['employer'] = $_POST['id']; $data['payable_by'] = sql_date_add($data['issued_on'], $employer->get_payment_terms_days(), 'day'); $invoice = Invoice::create($data); if ($invoice === false) { echo 'ko'; exit; } $desc = $_POST['period'] . ' month(s) of subscription'; $item_added = Invoice::add_item($invoice, $_POST['amount'], '1', $desc); $items = array(); $items[0]['itemdesc'] = $desc; $items[0]['amount'] = number_format($_POST['price'], '2', '.', ', '); $items[1]['itemdesc'] = 'Administration Fee'; $items[1]['amount'] = number_format($_POST['admin_fee'], '2', '.', ', '); // 2. generate the PDF version to be attached to sales.xx and the employer $branch_raw = $employer->get_branch(); $sales = 'sales.' . strtolower($branch_raw[0]['country']) . '@yellowelevator.com'; $branch_raw[0]['address'] = str_replace(array("\r\n", "\r"), "\n", $branch_raw[0]['address']); $branch_raw['address_lines'] = explode("\n", $branch_raw[0]['address']); $currency = $_POST['currency']; $pdf = new SubscriptionInvoice(); $pdf->AliasNbPages(); $pdf->SetAuthor('Yellow Elevator. This invoice was automatically generated. Signature is not required.'); $pdf->SetTitle($GLOBALS['COMPANYNAME'] . ' - Invoice ' . pad($invoice, 11, '0')); $pdf->SetCurrency($currency); $pdf->SetBranch($branch_raw); $pdf->AddPage(); $pdf->SetFont('Arial', '', 10); $pdf->SetTextColor(255, 255, 255); $pdf->SetFillColor(54, 54, 54); $pdf->Cell(60, 5, "Invoice Number", 1, 0, 'C', 1);