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 Share _template; } ?>