<?php
	session_start();
	ini_set('display_errors',1);
	error_reporting(E_ALL);
	
	if(empty($_SESSION['user']))
		die();
		
	if(!empty($_POST['exit'])){
		// echo '<pre>';
		// print_r($_POST);
		// echo '</pre>';
		//echo 'http://'. $_SERVER['HTTP_HOST'] . substr($_SERVER['PHP_SELF'], 0, strrpos($_SERVER['PHP_SELF'],'/')+1).'login.php';
		
		header('http://'. $_SERVER['HTTP_HOST'] . substr($_SERVER['PHP_SELF'], 0, strrpos($_SERVER['PHP_SELF'],'/')+1).'login.php');
		//unset($_SESSION['user']);
		//session_destroy();
	}

	include('config.php');
		
	if(!empty($_POST['checkbox'])){
		foreach($_POST['checkbox'] as $k => $v){
			$data .= $k . '=' . urlencode($v) . '&';
		}
	}
	
	if( $_POST['submit'] == 'Save' && isset($_POST['hidden'])){
		for($j = 0 ; $j < $count ; $j++){
			$sql_q_upd = "UPDATE $table SET date='". $date[$j] ."', name='". $name[$j] ."', tel='". $tel[$j] ."', reason='". $reason[$j] ."', comments='". $comments[$j] ."', 
			manager='". $manager[$j] ."', status='". $status[$j] ."' WHERE id='". $id[$j] ."'";
			$sql = mysql_query($sql_q_upd);
		}
	}
	
	if( $_POST['submit'] == 'Edit' && !empty($_POST['checkbox'])){
		savePost($data, $dest);
		die();
	}
	elseif(!empty($_POST['sort'])){
			$sort_param = $_POST['sort_sl'];
	}else{
		@header('location: http://'. $_SERVER['HTTP_HOST'] . $_SERVER['PHP_SELF']);
	}
?>

<table border='0' width='100%'>
	<tr>
		<td>
			<form method="post" action="search.php">
				<table>
					<tr>
						<td>
							<input type='text' name='search_f' value='Search...'>
						</td>
						<td>
							<input type='submit' name='search' value='Search'>
						</td>
						
					</tr>
					<tr>
						<td colspan='2'>
							<select name='search_sl'>
								<option value='id'>ID</option>
								<option value='date'>Date</option>
								<option value='name'>Name</option>
								<option value='tel'>Telefon</option>
								<option value='reason'>Reason</option>
								<option value='comments'>Comment</option>
								<option value='manager'>Manager</option>
								<option value='status'>Status</option>
							</select>
						</td>
					</tr>
				</table>
			</form>
		</td>
		<td align='right'> 
			<form action="" method="post">
				<table>
					<tr>
						<td>
							<select name='sort_sl'>
								<option value='id'>ID</option>
								<option value='date'>Date</option>
								<option value='name'>Name</option>
								<option value='tel'>Telefon</option>
								<option value='reason'>Reason</option>
								<option value='comments'>Comment</option>
								<option value='manager'>Manager</option>
								<option value='status'>Status</option>
							</select>
						</td>
						<td>
							<input type='submit' name='sort' value='Sort'>
						</td>
					</tr>
				</table>
			</form>
		</td>
	</tr> 
</table>
	
<FORM METHOD=POST ACTION="">
	<TABLE border=1 width=100%>
		<TR>
			<TD colspan=9 ><CENTER><b>ЗАПИСЬ ВХОДЯЩИХ ЗВОНКОВ</b></CENTER></TD>
		</TR>
		<TR>
			<td colspan='2'><b>ID</b></td>
			<TD><b>Дата</b></TD>
			<TD><CENTER><b>ФИО</b></CENTER></TD>
			<TD><b>Телефон</b></TD>
			<TD><b>Причина обращения</b></TD>
			<TD><b>Примечание</b></TD>
			<TD><b>Менеджер</b></TD>
			<TD><b>Обработка</b></TD>
		</TR>
		<TR>
			<TD colspan='2'></TD>
			<TD><INPUT TYPE="text" NAME="date" value="<?php echo date("d-m-Y G:i") ;?>"></TD>
			<TD><INPUT TYPE="text" NAME="name"></TD>
			<TD><INPUT TYPE="text" NAME="tel"></TD>
			<TD><INPUT TYPE="text" NAME="reason"></TD>
			<TD><INPUT TYPE="text" NAME="comments"></TD>
			<TD><SELECT NAME="manager">
<?php 
	foreach($file as $m_name){
		echo "<option>". $m_name ."</option>";
	}
?>

			</SELECT></TD>
			<TD><SELECT NAME="status">
				<option>Обработано</option>
				<option>Не обработано</option>
				<option>В процессе</option>
			</SELECT></TD>
		</TR>

<?php
	 	
	if ($_POST['submit'] == 'Save' && !isset($_POST['hidden'])){
		$sql_q_ins = mysql_query("INSERT INTO contacts (date, name, tel, reason, comments, manager, status)
			  VALUES ('$date', '$name', '$tel', '$reason'
			  , '$comments', '$manager', '$status')");
			  
	}
	
	if($_POST['submit'] == 'Delete' && !empty($_POST['checkbox'])){
		foreach($_POST['checkbox'] as $k => $id){
			$sql_q_dlt = mysql_query("DELETE FROM contacts WHERE id = " . $id . "");
		
		}
	}
	
		
	$sql_q_sel = mysql_query("SELECT*FROM contacts");
	while($record = mysql_fetch_array($sql_q_sel, MYSQL_ASSOC))
	{	
		$result[] = $record;
	}
	
	if(!empty($sort_param)){
		$result = sortArr($result,$sort_param);
	}
	
	
	foreach($result as $k => $v){
		echo "<tr>";
		foreach($v as $k1 => $v1){
			if( $k1 == 'id' ){
				echo "
					<td><INPUT TYPE='checkbox' name='checkbox[]'  value='$v1'></td>
					<td>$v1</td>";
			}elseif( $v1 == 'Обработано'){
				echo "<td>". $v1 ."<img src='images/t2.png'></td>";
			}elseif( $v1 == 'Не обработано'){
				echo "<td>". $v1 ."<img src='images/e2.png'></td>";
			}elseif( $v1 == 'В процессе' ){
				echo "<td>". $v1 ."<img src='images/q2.png'></td>";
			}else{
				echo "<td>". $v1 ."</td>";
			}
		}
		echo "</tr>";
	}
?>

		<TR>
			<TD></TD>
			<td></td>
			<TD></TD>
			<TD></TD>
			<TD></TD>
			<TD></TD>
			<TD></TD>
			<TD colspan=2>
			<INPUT TYPE="submit" name="submit" value="Edit">
			<INPUT TYPE="submit" name="submit" value="Save">
			<INPUT TYPE="submit" name="submit" value="Delete">
			</TD>
	
		</TR>
	</TABLE>
</FORM>
<form action='' method='post'>
	<INPUT TYPE="submit" name="exit" value="Exit">
</form>