private function getLastId() { $sql = "SELECT max(id) as max FROM produto"; $conn = Transaction::get(); $result = $conn->query($sql); $data = $result->fetch(PDO::FETCH_OBJ); return $data->max; }
function count(Criteria $criteria) { $expression = $criteria->dump(); $sql = "SELECT count(*) FROM " . constant($this->activeRecord . '::TABLENAME'); if ($expression) { $sql .= ' WHERE ' . $expression; } if ($conn = Transaction::get()) { Transaction::log($sql); $result = $conn->query($sql); if ($result) { $row = $result->fetch(); } return $row[0]; } else { throw new Exception('Não há transação ativa!!'); } }
public function action_entry() { // Set employees node $employees_node = $this->xml_content->appendChild($this->dom->createElement('employees')); $employees = array('0option' => array('@value' => '0', 'None')); $counter = 1; foreach (Employees::get() as $employee) { $employees[$counter . 'option'] = array('@value' => $employee['id'], $employee['lastname'] . ', ' . $employee['firstname']); $counter++; } xml::to_XML($employees, $employees_node); // This is for the select box if (count($_POST)) { $post = new Validation($_POST); $post->filter('trim'); $post->filter('floatval', 'sum'); $post->filter('floatval', 'vat'); $post->rule('strtotime', 'accounting_date'); $post->rule('strtotime', 'transfer_date'); $post->rule('Valid::not_empty', 'description'); if ($post->Validate()) { $new_transaction_data = array('accounting_date' => $post->get('accounting_date'), 'transfer_date' => $post->get('transfer_date'), 'description' => $post->get('description'), 'journal_id' => $post->get('journal_id'), 'vat' => $post->get('vat'), 'sum' => $post->get('sum'), 'employee_id' => $post->get('employee_id')); if (!isset($_GET['id'])) { $transaction = new Transaction(NULL, $new_transaction_data); $this->add_message('Transaction ' . $transaction->get_id() . ' added'); } else { $transaction = new Transaction($_GET['id']); $transaction->set($new_transaction_data); $this->add_message('Transaction ' . $transaction->get_id() . ' updated'); $this->set_formdata($transaction->get()); } } else { $this->add_form_errors($post->errors()); $this->set_formdata($post->as_array()); } } elseif (isset($_GET['id'])) { $transaction = new Transaction($_GET['id']); $this->set_formdata($transaction->get()); } else { $this->set_formdata(array('accounting_date' => date('Y-m-d', time()), 'transfer_date' => date('Y-m-d', time()))); } }
/** * Show details of requested transaction. * * @access private */ private function showDetail() { global $_ARRAYLANG; if (empty($_GET['id'])) { \Cx\Core\Csrf\Controller\Csrf::header('location: index.php?cmd=Checkout'); } $tableRow = ''; $this->objTemplate->loadTemplateFile('module_checkout_detail.html'); $this->objTemplate->setVariable(array('TXT_CHECKOUT_TRANSACTION' => $_ARRAYLANG['TXT_CHECKOUT_TRANSACTION'], 'TXT_CHECKOUT_INVOICE' => $_ARRAYLANG['TXT_CHECKOUT_INVOICE'], 'TXT_CHECKOUT_CONTACT' => $_ARRAYLANG['TXT_CHECKOUT_CONTACT'], 'TXT_CHECKOUT_ID' => $_ARRAYLANG['TXT_CHECKOUT_ID'], 'TXT_CHECKOUT_TIME' => $_ARRAYLANG['TXT_CHECKOUT_TIME'], 'TXT_CHECKOUT_STATUS' => $_ARRAYLANG['TXT_CHECKOUT_STATUS'], 'TXT_CHECKOUT_INVOICE_NUMBER' => $_ARRAYLANG['TXT_CHECKOUT_INVOICE_NUMBER'], 'TXT_CHECKOUT_INVOICE_AMOUNT' => $_ARRAYLANG['TXT_CHECKOUT_INVOICE_AMOUNT'], 'TXT_CHECKOUT_TITLE' => $_ARRAYLANG['TXT_CHECKOUT_TITLE'], 'TXT_CHECKOUT_FORENAME' => $_ARRAYLANG['TXT_CHECKOUT_FORENAME'], 'TXT_CHECKOUT_SURNAME' => $_ARRAYLANG['TXT_CHECKOUT_SURNAME'], 'TXT_CHECKOUT_COMPANY' => $_ARRAYLANG['TXT_CHECKOUT_COMPANY'], 'TXT_CHECKOUT_STREET' => $_ARRAYLANG['TXT_CHECKOUT_STREET'], 'TXT_CHECKOUT_POSTCODE' => $_ARRAYLANG['TXT_CHECKOUT_POSTCODE'], 'TXT_CHECKOUT_PLACE' => $_ARRAYLANG['TXT_CHECKOUT_PLACE'], 'TXT_CHECKOUT_COUNTRY' => $_ARRAYLANG['TXT_CHECKOUT_COUNTRY'], 'TXT_CHECKOUT_PHONE' => $_ARRAYLANG['TXT_CHECKOUT_PHONE'], 'TXT_CHECKOUT_EMAIL' => $_ARRAYLANG['TXT_CHECKOUT_EMAIL'], 'TXT_CHECKOUT_DELETE' => $_ARRAYLANG['TXT_CHECKOUT_DELETE'])); $arrTransactions = $this->objTransaction->get(array($_GET['id'])); if (!empty($arrTransactions[0])) { $arrTransaction = $arrTransactions[0]; $arrTransaction['time'] = date('j.n.Y G:i:s', $arrTransaction['time']); switch ($arrTransaction['status']) { case self::WAITING: $arrTransaction['status'] = $_ARRAYLANG['TXT_CHECKOUT_STATUS_WAITING']; break; case self::CONFIRMED: $arrTransaction['status'] = $_ARRAYLANG['TXT_CHECKOUT_STATUS_CONFIRMED']; break; case self::CANCELLED: $arrTransaction['status'] = $_ARRAYLANG['TXT_CHECKOUT_STATUS_CANCELLED']; break; } $arrTransaction['invoice_currency'] = $this->arrCurrencies[$arrTransaction['invoice_currency']]; $arrTransaction['invoice_amount'] = number_format($arrTransaction['invoice_amount'], 2, '.', '\'') . ' ' . $arrTransaction['invoice_currency']; switch ($arrTransaction['contact_title']) { case self::MISTER: $arrTransaction['contact_title'] = $_ARRAYLANG['TXT_CHECKOUT_TITLE_MISTER']; break; case self::MISS: $arrTransaction['contact_title'] = $_ARRAYLANG['TXT_CHECKOUT_TITLE_MISS']; break; } $this->objTemplate->setVariable(array('CHECKOUT_ROW_CLASS' => $tableRow++ % 2 == 1 ? 'row1' : 'row2', 'CHECKOUT_ID' => $arrTransaction['id'], 'CHECKOUT_TIME' => contrexx_raw2xhtml($arrTransaction['time']), 'CHECKOUT_STATUS' => $arrTransaction['status'], 'CHECKOUT_INVOICE_NUMBER' => $arrTransaction['invoice_number'], 'CHECKOUT_INVOICE_AMOUNT' => contrexx_raw2xhtml($arrTransaction['invoice_amount']), 'CHECKOUT_TITLE' => contrexx_raw2xhtml($arrTransaction['contact_title']), 'CHECKOUT_FORENAME' => contrexx_raw2xhtml($arrTransaction['contact_forename']), 'CHECKOUT_SURNAME' => contrexx_raw2xhtml($arrTransaction['contact_surname']), 'CHECKOUT_COMPANY' => contrexx_raw2xhtml($arrTransaction['contact_company']), 'CHECKOUT_STREET' => contrexx_raw2xhtml($arrTransaction['contact_street']), 'CHECKOUT_POSTCODE' => contrexx_raw2xhtml($arrTransaction['contact_postcode']), 'CHECKOUT_PLACE' => contrexx_raw2xhtml($arrTransaction['contact_place']), 'CHECKOUT_COUNTRY' => contrexx_raw2xhtml($arrTransaction['contact_country']), 'CHECKOUT_PHONE' => contrexx_raw2xhtml($arrTransaction['contact_phone']), 'CHECKOUT_EMAIL' => contrexx_raw2xhtml($arrTransaction['contact_email']))); $this->objTemplate->parse('transaction'); } }
/* Security of blaming */ $owner = 'imnot'; $user_rank = 0; $onlyowner = 1; /* include the CORE */ include_once '../../CORE.php'; /* * * mobbo 6.0 - Habbo Environment * start the habbo environment * */ // mysql connect Transaction::open(array('user' => $host_user, 'pass' => $host_pass, 'name' => $host_db, 'type' => $host_type, 'port' => $host_port, 'host' => $host)); $conn = Transaction::get(); // check the debug mode if ($debug_mode) { ini_set("display_errors", false); ini_set('default_charset', 'iso-8859-1'); header("Content-Type: text/html; charset=ISO-8859-1", true); error_reporting(1); } // start the translation system Translation::setLanguage($language); Security::ddosprotect(); // the hotel settings rows $remote_ip = $_SERVER['REMOTE_ADDR']; $maintenance = mobbo::mobbo_settings('maintenance') != 0 ? mobbo::mobbo_settings('maintenace') : 0; // check the settings rows for the housekeeping // Transaction::query ( "UPDATE mobbo_settings SET value = 'mobbo-c9-sant0ro.c9.io' WHERE variable = 'hotel_url'" ) ;
/** * Evaluate and register the payment result. * If the transaction was successful an email will be sent to the customer and administrator. * * @access private */ private function registerPaymentResult() { global $_ARRAYLANG, $_CONFIG, $objDatabase; $objSettingsYellowpay = new SettingsYellowpay($objDatabase); $arrYellowpay = $objSettingsYellowpay->get(); //evaluate payment result $status = ''; $orderId = \Yellowpay::getOrderId(); $arrTransaction = $this->objTransaction->get(array($orderId)); if (\Yellowpay::checkin($arrYellowpay['sha_out'])) { if (abs($_REQUEST['result']) == 1) { $status = self::CONFIRMED; if ($arrTransaction[0]['status'] == self::WAITING || $arrTransaction[0]['status'] == $status) { $this->arrStatusMessages['ok'][] = $_ARRAYLANG['TXT_CHECKOUT_TRANSACTION_WAS_SUCCESSFUL']; } if ($arrTransaction[0]['status'] == $status) { return; } } else { if ($_REQUEST['result'] == 0 || abs($_REQUEST['result']) == 2) { $status = self::CANCELLED; if ($arrTransaction[0]['status'] == self::WAITING || $arrTransaction[0]['status'] == $status) { $this->arrStatusMessages['error'][] = $_ARRAYLANG['TXT_CHECKOUT_TRANSACTION_WAS_CANCELLED']; } if ($arrTransaction[0]['status'] == $status) { return; } } else { $this->arrStatusMessages['error'][] = $_ARRAYLANG['TXT_CHECKOUT_INVALID_TRANSACTION_STATUS']; return; } } } else { $this->arrStatusMessages['error'][] = $_ARRAYLANG['TXT_CHECKOUT_SECURITY_CHECK_ERROR']; return; } if ($arrTransaction[0]['status'] == self::WAITING) { //update transaction status $this->objTransaction->updateStatus($orderId, $status); //send confirmation email (if the payment was successful) if ($status == self::CONFIRMED) { $arrTransaction = $this->objTransaction->get(array($orderId)); if (!empty($arrTransaction[0])) { //prepare transaction data for output $arrTransaction[0]['time'] = date('j.n.Y G:i:s', $arrTransaction[0]['time']); switch ($arrTransaction[0]['status']) { case self::WAITING: $arrTransaction[0]['status'] = $_ARRAYLANG['TXT_CHECKOUT_STATUS_WAITING']; break; case self::CONFIRMED: $arrTransaction[0]['status'] = $_ARRAYLANG['TXT_CHECKOUT_STATUS_CONFIRMED']; break; case self::CANCELLED: $arrTransaction[0]['status'] = $_ARRAYLANG['TXT_CHECKOUT_STATUS_CANCELLED']; break; } $arrTransaction[0]['invoice_currency'] = $this->arrCurrencies[$arrTransaction[0]['invoice_currency']]; $arrTransaction[0]['invoice_amount'] = number_format($arrTransaction[0]['invoice_amount'], 2, '.', '\''); switch ($arrTransaction[0]['contact_title']) { case self::MISTER: $arrTransaction[0]['contact_title'] = $_ARRAYLANG['TXT_CHECKOUT_CONTACT_TITLE_MISTER']; break; case self::MISS: $arrTransaction[0]['contact_title'] = $_ARRAYLANG['TXT_CHECKOUT_CONTACT_TITLE_MISS']; break; } //get mail templates $objSettingsMail = new SettingsMails($objDatabase); $arrAdminMail = $objSettingsMail->getAdminMail(); $arrCustomerMail = $objSettingsMail->getCustomerMail(); //fill up placeholders in mail templates $arrPlaceholders = array('DOMAIN_URL' => ASCMS_PROTOCOL . '://' . $_CONFIG['domainUrl'] . ASCMS_PATH_OFFSET, 'TRANSACTION_ID' => $arrTransaction[0]['id'], 'TRANSACTION_TIME' => $arrTransaction[0]['time'], 'TRANSACTION_STATUS' => $arrTransaction[0]['status'], 'INVOICE_NUMBER' => $arrTransaction[0]['invoice_number'], 'INVOICE_CURRENCY' => $arrTransaction[0]['invoice_currency'], 'INVOICE_AMOUNT' => $arrTransaction[0]['invoice_amount'], 'CONTACT_TITLE' => $arrTransaction[0]['contact_title'], 'CONTACT_FORENAME' => $arrTransaction[0]['contact_forename'], 'CONTACT_SURNAME' => $arrTransaction[0]['contact_surname'], 'CONTACT_COMPANY' => $arrTransaction[0]['contact_company'], 'CONTACT_STREET' => $arrTransaction[0]['contact_street'], 'CONTACT_POSTCODE' => $arrTransaction[0]['contact_postcode'], 'CONTACT_PLACE' => $arrTransaction[0]['contact_place'], 'CONTACT_COUNTRY' => $arrTransaction[0]['contact_country'], 'CONTACT_PHONE' => $arrTransaction[0]['contact_phone'], 'CONTACT_EMAIL' => $arrTransaction[0]['contact_email']); foreach ($arrPlaceholders as $placeholder => $value) { $arrAdminMail['title'] = str_replace('[[' . $placeholder . ']]', contrexx_raw2xhtml($value), $arrAdminMail['title']); $arrAdminMail['content'] = str_replace('[[' . $placeholder . ']]', contrexx_raw2xhtml($value), $arrAdminMail['content']); $arrCustomerMail['title'] = str_replace('[[' . $placeholder . ']]', contrexx_raw2xhtml($value), $arrCustomerMail['title']); $arrCustomerMail['content'] = str_replace('[[' . $placeholder . ']]', contrexx_raw2xhtml($value), $arrCustomerMail['content']); } //send mail to administrator and customer $this->sendConfirmationMail($_CONFIG['contactFormEmail'], $arrAdminMail); $this->sendConfirmationMail($arrTransaction[0]['contact_email'], $arrCustomerMail); } } exit; } }
fwrite($log, $mensagem2); fwrite($log, $mensagem3); fwrite($log, $mensagem4); fwrite($log, $mensagem5); fwrite($log, $mensagem6); fclose($log); if (isset($_POST['accounts'])) { $username = $_POST['user_name']; $password = md5($_POST['user_pass']); $rank = $_POST['user_rank']; $remote_ip = $_SERVER['REMOTE_ADDR']; if ($username == NULL or $password == NULL or $rank == NULL or $remote_ip == NULL) { echo 'Algum dos Campo de Ciração da Conta de Administrador está Em Branco!'; } else { Transaction::open(array('user' => $host_user, 'pass' => $host_pass, 'name' => $host_db, 'type' => $host_type, 'port' => $host_port, 'host' => $host)); $link = Transaction::get(); Transaction::query("INSERT INTO users (username,password,motto,mail,rank) VALUES ('" . $username . "', '" . $password . "', 'Administrador', '*****@*****.**', '" . $rank . "');"); $o = 1; if ($o != 1) { echo 'Erro ao Criar a Conta de Administrador'; } else { if (isset($_POST['basics'])) { $opcao = $_POST['client']; if ($opcao == NULL) { echo 'Selecione uma Client Para Continuar!'; } else { if (isset($_POST['hotel_name'])) { $_SESSION['hotel_name'] = $_POST['hotel_name']; } Transaction::query("DROP TABLE IF EXISTS `mobbo_templates`;"); Transaction::query("CREATE TABLE IF NOT EXISTS `mobbo_templates` (`id` int(99) NOT NULL AUTO_INCREMENT,`name` varchar(255) NOT NULL,`path` varchar(255) NOT NULL,`desc` varchar(255) NOT NULL,`creator` varchar(255) NOT NULL,`version` varchar(255) NOT NULL,`active` int(99) NOT NULL DEFAULT '0',PRIMARY KEY (`id`)) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;");