/**
* REST actions
*
* This function contains the REST actions with the assignments to
* the functions.
*/
public function __construct()
{
// runs the CConfig
$com = new CConfig(DBSetting::getPrefix() . ',course,link', dirname(__FILE__));
// runs the DBSetting
if ($com->used()) {
return;
}
$this->_conf = $com;
// initialize slim
$this->_app = new \Slim\Slim(array('debug' => true));
$this->_app->response->headers->set('Content-Type', 'application/json');
// POST AddCourse
$this->_app->post('(/:pre)/course', array($this, 'addCourse'));
// POST DeleteCourse
$this->_app->delete('(/:pre)/course/:courseid', array($this, 'deleteCourse'));
// PUT EditSetting
$this->_app->put('(/:pre)/' . $this->getPrefix() . '/setting/:setid', array($this, 'editSetting'));
// DELETE DeleteSetting
$this->_app->delete('(/:pre)/' . $this->getPrefix() . '/setting/:setid', array($this, 'deleteSetting'));
// POST AddSetting
$this->_app->post('(/:pre)/' . $this->getPrefix() . '/course/:courseid', array($this, 'addSetting'));
// GET GetExistsCourseSettings
$this->_app->get('(/:pre)/link/exists/course/:courseid', array($this, 'getExistsCourseSettings'));
// GET GetCourseSettings
$this->_app->get('(/:pre)/' . $this->getPrefix() . '/course/:courseid', array($this, 'getCourseSettings'));
// GET GetSetting
$this->_app->get('(/:pre)/' . $this->getPrefix() . '/setting/:setid', array($this, 'getSetting'));
// GET GetSettingByName
$this->_app->get('(/:pre)/' . $this->getPrefix() . '/course/:courseid/name/:setname', array($this, 'getSettingByName'));
// run Slim
$this->_app->run();
}
/**
* REST actions
*
* This function contains the REST actions with the assignments to
* the functions.
*/
public function __construct()
{
// runs the CConfig
$com = new CConfig(DBAttachment2::getPrefix() . ',course,link', dirname(__FILE__));
// runs the DBAttachment2
if ($com->used()) {
return;
}
$this->_conf = $com;
// initialize slim
$this->_app = new \Slim\Slim(array('debug' => true));
$this->_app->response->headers->set('Content-Type', 'application/json');
// POST AddCourse
$this->_app->post('(/:pre)/course(/)', array($this, 'addCourse'));
// POST DeleteCourse
$this->_app->delete('(/:pre)/course/:courseid(/)', array($this, 'deleteCourse'));
// PUT EditAttachment
$this->_app->put('(/:pre)/' . $this->getPrefix() . '(/attachment)/:aid(/)', array($this, 'editAttachment'));
// DELETE DeleteAttachment
$this->_app->delete('(/:pre)/' . $this->getPrefix() . '(/attachment)/:aid(/)', array($this, 'deleteAttachment'));
// POST AddAttachment
$this->_app->post('(/:pre)/' . $this->getPrefix(), array($this, 'addAttachment'));
// GET GetExistsCourseAttachments
$this->_app->get('(/:pre)/link/exists/course/:courseid(/)', array($this, 'getExistsCourseAttachments'));
// GET GetAttachment
$this->_app->get('(/:pre)/' . $this->getPrefix() . '(/attachment)/:aid(/)', array($this, 'getAttachment'));
// GET GetExerciseAttachments
$this->_app->get('(/:pre)/' . $this->getPrefix() . '/exercise/:eid(/)', array($this, 'getExerciseAttachments'));
// GET GetSheetAttachments
$this->_app->get('(/:pre)/' . $this->getPrefix() . '/exercisesheet/:esid(/)', array($this, 'getSheetAttachments'));
// GET GetCourseAttachments
$this->_app->get('(/:pre)/' . $this->getPrefix() . '/course/:courseid(/)', array($this, 'getCourseAttachments'));
// run Slim
$this->_app->run();
}
/**
* REST actions
*
* This function contains the REST actions with the assignments to
* the functions.
*
* @param Component $conf component data
*/
public function __construct()
{
// runs the CConfig
$com = new CConfig(LCourse::getPrefix(), dirname(__FILE__));
// runs the LCourse
if ($com->used()) {
return;
}
$conf = $com->loadConfig();
// initialize slim
$this->app = new \Slim\Slim(array('debug' => true));
$this->app->response->headers->set('Content-Type', 'application/json');
// initialize component
$this->_conf = $conf;
$this->query = CConfig::getLink($conf->getLinks(), "controller");
$this->_deleteCourse = CConfig::getLinks($conf->getLinks(), "deleteCourse");
$this->_postCourse = CConfig::getLinks($conf->getLinks(), "postCourse");
// initialize lURL
$this->lURL = $this->query->getAddress();
//POST AddCourse
$this->app->post('/' . $this->getPrefix() . '(/)', array($this, 'AddCourse'));
//PUT EditCourse
$this->app->put('/' . $this->getPrefix() . '/course/:courseid(/)', array($this, 'editCourse'));
//DELETE DeleteCourse
$this->app->delete('/' . $this->getPrefix() . '/course/:courseid(/)', array($this, 'deleteCourse'));
//POST AddCourseMember
$this->app->post('/' . $this->getPrefix() . '/course/:courseid/user/:userid/status/:status(/)', array($this, 'addCourseMember'));
//GET GetCourseMember
$this->app->get('/' . $this->getPrefix() . '/course/:courseid/user(/)', array($this, 'getCourseMember'));
//GET GetCourses
$this->app->get('/' . $this->getPrefix() . '/user/:userid(/)', array($this, 'getCourses'));
//run Slim
$this->app->run();
}
/**
* the component constructor
*/
public function __construct()
{
// runs the CConfig
$com = new CConfig(CControl::getPrefix() . ',link,definition', dirname(__FILE__));
// runs the DBSubmission
if ($com->used()) {
return;
}
// initialize slim
$this->_app = new \Slim\Slim();
$this->_app->response->headers->set('Content-Type', 'application/json');
// POST AddPlatform
$this->_app->post('/platform', array($this, 'addPlatform'));
// DELETE DeletePlatform
$this->_app->delete('/platform', array($this, 'deletePlatform'));
// GET GetExistsPlatform
$this->_app->get('/link/exists/platform', array($this, 'getExistsPlatform'));
// GET GetTableReferences
$this->_app->get('/tableReferences', array($this, 'getTableReferences'));
// PUT EditLink
$this->_app->put('/link/:linkid(/)', array($this, 'editLink'));
// DELETE DeleteLink
$this->_app->delete('/link/:linkid(/)', array($this, 'deleteLink'));
// POST SetLink
$this->_app->post('/link(/)', array($this, 'setLink'));
// GET GetLink
$this->_app->get('/link/:linkid(/)', array($this, 'getLink'));
// PUT EditComponent
$this->_app->put('/component/:componentid(/)', array($this, 'editComponent'));
// DELETE DeleteComponent
$this->_app->delete('/component/:componentid(/)', array($this, 'deleteComponent'));
// POST SetComponent
$this->_app->post('/component(/)', array($this, 'setComponent'));
// GET GetComponent
$this->_app->get('/component/:componentid(/)', array($this, 'getComponent'));
// GET GetComponentDefinitions
$this->_app->get('/definition(/)', array($this, 'getComponentDefinitions'));
// GET SendComponentDefinitions
$this->_app->get('(/definition)/send(/)', array($this, 'sendComponentDefinitions'));
// GET GetComponentDefinition
$this->_app->get('/definition/:componentid(/)', array($this, 'getComponentDefinition'));
// run Slim
$this->_app->run();
}
/**
* REST actions
*
* This function contains the REST actions with the assignments to
* the functions.
*/
public function __construct()
{
// runs the CConfig
$com = new CConfig(DBForm::getPrefix() . ',course,link', dirname(__FILE__));
// runs the DBForm
if ($com->used()) {
return;
}
$conf = $com->loadConfig();
// initialize component
$this->_conf = $conf;
$this->query = array(CConfig::getLink($conf->getLinks(), 'out'));
// initialize slim
$this->_app = new \Slim\Slim();
$this->_app->response->headers->set('Content-Type', 'application/json');
// POST AddCourse
$this->_app->post('/course(/)', array($this, 'addCourse'));
// POST DeleteCourse
$this->_app->delete('/course/:courseid(/)', array($this, 'deleteCourse'));
// PUT EditForm
$this->_app->put('/' . $this->getPrefix() . '(/form)/:formid(/)', array($this, 'editForm'));
// DELETE DeleteForm
$this->_app->delete('/' . $this->getPrefix() . '(/form)/:formid(/)', array($this, 'deleteForm'));
// POST AddForm
$this->_app->post('/' . $this->getPrefix() . '(/)', array($this, 'addForm'));
// GET GetForm
$this->_app->get('/' . $this->getPrefix() . '(/form)/:formid(/)', array($this, 'getForm'));
// GET GetCourseForms
$this->_app->get('/' . $this->getPrefix() . '/course/:courseid(/)', array($this, 'getCourseForms'));
// GET GetExistsCourseForms
$this->_app->get('/link/exists/course/:courseid(/)', array($this, 'getExistsCourseForms'));
// GET GetSheetForms
$this->_app->get('/' . $this->getPrefix() . '/exercisesheet/:esid(/)', array($this, 'getSheetForms'));
// GET GetExerciseForms
$this->_app->get('/' . $this->getPrefix() . '/exercise/:eid(/)', array($this, 'getExerciseForms'));
// run Slim
$this->_app->run();
}
/**
* REST actions
*
* This function contains the REST actions with the assignments to
* the functions.
*/
public function __construct()
{
// runs the CConfig
$com = new CConfig(DBChoice::getPrefix() . ',course,link', dirname(__FILE__));
// runs the DBChoice
if ($com->used()) {
return;
}
// initialize component
$this->_conf = $com;
// initialize slim
$this->_app = new \Slim\Slim(array('debug' => true));
$this->_app->response->headers->set('Content-Type', 'application/json');
// POST AddCourse
$this->_app->post('(/:preChoice(/:preForm(/:preExercise)))/course', array($this, 'addCourse'));
// DELETE DeleteCourse
$this->_app->delete('(/:preChoice(/:preForm(/:preExercise)))/course(/course)/:courseid', array($this, 'deleteCourse'));
// PUT EditChoice
$this->_app->put('(/:preChoice(/:preForm(/:preExercise)))/' . $this->getPrefix() . '(/choice)/:choiceid(/)', array($this, 'editChoice'));
// DELETE DeleteChoice
$this->_app->delete('(/:preChoice(/:preForm(/:preExercise)))/' . $this->getPrefix() . '(/choice)/:choiceid(/)', array($this, 'deleteChoice'));
// POST AddChoice
$this->_app->post('(/:preChoice(/:preForm(/:preExercise)))/' . $this->getPrefix() . '(/)', array($this, 'addChoice'));
// GET GetChoice
$this->_app->get('(/:preChoice(/:preForm(/:preExercise)))/' . $this->getPrefix() . '(/choice)/:choiceid(/)', array($this, 'getChoice'));
// GET GetCourseChoices
$this->_app->get('(/:preChoice(/:preForm(/:preExercise)))/' . $this->getPrefix() . '/course/:courseid(/)', array($this, 'getCourseChoices'));
// GET GetExistsCourseChoices
$this->_app->get('(/:preChoice(/:preForm(/:preExercise)))/link/exists/course/:courseid(/)', array($this, 'getExistsCourseChoices'));
// GET GetSheetChoices
$this->_app->get('(/:preChoice(/:preForm(/:preExercise)))/' . $this->getPrefix() . '/exercisesheet/:esid(/)', array($this, 'getSheetChoices'));
// GET GetExerciseChoices
$this->_app->get('(/:preChoice(/:preForm(/:preExercise)))/' . $this->getPrefix() . '/exercise/:eid(/)', array($this, 'getExerciseChoices'));
// GET GetFormChoices
$this->_app->get('(/:preChoice(/:preForm(/:preExercise)))/' . $this->getPrefix() . '/form/:formid(/)', array($this, 'getFormChoices'));
// run Slim
$this->_app->run();
}
/**
* REST actions
*
* This function contains the REST actions with the assignments to
* the functions.
*
* @param Component $conf component data
*/
public function __construct()
{
// runs the CConfig
$com = new CConfig(DBAttachment::getPrefix(), dirname(__FILE__));
// runs the DBAttachment
if ($com->used()) {
return;
}
$conf = $com->loadConfig();
// initialize component
$this->_conf = $conf;
$this->query = array(CConfig::getLink($conf->getLinks(), 'out'));
$this->query2 = array(CConfig::getLink($conf->getLinks(), 'out2'));
// initialize slim
$this->_app = new \Slim\Slim();
$this->_app->response->setStatus(409);
$this->_app->response->headers->set('Content-Type', 'application/json');
// POST AddPlatform
$this->_app->post('/platform', array($this, 'addPlatform'));
// DELETE DeletePlatform
$this->_app->delete('/platform', array($this, 'deletePlatform'));
// GET GetExistsPlatform
$this->_app->get('/link/exists/platform', array($this, 'getExistsPlatform'));
// PUT EditAttachment
$this->_app->put('/' . $this->getPrefix() . '(/attachment)/:aid(/)', array($this, 'editAttachment'));
// DELETE DeleteAttachment
$this->_app->delete('/' . $this->getPrefix() . '(/attachment)/:aid(/)', array($this, 'deleteAttachment'));
// DELETE DeleteExerciseAttachments
$this->_app->delete('/' . $this->getPrefix() . '/exercise/:eid(/)', array($this, 'deleteExerciseAttachment'));
// DELETE DeleteExerciseFileAttachment
$this->_app->delete('/' . $this->getPrefix() . '/exercise/:eid/file/:fileid(/)', array($this, 'deleteExerciseFileAttachment'));
// POST AddAttachment
$this->_app->post('/' . $this->getPrefix() . '(/)', array($this, 'addAttachment'));
// GET GetAttachment
$this->_app->get('/' . $this->getPrefix() . '(/attachment)/:aid(/)', array($this, 'getAttachment'));
// GET GetAllAttachments
$this->_app->get('/' . $this->getPrefix() . '(/attachment)(/)', array($this, 'getAllAttachments'));
// GET GetExerciseAttachments
$this->_app->get('/' . $this->getPrefix() . '/exercise/:eid(/)', array($this, 'getExerciseAttachments'));
// GET GetSheetAttachments
$this->_app->get('/' . $this->getPrefix() . '/exercisesheet/:esid(/)', array($this, 'getSheetAttachments'));
// run Slim
$this->_app->run();
}
//Sample POST route for PHP >=5.3
Slim::post('/post', function () {
echo '<p>Here are the details about your POST request:</p>';
print_r(Slim::request());
});
//Sample POST route for PHP <5.3
/*
Slim::post('/post', 'post_example');
function post_example() {
echo '<br/><br/>Here are the details about your POST request:<br/><br/>';
print_r(Slim::request());
}
*/
//Sample PUT route for PHP >=5.3
Slim::put('/put', function () {
echo '<p>Here are the details about your PUT request:</p>';
print_r(Slim::request());
});
//Sample PUT route for PHP <5.3
/*
Slim::put('/put', 'put_example');
function put_example() {
echo '<br/><br/>Here are the details about your PUT request:<br/><br/>';
print_r(Slim::request());
}
*/
//Sample DELETE route for PHP >=5.3
Slim::delete('/delete', function () {
echo '<p>Here are the details about your DELETE request:</p>';
print_r(Slim::request());
});
//Sample DELETE route for PHP <5.3
} else {
echo json_encode(array("status" => false, "message" => "Book ID {$id} does not exist"));
}
});
$app->post("/book", function () use($app, $db) {
$app->response()->header("Content-Type", "application/json");
$book = $app->request()->post();
$result = $db->books->insert($book);
echo json_encode(array("id" => $result["id"]));
});
$app->put("/book/:id", function ($id) use($app, $db) {
$app->response()->header("Content-Type", "application/json");
$book = $db->books()->where("id", $id);
if ($book->fetch()) {
$post = $app->request()->put();
$result = $book->update($post);
echo json_encode(array("status" => (bool) $result, "message" => "Book updated successfully"));
} else {
echo json_encode(array("status" => false, "message" => "Book id {$id} does not exist"));
}
});
$app->delete("/book/:id", function ($id) use($app, $db) {
$app->response()->header("Content-Type", "application/json");
$book = $db->books()->where("id", $id);
if ($book->fetch()) {
$result = $book->delete();
echo json_encode(array("status" => true, "message" => "Book deleted successfully"));
} else {
echo json_encode(array("status" => false, "message" => "Book id {$id} does not exist"));
}
});
<?php
require 'Slim/Slim.php';
$app = new Slim();
$app->get('/items', 'getItems');
$app->get('/items/:id', 'getItem');
$app->get('/items/search/:query', 'findByName');
$app->post('/items', 'addItem');
$app->put('/items/:id', 'updateItem');
$app->delete('/items/:id', 'deleteItem');
$app->run();
function getItems()
{
$sql = "select * FROM item ORDER BY name";
try {
$db = getConnection();
$stmt = $db->query($sql);
$items = $stmt->fetchAll(PDO::FETCH_OBJ);
$db = null;
// echo '{"items": ' . json_encode($items) . '}';
echo json_encode($items);
} catch (PDOException $e) {
echo '{"error":{"text":' . $e->getMessage() . '}}';
}
}
function getItem($id)
{
$sql = "SELECT * FROM item WHERE id=:id";
try {
$db = getConnection();
$stmt = $db->prepare($sql);
<h2>Slim Framework Extras</h2>
<p>
Custom View classes for Smarty, Twig, Mustache, and other template
frameworks are available online in a separate repository.
</p>
<p><a href="https://github.com/codeguy/Slim-Extras" target="_blank">Browse the Extras Repository</a></p>
</section>
</body>
</html>
EOT;
echo $template;
});
//POST route
$app->post('/post', function () {
echo 'This is a POST route';
});
//PUT route
$app->put('/put', function () {
echo 'This is a PUT route';
});
//DELETE route
$app->delete('/delete', function () {
echo 'This is a DELETE route';
});
/**
* Step 4: Run the Slim application
*
* This method should be called last. This is responsible for executing
* the Slim application using the settings and routes defined above.
*/
$app->run();
<?php
set_include_path(implode(PATH_SEPARATOR, array(realpath(dirname(__FILE__) . '/library'), get_include_path())));
require_once 'Slim/Slim.php';
require_once 'controller/ProdutosController.php';
$app = new Slim();
$pcontroller = new ProdutosController();
$app->get('/produtos', function () use($pcontroller) {
echo json_encode($pcontroller->listarProdutos());
});
$app->post('/produtos', function () use($pcontroller, $app) {
$produto = json_decode(file_get_contents("php://input"));
echo json_encode($pcontroller->salvarProduto($produto));
});
$app->put('/produtos', function () use($pcontroller, $app) {
$produto = $app->request()->put();
unset($produto['$$hashKey']);
echo json_encode($pcontroller->atualizarProduto($produto));
});
$app->delete('/produtos/:id', function ($id) use($pcontroller) {
echo $pcontroller->removerProduto($id);
});
$app->run();
<?php
require 'Slim/Slim.php';
$app = new Slim();
$app->get('/users', 'getUsers');
$app->post('/users', 'addUser');
$app->get('/users/:id', 'getUser');
$app->get('/users/search/:query', 'findByName');
$app->put('/users/:id', 'updateUser');
$app->delete('/users/:id', 'deleteUser');
$app->run();
function getConnection()
{
$dbhost = "127.0.0.1";
$dbuser = "******";
$dbpass = "******";
$dbname = "angular-mysql";
$dbh = new PDO("mysql:host={$dbhost};dbname={$dbname}", $dbuser, $dbpass);
$dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
return $dbh;
}
function getUsers()
{
$sql = "select * FROM users ORDER BY id";
try {
$db = getConnection();
$stmt = $db->query($sql);
$users = $stmt->fetchAll(PDO::FETCH_OBJ);
$db = null;
echo json_encode($users);
} catch (PDOException $e) {
<?php
require 'Slim/Slim.php';
$app = new Slim();
$app->get('/wines', 'getWines');
$app->get('/wines/:id', 'getWine');
$app->get('/wines/search/:query', 'findByName');
$app->post('/wines', 'addWine');
$app->put('/wines/:id', 'updateWine');
$app->delete('/wines/:id', 'deleteWine');
$app->run();
function getWines()
{
$sql = "select * FROM wine ORDER BY name";
try {
$db = getConnection();
$stmt = $db->query($sql);
$wines = $stmt->fetchAll(PDO::FETCH_OBJ);
$db = null;
// echo '{"wine": ' . json_encode($wines) . '}';
echo json_encode($wines);
} catch (PDOException $e) {
echo '{"error":{"text":' . $e->getMessage() . '}}';
}
}
function getWine($id)
{
$sql = "SELECT * FROM wine WHERE id=:id";
try {
$db = getConnection();
$stmt = $db->prepare($sql);
<?php
require 'Slim/Slim.php';
$app = new Slim();
$app->get('/beers', 'getBeers');
$app->get('/beers/:id', 'getBeer');
$app->get('/beers/search/:query', 'findByName');
$app->post('/beers', 'addBeer');
$app->put('/beers/:id', 'updateBeer');
$app->delete('/beers/:id', 'deleteBeer');
$app->run();
function getBeers()
{
$sql = "select * FROM wine ORDER BY name";
try {
$db = getConnection();
$stmt = $db->query($sql);
$beers = $stmt->fetchAll(PDO::FETCH_OBJ);
$db = null;
// echo '{"wine": ' . json_encode($beers) . '}';
echo json_encode($beers);
} catch (PDOException $e) {
echo '{"error":{"text":' . $e->getMessage() . '}}';
}
}
function getBeer($id)
{
$sql = "SELECT * FROM wine WHERE id=:id";
try {
$db = getConnection();
$stmt = $db->prepare($sql);
/**
* Test Slim sets PUT route
*
* Pre-conditions:
* You have initialized a Slim app with a PUT route.
*
* Post-conditions:
* The PUT route is returned, and its pattern and
* callable are set correctly.
*/
public function testSlimPutRoute(){
Slim::init();
$callable = function () { echo "foo"; };
$route = Slim::put('/foo/bar', $callable);
$this->assertEquals('/foo/bar', $route->getPattern());
$this->assertSame($callable, $route->getCallable());
}
require 'service/cart.php';
require 'service/qrcode.php';
require 'service/icon.php';
require 'service/dashboard.php';
require 'service/cart_cron.php';
require_once 'service/voucher_pdf.php';
require_once 'service/merchantrestaurants.php';
require_once 'service/merchantoutlet.php';
require_once 'service/merchantmenucategory.php';
$app = new Slim();
$app->config('debug', true);
$app->get('/wines', 'getWines');
$app->get('/wines/:id', 'getWine');
$app->get('/wines/search/:query', 'findByName');
$app->post('/wines', 'addWine');
$app->put('/wines/:id', 'updateWine');
$app->delete('/wines/:id', 'deleteWine');
/***************** Users ************/
$app->post('/users', 'addUser');
$app->post('/users/login', 'getlogin');
$app->post('/users/forgotPass', 'getforgetPass');
$app->post('/users/changePassword', 'changePassword');
$app->put('/users/:id', 'updateUser');
$app->put('/users/activeProfile/:id', 'activeProfile');
$app->get('/users', 'getAllUsers');
$app->get('/user/:id', 'getUser');
$app->post('/users/logout', 'getlogout');
$app->delete('/users/:id', 'deleteUser');
$app->get('/getAllMerchants', 'getAllMerchants');
$app->get('/getCustomer/:id', 'getCustomer');
$app->get('/getAllCustomers', 'getAllCustomers');
<?php
require 'Slim/Slim.php';
$app = new Slim();
//restful actions
//when the slim app receives a get/post/put/delete the relevant function is called
$app->get('/films', 'getFilms');
$app->get('/films/:id', 'getFilm');
$app->get('/films/search/:query', 'findByName');
$app->post('/films', 'addFilm');
$app->put('/films/:id', 'updateFilm');
$app->delete('/films/:id', 'deleteFilm');
$app->run();
function getFilms()
{
$sql = "select * FROM film ORDER BY title";
try {
$db = getConnection();
$stmt = $db->query($sql);
$films = $stmt->fetchAll(PDO::FETCH_OBJ);
$db = null;
echo '{"film": ' . json_encode($films) . '}';
} catch (PDOException $e) {
echo '{"error":{"text":' . $e->getMessage() . '}}';
}
}
function getFilm($id)
{
$sql = "SELECT * FROM film WHERE id=:id";
try {
$db = getConnection();
//Users
$app->post('/users', 'createUser');
//Done
$app->get('/users/all', 'getAllUsers');
//Done
$app->get('/users/common', 'getAllCommonUsers');
//Done
$app->get('/users/mailroom', 'getAllMailroomUsers');
//Done
$app->get('/users/admin', 'getAllAdminUsers');
//Done
//Mail
//$app->get('/mails/all','getAllMail');//Done
$app->post('/mails', 'submitMail');
//Done
$app->put('/mails/:id', 'updateMail');
//Done
$app->put('/mails/state/:id', 'changeState');
//Done
$app->put('/mails/recipient/confirm', 'confirmReceived');
//Done
$app->get('/mails/state/:id', 'getState');
$app->delete('/mails/:id', 'deleteMail');
//Done
$app->get('/mails/track/:id', 'trackMail');
//Done
$app->get('/mails/:id', 'getMailDetails');
//Done
$app->get('/mails/code/:id', 'getMailDetailsByCode');
//Done
//Tracker 1.Submitted
* 更新CP列表
*/
$app->put('/require/cp', function () use($app) {
$req_data = $app->request()->put();
$display_order = $req_data['require'];
//echo '===11==';
//dump($display_order);
$ids = implode(',', array_keys($display_order));
$sql = "UPDATE tb_require SET require_cp_id = CASE require_id ";
foreach ($display_order as $id => $ordinal) {
$sql .= sprintf("WHEN %d THEN %d ", $id, $ordinal);
}
$sql .= "END, require_state = CASE require_id ";
foreach ($display_order as $id => $ordinal) {
$sql .= sprintf("WHEN %d THEN 2 ", $id);
}
$sql .= " END WHERE require_id IN ({$ids})";
//echo '==='.$sql;
try {
$db = getConnection();
$stmt = $db->prepare($sql);
$stmt->execute();
$db = null;
echo '{"require":' . json_encode($display_order) . '}';
elog(" put require cp success. msg = " . json_encode($display_order));
} catch (PDOException $e) {
echo '{"error":{"text":"' . $e->getMessage() . '"}}';
elog(" put require cp error. data = " . json_encode($display_order) . " msg = " . $e->getMessage(), 'error');
}
});
/**
* 根据ID 修改需求
<?php
require dirname(__FILE__) . '/../Slim/Slim.php';
$app = new Slim();
$app->get("/", "getStores");
$app->get("/:id", "getStore");
$app->get("/search/:query", "findByName");
$app->post("/", "addStore");
$app->put("/:id", "updateStore");
$app->delete("/:id", "deleteStore");
$app->run();
function getStores()
{
$sql = "select * FROM store ORDER BY name";
try {
$db = getConnection();
$stmt = $db->query($sql);
$stores = $stmt->fetchAll(PDO::FETCH_OBJ);
$db = null;
// echo '{"wine": ' . json_encode($wines) . '}';
echo json_encode($stores);
} catch (PDOException $e) {
echo '{"error":{"text":' . $e->getMessage() . '}}';
}
}
function getStore($id)
{
$sql = "SELECT * FROM store WHERE id=:id";
try {
$db = getConnection();
$stmt = $db->prepare($sql);
<?php
require 'Slim/Slim.php';
require '../site/functions.php';
$app = new Slim();
$app->get('/accomplishment/:id', 'GetAccomplishment');
$app->get('/allaccomplishment/:id', 'GetAllAccomplishments');
$app->get('/accomplishment/search/:query', 'FinaByAccomplishment');
$app->post('/accomplishment', 'InsertAccomplishment');
$app->put('/accomplishment/:id', 'UpdateAccomplishment');
$app->delete('/accomplishment/:id', 'DeleteAccomplishment');
$app->get('/accomplishment/title/:keyword', 'getTitlesFromCache');
$app->get('/accomplishment/alltitle', 'getAllTitles');
$app->run();
// Generate Guid
function NewGuid()
{
$s = strtoupper(md5(uniqid(rand(), true)));
$guidText = substr($s, 0, 8) . substr($s, 8, 4) . substr($s, 12, 4) . substr($s, 16, 4) . substr($s, 20);
return $guidText;
}
// End Generate Guid
function getWines()
{
$sql = "select * FROM wine ORDER BY name";
try {
$db = getConnection();
$stmt = $db->query($sql);
$wines = $stmt->fetchAll(PDO::FETCH_OBJ);
$db = null;
echo '{"wine": ' . json_encode($wines) . '}';
<?php
session_start();
require 'Business/PatientData.php';
require 'Business/DoctorData.php';
require 'Business/StaffData.php';
require 'Business/MasterData.php';
require 'Slim/Slim.php';
$app = new Slim();
error_reporting(E_ALL);
ini_set("log_errors", true);
ini_set("error_log", "/Applications/MAMP/htdocs/HealthCareSystem/RestAPI/errorlog.log");
$app->get('/authenticate/:username/:password', 'authenticateUser');
$app->get('/', 'initialMessage');
$app->post('/registerUser', 'registerUser');
$app->put('/updateprofile/:id', 'updateProfile');
$app->get('/appointmentsList/:hosiptal/:doctor/:appdate', 'appointmentsList');
$app->post('/createAppointment', 'createAppointment');
$app->get('/hosiptalDoctorData', 'hosiptalDoctorData');
$app->get('/professionBasedData/:profession/:name', 'professionBasedData');
$app->get('/doctorMasterData/:doctorId', 'doctorMasterData');
$app->get('/userMasterData/:userId', 'userMasterData');
$app->post('/createUser', 'createUser');
$app->get('/patientList/:patientName', 'patientList');
$app->get('/appointmentPatientList/:patientName/:hosiptal/:appdate', 'appointmentPatientList');
$app->put('/updateAppointment/:appointmentId', 'updateAppointment');
$app->run();
function initialMessage()
{
try {
//echo "<h1>Hello Slim World</h1>";
ActiveRecord\Config::initialize(function ($cfg) {
$cfg->set_connections(array('development' => 'mysql://root:@localhost/todos'));
});
$app = new Slim();
function reqBody()
{
global $app;
return json_decode($app->request()->getBody(), true);
}
$app->get('/json', function () {
echo json_encode(array_map(function ($todo) {
return $todo->attributes();
}, Todo::all()));
});
$app->post('/json', function () {
$todo = new Todo(reqBody());
$todo->save();
});
$app->get('/json/:id', function ($id) {
echo Todo::find($id)->to_json();
});
$app->put('/json/:id', function ($id) {
Todo::find($id)->update_attributes(reqBody());
});
$app->delete('/json/:id', function ($id) {
Todo::find($id)->delete();
});
$app->get('/', function () {
echo file_get_contents('index.html');
});
$app->run();
$app->get('/users/search/:name', function ($name) use($user) {
$user->getByName($name);
});
$app->delete('/users/:id', function ($id) use($user) {
$user->delete($id);
});
$app->post('/users', function () use($user, $app) {
$request = $app->request();
$body = $request->getBody();
$vo = json_decode($body);
$user->insert($vo);
});
$app->put('/users/:id', function ($id) use($user, $app) {
$request = $app->request();
$body = $request->getBody();
$vo = json_decode($body);
$vo->facebook_user_id = $id;
$user->update($vo);
});
$app->put('/users/:id/score', function ($id) use($user, $app) {
$request = $app->request();
$body = $request->getBody();
$vo = json_decode($body);
$vo->facebook_user_id = $id;
$user->updateScore($vo);
$user->updatePlayerRewards($id, $vo->game_score, $vo->score);
});
$app->put('/users/:id/friends', function ($id) use($user, $app) {
$request = $app->request();
$body = $request->getBody();
$vo = json_decode($body);
// Access-Control headers are received during OPTIONS requests
if ($_SERVER['REQUEST_METHOD'] == 'OPTIONS') {
if (isset($_SERVER['HTTP_ACCESS_CONTROL_REQUEST_METHOD'])) {
header("Access-Control-Allow-Methods: GET, POST, OPTIONS, PUT, DELETE");
}
if (isset($_SERVER['HTTP_ACCESS_CONTROL_REQUEST_HEADERS'])) {
header("Access-Control-Allow-Headers: {$_SERVER['HTTP_ACCESS_CONTROL_REQUEST_HEADERS']}");
}
exit(0);
}
include 'Slim/Slim.php';
$app = new Slim();
$app->post('/login', 'userLogin');
$app->post('/join', 'userJoin');
$app->delete('/user', 'deleteUser');
$app->put('/user', 'updateUser');
$app->get('/user', 'getUser');
$app->get('/user/:id', 'getUser');
//INCOMPLETE:
//$app->post('/users/search', 'findByParameter');
$app->run();
function userLogin()
{
$request = Slim::getInstance()->request();
$user = json_decode($request->getBody());
//Get Salt
$sql = "SELECT\n\n salt\n\n FROM users WHERE username=:username LIMIT 1";
try {
$db = getConnection();
$stmt = $db->prepare($sql);
$stmt->bindParam("username", $user->username);
<?php
require "includes/index.php";
require_once "Slim/Slim.php";
$data = new Slim();
$data->get('/books/search', function () use($data) {
$query = $data->request()->params('name');
findByName($query);
});
$data->get('/books', 'getBooks');
$data->get('/books/:id', 'getBook');
//$data->get('/books/search:query', 'findByName');
$data->post('/books', 'addBook');
$data->put('/books/:id', 'updateBook');
$data->delete('/books/:id', 'deleteBook');
$data->run();
function getBooks()
{
$sql = "select * FROM books ORDER BY id DESC";
try {
$db = getConnection();
$stmt = $db->query($sql);
$books = $stmt->fetchAll(PDO::FETCH_OBJ);
$db = null;
echo json_encode($books);
} catch (PDOException $e) {
echo '{"error":{"text":' . $e->getMessage() . '}}';
}
}
function getBook($id)
{
<?php
require 'Slim/Slim.php';
require 'conexion.php';
$app = new Slim();
$app->get('/medicos', 'obtenerMedicos');
$app->get('/medicos/:id', 'obtenerMedico');
$app->post('/agregar_medico', 'agregarMedico');
$app->put('/medicos/:id', 'editarMedico');
$app->delete('/medicos/:id', 'eliminarMedico');
$app->get('/especialidades', 'obtenerEspecialidades');
$app->get('/especialidades/:id', 'obtenerEspecialidad');
$app->post('/agregar_especialidad', 'agregarEspecialidad');
$app->put('/especialidades/:id', 'editarEspecialidad');
$app->delete('/especialidades/:id', 'eliminarEspecialidad');
$app->get('/medicosespecialidades/:id', 'obtenerMedicoEspecialidades');
$app->post('/agregar_medicoespecialidad/:id', 'agregarMedicoEspecialidad');
$app->run();
function obtenerMedicos()
{
$sql = "select idMedico,CONCAT(Nombre,' ',Apellido) Nombre FROM medico where Estado=1 ORDER BY Nombre";
try {
$db = getConnection();
$stmt = $db->query($sql);
$wines = $stmt->fetchAll(PDO::FETCH_OBJ);
$db = null;
echo json_encode($wines);
} catch (PDOException $e) {
echo '{"error":{"text":' . $e->getMessage() . '}}';
}
}
<?php
require 'Slim/Slim.php';
$app = new Slim();
$app->get('/new-events', 'listNewEvents');
$app->put('/ack-event/:id', 'acknowledgeEvent');
$app->run();
function listNewEvents()
{
$sql = "SELECT event_id, user_id, wf_id, event_msg FROM events WHERE event_status=0 ORDER BY event_id";
try {
$dbT = getConnt();
$stmt = $dbT->query($sql);
$wines = $stmt->fetchAll(PDO::FETCH_OBJ);
$dbT = null;
echo json_encode($wines);
} catch (PDOException $e) {
echo '{"error":{"text":' . $e->getMessage() . '}}';
}
}
function acknowledgeEvent($id)
{
//$eid = $request->params('eid');
$sql = "UPDATE `events` SET event_status=2 WHERE event_id=:id";
try {
//$dbT = getConnection();
$dbT = getConnt();
$stmt = $dbT->prepare($sql);
//$stmt->bindParam("id", $eid)
$stmt->bindParam("id", $id);
$stmt->execute();
/**
* Test PUT route
*/
public function testPutRoute()
{
Slim_Environment::mock(array('REQUEST_METHOD' => 'PUT', 'SCRIPT_NAME' => '/foo', 'PATH_INFO' => '/bar'));
$s = new Slim();
$mw1 = function () {
echo "foo";
};
$mw2 = function () {
echo "bar";
};
$callable = function () {
echo "xyz";
};
$route = $s->put('/bar', $mw1, $mw2, $callable);
$s->call();
$this->assertEquals('foobarxyz', $s->response()->body());
$this->assertEquals('/bar', $route->getPattern());
$this->assertSame($callable, $route->getCallable());
}
