/**
* Campsite user_form block plugin
*
* Type: block
* Name: user_form
* Purpose: Provides a...
*
* @param string
* $p_params
* @param string
* $p_smarty
* @param string
* $p_content
*
* @return
*
*/
function smarty_block_user_form($p_params, $p_content, &$p_smarty, &$p_repeat)
{
$p_smarty->smarty->loadPlugin('smarty_function_get_resource_id');
$resourceId = smarty_function_get_resource_id($p_params, $p_smarty);
if (!isset($p_content)) {
return null;
}
$p_smarty->smarty->loadPlugin('smarty_shared_escape_special_chars');
$campsite = $p_smarty->getTemplateVars('gimme');
$url = $campsite->url;
$url->uri_parameter = "";
$template = null;
if (isset($p_params['template'])) {
$template = new MetaTemplate($resourceId);
if (!$template->defined()) {
CampTemplate::singleton()->trigger_error('invalid template "' . $p_params['template'] . '" specified in the user form');
return false;
}
} elseif (is_numeric($url->get_parameter('tpl'))) {
$template = $campsite->default_template;
}
if (!isset($p_params['submit_button'])) {
require_once $GLOBALS['g_campsiteDir'] . '/admin-files/localizer/Localizer.php';
if (!isGS('Submit')) {
camp_load_translation_strings("globals", $campsite->language->code);
}
$p_params['submit_button'] = getGS('Submit');
}
if (!isset($p_params['html_code']) || empty($p_params['html_code'])) {
$p_params['html_code'] = '';
}
if (!isset($p_params['button_html_code']) || empty($p_params['button_html_code'])) {
$p_params['button_html_code'] = '';
}
if (isset($template)) {
$url->uri_parameter = "template " . str_replace(' ', "\\ ", $template->name);
}
if ($campsite->user->defined && $campsite->user->subscription->defined) {
$subsType = $campsite->user->subscription->type == 'T' ? 'trial' : 'paid';
} else {
$subsType = null;
}
$html = "<form name=\"edit_user\" action=\"" . $url->uri_path . "\" method=\"post\" " . $p_params['html_code'] . ">\n";
if (!is_null($subsType)) {
$html .= "<input type=\"hidden\" name=\"f_substype\" value=\"" . $subsType . "\" />\n";
}
if (isset($template)) {
$html .= "<input type=\"hidden\" name=\"tpl\" value=\"" . $template->identifier . "\" />\n";
}
foreach ($campsite->url->form_parameters as $param) {
if ($param['name'] == 'tpl') {
continue;
}
$html .= '<input type="hidden" name="' . $param['name'] . '" value="' . htmlentities($param['value']) . "\" />\n";
}
$html .= $p_content;
$html .= "<input type=\"submit\" name=\"f_edit_user\" value=\"" . smarty_function_escape_special_chars($p_params['submit_button']) . "\" " . $p_params['button_html_code'] . " />\n</form>\n";
return $html;
}
}
$total_after_commission = $total * (1 - (int) COMMISSION_AS / 100);
$final_balance += $total_after_commission;
echo "</tr></table>";
echo "Total Sold : <b>\$" . number_format($total, 2) . "</b><br>";
echo "Gallery Commission (<b>" . COMMISSION_AS . "%</b>): <b>\$" . number_format($total - $total_after_commission, 2) . "</b><br><hr>";
echo "Final Balance : <b>\$" . number_format($total_after_commission, 2) . "</b><br>";
?>
<h2>Gallery Store Sales :</h2>
<table border=1><tr>
<?php
$total = 0;
$td = 0;
foreach ($sales as $key => $sale) {
if (isGS($key)) {
echo "<td>" . $key . "<sup>x" . $pns[$key] . "</sup> - <b>\$" . number_format($sale, 2) . "</b></td>";
$td++;
$total += $pns[$key] * $sale;
if ($td % 6 == 0) {
echo "</tr><tr>";
}
}
}
$total_after_commission = $total * (1 - (int) COMMISSION_GS / 100);
$final_balance += $total_after_commission;
echo "</tr></table>";
echo "Total Sold : <b>\$" . number_format($total, 2) . "</b><br>";
echo "Gallery Commission (<b>" . COMMISSION_GS . "%</b>): <b>\$" . number_format($total - $total_after_commission, 2) . "</b><br><hr>";
echo "Final Balance : <b>\$" . number_format($total_after_commission, 2) . "</b><br>";
?>
/**
* Campsite camp_select function plugin
*
* Type: function
* Name: camp_select
* Purpose: Provides a...
*
* @param string
* $p_unixtime the date in unixtime format from $smarty.now
* @param string
* $p_format the date format wanted
*
* @return
* string the formatted date
* null in case a non-valid format was passed
*/
function smarty_function_camp_select($p_params, &$p_smarty)
{
global $g_ado_db;
require_once $p_smarty->_get_plugin_filepath('function','html_options');
if (!isset($p_params['object']) || !isset($p_params['attribute'])) {
return;
}
if (!isset($p_params['html_code']) || empty($p_params['html_code'])) {
$p_params['html_code'] = '';
}
// gets the context variable
$campsite = $p_smarty->get_template_vars('gimme');
$html = '';
$object = strtolower($p_params['object']);
$attribute = strtolower($p_params['attribute']);
$selectTag = false;
switch($object) {
case 'user':
$fieldValue = CampRequest::GetVar('f_user_'.$attribute);
if ($attribute == 'gender') {
if (is_null($fieldValue)) {
$fieldValue = $campsite->user->$attribute;
}
$html = '<input type="radio" name="f_user_'.$attribute
.'" value="M" '.(($fieldValue == 'M') ? 'checked' : '').' '
. $p_params['html_code'] . '/> '
.smarty_function_escape_special_chars($p_params['male_name'])
.' <input type="radio" name="f_user_'.$attribute
.'" value="F" '.(($fieldValue == 'F') ? 'checked' : '').' '
. $p_params['html_code'] . ' /> '
.smarty_function_escape_special_chars($p_params['female_name']);
} elseif ($attribute == 'title') {
require_once($GLOBALS['g_campsiteDir'] . '/admin-files/localizer/Localizer.php');
if (!isGS('Mr.')) {
camp_load_translation_strings("users", $campsite->language->code);
}
if (is_null($fieldValue)) {
$fieldValue = $campsite->user->$attribute;
}
$selectTag = true;
$output = array(getGS('Mr.'), getGS('Mrs.'), getGS('Ms.'), getGS('Dr.'));
$values = array('Mr.', 'Mrs.', 'Ms.', 'Dr.');
$html = '<select name="f_user_'.$attribute.'" ' . $p_params['html_code'] . '>';
} elseif ($attribute == 'country') {
if (is_null($fieldValue)) {
$fieldValue = $campsite->user->country_code;
}
$sqlQuery = 'SELECT Code, Name FROM Countries '
.'GROUP BY Code ASC ORDER BY Name ASC';
$data = $g_ado_db->GetAll($sqlQuery);
foreach($data as $country) {
$output[] = $country['Name'];
$values[] = $country['Code'];
}
$selectTag = true;
$html = '<select name="f_user_'.$attribute.'" ' . $p_params['html_code'] . '>';
} elseif ($attribute == 'age') {
if (is_null($fieldValue)) {
$fieldValue = $campsite->user->$attribute;
}
$selectTag = true;
$output = array('0-17', '18-24', '25-39', '40-49', '50-65', '65 or over');
$values = array('0-17', '18-24', '25-39', '40-49', '50-65', '65-');
$html = '<select name="f_user_'.$attribute.'" ' . $p_params['html_code'] . '>';
} elseif ($attribute == 'employertype') {
require_once($GLOBALS['g_campsiteDir'] . '/admin-files/localizer/Localizer.php');
if (!isGS('Corporate')) {
camp_load_translation_strings("users", $campsite->language->code);
}
if (is_null($fieldValue)) {
$fieldValue = $campsite->user->$attribute;
}
$selectTag = true;
$output = array(getGS('Corporate'), getGS('Non-Governmental'), getGS('Government Agency'), getGS('Academic'), getGS('Media'), getGS('Other'));
$values = array('Corporate', 'NGO', 'Government Agency', 'Academic', 'Media', 'Other');
$html = '<select name="f_user_'.$attribute.'" ' . $p_params['html_code'] . '>';
} elseif (substr($attribute, 0, 4) == 'pref') {
if (is_null($fieldValue)) {
$fieldValue = $campsite->user->$attribute;
}
$html = '<input type="checkbox" name="f_user_'.$attribute.'" '
.(($attrValue == 'Y') ? ' value="on" checked />' : ' />')
.'<input type="hidden" name="f_has_pref'
.substr($attribute, 4, 1).'" value="1" ' . $p_params['html_code'] . ' />';
}
break;
case 'login':
if ($attribute == 'rememberuser') {
if (is_null($fieldValue)) {
$fieldValue = $campsite->user->$attribute;
}
$html = '<input type="checkbox" name="f_login_'.$attribute.'" '
. $p_params['html_code'] . ' />';
}
break;
case 'subscription':
$subsType = strtolower(CampRequest::GetVar('SubsType'));
if ($subsType != 'trial' && $subsType != 'paid') {
return null;
}
if ($attribute == 'languages') {
$publicationLanguages = $campsite->publication->languages_list(false);
foreach ($publicationLanguages as $language) {
$output[] = $language->name;
$values[] = $language->number;
}
$selectTag = true;
$html = '<select name="subscription_language[]" multiple size="3" ';
if ($subsType == 'paid') {
$html .= 'onchange="update_subscription_payment();" ';
}
$html .= 'id="select_language" ' . $p_params['html_code'] . '>';
} elseif ($attribute == 'alllanguages') {
$html = '<input type="checkbox" name="subs_all_languages" '
.'onchange="ToggleElementEnabled(\'select_language\');';
if ($subsType == 'paid') {
$html .= ' update_subscription_payment();';
}
$html .= '" ' . $p_params['html_code'] . ' />';
} elseif ($attribute == 'section') {
if ($campsite->subs_by_type == 'publication') {
$html = '<input type="hidden" name="cb_subs[]" value="'
.$campsite->section->number.'" />';
} elseif ($campsite->subs_by_type == 'section') {
$html = '<input type="checkbox" name="cb_subs[]" value="'
.$campsite->section->number.'" '
.'onchange="update_subscription_payment();" '
. $p_params['html_code'] . ' />';
}
}
break;
case 'search':
if ($attribute == 'mode') {
$html = '<input type="checkbox" name="f_match_all" '
. $p_params['html_code'] . ' />';
} elseif ($attribute == 'level') {
require_once($GLOBALS['g_campsiteDir'] . '/admin-files/localizer/Localizer.php');
if (!isGS('Publication')) {
camp_load_translation_strings("globals", $campsite->language->code);
}
$html = '<select name="f_search_'.$attribute.'" ' . $p_params['html_code'] . '>'
.'<option value="1" selected="selected">' . getGS('Publication') . '</option>'
.'<option value="2">' . getGS('Issue') . '</option>'
.'<option value="3">' . getGS('Section') . '</option>'
.'</select>';
} elseif ($attribute == 'section') {
require_once($GLOBALS['g_campsiteDir'] . '/admin-files/localizer/Localizer.php');
$constraints = array();
$operator = new Operator('is', 'integer');
if ($campsite->publication->defined) {
$constraints[] = new ComparisonOperation('IdPublication', $operator, $campsite->publication->identifier);
}
if ($campsite->language->defined) {
$constraints[] = new ComparisonOperation('IdLanguage', $operator, $campsite->language->number);
}
if ($campsite->issue->defined) {
$constraints[] = new ComparisonOperation('NrIssue', $operator, $campsite->issue->number);
}
$sectionsList = Section::GetList($constraints, array('Name'=>'ASC'), 0, 0, $count);
if (!isGS('-- ALL SECTIONS --')) {
camp_load_translation_strings("user_subscription_sections", $campsite->language->code);
}
$html = '<select name="f_search_section" ' . $p_params['html_code'] . '>';
$html .= '<option value="0" selected="selected">' . getGS('-- ALL SECTIONS --') . '</option>';
foreach ($sectionsList as $section) {
$html .= '<option value="' . $section->getSectionNumber() . '">'
. htmlspecialchars($section->getName()) . '</option>';
}
$html .= '</select>';
} elseif ($attribute == 'issue') {
$constraints = array();
$operator = new Operator('is', 'integer');
if ($campsite->publication->defined) {
$constraints[] = new ComparisonOperation('IdPublication', $operator, $campsite->publication->identifier);
}
if ($campsite->language->defined) {
$constraints[] = new ComparisonOperation('IdLanguage', $operator, $campsite->language->number);
}
$constraints[] = new ComparisonOperation('published', $operator, 'true');
$issuesList = Issue::GetList($constraints,
array(array('field'=>'bynumber', 'dir'=>'DESC')),
0, 0, $count);
$html = '<select name="f_search_issue" ' . $p_params['html_code'] . '>';
$html .= '<option value="0" selected="selected"> </option>';
foreach ($issuesList as $issue) {
$issueDesc = $issue->getIssueNumber() . '. '
. $issue->getName()
. ' ('. $issue->getPublicationDate() . ')';
$html .= '<option value="' . $issue->getIssueNumber() . '">'
. htmlspecialchars($issueDesc) . '</option>';
}
$html .= '</select>';
}
}
if ($selectTag == true) {
$html.= smarty_function_html_options(array('output' => $output,
'values' => $values,
'selected' => $fieldValue,
'print_result' => false),
$p_smarty);
$html.= '</select>';
}
return $html;
} // fn smarty_function_camp_select
require_once 'inc/mysql.php';
require_once 'inc/util.php';
$total_money = 0;
$line = 0;
$pncount = 0;
$ancount = 0;
$pns = array();
$ans = array();
$receipts = getReceiptsSummary($connection);
foreach ($receipts as $receipt) {
$total_money = $total_money + $receipt['price'];
$items = explode("#", trim($receipt['itemArray'], '#'));
$prices = explode("#", trim($receipt['priceArray'], '#'));
$date = substr($receipt['date'], 0, 10);
foreach ($items as $key => $item) {
if (isGS($item)) {
$pncount++;
$pns[$date][] = array($item => $prices[$key]);
} else {
$ancount++;
$ans[$date][] = array($item => $prices[$key]);
}
}
}
foreach ($ans as $day => $sales) {
$td = 0;
$total = 0;
echo "<h1>Auction/Quick Sales done on the " . $day . "</h1><table border=1><tr>";
foreach ($sales as $key => $sale) {
echo "<td>" . key($sale) . " - <b>\$" . number_format($sale[key($sale)], 2) . "</b></td>";
$td++;
function compareItemCodeWithID($item, $id)
{
$temp_artist_id = forceStringLength($id, 3, 0, true);
return strpos($item, (isGS($item) ? "PN" : "AN") . $temp_artist_id) === 0 ? true : false;
}
