Example #1
0
/**
 * @param $userid
 * @param $customerid
 * @param $serviceid
 * @param $hours
 * @param $date
 * @param $desc
 * @param $weeklyid
 * @return object
 * Add a new time to the database.
 */
function insertNewTime($userid, $customerid, $serviceid, $hours, $date, $desc, $weeklyid)
{
    $savedesc = saveDescription($desc, $weeklyid, $userid);
    $savecustomer = saveCustomer("", $customerid, $weeklyid, $userid);
    $saveservice = saveService("", $serviceid, $weeklyid, $userid);
    $userid = convertForInsert($userid);
    $hours = convertForInsert($hours);
    $date = convertForInsert($date);
    $sql = "INSERT INTO `tbl_time` (TimeID, UserID, Hours, HourDate, WeeklyID) VALUES (NULL, " . $userid . ", " . $hours . ", " . $date . ", " . $weeklyid . ");";
    $mysqli = new mysqli(Database::dbserver, Database::dbuser, Database::dbpass, Database::dbname);
    $mysqli->query($sql);
    $insertid = $mysqli->insert_id;
    $mysqli->close();
    $data = array("inserid" => $insertid, "savecustomer" => $savecustomer, "saveservice" => $saveservice, "savedesc" => $savedesc);
    return json_encode($data);
}
Example #2
0
     $display .= trackback_editor($target, $url, $title, $excerpt, $blog);
     $display = COM_createHTMLDocument($display, array('pagetitle' => $LANG_TRB['trackback']));
 } elseif ($mode == 'deleteservice' && SEC_checkToken()) {
     $pid = COM_applyFilter($_POST['service_id'], true);
     if ($pid > 0) {
         DB_delete($_TABLES['pingservice'], 'pid', $pid);
         $display = COM_refresh($_CONF['site_admin_url'] . '/trackback.php?mode=listservice&msg=66');
     } else {
         $display = COM_refresh($_CONF['site_admin_url'] . '/index.php');
     }
 } elseif ($mode == 'saveservice' && SEC_checkToken()) {
     $is_enabled = '';
     if (isset($_POST['is_enabled'])) {
         $is_enabled = $_POST['is_enabled'];
     }
     $display .= saveService(COM_applyFilter($_POST['service_id'], true), $_POST['service_name'], $_POST['service_site_url'], $_POST['service_ping_url'], $_POST['method'], $is_enabled);
 } else {
     if ($mode == 'editservice') {
         $service_id = 0;
         if (isset($_GET['service_id'])) {
             $service_id = COM_applyFilter($_GET['service_id'], true);
         }
         $pid = COM_applyFilter($service_id, true);
         $display .= editServiceForm($pid);
     } else {
         if ($mode == 'listservice') {
             $display .= COM_showMessageFromParameter();
             $display .= listServices();
             $display = COM_createHTMLDocument($display, array('pagetitle' => $LANG_TRB['services_headline']));
         } else {
             if ($mode == 'freepb') {