if (isset($_GET['$progress_id'])) {
$progress_id = $_GET['$progress_id'];
} else {
$progress_id = '';
}
if ($action != null) {
global $wpdb;
if ($progress_id != null) {
if ($action === "delete") {
$wpdb->query($wpdb->prepare("delete from " . SMART_DONATIONS_PROGRESS_TABLE . " WHERE progress_id=%d", $progress_id));
}
if ($action === "edit") {
$result = $wpdb->get_results($wpdb->prepare("SELECT * FROM " . SMART_DONATIONS_PROGRESS_TABLE . " WHERE progress_id=%d", $progress_id));
if (count($result) > 0) {
$result = $result[0];
$options = rednao_smart_donations_json_object($result->options, $result->styles, null, null, null, null);
$script = <<<EOF
<script type="text/javascript" language="javascript">
var smartDonationsSavedProgress_Id="%s";
var smartDonationsSavedCampaign_Id="%s";
var smartDonationsSavedName="%s";
var smartDonationsSavedProgressType="%s";
var smartDonationsSavedOptions=jQuery.parseJSON('%s');
</script>
EOF;
echo sprintf($script, $result->progress_id, $result->campaign_id, $result->progress_name, $result->progress_type, $options);
include SMART_DONATIONS_DIR . '/smart-donations-progress-add.php';
return;
}
}
}
function rednao_smart_donations_load_progress($id, $title, $returnComponent)
{
$options = get_transient("rednao_smart_donations_progress_{$id}");
$options = false;
if ($options == false) {
$options = null;
global $wpdb;
$result = $wpdb->get_results($wpdb->prepare("select options,styles,campaign_id from " . SMART_DONATIONS_PROGRESS_TABLE . " where progress_id=%d", $id));
if (count($result) > 0) {
$result = $result[0];
$options = $result->options;
$styles = $result->styles;
$campaign_id = $result->campaign_id;
if ($campaign_id == null) {
return "";
}
if ($campaign_id == 0) {
$result = $wpdb->get_results($wpdb->prepare("select coalesce(goal,0) goal,sum(mc_gross) amount,(select count(*) from " . SMART_DONATIONS_TRANSACTION_TABLE . " where campaign_id=%d) donators\n from " . SMART_DONATIONS_TRANSACTION_TABLE . " tran\n left join wp_smart_donations_campaign_table camp\n on tran.campaign_id=camp.campaign_id\n where tran.campaign_id=%d\n group by tran.campaign_id,goal", $campaign_id, $campaign_id));
} else {
$result = $wpdb->get_results($wpdb->prepare("select coalesce(goal,0) goal,sum(mc_gross) amount,(select count(*) from " . SMART_DONATIONS_TRANSACTION_TABLE . " where campaign_id=%d) donators\n from " . SMART_DONATIONS_CAMPAIGN_TABLE . " camp\n left join " . SMART_DONATIONS_TRANSACTION_TABLE . " tran\n on tran.campaign_id=camp.campaign_id\n where camp.campaign_id=%d\n group by tran.campaign_id,goal", $campaign_id, $campaign_id));
}
$amount = 0;
$goal = 0;
$donators = 0;
if (count($result) > 0) {
$amount = $result[0]->amount;
$goal = $result[0]->goal;
$donators = $result[0]->donators;
}
if ($options != null) {
$options = rednao_smart_donations_json_object($options, $styles, $amount, $goal, $donators, null);
set_transient("rednao_smart_donations_progress_{$id}", $options, 60 * 60 * 24 * 31);
}
}
}
wp_enqueue_script('jquery');
wp_enqueue_script('isolated-slider', plugin_dir_url(__FILE__) . 'js/rednao-isolated-jq.js');
wp_enqueue_script('smart-donations-progress-gen', plugin_dir_url(__FILE__) . 'js/smart-donations-progress-gen.js', array('isolated-slider'));
wp_enqueue_style('smart-donations-main-style', plugin_dir_url(__FILE__) . 'css/mainStyle.css');
wp_enqueue_style('smart-donations-Slider', plugin_dir_url(__FILE__) . 'css/smartDonationsSlider/jquery-ui-1.10.2.custom.min.css');
$random = rand();
if ($returnComponent == false) {
if ($options === null) {
return;
}
if ($title) {
echo "<div class='widget-wrapper widget'><div class='title-wrapper'><h3 class='widgettitle widget-title'>{$title}</h3><div class='clear'></div></div>";
}
?>
<div id="progressContainer<?php
echo $random;
?>
" class='wcontainer'></div>
<script>
var smartDonationsRootPath="<?php
echo plugin_dir_url(__FILE__);
?>
";
if(!window.smartDonationsProgressItemsToLoad)
window.smartDonationsProgressItemsToLoad=new Array();;
window.smartDonationsProgressItemsToLoad.push({'options':<?php
echo $options;
?>
,'element':'progressContainer<?php
echo $random;
?>
'});
</script>
<?php
if ($title) {
echo "</div>";
}
} else {
if (options === null) {
return "";
}
return "<div id='progressContainer{$random}'></div>\n <script>\n var smartDonationsRootPath=\"" . plugin_dir_url(__FILE__) . "\";\n if(!window.smartDonationsProgressItemsToLoad)\n window.smartDonationsProgressItemsToLoad=new Array();;\n window.smartDonationsProgressItemsToLoad.push({'options':{$options},'element':'progressContainer{$random}'});\n </script>\n ";
}
}