示例#1
0
文件: view.php 项目: calliander/wywo
 $page[] = '					<span class="type_text" id="type_text_' . $call['id'] . '">For ' . $call['type'] . ' Team</span>';
 $page[] = '				</div>';
 // Add the repair number if it exists.
 if ($call['repair']) {
     $page[] = '				<div class="call_info" id="call_repair_' . $call['id'] . '">';
     $page[] = '					<span class="repair_text" id="repair_text_' . $call['id'] . '"><strong>Repair:</strong> ' . $call['repair'] . '</span>';
     $page[] = '				</div>';
 }
 // Add the primary number.
 $page[] = '				<div class="call_info" id="call_primary_' . $call['id'] . '">';
 $page[] = '					<span class="primary_text" id="primary_text_' . $call['id'] . '"><strong>Phone #1:</strong> ' . phone_text($call['primary']) . '</span>';
 $page[] = '				</div>';
 // Add the secondary number if it exists.
 if ($call['secondary']) {
     $page[] = '				<div class="call_info" id="call_secondary_' . $call['id'] . '">';
     $page[] = '					<span class="secondary_text" id="secondary_text_' . $call['id'] . '"><strong>Phone #2:</strong> ' . phone_text($call['secondary']) . '</span>';
     $page[] = '				</div>';
 }
 // Employee who closed the call.
 $employee = mysql_real_escape_string($_COOKIE['wywo_user']);
 $password = $_COOKIE['wywo_pass'];
 // Get employee info for ability to close.
 $user = get_ldap($employee, $password);
 // Add the close link if a WYWO admin and the call is old.
 if (strpos($user[0]['apple-user-printattribute'][0], 'ALL') != FALSE && $call['status'] == 'old') {
     $page[] = '				<div class="call_close" id="call_close_' . $call['id'] . '">';
     $page[] = '					<a class="helped" href="./?area=close&id=' . $call['id'] . '" id="link_close_' . $call['id'] . '">Mark as Helped</a>';
     $page[] = '				</div>';
 }
 // Finish the left side.
 $page[] = '			</div>';
示例#2
0
文件: close.php 项目: calliander/wywo
    // The call ID.
    $call = mysql_fetch_assoc(mysql_query("SELECT * FROM `calls` WHERE `id`='" . $_GET['id'] . "'"));
    // Employee who closed the call.
    $employee = mysql_real_escape_string($_COOKIE['wywo_user']);
    $password = $_COOKIE['wywo_pass'];
    // Get employee info to see if the person is allowed to remove calls.
    $user = get_ldap($employee, $password);
    // Don't let regular employees remove calls. This is a backup in case they traverse the URL.
    if (strpos($user[0]['apple-user-printattribute'][0], 'ALL') == FALSE) {
        die(header('Location:./'));
    }
    // Starts the 'info' block with the primary number.
    $info = mysql_real_escape_string(phone_text($call['primary']));
    // Adds the secondary number if it's there.
    if ($call['secondary']) {
        $info .= ' / ' . mysql_real_escape_string(phone_text($call['secondary']));
    }
    // Adds the repair number if it's there.
    if ($call['repair']) {
        $info .= ' / ' . mysql_real_escape_string($call['repair']);
    }
    // Pulls the notes, loops through them, and puts them in a block.
    $notes_pull = mysql_query("SELECT * FROM `notes` WHERE `call`='" . $call['id'] . "'");
    while ($note = mysql_fetch_assoc($notes_pull)) {
        $notes .= mysql_real_escape_string(date('m/d/Y', $note['timestamp'])) . ' at ' . mysql_real_escape_string(date('g:ia', $note['timestamp'])) . ' by ' . mysql_real_escape_string($note['employee']) . ': ' . mysql_real_escape_string(str_replace("\n", '', $note['content'])) . "\n";
    }
    //	Insert the closed call into the archive, delete it, and delete all notes associated with it.
    mysql_query("INSERT INTO `archive` (`opened`, `closed`, `employee`, `type`, `customer`, `info`, `notes`) VALUES ('" . $call['timestamp'] . "', '" . time() . "', '" . $employee . "', '" . mysql_real_escape_string($call['type']) . "', '" . mysql_real_escape_string($call['customer']) . "', '" . $info . "', '" . $notes . "')");
    mysql_query("DELETE FROM `calls` WHERE `id`='" . $call['id'] . "'");
    mysql_query("DELETE FROM `notes` WHERE `call`='" . $call['id'] . "'");
}