extract($_GET);
extract($_POST);
$link = mysql_connect("localhost", "dracula", "[eqghjqltn") or die("DEADLINK");
mysql_select_db('work', $link);
mysql_query($query, $link);
$id_counter=mt_rand(1,1000000);
$data_create=date("Ymd");
$block='on';
$cr_manager = htmlspecialchars(urldecode($cr_manager));
$id_user_session = htmlspecialchars(urldecode($id_user_session));
$work = htmlspecialchars(urldecode($work));
$platej_name = htmlspecialchars(urldecode($platej_name));
$plan_sum = htmlspecialchars(urldecode($plan_sum));
$fact_sum = htmlspecialchars(urldecode($fact_sum));
$mat_sum = htmlspecialchars(urldecode($mat_sum));
$srok = htmlspecialchars(urldecode($srok));
if ($srok !== '') {
$collapse = $data_create;
} else {
$collapse = 0;
}
/*
echo "
$cr_manager,
$id_user_session,
$work,
$platej_name,
$plan_sum,
$fact_sum,
$yp.$mp.$dp,
$mat_sum,
$yf.$mf.$df,
$work_sum,
$srok,
$collapse,
$data_create
";
*/
$query = "insert into counter
(
id,
id_counter,
data_create,
data_archive,
block,
platej_name,
plan_sum,
plan_date,
fact_sum,
fact_date,
mat_sum,
work_sum,
srok,
collapse,
manager
) values (
'$work',
'$id_counter',
'$data_create',
'0',
'$block',
'$platej_name',
'$plan_sum',
'$yp$mp$dp',
'$fact_sum',
'$yf$mf$df',
'$mat_sum',
'$work_sum',
'$srok',
'$collapse',
'$cr_manager'
); ";
$result = mysql_query($query, $link);
header ("Location: http://192.168.3.99/fin/counter.php?id_user_session=".$id_user_session."&cr_manager=".$cr_manager."&work=".$work."");
exit;
?>