forked from science-ation/science-ation
81 lines
2.9 KiB
PHP
81 lines
2.9 KiB
PHP
<?
|
|
if($_GET['action']=="sponsorshipdelete") {
|
|
mysql_query("DELETE FROM sponsorships WHERE id='".intval($_GET['delete'])."'");
|
|
if(mysql_affected_rows())
|
|
message_push(happy(i18n("Successfully removed sponsorship")));
|
|
}
|
|
|
|
if($_POST['action']=="sponsorshipedit" || $_POST['action']=="sponsorshipadd") {
|
|
$sponsors_id=intval($_POST['sponsors_id']);
|
|
$sponsorships_id=intval($_POST['sponsorships_id']);
|
|
$fundraising_type=mysql_real_escape_string($_POST['fundraising_type']);
|
|
|
|
$value=mysql_real_escape_string($_POST['value']);
|
|
$status=mysql_real_escape_string($_POST['status']);
|
|
$probability=mysql_real_escape_string($_POST['probability']);
|
|
|
|
if($status=="confirmed" || $status=="received") $probability="100";
|
|
if($probability==100 && $status=="pending") $status="confirmed";
|
|
}
|
|
|
|
if($_POST['action']=="sponsorshipedit") {
|
|
if($sponsorships_id && $fundraising_type && $value) {
|
|
$q=mysql_query("SELECT * FROM sponsorships WHERE id='$sponsorships_id'");
|
|
$current=mysql_fetch_object($q);
|
|
|
|
unset($log);
|
|
$log=array();
|
|
if($current->fundraising_type!=$fundraising_type)
|
|
$log[]="Changed sponsorship type from $current->fundraising_type to $fundraising_type";
|
|
|
|
if($current->value!=$value)
|
|
$log[]="Changed sponsorship value from $current->value to $value";
|
|
|
|
if($current->status!=$status)
|
|
$log[]="Changed sponsorship status from $current->status to $status";
|
|
|
|
if($current->probability!=$probability)
|
|
$log[]="Changed sponsorship probability from $current->probability to $probability";
|
|
|
|
if(count($log)) {
|
|
mysql_query("UPDATE sponsorships SET fundraising_type='$fundraising_type', value='$value', status='$status', probability='$probability' WHERE id='$sponsorships_id'");
|
|
|
|
foreach($log AS $l) {
|
|
mysql_query("INSERT INTO sponsors_logs (sponsors_id,dt,users_id,log) VALUES (
|
|
'$current->sponsors_id',
|
|
NOW(),
|
|
'".$_SESSION['users_id']."',
|
|
'".mysql_real_escape_string($l)."')");
|
|
|
|
}
|
|
if(mysql_error())
|
|
message_push(error(mysql_error()));
|
|
else
|
|
message_push(happy(i18n("Saved sponsorship changes")));
|
|
}
|
|
else
|
|
message_push(happy(i18n("No changes were made")));
|
|
}
|
|
else {
|
|
message_push(error(i18n("Required fields were missing, please try again")));
|
|
}
|
|
|
|
}
|
|
if($_POST['action']=="sponsorshipadd") {
|
|
if($sponsors_id && $fundraising_type && $value) {
|
|
mysql_query("INSERT INTO sponsorships (sponsors_id,fundraising_type,value,status,probability,year) VALUES ('$sponsors_id','$fundraising_type','$value','$status','$probability','{$config['FAIRYEAR']}')");
|
|
mysql_query("INSERT INTO sponsors_logs (sponsors_id,dt,users_id,log) VALUES (
|
|
'$sponsors_id',
|
|
NOW(),
|
|
'".$_SESSION['users_id']."',
|
|
'".mysql_real_escape_string("Created sponsorship: type=$fundraising_type, value=\$$value, status=$status, probability=$probability%")."')");
|
|
message_push(happy(i18n("Added new sponsorship")));
|
|
}
|
|
else
|
|
message_push(error(i18n("Required fields were missing, please try again")));
|
|
if(mysql_error())
|
|
message_push(error(mysql_error()));
|
|
}
|
|
|
|
?>
|