public static function role($params, $currentUser, $con) { $roles = RoleQuery::create()->filterByStatus('Active')->orderBy('name', 'ASC'); if (isset($params->query)) { $roles->where('Role.Name like ?', "%{$params->query}%"); } $roles = $roles->select(array('id', 'name'))->find($con); $data = []; foreach ($roles as $role) { $data[] = $role; } $results['success'] = true; $results['data'] = $data; return $results; }
public static function update($params, $currentUser, $con) { // check role's permission $permission = RolePermissionQuery::create()->select('update_role')->findOneById($currentUser->role_id, $con); if (!$permission || $permission != 1) { throw new \Exception('Akses ditolak. Anda tidak mempunyai izin untuk melakukan operasi ini.'); } // check whether role is already exist $role = RoleQuery::create()->filterByStatus('Active')->filterByName($params->name)->where('Role.Id not like ?', $params->id)->count($con); if ($role != 0) { throw new \Exception('Jabatan ' . $params->name . ' sudah ada dalam data'); } $role = RoleQuery::create()->filterByStatus('Active')->findOneById($params->id, $con); if (!$role) { throw new \Exception('Data tidak ditemukan'); } $role->setName($params->name)->save($con); $rowHistory = new RowHistory(); $rowHistory->setRowId($params->id)->setData('role')->setTime(time())->setOperation('update')->setUserId($currentUser->id)->save($con); $results['success'] = true; $results['data'] = $params; return $results; }
/** * Get the associated ChildRole object * * @param ConnectionInterface $con Optional Connection object. * @return ChildRole The associated ChildRole object. * @throws PropelException */ public function getRole(ConnectionInterface $con = null) { if ($this->aRole === null && ($this->id !== "" && $this->id !== null)) { $this->aRole = ChildRoleQuery::create()->findPk($this->id, $con); // Because this foreign key represents a one-to-one relationship, we will create a bi-directional association. $this->aRole->setPermission($this); } return $this->aRole; }
/** * Returns a new ChildRoleQuery object. * * @param string $modelAlias The alias of a model in the query * @param Criteria $criteria Optional Criteria to build the query from * * @return ChildRoleQuery */ public static function create($modelAlias = null, Criteria $criteria = null) { if ($criteria instanceof ChildRoleQuery) { return $criteria; } $query = new ChildRoleQuery(); if (null !== $modelAlias) { $query->setModelAlias($modelAlias); } if ($criteria instanceof Criteria) { $query->mergeWith($criteria); } return $query; }
public function onMessage(ConnectionInterface $from, $msg) { $event = $from->event = 'anonymous'; $data = []; // if message did not exist then deny access if (!isset($msg) || $msg == '') { throw new Exception('Wrong turn buddy'); } // if event or data did not exist then deny access $msg = json_decode($msg); if (!$msg || !isset($msg->event) || !isset($msg->data)) { throw new Exception('Wrong turn buddy'); } // store baby store em to variables $event = $from->event = $msg->event; $params = $msg->data; // if user not loged in yet then deny access if ($from->Session->get('pos/state') != 1) { throw new Exception('Akses ditolak. Anda belum login.'); } // initiating propel orm require_once 'propel-config.php'; Propel::disableInstancePooling(); $con = Propel::getConnection('pos'); // if user don't have role assigned then deny access $role = RoleQuery::create()->findOneById($from->Session->get('pos/current_user')->role_id); if (!$role) { throw new Exception('Akses ditolak. Anda belum punya Jabatan.'); } // uh... decoding event to get requested module and method $decode = explode('/', $event); // if decoded array length is not 2 then deny access if (count($decode) != 2) { throw new Exception('Wrong turn buddy'); } // store baby store em to variables... again $module = $decode[0]; $method = $decode[1]; // list of all module that can be requested $registeredModule = array('chart', 'combo', 'credit', 'customer', 'debit', 'notification', 'option', 'populate', 'product', 'purchase', 'report', 'role', 'sales', 'secondParty', 'stock', 'supplier', 'unit', 'user'); // if requested module is not registered then deny access if (!in_array($module, $registeredModule)) { throw new Exception('Wrong turn buddy'); } // you know it.. begin transaction $con->beginTransaction(); // this is where magic begins.. // route to requested module $data = $this->{$module}($method, $params, $from, $con); // commit transaction $con->commit(); // store to results variable before spitting it out back to client $results['event'] = $event; $results['data'] = $data; // errmmmmm $from->send(json_encode($results)); // followup action if ($event == 'purchase/create' || $event == 'purchase/destroy' || $event == 'purchase/update') { // get update of last 30 Days transaction's data $data = $this->chart('last30DaysTransaction', new \stdClass(), $from, $con); $last30DaysTransaction['event'] = 'chart/last30DaysTransaction'; $last30DaysTransaction['data'] = $data; // iterate through all connected client foreach ($this->clients as $client) { // get notification update of each client $data = $this->notification('read', new \stdClass(), $client, $con); $results['event'] = 'notification/read'; $results['data'] = $data; // push notification to each client $client->send(json_encode($results)); // push last 30 Days transaction's data to each client $client->send(json_encode($last30DaysTransaction)); } } elseif ($event == 'sales/create' || $event == 'sales/destroy' || $event == 'sales/update') { // get update of last 30 Days transaction's data $data = $this->chart('last30DaysTransaction', new \stdClass(), $from, $con); $last30DaysTransaction['event'] = 'chart/last30DaysTransaction'; $last30DaysTransaction['data'] = $data; // iterate through all connected client foreach ($this->clients as $client) { // push last 30 Days transaction's data to each client $client->send(json_encode($last30DaysTransaction)); } } // finish return; }
/** * Removes this object from datastore and sets delete attribute. * * @param ConnectionInterface $con * @return void * @throws PropelException * @see Role::setDeleted() * @see Role::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(RoleTableMap::DATABASE_NAME); } $con->transaction(function () use($con) { $deleteQuery = ChildRoleQuery::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 Role or Criteria object. * * @param mixed $criteria Criteria or Role 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(RoleTableMap::DATABASE_NAME); } if ($criteria instanceof Criteria) { $criteria = clone $criteria; // rename for clarity } else { $criteria = $criteria->buildCriteria(); // build Criteria from Role object } if ($criteria->containsKey(RoleTableMap::COL_ID) && $criteria->keyContainsValue(RoleTableMap::COL_ID)) { throw new PropelException('Cannot insert a value for auto-increment primary key (' . RoleTableMap::COL_ID . ')'); } // Set the correct dbName $query = RoleQuery::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); }); }
/** * Get the associated ChildRole object * * @param ConnectionInterface $con Optional Connection object. * @return ChildRole The associated ChildRole object. * @throws PropelException */ public function getRole(ConnectionInterface $con = null) { if ($this->aRole === null && ($this->role_id !== "" && $this->role_id !== null)) { $this->aRole = ChildRoleQuery::create()->findPk($this->role_id, $con); /* The following can be used additionally to guarantee the related object contains a reference to this object. This level of coupling may, however, be undesirable since it could result in an only partially populated collection in the referenced object. $this->aRole->addNotificationOptions($this); */ } return $this->aRole; }