[insert_php]
global $wpdb;
$total_payable=100;
$total_special=0;
$contribution=0;
$locations = $wpdb->get_results(“SELECT * FROM {$wpdb->prefix}bp_xprofile_data WHERE field_id=11 AND user_id=$current_user->ID”,OBJECT);
foreach($locations as $location){
$u_location=$location->value;
}
$year_reg = $wpdb->get_results(“SELECT * FROM {$wpdb->prefix}bp_xprofile_data WHERE field_id=11 AND user_id=$current_user->ID”,OBJECT);
foreach($year_reg as $year_regs){
$year=$year_regs->value;
}
echo “
Adhérer Depuis |
“.$year.” |
“;
echo “
Member ID |
“.$current_user->user_login.” |
“;
echo “
Etat de Residence |
“.$u_location.” |
“;
$total=0;
$adhesion = $wpdb->get_results(“SELECT * FROM {$wpdb->prefix}bp_xprofile_data WHERE field_id=13 AND user_id=$current_user->ID”,OBJECT);
foreach($adhesion as $ads){
$adhes=$ads->value;
$total=$total+$adhes;
}
echo “
Adhesion |
$”.$adhes.” |
“;
$price_fields = $wpdb->get_results(“SELECT * FROM {$wpdb->prefix}bp_xprofile_fields WHERE group_id=2 order by name ASC “,OBJECT);
foreach($price_fields as $field){
$rece_nnames=”;
$receipt=”;
$field_idd=$field->id;
$field_nname=$field->name;
$prices = $wpdb->get_results(“SELECT * FROM {$wpdb->prefix}bp_xprofile_data WHERE field_id=$field_idd AND user_id=$current_user->ID”,OBJECT);
$receipt_fields = $wpdb->get_results(“SELECT * FROM {$wpdb->prefix}bp_xprofile_fields WHERE name like ‘receipt-$field_nname%'”,OBJECT);
foreach($receipt_fields as $receipt_field){
$rec_idd=$receipt_field->field_id;
$rece_nnames = $wpdb->get_results(“SELECT * FROM {$wpdb->prefix}bp_xprofile_data WHERE field_id=$rec_idd AND user_id=$current_user->ID”,OBJECT);
}
foreach($rece_nnames as $rece){
$receipt=$rece->value;
}
foreach($prices as $price){
$price=$price->value;
$price=intval($price);
if($price && $price!=”){
$total=$total+$price;
echo “
“;
if($receipt){
echo “
“.$field->name.” (“.$receipt.”) |
“;
}
else{
echo “
“.$field->name.” |
“;
}
echo “
$”.$price.” |
“;
echo “
“;
}
}
}
$price_fields = $wpdb->get_results(“SELECT * FROM {$wpdb->prefix}bp_xprofile_fields WHERE group_id=3 order by name ASC “,OBJECT);
foreach($price_fields as $field){
$rece_nnames=”;
$receipt=”;
$field_idd=$field->id;
$field_nname=$field->name;
$prices = $wpdb->get_results(“SELECT * FROM {$wpdb->prefix}bp_xprofile_data WHERE field_id=$field_idd AND user_id=$current_user->ID”,OBJECT);
$receipt_fields = $wpdb->get_results(“SELECT * FROM {$wpdb->prefix}bp_xprofile_fields WHERE name like ‘receipt-$field_nname%'”,OBJECT);
foreach($receipt_fields as $receipt_field){
$rec_idd=$receipt_field->field_id;
$rece_nnames = $wpdb->get_results(“SELECT * FROM {$wpdb->prefix}bp_xprofile_data WHERE field_id=$rec_idd AND user_id=$current_user->ID”,OBJECT);
}
foreach($rece_nnames as $rece){
$receipt=$rece->value;
}
foreach($prices as $price){
$price=$price->value;
$price=intval($price);
if($price && $price!=”){
$total=$total+$price;
echo “
“;
if($receipt){
echo “
“.$field->name.” (“.$receipt.”) |
“;
}
else{
echo “
“.$field->name.” |
“;
}
echo “
$”.$price.” |
“;
echo “
“;
}
}
}
$diff=”;
$status= $wpdb->get_results(“SELECT * FROM {$wpdb->prefix}bp_xprofile_data WHERE field_id=15 AND user_id=$current_user->ID”,OBJECT);
foreach($status as $st){
$u_st=$st->user_value;
}
echo “
Total Contribue |
“;
echo “
$”.$total.” |
“;
echo “
“;
if($u_st==1){
$u_sst=”A Jour”;
$class=”green”;
echo “
Status |
“;
echo “
“.$u_sst.” |
“;
echo “
“;
}else{
$u_sst=”Non-A-Jour”;
$class=”red”;
echo “
Montant a Payé |
“;
echo “
$”.$diff.” |
“;
echo “
“;
echo “
Status |
“;
echo “
“.$u_sst.” |
“;
echo “
“;
}
[/insert_php]