/**
* Returns a new ChildOptionQuery object.
*
* @param string $modelAlias The alias of a model in the query
* @param Criteria $criteria Optional Criteria to build the query from
*
* @return ChildOptionQuery
*/
public static function create($modelAlias = null, Criteria $criteria = null)
{
if ($criteria instanceof ChildOptionQuery) {
return $criteria;
}
$query = new ChildOptionQuery();
if (null !== $modelAlias) {
$query->setModelAlias($modelAlias);
}
if ($criteria instanceof Criteria) {
$query->mergeWith($criteria);
}
return $query;
}
function changeAppPhoto($params)
{
require 'session.php';
$con = Propel::getConnection('pos');
$con->beginTransaction();
$operationTime = time();
$unique = session_id() . time();
$file = $_FILES['photo'];
$folder = $session->get('pos/folder') . '/resources/images/';
$ext = pathinfo($file['name'], PATHINFO_EXTENSION);
$newfile = $unique . '.' . $ext;
$newfile_full_path = $folder . $newfile;
try {
if ($file['name'] == '') {
throw new Exception('Missing file');
}
if ($file['error'] > 0) {
throw new Exception($file['error']);
}
move_uploaded_file($file['tmp_name'], $newfile_full_path);
$appPhoto = OptionQuery::create()->filterByName(['app_photo'])->findOne($con);
$appPhoto->setValue($newfile)->save($con);
$results['success'] = true;
$results['photo'] = $newfile;
$con->commit();
} catch (Exception $e) {
$con->rollBack();
$results['success'] = false;
$results['errmsg'] = $e->getMessage();
}
return $results;
}
public static function updateClientIdentity($params, $currentUser, $con)
{
$option = OptionQuery::create()->filterByName('client_name')->findOne($con);
$option->setValue($params->client_name)->save($con);
$option = OptionQuery::create()->filterByName('client_address')->findOne($con);
$option->setValue($params->client_address)->save($con);
$option = OptionQuery::create()->filterByName('client_phone')->findOne($con);
$option->setValue($params->client_phone)->save($con);
$option = OptionQuery::create()->filterByName('client_email')->findOne($con);
$option->setValue($params->client_email)->save($con);
$option = OptionQuery::create()->filterByName('client_website')->findOne($con);
$option->setValue($params->client_website)->save($con);
$results['success'] = true;
$results['data'] = 'Yay';
return $results;
}
use ORM\CreditQuery;
use ORM\CreditPaymentQuery;
use ORM\OptionQuery;
use Propel\Runtime\Propel;
require '../../vendor/autoload.php';
require '../propel-config.php';
require '../session.php';
if (!$session->get('pos/state') === 1) {
die('Akses ditolak. Anda belum masuk.');
}
$con = Propel::getConnection('pos');
$con->beginTransaction();
$id = isset($_GET['id']) ? $_GET['id'] : die('Missing Parameter.');
// Get application info from database
$info = [];
$options = OptionQuery::create()->filterByName(['app_name', 'app_photo', 'dev_name', 'dev_email', 'dev_phone', 'dev_website', 'dev_address', 'client_name', 'client_email', 'client_phone', 'client_website', 'client_address', 'homepath'])->find($con);
foreach ($options as $row) {
$info[$row->getName()] = $row->getValue();
}
$info = (object) $info;
?>
<!DOCTYPE html>
<html lang="id">
<head>
<title>Print Nota Piutang <?php
echo $id;
?>
</title>
<link rel="stylesheet" type="text/css" href="print.css">
</head>
require '../vendor/autoload.php';
require 'propel-config.php';
require 'session.php';
$con = Propel::getConnection('pos');
$con->beginTransaction();
try {
// Get application info from database
$info = [];
$options = OptionQuery::create()->filterByName(['app_name', 'app_photo', 'dev_name', 'dev_email', 'dev_phone', 'dev_website', 'dev_address', 'client_name', 'client_email', 'client_phone', 'client_website', 'client_address', 'homepath'])->find($con);
foreach ($options as $row) {
$info[$row->getName()] = $row->getValue();
}
$root['info'] = $info;
// get shortcut key from database
$shortcutKeys = [];
$keys = OptionQuery::create()->filterByName(['sales_key', 'sales_add_key', 'sales_pay_key', 'sales_save_key', 'sales_cancel_key', 'purchase_key', 'purchase_add_key', 'purchase_pay_key', 'purchase_save_key', 'purchase_cancel_key'])->find($con);
foreach ($keys as $key) {
$shortcutKeys[$key->getName()] = $key->getValue();
}
$root['shortcutKeys'] = $shortcutKeys;
// Check previous session
try {
if ($session->get('pos/state') === 0 || !isset($session->get('pos/current_user')->id)) {
throw new Exception();
}
$user = UserQuery::create()->filterById($session->get('pos/current_user')->id)->select(['id', 'user', 'role_id'])->leftJoin('Detail')->withColumn('Detail.Name', 'name')->withColumn('Detail.Address', 'address')->withColumn('Detail.Phone', 'phone')->findOne($con);
if (!$user) {
throw new Exception();
}
$root['state'] = 1;
$root['current_user'] = (object) $user;
/**
* Removes this object from datastore and sets delete attribute.
*
* @param ConnectionInterface $con
* @return void
* @throws PropelException
* @see Option::setDeleted()
* @see Option::isDeleted()
*/
public function delete(ConnectionInterface $con = null)
{
if ($this->isDeleted()) {
throw new PropelException("This object has already been deleted.");
}
if ($con === null) {
$con = Propel::getServiceContainer()->getWriteConnection(OptionTableMap::DATABASE_NAME);
}
$con->transaction(function () use($con) {
$deleteQuery = ChildOptionQuery::create()->filterByPrimaryKey($this->getPrimaryKey());
$ret = $this->preDelete($con);
if ($ret) {
$deleteQuery->delete($con);
$this->postDelete($con);
$this->setDeleted(true);
}
});
}
/**
* Performs an INSERT on the database, given a Option or Criteria object.
*
* @param mixed $criteria Criteria or Option object containing data that is used to create the INSERT statement.
* @param ConnectionInterface $con the ConnectionInterface connection to use
* @return mixed The new primary key.
* @throws PropelException Any exceptions caught during processing will be
* rethrown wrapped into a PropelException.
*/
public static function doInsert($criteria, ConnectionInterface $con = null)
{
if (null === $con) {
$con = Propel::getServiceContainer()->getWriteConnection(OptionTableMap::DATABASE_NAME);
}
if ($criteria instanceof Criteria) {
$criteria = clone $criteria;
// rename for clarity
} else {
$criteria = $criteria->buildCriteria();
// build Criteria from Option object
}
// Set the correct dbName
$query = OptionQuery::create()->mergeWith($criteria);
// use transaction because $criteria could contain info
// for more than one table (I guess, conceivably)
return $con->transaction(function () use($con, $query) {
return $query->doInsert($con);
});
}
