// $debug=yes;
/***********
show indivdual or team donation data
***********/
require'../commonfiles/Functions.php';
require'../commonfiles/MyFunctions.php';
require'../commonfiles/brandconfig.php';
require'../commonfiles/newtemplate.php';
if($get_qrcode_image && $donation_team_member_id)
{
if(@!is_file("../cache_image/$donation_team_member_id"))
{
require'../commonfiles/phpqrcode/qrlib.php';
$url = "http://$HTTP_HOST//donation/donation.php?donation_team_member_id=$donation_team_member_id";
QRcode::png($url, "../cache_image/$donation_team_member_id");
}
echo file_get_contents("../cache_image/$donation_team_member_id");
exit();
}
if($get_qrcode_image && $donation_individual_id)
{
if(@!is_file("../cache_image/$donation_individual_id"))
{
require'../commonfiles/phpqrcode/qrlib.php';
$url = "http://$HTTP_HOST//donation/donation.php?donation_individual_id=$donation_individual_id";
QRcode::png($url, "../cache_image/$donation_individual_id");
}
echo file_get_contents("../cache_image/$donation_individual_id");
exit();
}
// connect mysql
$crm = new MySQL_class;
$crm->Create($crm_db,$crm_user,$crm_host,$crm_pass);
$gc_sql=$crm; // session handling
$db_foo = $crm; // template handling
$cdc = new MySQL_class;
$cdc->Create($cdc_db,$cdc_user,$cdc_host,$cdc_pass);
$tmp = new MySQL_class;
$tmp->Create($template_db,$template_user,$template_host_2,$template_pass);
// connect mysql IMAGES
$sql_image = new MySQL_class;
$sql_image->Create($image_db,$image_user,$image_host,$image_pass);
// foil hackers
unset($u_type,$u_id,$session_email);
if($get_qrcode_image && $donation_team_member_id)
{
if(@!is_file("../cache_image/$donation_team_member_id"))
{
require'../commonfiles/phpqrcode/qrlib.php';
$phone_menu_url = "http://$HTTP_HOST/donation/donation.php?donation_team_member_id=$donation_team_member_id";
QRcode::png($phone_menu_url, "../cache_image/$donation_team_member_id");
}
//header('Content-Type: image/png');
$qrcode_image = file_get_contents("../cache_image/$donation_team_member_id");
echo $qrcode_image;
exit();
}
// start session
start_session($php_sessid);
if($u_type=="customer")
{
echo"Access Denied";
exit();
}
$staging = "";
if(page_auth(3,$u_type,$cdc) == "yes")
{
$staging = "yes";
}
// login
unset($u_type,$u_id,$session_email);
start_session($sessid);
app_log('donation',$PHP_SELF,$search_word,$u_id,'view',$code,$array);
// page starts
$message_array = get_messages('donation_donation',$language_c,$TEMPLATE_MESSAGE,$code,$tmp);
// get the contact or company cdc_id and campaign id from the fundraiser_id
unset($cdc_id);
if($donation_individual_id)
{
$query = "select contact_id, donation_id, monetary_goal, description, donation_id
from $DONATION_INDIVIDUAL
where id = '$donation_individual_id'
and brand = '$code' ";
$data = $crm->mydata($query);
if(!$data[contact_id][0])
{
echo"error1: invalid id";
exit();
}
$team_id = '';
$description = $data[description][0];
$personal_monetary_goal = $data[monetary_goal][0];
$donation_id = $data[donation_id][0];
$cdc_type = 'contact';
$cdc_id = $data[contact_id][0];
$donation_id = $data[donation_id][0];
$edit_account = urlencode("/donation/donation.php?donation_individual_id=$donation_individual_id");
}
if($donation_team_member_id)
{
$query = "select donation_team_id, monetary_goal, contact_id
from $DONATION_TEAM_MEMBER
where id = '".ass($donation_team_member_id)."'
and brand = '$code' ";
$data = $crm->mydata($query);
if(!$data[donation_team_id][0])
{
echo"error2: invalid id";
exit();
}
$team_id = $data[donation_team_id][0];
$personal_monetary_goal = $data[monetary_goal][0];
$cdc_type = 'contact';
$cdc_id = $data[contact_id][0];
$query = "select donation_id
from $DONATION_TEAM
where brand = '$code'
and id = '$team_id' ";
$data = $crm->mydata($query);
$donation_id = $data[donation_id][0];
$edit_account = urlencode("/donation/donation.php?donation_team_member_id=$donation_team_member_id");
}
if($team_id)
{
$cdc_type = 'company';
}
if(!$team_id && !$cdc_id)
{
echo"error: Invalid id";
exit();
}
if($team_id)
{
$query = "select donation_id, monetary_goal, captain_contact_id
from $DONATION_TEAM
where id = '".ass($team_id)."'
and brand = '$code' ";
$data = $crm->mydata($query);
$captain_id = $data['captain_contact_id'][0];
if(!$cdc_id)
{
$cdc_id = $captain_id;
}
$personal_monetary_goal = $data['monetary_goal'][0];
$campaign_id = $data['campaign_id'][0];
}
if(!$cdc_id)
{
echo "Invalid Fundraiser";
exit();
}
$query = "select name, description, currency
from $CAMPAIGN
where id = '$campaign_id'
and brand = '$code' ";
$data = $crm->mydata($query);
$campaign_name = $data['name'][0];
$campaign_description = $data['description'][0];
$campaign_currency = $data['currency'][0];
// start template engine
$tpl = new rFastTemplate(".");
$tpl->no_strict();
$tpl->quiet();
if($donation_individual_id)
{
$body = get_template('242',$TEMPLATE,$tmp,$code,$staging);
}
if($donation_team_member_id)
{
$body = get_template('229',$TEMPLATE,$tmp,$code,$staging);
}
if($team_id && !$donation_team_member_id)
{
$body = get_template('230',$TEMPLATE,$tmp,$code,$staging);
}
if(!$mobile)
{
$main = get_template('40',$TEMPLATE,$tmp,$code,$staging);
} else {
$main = get_template('250',$TEMPLATE,$tmp,$code,$staging);
$host_name = explode(".",$HTTP_HOST);
$b = count($host_name) - 1;
$a = count($host_name) - 2;
$host_name = ".$host_name[$a].$host_name[$b]";
setcookie("mobile", 'yes', time()+43200, "/",$host_name);
}
$tpl->define_raw( array( main => $main,
body => $body ));
$tpl = show_login($u_id,$tpl);
$tpl = html_chunks($staging,$tpl,$code,$brnd);
if($cdc_id==$u_id)
{
$tpl->assign(array( CDC_ID => $cdc_id ));
}
if($donation_id)
{
$query = "select name, description
from $DONATION
where id = '$donation_id'
and brand = '$code' ";
$data = $crm->mydata($query);
$tpl->assign(array( DONATION_NAME => $data[name][0],
DONATION_ID => $donation_id ));
}
// asign basic stuff
$tpl->assign( array( SELF => $PHP_SELF,
MESSAGE => $message,
ALT_MESSAGE => strip_tags($alt_message),
DONATION_TEAM_MEMBER_ID => $donation_team_member_id,
DONATION_INDIVIDUAL_ID => $donation_individual_id,
EDIT_ACCOUNT => $edit_account,
TEAM_ID => $team_id,
CAMPAIGN_NAME => $campaign_name,
CAMPAIGN_DESCRIPTION => $campaign_description,
CAMPAIGN_CURRENCY => $campaign_currency ));
// solo fundraiser
if($donation_individual_id)
{
// get the personal message if no personal message get the default personal message
$query = "select personal_message, monetary_goal, donation_team_id
from $DONATION_TEAM_MEMBER
where id = '".ass($donation_team_member_id)."'
and brand = '$code' ";
$data = $crm->mydata($query);
$monetary_goal = $data[monetary_goal][0];
$personal_message = $data[personal_message][0];
if(!$data[personal_message][0])
{
$query = "select individual_note
from $DONATION
where id = '".$data[donation_team_id][0]."'
and brand = '$code' ";
$data = $crm->mydata($query);
$personal_message = $data[individual_note][0];
}
$entity_info = get_cdc($cdc_id,$code,$cdc);
// see if there is an image on the file server ....
$query = "select img_tag
from $IMAGE
where id_type = 'donation_individual_id'
and id_value = '".ass($donation_individual_id)."'
and brand = '$code' ";
$data = $sql_image->mydata($query);
if($data[img_tag][0])
{
$entity_info[image_large] = $data[img_tag][0];
}
$path = $_SERVER['HTTPS'] == 'on' ? 'https' : 'http';
$path .= "://" . $_SERVER["HTTP_HOST"] . $PHP_SELF ."?donation_individual_id=$donation_individual_id";
$tpl->assign( array( CONTACT_FIRST_NAME => $entity_info[first_name],
CONTACT_LAST_NAME => $entity_info[last_name],
PATH => urlencode($path),
SOURCE => $_SERVER["HTTP_HOST"],
PAGE_TITLE => "$entity_info[first_name] $entity_info[last_name]",
PERSONAL_MESSAGE => $personal_message,
DESCRIPTION => $description,
DONATION_INDIVIDUAL_ID => $donation_individual_id,
MONETARY_GOAL => $monetary_goal,
CONTACT_EMAIL => $entity_info[email],
CONTACT_TELEPHONE => $entity_info[telephone_1],
CONTACT_IMAGE => $entity_info[image_large]?$entity_info[image_large]:"
" ));
// get teams they belong to
$query = "select donation_team_id
from $DONATION_TEAM_MEMBER
where contact_id = '$cdc_id'
and brand = '$code' ";
$c_data = $crm->mydata($query);
// for each team => usually only one
for($a=0;$amydata($query);
$team_name = ss($c_data_campaign[name][0]);
if(trim($team_name))
{
$the_goal = ($c_data_campaign[monetary_goal][0]);
$tpl->assign( array( THE_TEAM_NAME => $team_name,
THE_DONATION_TEAM_ID => $c_data_campaign[id][0],
THE_GOAL => number_format($the_goal,2) ));
$tpl->parse("TEAMS",".teams");
}
}
// donations
$query = "select order_header_id, name_in_donor_scroll, amount_in_donor_scroll
from $DONATION_GIFT
where id_type = 'donation_individual_id'
and id_value = '".ass($donation_individual_id)."'
and brand = '$code' ";
$data = $crm->mydata($query);
// for each donation for the contact
$total_sum = 0;
$counter = 0;
unset($donor_js);
for($a=0;$a its a single donation so it will return a single record !!!
//$query = "select sum(b.price*b.quantity) as sum
$query = "select (b.price*b.quantity) as sum, a.contact_id, b.currency
from $ORDER_HEADER a, $ORDER_DETAIL b
where b.order_header_id = a.order_header_id
and a.order_header_id = '".$data[order_header_id][$a]."'
and a.brand = '$code'
and a.status = 'PAID' ";
$data_r = $crm->mydata($query);
$total_sum += $data_r[sum][0];
// donor foo
unset($donor_name,$donor_currency,$donor_amount);
if($data[name_in_donor_scroll][$a] == 'Y')
{
$donor_name = get_cdc($data_r[contact_id][0],$code,$cdc);
$donor_name = $donor_name[first_name]." ".$donor_name[last_name];
}
if($data[amount_in_donor_scroll][$a] == 'Y')
{
$donor_currency = $data_r[currency][0];
$donor_amount = number_format($data_r[sum][0],2);
}
if($data[name_in_donor_scroll][$a] == 'Y' || $data[amount_in_donor_scroll][$a] == 'Y')
{
$donor_js[] = "box_".$counter;
$tpl->assign( array( DONOR_NAME => trim($donor_name)?$donor_name:"Anonymous",
DONOR_CURRENCY => $donor_currency,
DONOR_AMOUNT => $donor_amount,
COUNTER => $counter ));
$tpl->parse("DONORS",".donors");
$counter++;
}
}
// donors javascript
if(is_array($donor_js))
{
$tpl->assign( array( JS_DONOR_ID_ARRAY => implode("','", $donor_js) ));
}
$percentage_made = @number_format(($total_sum/$personal_monetary_goal)*100, 2);
// only show admin options if its current user donation page
if(!$u_id || $u_id != $cdc_id)
{
$tpl->assign( array( HIDE_ADMIN_OPTIONS_1 => "" ));
}
$tpl->assign( array( TOTAL_SUM => number_format($total_sum,2),
PERSONAL_MONETARY_GOAL => number_format($personal_monetary_goal,2),
TOTAL_SUM2 => $total_sum,
PERSONAL_MONETARY_GOAL2 => $personal_monetary_goal,
PERCENTAGE_MADE => $percentage_made,
JS_DONOR_COUNTER => $counter ));
}
// team member page
if($donation_team_member_id)
{
// get the personal message if no personal message get the default personal message
$query = "select personal_message, monetary_goal, donation_team_id
from $DONATION_TEAM_MEMBER
where id = '".ass($donation_team_member_id)."'
and brand = '$code' ";
$data = $crm->mydata($query);
$monetary_goal = $data[monetary_goal][0];
$personal_message = $data[personal_message][0];
if(!$data[personal_message][0])
{
$query = "select individual_note
from $DONATION
where id = '".$data[donation_team_id][0]."'
and brand = '$code' ";
$data = $crm->mydata($query);
$personal_message = $data[individual_note][0];
}
$entity_info = get_cdc($cdc_id,$code,$cdc);
$tpl->assign( array( CONTACT_FIRST_NAME => $entity_info[first_name],
CONTACT_LAST_NAME => $entity_info[last_name],
PAGE_TITLE => "$entity_info[first_name] $entity_info[last_name]",
PERSONAL_MESSAGE => $personal_message,
MONETARY_GOAL => $monetary_goal,
CONTACT_EMAIL => $entity_info[email],
CONTACT_TELEPHONE => $entity_info[telephone_1],
CONTACT_IMAGE => $entity_info[image_large]?$entity_info[image_large]:"
" ));
// get teams they belong to
$query = "select donation_team_id
from $DONATION_TEAM_MEMBER
where contact_id = '$cdc_id'
and brand = '$code' ";
$c_data = $crm->mydata($query);
// for each team => usually only one
for($a=0;$amydata($query);
$team_name = ss($c_data_campaign[name][0]);
if(trim($team_name))
{
$the_goal = ($c_data_campaign[monetary_goal][0]);
$tpl->assign( array( THE_TEAM_NAME => $team_name,
THE_DONATION_TEAM_ID => $c_data_campaign[id][0],
THE_GOAL => number_format($the_goal,2) ));
$tpl->parse("TEAMS",".teams");
}
}
// donations
$query = "select order_header_id, name_in_donor_scroll, amount_in_donor_scroll
from $DONATION_GIFT
where id_type = 'donation_team_member_id'
and id_value = '".ass($donation_team_member_id)."'
and brand = '$code' ";
$data = $crm->mydata($query);
// for each donation for the contact
$total_sum = 0;
$counter = 0;
unset($donor_js);
for($a=0;$a its a single donation so it will return a single record !!!
//$query = "select sum(b.price*b.quantity) as sum
$query = "select (b.price*b.quantity) as sum, a.contact_id, b.currency
from $ORDER_HEADER a, $ORDER_DETAIL b
where b.order_header_id = a.order_header_id
and a.order_header_id = '".$data[order_header_id][$a]."'
and a.brand = '$code'
and a.status = 'PAID' ";
$data_r = $crm->mydata($query);
$total_sum += $data_r[sum][0];
// donor foo
unset($donor_name,$donor_currency,$donor_amount);
if($data[name_in_donor_scroll][$a] == 'Y')
{
$donor_name = get_cdc($data_r[contact_id][0],$code,$cdc);
$donor_name = $donor_name[first_name]." ".$donor_name[last_name];
}
if($data[amount_in_donor_scroll][$a] == 'Y')
{
$donor_currency = $data_r[currency][0];
$donor_amount = number_format($data_r[sum][0],2);
}
if($data[name_in_donor_scroll][$a] == 'Y' || $data[amount_in_donor_scroll][$a] == 'Y')
{
$donor_js[] = "box_".$counter;
$tpl->assign( array( DONOR_NAME => trim($donor_name)?$donor_name:"Anonymous",
DONOR_CURRENCY => $donor_currency,
DONOR_AMOUNT => $donor_amount,
COUNTER => $counter ));
$tpl->parse("DONORS",".donors");
$counter++;
}
}
// donors javascript
if(is_array($donor_js))
{
$tpl->assign( array( JS_DONOR_ID_ARRAY => implode("','", $donor_js) ));
}
$percentage_made = @number_format(($total_sum/$personal_monetary_goal)*100, 2);
// only show admin options if its current user donation page
if(!$u_id || $u_id != $cdc_id)
{
$tpl->assign( array( HIDE_ADMIN_OPTIONS_1 => "" ));
}
$tpl->assign( array( TOTAL_SUM => number_format($total_sum,2),
PERSONAL_MONETARY_GOAL => number_format($personal_monetary_goal,2),
TOTAL_SUM2 => $total_sum,
PERSONAL_MONETARY_GOAL2 => $personal_monetary_goal,
PERCENTAGE_MADE => $percentage_made,
JS_DONOR_COUNTER => $counter ));
}
// team page
if($team_id && !$donation_team_member_id)
{
$query = "select name, description, donation_id
from $DONATION_TEAM
where id = '".ass($team_id)."'
and brand = '$code' ";
$data = $crm->mydata($query);
if(!$data[description][0])
{
$query = "select team_note from $DONATION
where id = '".$data[donation_id][0]."'
and brand = '$code' ";
$tdata = $crm->mydata($query);
$data[description][0] = $tdata[team_note][0];
}
$tpl->assign(array( TEAM_NAME => $data[name][0],
TEAM_DESCRIPTION => $data[description][0] ));
$query = "select img_tag
from $IMAGE
where id_type = 'donation_team_id'
and id_value= '".ass($team_id)."'
and brand = '$code' ";
$data = $sql_image->mydata($query);
$tpl->assign( array( PAGE_TITLE => 'Team Page',
TEAM_IMAGE => $data[img_tag][0] ));
// get contacts (team members) in it
$query = "select contact_id
from $DONATION_TEAM_MEMBER
where id = '".ass($team_id)."'
and disable = '0'
and brand = '$code' ";
//$c_data = $crm->mydata($query);
// see if its team captain
$query = "select captain_contact_id, password
from $DONATION_TEAM
where id = '".ass($team_id)."'
and brand = '$code' ";
$data = $crm->mydata($query);
$team_captain_id = $data[captain_contact_id][0];
$password = $data[password][0];
if(!trim($password))
{
$tpl->assign(array( HIDE_PASSWORD_1 => '' ));
}
$query = "select a.first_name, a.last_name, b.id, b.monetary_goal, b.contact_id
from $CRM_CDC a, $DONATION_TEAM_MEMBER b
where a.cdc_id = b.contact_id
and b.donation_team_id = '".ass($team_id)."'
and a.brand = '$code'
order by first_name, last_name ";
$data = $crm->mydata($query);
// for each team member => contact in company
$team_member_fundraiser_id_array = array();
$team_captain_id = "";
$sum_team_member_goals = 0;
for($a=0;$aassign( array( CONTACT_NAME => $name_contact,
THE_DONATION_TEAM_MEMBER_ID => $data[id][$a],
THE_GOAL => number_format($the_goal,2),
IS_TEAM_CAPTAIN => $data_team_captain[id][0]?"[Team Captain]":"",
));
$tpl->parse("CONTACTS",".contacts");
}
// donations => we add here also donation of team members!
$query = "select g.order_header_id, g.name_in_donor_scroll, g.amount_in_donor_scroll
from $DONATION_GIFT g, $DONATION_TEAM_MEMBER m
where id_type = 'donation_team_member_id'
and id_value = m.id
and m.donation_team_id = '".ass($team_id)."'
and g.brand = '$code' ";
$data = $crm->mydata($query);
// for each donation for the team
$total_sum = 0;
$counter = 0;
unset($donor_js);
for($a=0;$a its a single donation so it will return a single record !!!
//$query = "select sum(b.price*b.quantity) as sum
$query = "select (b.price*b.quantity) as sum, a.contact_id, b.currency
from $ORDER_HEADER a, $ORDER_DETAIL b
where b.order_header_id = a.order_header_id
and a.order_header_id = '".$data[order_header_id][$a]."'
and a.brand = '$code'
and a.status = 'PAID' ";
$data_r = $crm->mydata($query);
$total_sum += $data_r[sum][0];
// donor foo
unset($donor_name,$donor_currency,$donor_amount);
if($data[name_in_donor_scroll][$a] == 'Y')
{
$donor_name = get_cdc($data_r[contact_id][0],$code,$cdc);
$donor_name = $donor_name[first_name]." ".$donor_name[last_name];
}
if($data[amount_in_donor_scroll][$a] == 'Y')
{
$donor_currency = $data_r[currency][0];
$donor_amount = number_format($data_r[sum][0],2);
}
if($data[name_in_donor_scroll][$a] == 'Y' || $data[amount_in_donor_scroll][$a] == 'Y')
{
$donor_js[] = "box_".$counter;
$tpl->assign( array( DONOR_NAME => trim($donor_name)?$donor_name:"Anonymous",
DONOR_CURRENCY => $donor_currency,
DONOR_AMOUNT => $donor_amount,
COUNTER => $counter,
));
$tpl->parse("DONORS",".donors");
$counter++;
}
}
// donors javascript
if(is_array($donor_js))
{
$tpl->assign( array( JS_DONOR_ID_ARRAY => implode("','", $donor_js),
));
}
// company goal
if($sum_team_member_goals > $personal_monetary_goal)
{
$personal_monetary_goal = $sum_team_member_goals;
}
$percentage_made = @number_format(($total_sum/$personal_monetary_goal)*100, 2);
// only show admin options if user is team captain
if(!$u_id || $u_id != $cdc_id)
{
$tpl->assign( array( HIDE_ADMIN_OPTIONS_1 => "",
));
}
$tpl->assign( array( TOTAL_SUM => number_format($total_sum,2),
PERSONAL_MONETARY_GOAL => number_format($personal_monetary_goal,2),
TOTAL_SUM2 => $total_sum,
PERSONAL_MONETARY_GOAL2 => $personal_monetary_goal,
PERCENTAGE_MADE => $percentage_made,
JS_DONOR_COUNTER => $counter,
));
}
// Social networks => assign a PATH(event_id or article_id) and a NAME(event or article)
$path = $_SERVER['HTTPS'] == 'on' ? 'https' : 'http';
$path .= "://" . $_SERVER["HTTP_HOST"] . $PHP_SELF ."?fundraiser_id=$fundraiser_id";
$social_foo = get_social_foo(urlencode(ss("Donations Page For: $entity_info[company_name] $entity_info[first_name] $entity_info[last_name]")), $path);
$tpl->assign(array( SOCIAL_FOO => $social_foo ));
$tpl->parse( MAIN, array( "body", "main" ));
$tpl->FastPrint();
exit();
// functions
function get_social_foo($name, $path)
{
return
<<< _template
_template;
}
?>