/** * @url GET user/{userId} */ protected function getAllUserOrder($userId) { if ($userId == \TTO::getUserId() || \TTO::getRole() == 'admin') { $statement = 'SELECT * FROM `order` WHERE userId = :userId ORDER BY status DESC'; $bind = array('userId' => $userId); return \Db::getResult($statement, $bind); } else { throw new RestException(401, 'No Authorize or Invalid request !!!'); } }
/** * @url GET user/{userId} */ protected function getAllUserSection($userId, $courseId) { $statement = ' SELECT * FROM section AS S WHERE S.courseId = :courseId '; $bind = array('courseId' => $courseId); return \Db::getResult($statement, $bind); }
/** * @url GET allcourseitem/{courseId} */ protected function getAllCourseItem($courseId) { $statement = ' SELECT * FROM view_course_item AS VCI WHERE VCI.courseId = :courseId '; $bind = array('courseId' => $courseId); return \Db::getResult($statement, $bind); }
function RouteReport() { $varResult = Db::getResult('SELECT * FROM routes ORDER BY rtcode'); echo '<div id="RouteReport" class="RouteReport">' . "\n"; echo '<table border="0" cellpadding="0" cellspacing="0" width="100%">'; echo '<tr><th><h3>Route</h3></th><th><h3>Assignment</h3></th></tr>'; foreach ($varResult as $varRouteReport) { echo '<tr><td>' . $varRouteReport['rtcode'] . ' - ' . $varRouteReport['description'] . '</td>'; echo '<td>' . $varRouteReport['assignment'] . '</td></tr>'; } echo '</table>'; echo '</div>'; }
/** * @url GET allcommentdetail/{commenHeaderId} */ protected function getAllCommentDetail($commenHeaderId) { $statement = ' SELECT CD.*, U.nickname, U.avatarId FROM comment_detail AS CD INNER JOIN user AS U ON U.userId = C.userId WHERE commentHeaderId = :commentHeaderId ORDER BY CD.timestamp '; $bind = array('commentHeaderId' => $commentHeaderId); return \Db::getResult($statement, $bind); }
/** * @url GET item/{courseSectionId} */ protected function getItem($courseSectionId) { if (\TTO::getRole() == 'admin') { $statement = ' SELECT * FROM view_course_item AS CI WHERE CI.courseSectionId = :courseSectionId ORDER BY CI.courseItemId DESC '; $bind = array('courseSectionId' => $courseSectionId); return \Db::getResult($statement, $bind); } else { throw new RestException(401, 'No Authorize or Invalid request !!!'); } }
/** * @url GET allnotification/{userId} */ protected function getAllNotification($userId) { $statement = ' SELECT N.*, U.nickname, FU.nickname AS fromNickname FROM notification AS N INNER JOIN user AS U ON U.userId = N.userId INNER JOIN user AS FU ON FU.userId = N.fromUserId WHERE N.userId = :userId ORDER BY N.timestamp DESC '; $bind = array('userId' => $userId); return \Db::getResult($statement, $bind); }
/** * @url GET usercourselist/{userId} */ protected function getUserCourseList($userId) { if ($userId == \TTO::getUserId() || \TTO::getRole() == 'admin') { $statement = ' SELECT * FROM user_course AS UC INNER JOIN course AS C ON UC.courseId = C.courseId WHERE UC.userId = :userId '; $bind = array('userId' => $userId); return \Db::getResult($statement, $bind); } else { throw new RestException(401, 'No Authorize or Invalid request !!!'); } }
/** * @url GET /user/{userId} */ protected function getAllUserItem($userId, $taskId) { if ($userId == \TTO::getUserId() || \TTO::getRole() == 'admin') { $statement = ' SELECT I.*, UI.userId, UI.status, UI.point, UI.userContent FROM item AS I LEFT OUTER JOIN user_item AS UI ON UI.itemId = I.itemId AND UI.userId = :userId WHERE I.taskId = :taskId '; $bind = array('userId' => $userId, 'taskId' => $taskId); return \Db::getResult($statement, $bind); } else { throw new RestException(401, 'No Authorize or Invalid request !!!'); } }
/** * @url GET by-course-section/{userId}/{courseSectionId} */ protected function getByCourseSection($userId, $courseSectionId) { if ($userId == \TTO::getUserId() || \TTO::getRole() == 'admin') { $statement = ' SELECT * FROM view_course_item AS CI LEFT OUTER JOIN user_course_item AS UCI ON CI.courseItemId = UCI.courseItemId AND UCI.userId = :userId WHERE CI.courseSectionId = :courseSectionId ORDER BY CI.courseItemId '; $bind = array('userId' => $userId, 'courseSectionId' => $courseSectionId); return \Db::getResult($statement, $bind); } else { throw new RestException(401, 'No Authorize or Invalid request !!!'); } }
/** * @url GET user/{userId} */ protected function getAllUserTask($userId, $sectionId) { if ($userId == \TTO::getUserId() || \TTO::getRole() == 'admin') { $statement = ' SELECT T.*, TT.name AS taskTypeName, TT.theme FROM task AS T INNER JOIN task_type AS TT ON TT.taskTypeId = T.taskTypeId LEFT OUTER JOIN user_task AS UT ON UT.taskId = T.taskId AND UT.userId = :userId WHERE sectionId = :sectionId '; $bind = array('userId' => $userId, 'sectionId' => $sectionId); return \Db::getResult($statement, $bind); } else { throw new RestException(401, 'No Authorize or Invalid request !!!'); } }
/** * @url GET by-course-item/{userId}/{courseItemId} */ protected function getByCourseItem($userId, $courseItemId) { if ($userId == \TTO::getUserId() || \TTO::getRole() == 'admin') { $statement = ' SELECT UCI.*, CI.*, I.code, I.content, I.itemGroupId FROM course_item AS CI INNER JOIN item AS I ON CI.itemId = I.itemId LEFT OUTER JOIN user_course_item AS UCI ON UCI.courseItemId = CI.courseItemId AND UCI.userId = :userId WHERE CI.courseItemId = :courseItemId '; $bind = array('courseItemId' => $courseItemId, 'userId' => $userId); $response = \Db::getRow($statement, $bind); $itemId = $response['itemId']; $userCourseItemId = $response['userCourseItemId']; $response += array('allItemDetail' => array()); $statement = ' SELECT UCID.*, ID.* FROM item_detail AS ID LEFT OUTER JOIN user_course_item_detail AS UCID ON UCID.itemDetailId = ID.itemDetailId AND UCID.userCourseItemId = :userCourseItemId WHERE itemId = :itemId ORDER BY seq '; $bind = array('itemId' => $itemId, 'userCourseItemId' => $userCourseItemId); $allItemDetail = \Db::getResult($statement, $bind); foreach ($allItemDetail as $itemDetail) { if ($itemDetail['itemTypeId'] == 1) { if ($itemDetail['status'] == 'done') { $statement = ' SELECT itemRadioId FROM user_course_item_radio WHERE userCourseItemId = :userCourseItemId AND itemDetailId = :itemDetailId '; $bind = array('userCourseItemId' => $userCourseItemId, 'itemDetailId' => $itemDetail['itemDetailId']); $userItemRadioId = \Db::getValue($statement, $bind); $itemDetail += array('userItemRadioId' => $userItemRadioId); } $statement = 'SELECT * FROM item_radio WHERE itemDetailId = :itemDetailId'; $bind = array('itemDetailId' => $itemDetail['itemDetailId']); $allItemRadio = \Db::getResult($statement, $bind); $itemDetail += array('allItemRadio' => $allItemRadio); } if ($itemDetail['itemTypeId'] == 3) { $statement = ' SELECT IDS.*, UCIS.userIsAnswer FROM item_select AS IDS LEFT OUTER JOIN user_course_item_select AS UCIS ON IDS.itemSelectId = UCIS.itemSelectId AND IDS.itemDetailId = UCIS.itemDetailId AND UCIS.userCourseItemId = :userCourseItemId WHERE IDS.itemDetailId = :itemDetailId '; $bind = array('itemDetailId' => $itemDetail['itemDetailId'], 'userCourseItemId' => $userCourseItemId); $allItemSelect = \Db::getResult($statement, $bind); $itemDetail += array('allItemSelect' => $allItemSelect); } if ($itemDetail['itemTypeId'] == 4) { $statement = ' SELECT II.*, UCII.userAnswer FROM item_input AS II LEFT OUTER JOIN user_course_item_input AS UCII ON II.itemInputId = UCII.itemInputId AND II.itemDetailId = UCII.itemDetailId AND UCII.userCourseItemId = :userCourseItemId WHERE II.itemDetailId = :itemDetailId '; $bind = array('itemDetailId' => $itemDetail['itemDetailId'], 'userCourseItemId' => $userCourseItemId); $allItemInput = \Db::getResult($statement, $bind); $itemDetail += array('allItemInput' => $allItemInput); } $response['allItemDetail'][] = $itemDetail; } return $response; } else { throw new RestException(401, 'No Authorize or Invalid request !!!'); } }
/** * @url GET allitemgroup */ protected function getAllItemGroup() { $statement = 'SELECT * FROM item_group'; $response = \Db::getResult($statement); return $response; }
<?php /** * Created by JetBrains PhpStorm. * User: jwfoxjr * Date: 8/28/11 * Time: 12:29 AM * To change this template use File | Settings | File Templates. */ require_once 'Db.php'; /*** Setup our Connection */ // Db::setConnectionInfo('fundsmaster', 'root', '#--5ql4dm1n--#', 'mysql', 'localhost'); $q = $_GET['q']; /*** prepare the SQL statement ***/ $sql = 'SELECT house, street, apt, id FROM address WHERE street="' . $q . '" ORDER BY house,apt ASC'; $result = Db::getResult($sql); echo '<select size="5">'; /*** loop of the results ***/ foreach ($result as $key => $house) { echo '<option name="' . $house['id'] . '" value="' . $house['id'] . '">' . $house['house'] . ' ' . $house['street'] . ' ' . $house['apt'] . '</option>'; }
/** * @url GET * @url GET allpackage */ protected function getAllPackage() { $statement = 'SELECT * FROM coin WHERE status = :status ORDER BY amount'; $bind = array('status' => 'active'); return \Db::getResult($statement, $bind); }
<link href="<?php echo $config['baseurl']; ?> /assets/css/card.css" type="text/css" rel="stylesheet" /> <?php $projectId = intval($_GET['id']); $statusNames = getStatusNames(); $cardTypes = getCardTypes(); $project = getProject($projectId); if ($project) { $cards = Db::getResult('SELECT * FROM cards WHERE project_id = ?', $projectId); ?> <div id="page-header"> <h2><?php echo $project['name']; ?> </h2> <div class="add-form-holder"> <a id="create-card" href="#create-card" class="ui-link ui-state-default ui-corner-all"> <span class="ui-icon ui-icon-plusthick"></span>Add New Card </a> <form id="card-form" name="card-form" onsubmit="return createCard()" class="invisible"> <label>Card Title</label> <input type="text" name="title" id="title" size="70"/> <label>type</label> <select name="card_type" id="card_type"> <?php foreach ($cardTypes as $cardType) { ?> <option value="<?php echo $cardType['id'];
/** * @smart-auto-routing false * @url getallbank * @url GET */ protected function getAllBank() { $statement = 'SELECT * FROM bank WHERE status = :status'; $bind = array('status' => 'active'); return \Db::getResult($statement, $bind); }
/** * @url GET allAvatar */ function getAllAvatar() { $statement = 'SELECT * FROM avatar'; return \Db::getResult($statement); }
function getCardTypes() { return Db::getResult('SELECT * FROM card_types'); }
/** * @url GET / */ protected function getConvertItem() { if (\TTO::getRole() == 'admin') { $response = new \stdClass(); $statement = 'SELECT itemId, code, content, itemTypeId FROM item'; //$bind = array('itemTypeId' => $itemTypeId); $allItem = \Db::getResult($statement); foreach ($allItem as &$item) { $newItem = new \stdClass(); switch ($item['itemTypeId']) { case 1: $newItem->question = $item['content']; $statement = 'SELECT content, isAnswer, point FROM item_radio WHERE itemId = :itemId'; $bind = array('itemId' => $item['itemId']); $newItem->allRadio = \Db::getResult($statement, $bind); foreach ($newItem->allRadio as &$radio) { if ($radio['isAnswer']) { $radio['isAnswer'] = true; } else { $radio['isAnswer'] = false; } } break; case 3: $newItem->question = $item['content']; $statement = 'SELECT content, isAnswer, point FROM item_select WHERE itemId = :itemId'; $bind = array('itemId' => $item['itemId']); $newItem->allSelect = \Db::getResult($statement, $bind); foreach ($newItem->allSelect as &$select) { if ($select['isAnswer']) { $select['isAnswer'] = true; } else { $select['isAnswer'] = false; } } break; case 4: $newItem->question = $item['content']; $statement = 'SELECT question, answer, answerType, point FROM item_input WHERE itemId = :itemId'; $bind = array('itemId' => $item['itemId']); $newItem->allInput = \Db::getResult($statement, $bind); break; default: break; } if ($item['itemTypeId'] == 1 || $item['itemTypeId'] == 3 || $item['itemTypeId'] == 4) { $content2 = json_encode($newItem, JSON_UNESCAPED_UNICODE); } else { $content2 = $item['content']; } $statement = ' UPDATE item SET content2 = :content2 WHERE itemId = :itemId '; $bind = array('itemId' => $item['itemId'], 'content2' => $content2); \Db::execute($statement, $bind); $item['content2'] = $content2; } return $allItem; } else { throw new RestException(401, 'No Authorize or Invalid request !!!'); } }