Автоматизация рабочего места менеджера по продажам

<?php

echo '<form action="index.php?action=contract_add_run" method="post"

name="form1">';

echo '<h2>Заполните форму, чтобы добавить новый контракт</h2>';

echo'

<h3>

<table width="100%" border="1" class="shap2">

<tr>

<td colspan="2" class="shap1">Информация о договоре</td>

</tr>

<tr>

<td>

<label for="date">Дата заключения</label>

<input type="date" name="date" id="date">

</td>

</tr>

<tr>

<td>

<label for="usluga">Организвция</label>

<select name="organization" id="organization">';

$result = mysql_query("SELECT idOrganization, Org_name FROM

Organization");

while (($row = mysql_fetch_assoc($result)) != null)

{

echo '<option value="' . $row["idOrganization"] . '">' . $row["Org_name"] .

'</option>';

}

echo '

</select>

</td>

</tr>

<tr>

<td>

<label for="usluga">Услуга </label>

<select name="usluga" id="usluga">';

$result = mysql_query("SELECT * FROM Uslugi");

while (($row = mysql_fetch_assoc($result)) != null)

{

echo '<option value="' . $row["idUslugi"] . '">' . $row["Vid_Uslugi"] .

'</option>';

}

echo '

</select>

</td>

</tr>

<tr>

<td colspan="2">

<input name="zapisat" type="submit" class="vhod" id="zapisat"

value="Сохранить">

</td>

</tr>

</table>

</h3>

</form>';

?>

1.10 contract_add_run.php

<?

$result = mysql_query(

"INSERT INTO Dogovor (Data_zakl, Manager_idManager,

Organization_idOrganization, Uslugi_idUslugi)

VALUES ('".$_POST['date']."',

'".$user_id."',

'".$_POST['organization']."',

'".$_POST['usluga']."')");

if ($result)

echo "<center><br>Договор добавлен!</center>";

else

die('MySQL error:'.mysql_error());

?>

1.11 contract_info.php

<h3>

<table width="100%" border="1" class="shap2">

<tr>

<td colspan="10" class="shap1">Информация о договорах</td>

</tr>

<tr>

<td>Дата договора<br>

<a href =

"/index.php?action=contract_info&order_field=Data_zakl&order_type=asc"

>&uArr;</a>

<a href =

"/index.php?action=contract_info&order_field=Data_zakl&order_type=desc

">&dArr;</a>

</td>

<td>Менеджер</td>

<td>Организация</td>

<td>Услуга</td>

</tr>

<?php

$query = "SELECT Dogovor.*, Manager.FIO_manager,

Organization.Org_name, Uslugi.Vid_Uslugi

FROM Dogovor

INNER JOIN Manager ON (Dogovor.Manager_idManager =

Manager.idManager)

INNER JOIN Organization ON (Dogovor.Organization_idOrganization =

Organization.idOrganization)

INNER JOIN Uslugi ON (Dogovor.Uslugi_idUslugi = Uslugi.idUslugi)";

if (isset($_GET['order_field']))

{

$query .= " ORDER BY ". $_GET['order_field'] ." ".

strtoupper($_GET['order_type']);

}

$result = mysql_query($query);

while ($row = mysql_fetch_array($result))

{

echo'<tr>';

echo'<td>'.$row['Data_zakl'].'</td>';

echo'<td>'.$row['FIO_manager'].'</td>';

echo'<td>'.$row['Org_name'].'</td>';

echo'<td>'.$row['Vid_Uslugi'].'</td>';

echo'</tr>';

}

?>

</table>

</h3>

1.12 contract_control.php

<form action="index.php?action=contract_control_run" method="post"

name="form1">

<h3>

<table width="100%" border="1" class="shap2">

<tr>

<td colspan="5" class="shap1">Управление клиентами</td>

</tr>

<tr>

<td ></td>

<td>Дата договора</td>

<td>Менеджер</td>

<td>Организация</td>

<td>Услуга</td>

</tr>

<?php

$query = "SELECT Dogovor.*, Manager.FIO_manager,

Organization.Org_name, Uslugi.Vid_Uslugi

FROM Dogovor

INNER JOIN Manager ON (Dogovor.Manager_idManager =

Manager.idManager)

INNER JOIN Organization ON (Dogovor.Organization_idOrganization =

Organization.idOrganization)

INNER JOIN Uslugi ON (Dogovor.Uslugi_idUslugi = Uslugi.idUslugi)";

if (isset($_GET['order_field']))

{

$query .= " ORDER BY ". $_GET['order_field'] ." ".

strtoupper($_GET['order_type']);

}

$row_ind=0;

$result = mysql_query($query);

while ($row = mysql_fetch_array($result))

{

$row_ind++;

$checked = ($row_ind == 1 ? 'checked="checked"' : '');

echo'<tr>';

echo'<td><input name="record_id" type="radio" '. $checked .' value="'.

$row['idDogovor'] .'"></td>';

echo'<td>'.$row['Data_zakl'].'</td>';

echo'<td>'.$row['FIO_manager'].'</td>';

echo'<td>'.$row['Org_name'].'</td>';

echo'<td>'.$row['Vid_Uslugi'].'</td>';

echo'</tr>';

}

?>

<tr>

<td colspan="5">

<input name="delete" type="submit" class="vhod" value="Удалить">

</td>

</tr>

</table>

</h3>

</form>

1.13 contract_control_run.php

<?

$record_id = $_REQUEST['record_id'];

$result = mysql_query("DELETE FROM Dogovor WHERE (idDogovor =

'". $record_id ."') LIMIT 1");

if ($result)

echo "<center><br>Запись удалена</center>";

else

die('MySQL error:'.mysql_error());

?>

1.14 style.css

body {

font-family: verdana, helvetica, arial, sans-serif;

margin: 0;

padding: 0;

background-color : #AAA;

}

.tbl1

{

background-repeat: no-repeat;

background-color : #FFF;

background-image: url(../images/back.jpg);

}

#navcontainer { width: 100%; border-top: 1px solid #711;}

#navcontainer ul

{

margin-left: 0;padding-left: 0;

list-style-type: none;

font-size: 85%;

font-family: Times,serif;

}

#navcontainer a

{display: block;

width: 100%;

padding: 0.25em;

background-color: ;

border-bottom: 1px solid #711;

color: #711;text-decoration: none;

}

#navcontainer a:hover{

background-color: #711;

color: #fff;

font-size: 85%;

}

p,main {

font-family: serif;

color: black;

margin-top: 0.3em;

font-size: 18px;

font-weight: 400;

text-align: center;

}

h1,h2,h3 {

font-family: arial Rounded MT Bold, arial, Helvetica;

font-weight: bold;

border-bottom: 0px solid #666;

color: #711;

margin-bottom: 0em;

font-size: 24px;

text-align: center;

}

a {

color: #711;

}

.vhod {

text-align: center;

}

#Knopka1 {

padding-left: 5px;

}

.shap1 {

font-family: Georgia, "Times New Roman", Times, serif;

font-size: 24px;

font-weight: 400;

color: #603;

text-align: center;

}

.shap2 {

font-family: Georgia, "Times New Roman", Times, serif;

font-size: 18px;

font-weight: 400;

color: #603;

text-align: center;

}

.infkl {

font-family: Georgia, "Times New Roman", Times, serif;

font-size: 14px;

font-weight: 400;

color: #603;

text-align: center;

}

Размещено на Allbest.ru