function ciniki_conferences_attendeeList($ciniki)
{
//
// Find all the required and optional arguments
//
ciniki_core_loadMethod($ciniki, 'ciniki', 'core', 'private', 'prepareArgs');
$rc = ciniki_core_prepareArgs($ciniki, 'no', array('business_id' => array('required' => 'yes', 'blank' => 'no', 'name' => 'Business')));
if ($rc['stat'] != 'ok') {
return $rc;
}
$args = $rc['args'];
//
// Check access to business_id as owner, or sys admin.
//
ciniki_core_loadMethod($ciniki, 'ciniki', 'conferences', 'private', 'checkAccess');
$rc = ciniki_conferences_checkAccess($ciniki, $args['business_id'], 'ciniki.conferences.attendeeList');
if ($rc['stat'] != 'ok') {
return $rc;
}
//
// Get the list of attendees
//
$strsql = "SELECT ciniki_conferences_attendees.id, " . "ciniki_conferences_attendees.conference_id, " . "ciniki_conferences_attendees.customer_id, " . "ciniki_conferences_attendees.status " . "FROM ciniki_conferences_attendees " . "WHERE ciniki_conferences_attendees.business_id = '" . ciniki_core_dbQuote($ciniki, $args['business_id']) . "' " . "";
ciniki_core_loadMethod($ciniki, 'ciniki', 'core', 'private', 'dbHashQueryArrayTree');
$rc = ciniki_core_dbHashQueryArrayTree($ciniki, $strsql, 'ciniki.conferences', array(array('container' => 'attendees', 'fname' => 'id', 'fields' => array('id', 'conference_id', 'customer_id', 'status'))));
if ($rc['stat'] != 'ok') {
return $rc;
}
if (isset($rc['attendees'])) {
$attendees = $rc['attendees'];
} else {
$attendees = array();
}
return array('stat' => 'ok', 'attendees' => $attendees);
}
function ciniki_merchandise_imageList($ciniki)
{
//
// Find all the required and optional arguments
//
ciniki_core_loadMethod($ciniki, 'ciniki', 'core', 'private', 'prepareArgs');
$rc = ciniki_core_prepareArgs($ciniki, 'no', array('business_id' => array('required' => 'yes', 'blank' => 'no', 'name' => 'Business')));
if ($rc['stat'] != 'ok') {
return $rc;
}
$args = $rc['args'];
//
// Check access to business_id as owner, or sys admin.
//
ciniki_core_loadMethod($ciniki, 'ciniki', 'merchandise', 'private', 'checkAccess');
$rc = ciniki_merchandise_checkAccess($ciniki, $args['business_id'], 'ciniki.merchandise.imageList');
if ($rc['stat'] != 'ok') {
return $rc;
}
//
// Get the list of images
//
$strsql = "SELECT ciniki_merchandise_images.id, " . "ciniki_merchandise_images.product_id, " . "ciniki_merchandise_images.name, " . "ciniki_merchandise_images.permalink, " . "ciniki_merchandise_images.sequence, " . "ciniki_merchandise_images.flags, " . "ciniki_merchandise_images.image_id, " . "ciniki_merchandise_images.description " . "FROM ciniki_merchandise_images " . "WHERE ciniki_merchandise_images.business_id = '" . ciniki_core_dbQuote($ciniki, $args['business_id']) . "' " . "";
ciniki_core_loadMethod($ciniki, 'ciniki', 'core', 'private', 'dbHashQueryArrayTree');
$rc = ciniki_core_dbHashQueryArrayTree($ciniki, $strsql, 'ciniki.merchandise', array(array('container' => 'images', 'fname' => 'id', 'fields' => array('id', 'product_id', 'name', 'permalink', 'sequence', 'flags', 'image_id', 'description'))));
if ($rc['stat'] != 'ok') {
return $rc;
}
if (isset($rc['images'])) {
$images = $rc['images'];
} else {
$images = array();
}
return array('stat' => 'ok', 'images' => $images);
}
function ciniki_artistprofiles_artistList($ciniki)
{
//
// Find all the required and optional arguments
//
ciniki_core_loadMethod($ciniki, 'ciniki', 'core', 'private', 'prepareArgs');
$rc = ciniki_core_prepareArgs($ciniki, 'no', array('business_id' => array('required' => 'yes', 'blank' => 'no', 'name' => 'Business'), 'category_permalink' => array('required' => 'no', 'blank' => 'yes', 'name' => 'Category')));
if ($rc['stat'] != 'ok') {
return $rc;
}
$args = $rc['args'];
//
// Check access to business_id as owner, or sys admin.
//
ciniki_core_loadMethod($ciniki, 'ciniki', 'artistprofiles', 'private', 'checkAccess');
$rc = ciniki_artistprofiles_checkAccess($ciniki, $args['business_id'], 'ciniki.artistprofiles.artistList');
if ($rc['stat'] != 'ok') {
return $rc;
}
//
// Get the list of artists
//
if (ciniki_core_checkModuleFlags($ciniki, 'ciniki.artistprofiles', 0x100) && isset($args['category_permalink']) && $args['category_permalink'] != '') {
if (ciniki_core_checkModuleFlags($ciniki, 'ciniki.artistprofiles', 0x200) && $args['category_permalink'] == 'featured') {
$strsql = "SELECT ciniki_artistprofiles.id, " . "ciniki_artistprofiles.name, " . "ciniki_artistprofiles.sort_name, " . "ciniki_artistprofiles.permalink, " . "ciniki_artistprofiles.status, " . "ciniki_artistprofiles.flags " . "FROM ciniki_artistprofiles " . "WHERE ciniki_artistprofiles.business_id = '" . ciniki_core_dbQuote($ciniki, $args['business_id']) . "' " . "AND (flags&0x01) = 0x01 " . "ORDER BY sort_name " . "";
} else {
$strsql = "SELECT ciniki_artistprofiles.id, " . "ciniki_artistprofiles.name, " . "ciniki_artistprofiles.sort_name, " . "ciniki_artistprofiles.permalink, " . "ciniki_artistprofiles.status, " . "ciniki_artistprofiles.flags " . "FROM ciniki_artistprofiles_tags, ciniki_artistprofiles " . "WHERE ciniki_artistprofiles_tags.business_id = '" . ciniki_core_dbQuote($ciniki, $args['business_id']) . "' " . "AND ciniki_artistprofiles_tags.tag_type = 10 " . "AND ciniki_artistprofiles_tags.permalink = '" . ciniki_core_dbQuote($ciniki, $args['category_permalink']) . "' " . "AND ciniki_artistprofiles_tags.artist_id = ciniki_artistprofiles.id " . "AND ciniki_artistprofiles.business_id = '" . ciniki_core_dbQuote($ciniki, $args['business_id']) . "' " . "ORDER BY sort_name " . "";
}
} else {
$strsql = "SELECT ciniki_artistprofiles.id, " . "ciniki_artistprofiles.name, " . "ciniki_artistprofiles.sort_name, " . "ciniki_artistprofiles.permalink, " . "ciniki_artistprofiles.status, " . "ciniki_artistprofiles.flags " . "FROM ciniki_artistprofiles " . "WHERE ciniki_artistprofiles.business_id = '" . ciniki_core_dbQuote($ciniki, $args['business_id']) . "' " . "ORDER BY sort_name " . "";
}
ciniki_core_loadMethod($ciniki, 'ciniki', 'core', 'private', 'dbHashQueryArrayTree');
$rc = ciniki_core_dbHashQueryArrayTree($ciniki, $strsql, 'ciniki.artistprofiles', array(array('container' => 'artists', 'fname' => 'id', 'fields' => array('id', 'name', 'sort_name', 'permalink', 'status', 'flags'))));
if ($rc['stat'] != 'ok') {
return $rc;
}
if (isset($rc['artists'])) {
$artists = $rc['artists'];
} else {
$artists = array();
}
$rsp = array('stat' => 'ok', 'artists' => $artists);
//
// Return list of categories
//
if (ciniki_core_checkModuleFlags($ciniki, 'ciniki.artistprofiles', 0x100)) {
ciniki_core_loadMethod($ciniki, 'ciniki', 'artistprofiles', 'web', 'subMenuItems');
$rc = ciniki_artistprofiles_web_subMenuItems($ciniki, array(), $args['business_id'], array());
if ($rc['stat'] != 'ok') {
return $rc;
}
$rsp['categories'] = $rc['submenu'];
}
return $rsp;
}
function ciniki_conferences_presentationList($ciniki)
{
//
// Find all the required and optional arguments
//
ciniki_core_loadMethod($ciniki, 'ciniki', 'core', 'private', 'prepareArgs');
$rc = ciniki_core_prepareArgs($ciniki, 'no', array('business_id' => array('required' => 'yes', 'blank' => 'no', 'name' => 'Business'), 'conference_id' => array('required' => 'yes', 'blank' => 'no', 'name' => 'Conference'), 'status' => array('required' => 'no', 'blank' => 'yes', 'name' => 'Status')));
if ($rc['stat'] != 'ok') {
return $rc;
}
$args = $rc['args'];
//
// Check access to business_id as owner, or sys admin.
//
ciniki_core_loadMethod($ciniki, 'ciniki', 'conferences', 'private', 'checkAccess');
$rc = ciniki_conferences_checkAccess($ciniki, $args['business_id'], 'ciniki.conferences.presentationList');
if ($rc['stat'] != 'ok') {
return $rc;
}
//
// Load conference maps
//
ciniki_core_loadMethod($ciniki, 'ciniki', 'conferences', 'private', 'maps');
$rc = ciniki_conferences_maps($ciniki);
if ($rc['stat'] != 'ok') {
return $rc;
}
$maps = $rc['maps'];
//
// Get the list of presentations
//
$strsql = "SELECT ciniki_conferences_presentations.id, " . "ciniki_conferences_presentations.conference_id, " . "ciniki_conferences_presentations.customer_id, " . "ciniki_customers.display_name, " . "ciniki_customer_emails.email, " . "ciniki_conferences_presentations.presentation_number, " . "ciniki_conferences_presentations.presentation_type, " . "ciniki_conferences_presentations.status, " . "ciniki_conferences_presentations.status AS status_text, " . "ciniki_conferences_presentations.submission_date, " . "ciniki_conferences_presentations.field, " . "ciniki_conferences_presentations.title, " . "ciniki_conferences_presentations.permalink, " . "ciniki_conferences_presentations.description " . "FROM ciniki_conferences_presentations " . "LEFT JOIN ciniki_customers ON (" . "ciniki_conferences_presentations.customer_id = ciniki_customers.id " . "AND ciniki_customers.business_id = '" . ciniki_core_dbQuote($ciniki, $args['business_id']) . "' " . ") " . "LEFT JOIN ciniki_customer_emails ON (" . "ciniki_customers.id = ciniki_customer_emails.id " . "AND ciniki_customer_emails.business_id = '" . ciniki_core_dbQuote($ciniki, $args['business_id']) . "' " . ") " . "WHERE ciniki_conferences_presentations.business_id = '" . ciniki_core_dbQuote($ciniki, $args['business_id']) . "' " . "";
if (isset($args['status']) && $args['status'] > 0) {
$strsql .= "AND ciniki_conferences_presentations.status = '" . ciniki_core_dbQuote($ciniki, $args['status']) . "' ";
}
$strsql .= "ORDER BY submission_date ";
ciniki_core_loadMethod($ciniki, 'ciniki', 'core', 'private', 'dbHashQueryArrayTree');
$rc = ciniki_core_dbHashQueryArrayTree($ciniki, $strsql, 'ciniki.conferences', array(array('container' => 'presentations', 'fname' => 'id', 'fields' => array('id', 'conference_id', 'customer_id', 'presentation_number', 'presentation_type', 'status', 'status_text', 'submission_date', 'field', 'title', 'display_name', 'permalink', 'description'), 'maps' => array('status_text' => $maps['presentation']['status']))));
if ($rc['stat'] != 'ok') {
return $rc;
}
$email_list = '';
if (isset($rc['presentations'])) {
$presentations = $rc['presentations'];
foreach ($presentations as $pid => $presentation) {
$presentations[$pid]['display_title'] = sprintf("#%03d: ", $presentation['presentation_number']) . $presentation['title'];
$email_list .= ($email_list != '' ? ', ' : '') . '"' . $presentation['display_name'] . '" ' . $presentation['email'];
}
} else {
$presentations = array();
}
return array('stat' => 'ok', 'presentations' => $presentations, 'emails' => $email_list);
}
function ciniki_merchandise_productSearch($ciniki)
{
//
// Find all the required and optional arguments
//
ciniki_core_loadMethod($ciniki, 'ciniki', 'core', 'private', 'prepareArgs');
$rc = ciniki_core_prepareArgs($ciniki, 'no', array('business_id' => array('required' => 'yes', 'blank' => 'no', 'name' => 'Business'), 'start_needle' => array('required' => 'yes', 'blank' => 'no', 'name' => 'Search String'), 'limit' => array('required' => 'no', 'blank' => 'yes', 'name' => 'Limit')));
if ($rc['stat'] != 'ok') {
return $rc;
}
$args = $rc['args'];
//
// Check access to business_id as owner, or sys admin.
//
ciniki_core_loadMethod($ciniki, 'ciniki', 'merchandise', 'private', 'checkAccess');
$rc = ciniki_merchandise_checkAccess($ciniki, $args['business_id'], 'ciniki.merchandise.productList');
if ($rc['stat'] != 'ok') {
return $rc;
}
//
// Get the list of products
//
$strsql = "SELECT ciniki_merchandise.id, " . "ciniki_merchandise.code, " . "ciniki_merchandise.name, " . "ciniki_merchandise.permalink, " . "ciniki_merchandise.status, " . "ciniki_merchandise.sequence, " . "ciniki_merchandise.flags, " . "ciniki_merchandise.unit_amount, " . "ciniki_merchandise.unit_discount_amount, " . "ciniki_merchandise.unit_discount_percentage, " . "ciniki_merchandise.taxtype_id, " . "ciniki_merchandise.inventory, " . "ciniki_merchandise.shipping_other, " . "ciniki_merchandise.shipping_CA, " . "ciniki_merchandise.shipping_US, " . "ciniki_merchandise.primary_image_id, " . "ciniki_merchandise.synopsis, " . "ciniki_merchandise.description " . "FROM ciniki_merchandise " . "WHERE ciniki_merchandise.business_id = '" . ciniki_core_dbQuote($ciniki, $args['business_id']) . "' " . "";
if (ciniki_core_checkModuleFlags($ciniki, 'ciniki.merchandise', 0x1)) {
$strsql .= "AND (code LIKE '" . ciniki_core_dbQuote($ciniki, $args['start_needle']) . "%' " . "OR code LIKE '% " . ciniki_core_dbQuote($ciniki, $args['start_needle']) . "%' " . "OR name LIKE '" . ciniki_core_dbQuote($ciniki, $args['start_needle']) . "%' " . "OR name LIKE '% " . ciniki_core_dbQuote($ciniki, $args['start_needle']) . "%' " . ") ";
} else {
$strsql .= "AND (name LIKE '" . ciniki_core_dbQuote($ciniki, $args['start_needle']) . "%' " . "OR name LIKE '% " . ciniki_core_dbQuote($ciniki, $args['start_needle']) . "%' " . ") ";
}
if (isset($args['limit']) && is_numeric($args['limit']) && $args['limit'] > 0) {
$strsql .= "LIMIT " . ciniki_core_dbQuote($ciniki, $args['limit']) . " ";
} else {
$strsql .= "LIMIT 25 ";
}
ciniki_core_loadMethod($ciniki, 'ciniki', 'core', 'private', 'dbHashQueryArrayTree');
$rc = ciniki_core_dbHashQueryArrayTree($ciniki, $strsql, 'ciniki.merchandise', array(array('container' => 'products', 'fname' => 'id', 'fields' => array('id', 'code', 'name', 'permalink', 'status', 'sequence', 'flags', 'unit_amount', 'unit_discount_amount', 'unit_discount_percentage', 'taxtype_id', 'inventory', 'shipping_other', 'shipping_CA', 'shipping_US', 'primary_image_id', 'synopsis', 'description'))));
if ($rc['stat'] != 'ok') {
return $rc;
}
if (isset($rc['products'])) {
$products = $rc['products'];
foreach ($products as $pid => $product) {
if (ciniki_core_checkModuleFlags($ciniki, 'ciniki.merchandise', 0x1) && $product['code'] != '') {
$products[$pid]['display_name'] = $product['code'] . ' - ' . $product['name'];
} else {
$products[$pid]['display_name'] = $product['name'];
}
}
} else {
$products = array();
}
return array('stat' => 'ok', 'products' => $products);
}
function ciniki_merchandise_web_productLoad($ciniki, $business_id, $args)
{
$strsql = "SELECT ciniki_merchandise.id, " . "ciniki_merchandise.uuid, " . "ciniki_merchandise.name, " . "ciniki_merchandise.permalink, " . "ciniki_merchandise.flags, " . "ciniki_merchandise.primary_image_id, " . "'' AS primary_image_caption, " . "ciniki_merchandise.synopsis, " . "ciniki_merchandise.description " . "FROM ciniki_merchandise " . "WHERE ciniki_merchandise.business_id = '" . ciniki_core_dbQuote($ciniki, $business_id) . "' " . "";
if (isset($args['permalink']) && $args['permalink'] != '') {
$strsql .= "AND ciniki_merchandise.permalink = '" . ciniki_core_dbQuote($ciniki, $args['permalink']) . "' ";
} elseif (isset($args['id']) && $args['id'] > 0) {
$strsql .= "AND ciniki_merchandise.id = '" . ciniki_core_dbQuote($ciniki, $args['id']) . "' ";
} else {
return array('stat' => 'fail', 'err' => array('code' => 'ciniki.merchandise.27', 'msg' => 'No product specified'));
}
ciniki_core_loadMethod($ciniki, 'ciniki', 'core', 'private', 'dbHashQuery');
$rc = ciniki_core_dbHashQuery($ciniki, $strsql, 'ciniki.merchandise', 'product');
if ($rc['stat'] != 'ok') {
return array('stat' => 'fail', 'err' => array('code' => 'ciniki.merchandise.28', 'msg' => 'Product not found', 'err' => $rc['err']));
}
if (!isset($rc['product'])) {
return array('stat' => 'fail', 'err' => array('code' => 'ciniki.merchandise.29', 'msg' => 'Unable to find Product'));
}
$product = $rc['product'];
//
// Get the images
//
if (isset($args['images']) && $args['images'] == 'yes') {
$strsql = "SELECT id, " . "name AS title, " . "permalink, " . "flags, " . "image_id, " . "description " . "FROM ciniki_merchandise_images " . "WHERE product_id = '" . ciniki_core_dbQuote($ciniki, $product['id']) . "' " . "AND business_id = '" . ciniki_core_dbQuote($ciniki, $business_id) . "' " . "";
ciniki_core_loadMethod($ciniki, 'ciniki', 'core', 'private', 'dbHashQueryArrayTree');
$rc = ciniki_core_dbHashQueryArrayTree($ciniki, $strsql, 'ciniki.merchandise', array(array('container' => 'images', 'fname' => 'id', 'fields' => array('id', 'title', 'permalink', 'flags', 'image_id', 'description'))));
if ($rc['stat'] != 'ok') {
return $rc;
}
if (isset($rc['images'])) {
$product['images'] = $rc['images'];
} else {
$product['images'] = array();
}
if ($product['primary_image_id'] > 0) {
$found = 'no';
foreach ($product['images'] as $image) {
if ($image['image_id'] == $product['primary_image_id']) {
$found = 'yes';
}
}
if ($found == 'no') {
array_unshift($product['images'], array('title' => '', 'flags' => 1, 'permalink' => $product['uuid'], 'image_id' => $product['primary_image_id'], 'description' => ''));
}
}
}
return array('stat' => 'ok', 'product' => $product);
}
function ciniki_merchandise_web_productList($ciniki, $settings, $business_id, $args)
{
//
// Load INTL settings
//
ciniki_core_loadMethod($ciniki, 'ciniki', 'businesses', 'private', 'intlSettings');
$rc = ciniki_businesses_intlSettings($ciniki, $business_id);
if ($rc['stat'] != 'ok') {
return $rc;
}
$intl_timezone = $rc['settings']['intl-default-timezone'];
$intl_currency_fmt = numfmt_create($rc['settings']['intl-default-locale'], NumberFormatter::CURRENCY);
$intl_currency = $rc['settings']['intl-default-currency'];
//
// Load the list of products for an object
//
if (isset($args['object']) && $args['object'] != '' && isset($args['object_id']) && $args['object_id'] != '') {
$strsql = "SELECT ciniki_merchandise_objrefs.id AS ref_id, " . "ciniki_merchandise.id, " . "ciniki_merchandise.code, " . "ciniki_merchandise.name, " . "ciniki_merchandise.permalink, " . "ciniki_merchandise.inventory, " . "ciniki_merchandise.unit_amount, " . "ciniki_merchandise.primary_image_id, " . "ciniki_merchandise.synopsis, ";
if (isset($settings['page-merchandise-active']) && $settings['page-merchandise-active'] == 'yes') {
$strsql .= "'yes' AS is_details ";
} else {
$strsql .= "'no' AS is_details ";
}
$strsql .= "FROM ciniki_merchandise_objrefs " . "LEFT JOIN ciniki_merchandise ON (" . "ciniki_merchandise_objrefs.product_id = ciniki_merchandise.id " . "AND ciniki_merchandise.status = 10 " . "AND (ciniki_merchandise.flags&0x01) = 0x01 " . "AND ciniki_merchandise.business_id = '" . ciniki_core_dbQuote($ciniki, $business_id) . "' " . ") " . "WHERE ciniki_merchandise_objrefs.business_id = '" . ciniki_core_dbQuote($ciniki, $business_id) . "' " . "AND ciniki_merchandise_objrefs.object = '" . ciniki_core_dbQuote($ciniki, $args['object']) . "' " . "AND ciniki_merchandise_objrefs.object_id = '" . ciniki_core_dbQuote($ciniki, $args['object_id']) . "' " . "ORDER BY ciniki_merchandise_objrefs.sequence, ciniki_merchandise.name " . "";
ciniki_core_loadMethod($ciniki, 'ciniki', 'core', 'private', 'dbHashQueryArrayTree');
$rc = ciniki_core_dbHashQueryArrayTree($ciniki, $strsql, 'ciniki.merchandise', array(array('container' => 'products', 'fname' => 'id', 'fields' => array('id', 'code', 'name', 'permalink', 'image_id' => 'primary_image_id', 'synopsis', 'is_details'))));
if ($rc['stat'] != 'ok') {
return $rc;
}
if (isset($rc['products'])) {
foreach ($rc['products'] as $pid => $product) {
$rc['products'][$pid]['localurl'] = '/merchandise/' . $product['permalink'];
if (ciniki_core_checkModuleFlags($ciniki, 'ciniki.merchandise', 0x1)) {
$rc['products'][$pid]['title'] = ($product['code'] != '' ? $product['code'] . ' - ' : '') . $product['name'];
} else {
$rc['products'][$pid]['title'] = $product['name'];
}
// $rc['products'][$pid]['unit_amount_display'] = numfmt_format_currency($intl_currency_fmt, $product['unit_amount'], $intl_currency);
}
return array('stat' => 'ok', 'products' => $rc['products']);
} else {
return array('stat' => 'ok', 'products' => array());
}
}
return array('stat' => 'ok', 'products' => array());
}
function ciniki_conferences_sessionList($ciniki)
{
//
// Find all the required and optional arguments
//
ciniki_core_loadMethod($ciniki, 'ciniki', 'core', 'private', 'prepareArgs');
$rc = ciniki_core_prepareArgs($ciniki, 'no', array('business_id' => array('required' => 'yes', 'blank' => 'no', 'name' => 'Business')));
if ($rc['stat'] != 'ok') {
return $rc;
}
$args = $rc['args'];
//
// Check access to business_id as owner, or sys admin.
//
ciniki_core_loadMethod($ciniki, 'ciniki', 'conferences', 'private', 'checkAccess');
$rc = ciniki_conferences_checkAccess($ciniki, $args['business_id'], 'ciniki.conferences.sessionList');
if ($rc['stat'] != 'ok') {
return $rc;
}
//
// Load business settings
//
ciniki_core_loadMethod($ciniki, 'ciniki', 'businesses', 'private', 'intlSettings');
$rc = ciniki_businesses_intlSettings($ciniki, $args['business_id']);
if ($rc['stat'] != 'ok') {
return $rc;
}
$intl_timezone = $rc['settings']['intl-default-timezone'];
ciniki_core_loadMethod($ciniki, 'ciniki', 'users', 'private', 'datetimeFormat');
$datetime_format = ciniki_users_datetimeFormat($ciniki, 'php');
//
// Get the list of sessions
//
$strsql = "SELECT ciniki_conferences_sessions.id, " . "ciniki_conferences_sessions.conference_id, " . "ciniki_conferences_sessions.room_id, " . "ciniki_conferences_sessions.name, " . "ciniki_conferences_rooms.name AS room, " . "ciniki_conferences_rooms.sequence, " . "ciniki_conferences_sessions.session_start, " . "ciniki_conferences_sessions.session_end " . "FROM ciniki_conferences_sessions " . "WHERE ciniki_conferences_sessions.business_id = '" . ciniki_core_dbQuote($ciniki, $args['business_id']) . "' " . "";
ciniki_core_loadMethod($ciniki, 'ciniki', 'core', 'private', 'dbHashQueryArrayTree');
$rc = ciniki_core_dbHashQueryArrayTree($ciniki, $strsql, 'ciniki.conferences', array(array('container' => 'sessions', 'fname' => 'id', 'fields' => array('id', 'conference_id', 'name', 'room_id', 'room', 'sequence', 'session_start', 'session_end'), 'utctotz' => array('session_start' => array('format' => $datetime_format, 'timezone' => $intl_timezone)))));
if ($rc['stat'] != 'ok') {
return $rc;
}
if (isset($rc['sessions'])) {
$sessions = $rc['sessions'];
} else {
$sessions = array();
}
return array('stat' => 'ok', 'sessions' => $sessions);
}
function ciniki_artistprofiles_artistSearch($ciniki)
{
//
// Find all the required and optional arguments
//
ciniki_core_loadMethod($ciniki, 'ciniki', 'core', 'private', 'prepareArgs');
$rc = ciniki_core_prepareArgs($ciniki, 'no', array('business_id' => array('required' => 'yes', 'blank' => 'no', 'name' => 'Business'), 'start_needle' => array('required' => 'yes', 'blank' => 'no', 'name' => 'Search String'), 'limit' => array('required' => 'no', 'blank' => 'no', 'default' => '15', 'name' => 'Limit')));
if ($rc['stat'] != 'ok') {
return $rc;
}
$args = $rc['args'];
//
// Check access to business_id as owner, or sys admin.
//
ciniki_core_loadMethod($ciniki, 'ciniki', 'artistprofiles', 'private', 'checkAccess');
$rc = ciniki_artistprofiles_checkAccess($ciniki, $args['business_id'], 'ciniki.artistprofiles.artistSearch');
if ($rc['stat'] != 'ok') {
return $rc;
}
//
// Get the list of artists
//
$strsql = "SELECT ciniki_artistprofiles.id, " . "ciniki_artistprofiles.name, " . "ciniki_artistprofiles.sort_name, " . "ciniki_artistprofiles.permalink, " . "ciniki_artistprofiles.status, " . "ciniki_artistprofiles.flags " . "FROM ciniki_artistprofiles " . "WHERE ciniki_artistprofiles.business_id = '" . ciniki_core_dbQuote($ciniki, $args['business_id']) . "' " . "AND (name like '" . ciniki_core_dbQuote($ciniki, $args['start_needle']) . "%' " . "OR name like '% " . ciniki_core_dbQuote($ciniki, $args['start_needle']) . "%' " . ") " . "ORDER BY sort_name " . "";
if (isset($args['limit']) && is_numeric($args['limit']) && $args['limit'] > 0) {
$strsql .= "LIMIT " . ciniki_core_dbQuote($ciniki, $args['limit']) . " ";
// is_numeric verified
} else {
$strsql .= "LIMIT 25 ";
}
ciniki_core_loadMethod($ciniki, 'ciniki', 'core', 'private', 'dbHashQueryArrayTree');
$rc = ciniki_core_dbHashQueryArrayTree($ciniki, $strsql, 'ciniki.artistprofiles', array(array('container' => 'artists', 'fname' => 'id', 'fields' => array('id', 'name', 'sort_name', 'permalink', 'status', 'flags'))));
if ($rc['stat'] != 'ok') {
return $rc;
}
if (isset($rc['artists'])) {
$artists = $rc['artists'];
} else {
$artists = array();
}
return array('stat' => 'ok', 'artists' => $artists);
}
function ciniki_merchandise_hooks_productList($ciniki, $business_id, $args)
{
//
// Load INTL settings
//
ciniki_core_loadMethod($ciniki, 'ciniki', 'businesses', 'private', 'intlSettings');
$rc = ciniki_businesses_intlSettings($ciniki, $business_id);
if ($rc['stat'] != 'ok') {
return $rc;
}
$intl_timezone = $rc['settings']['intl-default-timezone'];
$intl_currency_fmt = numfmt_create($rc['settings']['intl-default-locale'], NumberFormatter::CURRENCY);
$intl_currency = $rc['settings']['intl-default-currency'];
//
// Load the list of products for an object
//
if (isset($args['object']) && $args['object'] != '' && isset($args['object_id']) && $args['object_id'] != '') {
$strsql = "SELECT ciniki_merchandise_objrefs.id AS ref_id, " . "ciniki_merchandise.id, " . "ciniki_merchandise.code, " . "ciniki_merchandise.name, " . "ciniki_merchandise.inventory, " . "ciniki_merchandise.unit_amount " . "FROM ciniki_merchandise_objrefs " . "LEFT JOIN ciniki_merchandise ON (" . "ciniki_merchandise_objrefs.product_id = ciniki_merchandise.id " . "AND ciniki_merchandise.business_id = '" . ciniki_core_dbQuote($ciniki, $business_id) . "' " . ") " . "WHERE ciniki_merchandise_objrefs.business_id = '" . ciniki_core_dbQuote($ciniki, $business_id) . "' " . "AND ciniki_merchandise_objrefs.object = '" . ciniki_core_dbQuote($ciniki, $args['object']) . "' " . "AND ciniki_merchandise_objrefs.object_id = '" . ciniki_core_dbQuote($ciniki, $args['object_id']) . "' " . "ORDER BY ciniki_merchandise_objrefs.sequence, ciniki_merchandise.name " . "";
ciniki_core_loadMethod($ciniki, 'ciniki', 'core', 'private', 'dbHashQueryArrayTree');
$rc = ciniki_core_dbHashQueryArrayTree($ciniki, $strsql, 'ciniki.merchandise', array(array('container' => 'products', 'fname' => 'id', 'fields' => array('ref_id', 'product_id' => 'id', 'code', 'name', 'inventory', 'unit_amount'))));
if ($rc['stat'] != 'ok') {
return $rc;
}
if (isset($rc['products'])) {
foreach ($rc['products'] as $pid => $product) {
if (ciniki_core_checkModuleFlags($ciniki, 'ciniki.merchandise', 0x1) && $product['code'] != '') {
$rc['products'][$pid]['display_name'] = $product['code'] . ' - ' . $product['name'];
} else {
$rc['products'][$pid]['display_name'] = $product['name'];
}
$rc['products'][$pid]['unit_amount_display'] = numfmt_format_currency($intl_currency_fmt, $product['unit_amount'], $intl_currency);
}
return array('stat' => 'ok', 'products' => $rc['products']);
} else {
return array('stat' => 'ok', 'products' => array());
}
}
return array('stat' => 'fail', 'err' => array('code' => 'ciniki.merchandise.1', 'msg' => 'Unable to get the product list'));
}
function ciniki_conferences_sessionGet($ciniki)
{
//
// Find all the required and optional arguments
//
ciniki_core_loadMethod($ciniki, 'ciniki', 'core', 'private', 'prepareArgs');
$rc = ciniki_core_prepareArgs($ciniki, 'no', array('business_id' => array('required' => 'yes', 'blank' => 'no', 'name' => 'Business'), 'session_id' => array('required' => 'yes', 'blank' => 'no', 'name' => 'Conference Session'), 'conference_id' => array('required' => 'yes', 'blank' => 'no', 'name' => 'Conference')));
if ($rc['stat'] != 'ok') {
return $rc;
}
$args = $rc['args'];
//
// Make sure this module is activated, and
// check permission to run this function for this business
//
ciniki_core_loadMethod($ciniki, 'ciniki', 'conferences', 'private', 'checkAccess');
$rc = ciniki_conferences_checkAccess($ciniki, $args['business_id'], 'ciniki.conferences.sessionGet');
if ($rc['stat'] != 'ok') {
return $rc;
}
//
// Load business settings
//
ciniki_core_loadMethod($ciniki, 'ciniki', 'businesses', 'private', 'intlSettings');
$rc = ciniki_businesses_intlSettings($ciniki, $args['business_id']);
if ($rc['stat'] != 'ok') {
return $rc;
}
$intl_timezone = $rc['settings']['intl-default-timezone'];
$intl_currency_fmt = numfmt_create($rc['settings']['intl-default-locale'], NumberFormatter::CURRENCY);
$intl_currency = $rc['settings']['intl-default-currency'];
ciniki_core_loadMethod($ciniki, 'ciniki', 'users', 'private', 'datetimeFormat');
$datetime_format = ciniki_users_datetimeFormat($ciniki, 'php');
//
// Return default for new Conference Session
//
if ($args['session_id'] == 0) {
$session = array('id' => 0, 'conference_id' => '', 'room_id' => '', 'name' => '', 'session_start' => '', 'session_end' => '');
} else {
$strsql = "SELECT ciniki_conferences_sessions.id, " . "ciniki_conferences_sessions.conference_id, " . "ciniki_conferences_sessions.room_id, " . "ciniki_conferences_sessions.name, " . "ciniki_conferences_sessions.session_start, " . "ciniki_conferences_sessions.session_end " . "FROM ciniki_conferences_sessions " . "WHERE ciniki_conferences_sessions.business_id = '" . ciniki_core_dbQuote($ciniki, $args['business_id']) . "' " . "AND ciniki_conferences_sessions.id = '" . ciniki_core_dbQuote($ciniki, $args['session_id']) . "' " . "";
ciniki_core_loadMethod($ciniki, 'ciniki', 'core', 'private', 'dbHashQueryArrayTree');
$rc = ciniki_core_dbHashQueryArrayTree($ciniki, $strsql, 'ciniki.conferences', array(array('container' => 'sessions', 'fname' => 'id', 'fields' => array('id', 'conference_id', 'room_id', 'name', 'session_start', 'session_end'), 'utctotz' => array('session_start' => array('format' => $datetime_format, 'timezone' => $intl_timezone), 'session_end' => array('format' => $datetime_format, 'timezone' => $intl_timezone)))));
if ($rc['stat'] != 'ok') {
return array('stat' => 'fail', 'err' => array('pkg' => 'ciniki', 'code' => '3599', 'msg' => 'Conference Session not found', 'err' => $rc['err']));
}
if (!isset($rc['sessions'][0])) {
return array('stat' => 'fail', 'err' => array('pkg' => 'ciniki', 'code' => '3600', 'msg' => 'Unable to find Conference Session'));
}
$session = $rc['sessions'][0];
}
//
// Get the list of rooms
//
$strsql = "SELECT ciniki_conferences_rooms.id, " . "ciniki_conferences_rooms.conference_id, " . "ciniki_conferences_rooms.name, " . "ciniki_conferences_rooms.sequence " . "FROM ciniki_conferences_rooms " . "WHERE ciniki_conferences_rooms.business_id = '" . ciniki_core_dbQuote($ciniki, $args['business_id']) . "' " . "AND ciniki_conferences_rooms.conference_id = '" . ciniki_core_dbQuote($ciniki, $args['conference_id']) . "' " . "ORDER BY ciniki_conferences_rooms.sequence, ciniki_conferences_rooms.name " . "";
ciniki_core_loadMethod($ciniki, 'ciniki', 'core', 'private', 'dbHashQueryArrayTree');
$rc = ciniki_core_dbHashQueryArrayTree($ciniki, $strsql, 'ciniki.conferences', array(array('container' => 'rooms', 'fname' => 'id', 'fields' => array('id', 'conference_id', 'name', 'sequence'))));
if ($rc['stat'] != 'ok') {
return $rc;
}
if (isset($rc['rooms'])) {
$rooms = $rc['rooms'];
} else {
$rooms = array();
}
return array('stat' => 'ok', 'session' => $session, 'rooms' => $rooms);
}
function ciniki_conferences_conferenceScheduleDownload($ciniki)
{
//
// Find all the required and optional arguments
//
ciniki_core_loadMethod($ciniki, 'ciniki', 'core', 'private', 'prepareArgs');
$rc = ciniki_core_prepareArgs($ciniki, 'no', array('business_id' => array('required' => 'yes', 'blank' => 'no', 'name' => 'Business'), 'conference_id' => array('required' => 'yes', 'blank' => 'no', 'name' => 'Conference')));
if ($rc['stat'] != 'ok') {
return $rc;
}
$args = $rc['args'];
//
// Make sure this module is activated, and
// check permission to run this function for this business
//
ciniki_core_loadMethod($ciniki, 'ciniki', 'conferences', 'private', 'checkAccess');
$rc = ciniki_conferences_checkAccess($ciniki, $args['business_id'], 'ciniki.conferences.conferenceScheduleDownload');
if ($rc['stat'] != 'ok') {
return $rc;
}
ciniki_core_loadMethod($ciniki, 'ciniki', 'core', 'private', 'dbHashQuery');
ciniki_core_loadMethod($ciniki, 'ciniki', 'core', 'private', 'dbHashQueryArrayTree');
ciniki_core_loadMethod($ciniki, 'ciniki', 'core', 'private', 'dbHashQueryIDTree');
//
// Load business settings
//
ciniki_core_loadMethod($ciniki, 'ciniki', 'businesses', 'private', 'intlSettings');
$rc = ciniki_businesses_intlSettings($ciniki, $args['business_id']);
if ($rc['stat'] != 'ok') {
return $rc;
}
$intl_timezone = $rc['settings']['intl-default-timezone'];
$intl_currency_fmt = numfmt_create($rc['settings']['intl-default-locale'], NumberFormatter::CURRENCY);
$intl_currency = $rc['settings']['intl-default-currency'];
ciniki_core_loadMethod($ciniki, 'ciniki', 'users', 'private', 'dateFormat');
ciniki_core_loadMethod($ciniki, 'ciniki', 'users', 'private', 'timeFormat');
$date_format = ciniki_users_dateFormat($ciniki, 'php');
$time_format = ciniki_users_timeFormat($ciniki, 'php');
$mysql_date_format = ciniki_users_dateFormat($ciniki, 'mysql');
//
// Load conference maps
//
ciniki_core_loadMethod($ciniki, 'ciniki', 'conferences', 'private', 'maps');
$rc = ciniki_conferences_maps($ciniki);
if ($rc['stat'] != 'ok') {
return $rc;
}
$maps = $rc['maps'];
$strsql = "SELECT ciniki_conferences.id, " . "ciniki_conferences.name, " . "ciniki_conferences.permalink, " . "ciniki_conferences.status, " . "ciniki_conferences.status AS status_text, " . "ciniki_conferences.flags, " . "DATE_FORMAT(ciniki_conferences.start_date, '" . ciniki_core_dbQuote($ciniki, $mysql_date_format) . "') AS start_date, " . "DATE_FORMAT(ciniki_conferences.end_date, '" . ciniki_core_dbQuote($ciniki, $mysql_date_format) . "') AS end_date, " . "ciniki_conferences.synopsis, " . "ciniki_conferences.description, " . "ciniki_conferences.imap_mailbox, " . "ciniki_conferences.imap_username, " . "ciniki_conferences.imap_password, " . "ciniki_conferences.imap_subject " . "FROM ciniki_conferences " . "WHERE ciniki_conferences.business_id = '" . ciniki_core_dbQuote($ciniki, $args['business_id']) . "' " . "AND ciniki_conferences.id = '" . ciniki_core_dbQuote($ciniki, $args['conference_id']) . "' " . "";
$rc = ciniki_core_dbHashQuery($ciniki, $strsql, 'ciniki.conferences', 'conference');
if ($rc['stat'] != 'ok') {
return array('stat' => 'fail', 'err' => array('pkg' => 'ciniki', 'code' => '3631', 'msg' => 'Conference not found', 'err' => $rc['err']));
}
if (!isset($rc['conference'])) {
return array('stat' => 'fail', 'err' => array('pkg' => 'ciniki', 'code' => '3632', 'msg' => 'Unable to find Conference'));
}
$conference = $rc['conference'];
if (isset($maps['conference']['status'][$conference['status_text']])) {
$conference['status_text'] = $maps['conference']['status'][$conference['status_text']];
}
$strsql = "SELECT ciniki_conferences_sessions.id, " . "CONCAT_WS('-', ciniki_conferences_sessions.id, ciniki_conferences_presentations.id) AS rowid, " . "ciniki_conferences_sessions.conference_id, " . "ciniki_conferences_sessions.room_id, " . "ciniki_conferences_rooms.name AS room, " . "ciniki_conferences_rooms.sequence, " . "ciniki_conferences_sessions.name, " . "ciniki_conferences_sessions.session_start AS start_time, " . "ciniki_conferences_sessions.session_start AS start_date, " . "ciniki_conferences_sessions.session_end AS end_time, " . "IFNULL(ciniki_conferences_presentations.id, 0) AS presentation_id, " . "IFNULL(ciniki_conferences_presentations.customer_id, 0) AS customer_id, " . "IFNULL(ciniki_conferences_presentations.presentation_number, '') AS presentation_number, " . "IFNULL(ciniki_conferences_presentations.title, '') AS presentation_title, " . "IFNULL(ciniki_conferences_presentations.description, '') AS presentation_description, " . "IFNULL(ciniki_customers.display_name, '') AS display_name, " . "IFNULL(ciniki_conferences_presentations.status, 0) AS status, " . "IFNULL(ciniki_conferences_presentations.status, '') AS status_text, " . "IFNULL(ciniki_conferences_attendees.status, 0) AS registration, " . "IFNULL(ciniki_conferences_attendees.status, 0) AS registration_text " . "FROM ciniki_conferences_sessions " . "INNER JOIN ciniki_conferences_rooms ON (" . "ciniki_conferences_sessions.room_id = ciniki_conferences_rooms.id " . "AND ciniki_conferences_rooms.business_id = '" . ciniki_core_dbQuote($ciniki, $args['business_id']) . "' " . ") " . "LEFT JOIN ciniki_conferences_presentations ON (" . "ciniki_conferences_sessions.id = ciniki_conferences_presentations.session_id " . "AND ciniki_conferences_presentations.business_id = '" . ciniki_core_dbQuote($ciniki, $args['business_id']) . "' " . ") " . "LEFT JOIN ciniki_conferences_attendees ON (" . "ciniki_conferences_presentations.customer_id = ciniki_conferences_attendees.customer_id " . "AND ciniki_conferences_presentations.conference_id = ciniki_conferences_attendees.conference_id " . "AND ciniki_conferences_attendees.business_id = '" . ciniki_core_dbQuote($ciniki, $args['business_id']) . "' " . ") " . "LEFT JOIN ciniki_customers ON (" . "ciniki_conferences_presentations.customer_id = ciniki_customers.id " . "AND ciniki_customers.business_id = '" . ciniki_core_dbQuote($ciniki, $args['business_id']) . "' " . ") " . "WHERE ciniki_conferences_sessions.business_id = '" . ciniki_core_dbQuote($ciniki, $args['business_id']) . "' " . "AND ciniki_conferences_sessions.conference_id = '" . ciniki_core_dbQuote($ciniki, $args['conference_id']) . "' " . "ORDER BY ciniki_conferences_sessions.session_start, " . "ciniki_conferences_rooms.name, " . "ciniki_conferences_rooms.sequence, " . "ciniki_conferences_presentations.title " . "";
ciniki_core_loadMethod($ciniki, 'ciniki', 'core', 'private', 'dbHashQueryArrayTree');
$rc = ciniki_core_dbHashQueryArrayTree($ciniki, $strsql, 'ciniki.conferences', array(array('container' => 'times', 'fname' => 'start_time', 'fields' => array('start_time', 'start_date', 'end_time'), 'utctotz' => array('start_time' => array('format' => $time_format, 'timezone' => $intl_timezone), 'start_date' => array('format' => $date_format, 'timezone' => $intl_timezone), 'end_time' => array('format' => $time_format, 'timezone' => $intl_timezone))), array('container' => 'rooms', 'fname' => 'room_id', 'fields' => array('id' => 'room_id', 'name' => 'room', 'session_name' => 'name', 'presentation_id')), array('container' => 'presentations', 'fname' => 'presentation_id', 'fields' => array('id', 'conference_id', 'room_id', 'room', 'sequence', 'name', 'start_time', 'start_date', 'end_time', 'presentation_id', 'customer_id', 'presentation_number', 'presentation_title', 'presentation_description', 'display_name', 'status', 'status_text', 'registration', 'registration_text'), 'utctotz' => array('start_time' => array('format' => $time_format, 'timezone' => $intl_timezone), 'start_date' => array('format' => $date_format, 'timezone' => $intl_timezone), 'end_time' => array('format' => $time_format, 'timezone' => $intl_timezone)), 'maps' => array('status_text' => $maps['presentation']['status'], 'registration_text' => $maps['attendee']['status']))));
if ($rc['stat'] != 'ok') {
return $rc;
}
if (isset($rc['times'])) {
$timeslots = $rc['times'];
} else {
$timeslots = array();
}
//
// Generate the word file
//
require_once $ciniki['config']['core']['lib_dir'] . '/PHPWord/src/PhpWord/Autoloader.php';
\PhpOffice\PhpWord\Autoloader::register();
require $ciniki['config']['core']['lib_dir'] . '/PHPWord/src/PhpWord/PhpWord.php';
$PHPWord = new \PhpOffice\PhpWord\PhpWord();
$PHPWord->addTitleStyle(1, array('bold' => true, 'size' => 18), array('spaceBefore' => 240, 'spaceAfter' => 120));
$PHPWord->addTitleStyle(2, array('bold' => true, 'size' => 16), array('spaceBefore' => 120, 'spaceAfter' => 120));
$PHPWord->addTitleStyle(3, array('bold' => false, 'size' => 14), array('spaceBefore' => 120, 'spaceAfter' => 120));
$style_table = array('cellMargin' => 80, 'borderColor' => 'aaaaaa', 'borderSize' => 6);
$style_header = array('borderSize' => 6, 'borderColor' => 'aaaaaa', 'bgColor' => 'dddddd', 'valign' => 'center');
$style_cell = array('borderSize' => 6, 'borderColor' => 'aaaaaa', 'valign' => 'center', 'bgcolor' => 'ffffff');
$style_header_font = array('bold' => true, 'spaceAfter' => 20);
$style_cell_font = array();
$style_header_pleft = array('align' => 'left');
$style_header_pright = array('align' => 'right');
$style_cell_pleft = array('align' => 'left');
$style_cell_pright = array('align' => 'right');
$section = $PHPWord->addSection();
$header = $section->addHeader();
$table = $header->addTable();
$table->addRow();
$cell = $table->addCell(9600);
$cell->addText($conference['name'], array('size' => '16'), array('align' => 'center'));
//print "<pre>" . print_r($timeslots, true) . "</pre>";
//exit;
//
// Create a table with a row for each time slot
//
$cur_date = '';
$table = $section->addTable($style_table);
$session_number = 1;
foreach ($timeslots as $timeslot) {
//
// Add the date as a header
//
if ($timeslot['start_date'] != $cur_date) {
$table->addRow();
$cell = $table->addCell(1500, $style_cell);
$cell->addText($timeslot['start_date']);
$cell->setGridSpan(2);
$cur_date = $timeslot['start_date'];
// $session_number = 1;
}
//
// Add the time slot
//
$table->addRow();
$cell = $table->addCell(1500, $style_cell);
$cell->addText($timeslot['start_time'] . ' - ' . $timeslot['end_time'], $style_cell_font);
$nonsession_info = array();
$session_info = array();
if (isset($timeslot['rooms']) && count($timeslot['rooms']) > 0) {
foreach ($timeslot['rooms'] as $room) {
if (!isset($room['presentations']) || $room['presentation_id'] == 0) {
if (isset($room['presentations'][0])) {
$session = $room['presentations'][0];
if ($session['name'] != '') {
$nonsession_info[] = $session['name'];
}
}
$nonsession_info[] = "Location: " . $room['name'];
} else {
$session_info[] = $session_number . ". " . $room['session_name'] . ": ";
$presentation_number = 1;
$presentation_info = '';
foreach ($room['presentations'] as $presentation) {
if ($presentation_number > 1) {
$presentation_info .= "; ";
}
$presentation_info .= $presentation_number . ") " . $presentation['display_name'];
$presentation_number++;
}
$session_info[] = $presentation_info;
$session_info[] = "Location: " . $room['name'];
$session_info[] = "";
$session_number++;
}
}
}
$cell = $table->addCell(2500, $style_cell);
foreach ($nonsession_info as $line) {
$cell->addText($line, $style_cell_font);
}
$cell = $table->addCell(5500, $style_cell);
foreach ($session_info as $line) {
$cell->addText($line, $style_cell_font);
}
}
$section = $PHPWord->addSection();
$header = $section->addHeader();
$table = $header->addTable();
$table->addRow();
$cell = $table->addCell(9600);
$cell->addText($conference['name'], array('size' => '16'), array('align' => 'center'));
$session_number = 1;
foreach ($timeslots as $timeslot) {
if (isset($timeslot['rooms']) && count($timeslot['rooms']) > 0) {
foreach ($timeslot['rooms'] as $room) {
if (!isset($room['presentations']) || $room['presentation_id'] == 0) {
continue;
}
$section->addTitle($session_number . ". " . $room['session_name'], 1);
if (isset($room['presentations']) && $room['presentation_id'] != 0) {
foreach ($room['presentations'] as $pid => $presentation) {
$section->addTitle($presentation['display_name'], 2);
$section->addTitle(htmlspecialchars($presentation['presentation_title']), 3);
$lines = explode("\n", $presentation['presentation_description']);
foreach ($lines as $line) {
$section->addText(htmlspecialchars($line), array());
}
$section->addText('');
}
}
$session_number++;
}
}
}
//
// Output the word file
//
header('Content-Type: application/vnd.openxmlformats-officedocument.wordprocessingml.document');
header('Content-Disposition: attachment;filename="' . preg_replace("/[^A-Za-z0-9]/", '', $conference['name']) . '.docx"');
header('Cache-Control: max-age=0');
$objWriter = \PhpOffice\PhpWord\IOFactory::createWriter($PHPWord, 'Word2007');
$objWriter->save('php://output');
return array('stat' => 'exit');
}
function ciniki_merchandise_productGet($ciniki)
{
//
// Find all the required and optional arguments
//
ciniki_core_loadMethod($ciniki, 'ciniki', 'core', 'private', 'prepareArgs');
$rc = ciniki_core_prepareArgs($ciniki, 'no', array('business_id' => array('required' => 'yes', 'blank' => 'no', 'name' => 'Business'), 'product_id' => array('required' => 'yes', 'blank' => 'no', 'name' => 'Merchandise Product'), 'images' => array('required' => 'no', 'blank' => 'yes', 'name' => 'Images')));
if ($rc['stat'] != 'ok') {
return $rc;
}
$args = $rc['args'];
//
// Make sure this module is activated, and
// check permission to run this function for this business
//
ciniki_core_loadMethod($ciniki, 'ciniki', 'merchandise', 'private', 'checkAccess');
$rc = ciniki_merchandise_checkAccess($ciniki, $args['business_id'], 'ciniki.merchandise.productGet');
if ($rc['stat'] != 'ok') {
return $rc;
}
//
// Load business settings
//
ciniki_core_loadMethod($ciniki, 'ciniki', 'businesses', 'private', 'intlSettings');
$rc = ciniki_businesses_intlSettings($ciniki, $args['business_id']);
if ($rc['stat'] != 'ok') {
return $rc;
}
$intl_timezone = $rc['settings']['intl-default-timezone'];
$intl_currency_fmt = numfmt_create($rc['settings']['intl-default-locale'], NumberFormatter::CURRENCY);
$intl_currency = $rc['settings']['intl-default-currency'];
ciniki_core_loadMethod($ciniki, 'ciniki', 'users', 'private', 'datetimeFormat');
$datetime_format = ciniki_users_datetimeFormat($ciniki, 'php');
//
// Return default for new Merchandise Product
//
if ($args['product_id'] == 0) {
$product = array('id' => 0, 'code' => '', 'name' => '', 'permalink' => '', 'status' => '10', 'sequence' => '1', 'flags' => '0', 'unit_amount' => '', 'unit_discount_amount' => '', 'unit_discount_percentage' => '', 'taxtype_id' => '0', 'inventory' => '', 'shipping_other' => '', 'shipping_CA' => '', 'shipping_US' => '', 'primary_image_id' => '0', 'synopsis' => '', 'description' => '', 'images' => array());
} else {
$strsql = "SELECT ciniki_merchandise.id, " . "ciniki_merchandise.code, " . "ciniki_merchandise.name, " . "ciniki_merchandise.permalink, " . "ciniki_merchandise.status, " . "ciniki_merchandise.sequence, " . "ciniki_merchandise.flags, " . "ciniki_merchandise.unit_amount, " . "ciniki_merchandise.unit_discount_amount, " . "ciniki_merchandise.unit_discount_percentage, " . "ciniki_merchandise.taxtype_id, " . "ciniki_merchandise.inventory, " . "ciniki_merchandise.shipping_other, " . "ciniki_merchandise.shipping_CA, " . "ciniki_merchandise.shipping_US, " . "ciniki_merchandise.primary_image_id, " . "ciniki_merchandise.synopsis, " . "ciniki_merchandise.description " . "FROM ciniki_merchandise " . "WHERE ciniki_merchandise.business_id = '" . ciniki_core_dbQuote($ciniki, $args['business_id']) . "' " . "AND ciniki_merchandise.id = '" . ciniki_core_dbQuote($ciniki, $args['product_id']) . "' " . "";
ciniki_core_loadMethod($ciniki, 'ciniki', 'core', 'private', 'dbHashQuery');
$rc = ciniki_core_dbHashQuery($ciniki, $strsql, 'ciniki.merchandise', 'product');
if ($rc['stat'] != 'ok') {
return array('stat' => 'fail', 'err' => array('code' => 'ciniki.merchandise.17', 'msg' => 'Merchandise Product not found', 'err' => $rc['err']));
}
if (!isset($rc['product'])) {
return array('stat' => 'fail', 'err' => array('code' => 'ciniki.merchandise.18', 'msg' => 'Unable to find Merchandise Product'));
}
$product = $rc['product'];
$product['unit_amount'] = $product['unit_amount'] == 0 ? '' : numfmt_format_currency($intl_currency_fmt, $product['unit_amount'], $intl_currency);
$product['unit_discount_amount'] = $product['unit_discount_amount'] == 0 ? '' : numfmt_format_currency($intl_currency_fmt, $product['unit_discount_amount'], $intl_currency);
$product['shipping_other'] = $product['shipping_other'] == 0 ? '' : numfmt_format_currency($intl_currency_fmt, $product['shipping_other'], $intl_currency);
$product['shipping_CA'] = $product['shipping_CA'] == 0 ? '' : numfmt_format_currency($intl_currency_fmt, $product['shipping_CA'], $intl_currency);
$product['shipping_US'] = $product['shipping_US'] == 0 ? '' : numfmt_format_currency($intl_currency_fmt, $product['shipping_US'], $intl_currency);
//
// Get any tags for this product
//
if (ciniki_core_checkModuleFlags($ciniki, 'ciniki.merchandise', 0x4)) {
$product['categories'] = array();
$strsql = "SELECT tag_type, tag_name AS lists " . "FROM ciniki_merchandise_tags " . "WHERE product_id = '" . ciniki_core_dbQuote($ciniki, $args['product_id']) . "' " . "AND business_id = '" . ciniki_core_dbQuote($ciniki, $args['business_id']) . "' " . "ORDER BY tag_type, tag_name " . "";
ciniki_core_loadMethod($ciniki, 'ciniki', 'core', 'private', 'dbHashQueryTree');
$rc = ciniki_core_dbHashQueryTree($ciniki, $strsql, 'ciniki.merchandise', array(array('container' => 'tags', 'fname' => 'tag_type', 'name' => 'tags', 'fields' => array('tag_type', 'lists'), 'dlists' => array('lists' => '::'))));
if ($rc['stat'] != 'ok') {
return $rc;
}
if (isset($rc['tags'])) {
foreach ($rc['tags'] as $tags) {
if ($tags['tags']['tag_type'] == 10) {
$product['categories'] = $tags['tags']['lists'];
}
}
}
}
//
// Get the list of object references for this product
//
$strsql = "SELECT id, object, object_id, 'Unknown' as display_name " . "FROM ciniki_merchandise_objrefs " . "WHERE product_id = '" . ciniki_core_dbQuote($ciniki, $args['product_id']) . "' " . "";
ciniki_core_loadMethod($ciniki, 'ciniki', 'core', 'private', 'dbHashQueryArrayTree');
$rc = ciniki_core_dbHashQueryArrayTree($ciniki, $strsql, 'ciniki.merchandise', array(array('container' => 'objrefs', 'fname' => 'id', 'fields' => array('id', 'object', 'object_id', 'display_name'))));
if ($rc['stat'] != 'ok') {
return $rc;
}
if (isset($rc['objrefs'])) {
$product['objrefs'] = $rc['objrefs'];
foreach ($product['objrefs'] as $rid => $ref) {
list($pkg, $mod, $obj) = explode('.', $ref['object']);
$rc = ciniki_core_loadMethod($ciniki, $pkg, $mod, 'hooks', 'getObjectName');
if ($rc['stat'] == 'ok') {
$fn = $rc['function_call'];
$rc = $fn($ciniki, $args['business_id'], array('object' => $ref['object'], 'object_id' => $ref['object_id']));
if ($rc['stat'] == 'ok' && isset($rc['name'])) {
$product['objrefs'][$rid]['display_name'] = $rc['name'];
}
}
}
} else {
$product['objrefs'] = array();
}
//
// Get the additional images for this product
//
if (isset($args['images']) && $args['images'] == 'yes') {
ciniki_core_loadMethod($ciniki, 'ciniki', 'images', 'hooks', 'loadThumbnail');
$strsql = "SELECT ciniki_merchandise_images.id, " . "ciniki_merchandise_images.image_id, " . "ciniki_merchandise_images.name, " . "ciniki_merchandise_images.sequence, " . "ciniki_merchandise_images.description " . "FROM ciniki_merchandise_images " . "WHERE ciniki_merchandise_images.product_id = '" . ciniki_core_dbQuote($ciniki, $args['product_id']) . "' " . "AND ciniki_merchandise_images.business_id = '" . ciniki_core_dbQuote($ciniki, $args['business_id']) . "' " . "ORDER BY ciniki_merchandise_images.sequence, ciniki_merchandise_images.date_added, ciniki_merchandise_images.name " . "";
$rc = ciniki_core_dbHashQueryArrayTree($ciniki, $strsql, 'ciniki.artcatalog', array(array('container' => 'images', 'fname' => 'id', 'fields' => array('id', 'image_id', 'name', 'sequence', 'description'))));
if ($rc['stat'] != 'ok') {
return $rc;
}
if (isset($rc['images'])) {
$product['images'] = $rc['images'];
foreach ($product['images'] as $inum => $img) {
if (isset($img['image_id']) && $img['image_id'] > 0) {
$rc = ciniki_images_hooks_loadThumbnail($ciniki, $args['business_id'], array('image_id' => $img['image_id'], 'maxlength' => 75));
if ($rc['stat'] != 'ok') {
return $rc;
}
$product['images'][$inum]['image_data'] = 'data:image/jpg;base64,' . base64_encode($rc['image']);
}
}
}
}
}
$rsp = array('stat' => 'ok', 'product' => $product);
//
// Check if all tags should be returned
//
$rsp['categories'] = array();
if (ciniki_core_checkModuleFlags($ciniki, 'ciniki.merchandise', 0x4)) {
//
// Get the available tags
//
ciniki_core_loadMethod($ciniki, 'ciniki', 'core', 'private', 'dbQueryList');
$strsql = "SELECT DISTINCT tag_name FROM ciniki_merchandise_tags WHERE tag_type = 10 AND business_id = '" . ciniki_core_dbQuote($ciniki, $args['business_id']) . "' ";
$rc = ciniki_core_dbQueryList($ciniki, $strsql, 'ciniki.merchandise', 'categories', 'tag_name');
if ($rc['stat'] != 'ok') {
return array('stat' => 'fail', 'err' => array('code' => 'ciniki.merchandise.19', 'msg' => 'Unable to get list of categories', 'err' => $rc['err']));
}
if (isset($rc['categories'])) {
$rsp['categories'] = $rc['categories'];
}
}
return $rsp;
}
function ciniki_conferences_presentationSearch($ciniki)
{
//
// Find all the required and optional arguments
//
ciniki_core_loadMethod($ciniki, 'ciniki', 'core', 'private', 'prepareArgs');
$rc = ciniki_core_prepareArgs($ciniki, 'no', array('business_id' => array('required' => 'yes', 'blank' => 'no', 'name' => 'Business'), 'conference_id' => array('required' => 'yes', 'blank' => 'no', 'name' => 'Conference'), 'start_needle' => array('required' => 'yes', 'blank' => 'no', 'name' => 'Search String'), 'limit' => array('required' => 'no', 'blank' => 'no', 'name' => 'Limit')));
if ($rc['stat'] != 'ok') {
return $rc;
}
$args = $rc['args'];
//
// Make sure this module is activated, and
// check permission to run this function for this business
//
ciniki_core_loadMethod($ciniki, 'ciniki', 'conferences', 'private', 'checkAccess');
$rc = ciniki_conferences_checkAccess($ciniki, $args['business_id'], 'ciniki.conferences.conferenceGet');
if ($rc['stat'] != 'ok') {
return $rc;
}
ciniki_core_loadMethod($ciniki, 'ciniki', 'core', 'private', 'dbHashQuery');
ciniki_core_loadMethod($ciniki, 'ciniki', 'core', 'private', 'dbHashQueryArrayTree');
ciniki_core_loadMethod($ciniki, 'ciniki', 'core', 'private', 'dbHashQueryIDTree');
//
// Load business settings
//
ciniki_core_loadMethod($ciniki, 'ciniki', 'businesses', 'private', 'intlSettings');
$rc = ciniki_businesses_intlSettings($ciniki, $args['business_id']);
if ($rc['stat'] != 'ok') {
return $rc;
}
$intl_timezone = $rc['settings']['intl-default-timezone'];
$intl_currency_fmt = numfmt_create($rc['settings']['intl-default-locale'], NumberFormatter::CURRENCY);
$intl_currency = $rc['settings']['intl-default-currency'];
ciniki_core_loadMethod($ciniki, 'ciniki', 'users', 'private', 'dateFormat');
$date_format = ciniki_users_dateFormat($ciniki, 'php');
$mysql_date_format = ciniki_users_dateFormat($ciniki, 'mysql');
//
// Load conference maps
//
ciniki_core_loadMethod($ciniki, 'ciniki', 'conferences', 'private', 'maps');
$rc = ciniki_conferences_maps($ciniki);
if ($rc['stat'] != 'ok') {
return $rc;
}
$maps = $rc['maps'];
//
// Search the presentations
//
$strsql = "SELECT ciniki_conferences_presentations.id, " . "ciniki_conferences_presentations.conference_id, " . "ciniki_conferences_presentations.customer_id, " . "ciniki_customers.display_name, " . "ciniki_conferences_presentations.presentation_number, " . "ciniki_conferences_presentations.presentation_type, " . "ciniki_conferences_presentations.presentation_type AS presentation_type_text, " . "ciniki_conferences_presentations.status, " . "ciniki_conferences_presentations.status AS status_text, " . "ciniki_conferences_attendees.status AS registration, " . "ciniki_conferences_attendees.status AS registration_text, " . "ciniki_conferences_presentations.submission_date, " . "ciniki_conferences_presentations.field, " . "ciniki_conferences_presentations.title, " . "ciniki_conferences_presentations.permalink, " . "IF(ciniki_conferences_presentation_reviews.vote > 0, 'yes', 'no') AS voted, " . "COUNT(ciniki_conferences_presentation_reviews.id) AS num_votes " . "FROM ciniki_conferences_presentations " . "LEFT JOIN ciniki_conferences_attendees ON (" . "ciniki_conferences_presentations.customer_id = ciniki_conferences_attendees.customer_id " . "AND ciniki_conferences_presentations.conference_id = ciniki_conferences_attendees.conference_id " . "AND ciniki_conferences_attendees.business_id = '" . ciniki_core_dbQuote($ciniki, $args['business_id']) . "' " . ") " . "LEFT JOIN ciniki_customers ON (" . "ciniki_conferences_presentations.customer_id = ciniki_customers.id " . "AND ciniki_customers.business_id = '" . ciniki_core_dbQuote($ciniki, $args['business_id']) . "' " . ") " . "LEFT JOIN ciniki_conferences_presentation_reviews ON (" . "ciniki_conferences_presentations.id = ciniki_conferences_presentation_reviews.presentation_id " . "AND ciniki_conferences_presentation_reviews.business_id = '" . ciniki_core_dbQuote($ciniki, $args['business_id']) . "' " . ") " . "WHERE ciniki_conferences_presentations.business_id = '" . ciniki_core_dbQuote($ciniki, $args['business_id']) . "' " . "";
if (isset($args['presentation_status']) && $args['presentation_status'] > 0) {
$strsql .= "AND ciniki_conferences_presentations.status = '" . ciniki_core_dbQuote($ciniki, $args['presentation_status']) . "' ";
}
if (isset($args['presentation_type']) && $args['presentation_type'] > 0) {
$strsql .= "AND ciniki_conferences_presentations.presentation_type = '" . ciniki_core_dbQuote($ciniki, $args['presentation_type']) . "' ";
}
$strsql .= "AND (" . "ciniki_customers.display_name LIKE '" . ciniki_core_dbQuote($ciniki, $args['start_needle']) . "%' " . "OR ciniki_customers.display_name LIKE '% " . ciniki_core_dbQuote($ciniki, $args['start_needle']) . "%' " . "OR ciniki_conferences_presentations.title LIKE '" . ciniki_core_dbQuote($ciniki, $args['start_needle']) . "%' " . "OR ciniki_conferences_presentations.title LIKE '% " . ciniki_core_dbQuote($ciniki, $args['start_needle']) . "%' " . ") " . "";
$strsql .= "GROUP BY ciniki_conferences_presentations.id, voted ";
$strsql .= "ORDER BY submission_date ";
$rc = ciniki_core_dbHashQueryArrayTree($ciniki, $strsql, 'ciniki.conferences', array(array('container' => 'presentations', 'fname' => 'id', 'fields' => array('id', 'conference_id', 'customer_id', 'presentation_type', 'presentation_number', 'status', 'status_text', 'registration', 'registration_text', 'submission_date', 'field', 'title', 'display_name', 'permalink'), 'utctotz' => array('submission_date' => array('format' => 'M j', 'timezone' => $intl_timezone)), 'maps' => array('status_text' => $maps['presentation']['status'], 'registration_text' => $maps['attendee']['status'], 'presentation_type_text' => $maps['presentation']['presentation_type'])), array('container' => 'voted', 'fname' => 'voted', 'fields' => array('voted', 'num_votes'))));
if ($rc['stat'] != 'ok') {
return $rc;
}
if (isset($rc['presentations'])) {
$presentations = $rc['presentations'];
foreach ($presentations as $pid => $presentation) {
$presentations[$pid]['display_title'] = sprintf("#%03d: ", $presentation['presentation_number']) . $presentation['title'];
$presentations[$pid]['votes_received'] = 0;
$presentations[$pid]['total_reviews'] = 0;
if (isset($presentation['voted'])) {
foreach ($presentation['voted'] as $vote) {
$presentations[$pid]['total_reviews'] += $vote['num_votes'];
if ($vote['voted'] == 'yes') {
$presentations[$pid]['votes_received'] += $vote['num_votes'];
}
}
unset($presentations[$pid]['voted']);
}
}
} else {
$presentations = array();
}
return array('stat' => 'ok', 'presentations' => $presentations);
}
function ciniki_conferences_conferenceGet($ciniki)
{
//
// Find all the required and optional arguments
//
ciniki_core_loadMethod($ciniki, 'ciniki', 'core', 'private', 'prepareArgs');
$rc = ciniki_core_prepareArgs($ciniki, 'no', array('business_id' => array('required' => 'yes', 'blank' => 'no', 'name' => 'Business'), 'conference_id' => array('required' => 'yes', 'blank' => 'no', 'name' => 'Conference'), 'cfplogs' => array('required' => 'no', 'blank' => 'yes', 'name' => 'CFP Log Entries'), 'presentations' => array('required' => 'no', 'blank' => 'yes', 'name' => 'Presentations'), 'presentation_status' => array('required' => 'no', 'blank' => 'yes', 'name' => 'Presentations'), 'registration_status' => array('required' => 'no', 'blank' => 'yes', 'name' => 'Registrations'), 'presentation_type' => array('required' => 'no', 'blank' => 'yes', 'name' => 'Presentations'), 'reviewers' => array('required' => 'no', 'blank' => 'yes', 'name' => 'Reviewers'), 'attendees' => array('required' => 'no', 'blank' => 'yes', 'name' => 'Attendees'), 'attendee_status' => array('required' => 'no', 'blank' => 'yes', 'name' => 'Presentations'), 'rooms' => array('required' => 'no', 'blank' => 'yes', 'name' => 'Rooms'), 'sessions' => array('required' => 'no', 'blank' => 'yes', 'name' => 'Session'), 'sessionpresentations' => array('required' => 'no', 'blank' => 'yes', 'name' => 'Assigned Presentations'), 'stats' => array('required' => 'no', 'blank' => 'yes', 'name' => 'Stats')));
if ($rc['stat'] != 'ok') {
return $rc;
}
$args = $rc['args'];
//
// Make sure this module is activated, and
// check permission to run this function for this business
//
ciniki_core_loadMethod($ciniki, 'ciniki', 'conferences', 'private', 'checkAccess');
$rc = ciniki_conferences_checkAccess($ciniki, $args['business_id'], 'ciniki.conferences.conferenceGet');
if ($rc['stat'] != 'ok') {
return $rc;
}
ciniki_core_loadMethod($ciniki, 'ciniki', 'core', 'private', 'dbHashQuery');
ciniki_core_loadMethod($ciniki, 'ciniki', 'core', 'private', 'dbHashQueryArrayTree');
ciniki_core_loadMethod($ciniki, 'ciniki', 'core', 'private', 'dbHashQueryIDTree');
//
// Load business settings
//
ciniki_core_loadMethod($ciniki, 'ciniki', 'businesses', 'private', 'intlSettings');
$rc = ciniki_businesses_intlSettings($ciniki, $args['business_id']);
if ($rc['stat'] != 'ok') {
return $rc;
}
$intl_timezone = $rc['settings']['intl-default-timezone'];
$intl_currency_fmt = numfmt_create($rc['settings']['intl-default-locale'], NumberFormatter::CURRENCY);
$intl_currency = $rc['settings']['intl-default-currency'];
ciniki_core_loadMethod($ciniki, 'ciniki', 'users', 'private', 'dateFormat');
ciniki_core_loadMethod($ciniki, 'ciniki', 'users', 'private', 'timeFormat');
$date_format = ciniki_users_dateFormat($ciniki, 'php');
$time_format = ciniki_users_timeFormat($ciniki, 'php');
$mysql_date_format = ciniki_users_dateFormat($ciniki, 'mysql');
//
// Load conference maps
//
ciniki_core_loadMethod($ciniki, 'ciniki', 'conferences', 'private', 'maps');
$rc = ciniki_conferences_maps($ciniki);
if ($rc['stat'] != 'ok') {
return $rc;
}
$maps = $rc['maps'];
//
// Return default for new Conference
//
$email_list = '';
if ($args['conference_id'] == 0) {
$conference = array('id' => 0, 'name' => '', 'permalink' => '', 'status' => '10', 'flags' => '0', 'start_date' => '', 'end_date' => '', 'synopsis' => '', 'description' => '');
} else {
$strsql = "SELECT ciniki_conferences.id, " . "ciniki_conferences.name, " . "ciniki_conferences.permalink, " . "ciniki_conferences.status, " . "ciniki_conferences.status AS status_text, " . "ciniki_conferences.flags, " . "DATE_FORMAT(ciniki_conferences.start_date, '" . ciniki_core_dbQuote($ciniki, $mysql_date_format) . "') AS start_date, " . "DATE_FORMAT(ciniki_conferences.end_date, '" . ciniki_core_dbQuote($ciniki, $mysql_date_format) . "') AS end_date, " . "ciniki_conferences.synopsis, " . "ciniki_conferences.description, " . "ciniki_conferences.imap_mailbox, " . "ciniki_conferences.imap_username, " . "ciniki_conferences.imap_password, " . "ciniki_conferences.imap_subject " . "FROM ciniki_conferences " . "WHERE ciniki_conferences.business_id = '" . ciniki_core_dbQuote($ciniki, $args['business_id']) . "' " . "AND ciniki_conferences.id = '" . ciniki_core_dbQuote($ciniki, $args['conference_id']) . "' " . "";
$rc = ciniki_core_dbHashQuery($ciniki, $strsql, 'ciniki.conferences', 'conference');
if ($rc['stat'] != 'ok') {
return array('stat' => 'fail', 'err' => array('pkg' => 'ciniki', 'code' => '2840', 'msg' => 'Conference not found', 'err' => $rc['err']));
}
if (!isset($rc['conference'])) {
return array('stat' => 'fail', 'err' => array('pkg' => 'ciniki', 'code' => '2841', 'msg' => 'Unable to find Conference'));
}
$conference = $rc['conference'];
if (isset($maps['conference']['status'][$conference['status_text']])) {
$conference['status_text'] = $maps['conference']['status'][$conference['status_text']];
}
//
// Check if CFP logs should be returned
//
if (isset($args['cfplogs']) && $args['cfplogs'] == 'yes') {
$strsql = "SELECT ciniki_conferences_cfplogs.id, " . "ciniki_conferences_cfplogs.name, " . "ciniki_conferences_cfplogs.url, " . "ciniki_conferences_cfplogs.sent_date, " . "ciniki_conferences_cfplogs.email " . "FROM ciniki_conferences_cfplogs " . "WHERE ciniki_conferences_cfplogs.business_id = '" . ciniki_core_dbQuote($ciniki, $args['business_id']) . "' " . "AND ciniki_conferences_cfplogs.conference_id = '" . ciniki_core_dbQuote($ciniki, $args['conference_id']) . "' " . "";
$rc = ciniki_core_dbHashQueryArrayTree($ciniki, $strsql, 'ciniki.conferences', array(array('container' => 'cfplogs', 'fname' => 'id', 'fields' => array('id', 'name', 'url', 'email', 'sent_date'), 'utctotz' => array('sent_date' => array('format' => $date_format, 'timezone' => 'UTC')))));
if ($rc['stat'] != 'ok') {
return $rc;
}
if (isset($rc['cfplogs'])) {
$conference['cfplogs'] = $rc['cfplogs'];
} else {
$conference['cfplogs'] = array();
}
}
//
// Check if presentations should be returned
//
if (isset($args['presentations']) && $args['presentations'] == 'yes') {
$strsql = "SELECT ciniki_conferences_presentations.id, " . "ciniki_conferences_presentations.conference_id, " . "ciniki_conferences_presentations.customer_id, " . "ciniki_customers.display_name, " . "ciniki_conferences_presentations.presentation_number, " . "ciniki_conferences_presentations.presentation_type, " . "ciniki_conferences_presentations.presentation_type AS presentation_type_text, " . "ciniki_conferences_presentations.status, " . "ciniki_conferences_presentations.status AS status_text, " . "IFNULL(ciniki_conferences_attendees.status, 0) AS registration, " . "IFNULL(ciniki_conferences_attendees.status, 0) AS registration_text, " . "ciniki_conferences_presentations.submission_date, " . "ciniki_conferences_presentations.field, " . "ciniki_conferences_presentations.title, " . "ciniki_conferences_presentations.permalink, " . "IF(ciniki_conferences_presentation_reviews.vote > 0, 'yes', 'no') AS voted, " . "COUNT(ciniki_conferences_presentation_reviews.id) AS num_votes " . "FROM ciniki_conferences_presentations " . "LEFT JOIN ciniki_conferences_attendees ON (" . "ciniki_conferences_presentations.customer_id = ciniki_conferences_attendees.customer_id " . "AND ciniki_conferences_presentations.conference_id = ciniki_conferences_attendees.conference_id " . "AND ciniki_conferences_attendees.business_id = '" . ciniki_core_dbQuote($ciniki, $args['business_id']) . "' " . ") " . "LEFT JOIN ciniki_customers ON (" . "ciniki_conferences_presentations.customer_id = ciniki_customers.id " . "AND ciniki_customers.business_id = '" . ciniki_core_dbQuote($ciniki, $args['business_id']) . "' " . ") " . "LEFT JOIN ciniki_conferences_presentation_reviews ON (" . "ciniki_conferences_presentations.id = ciniki_conferences_presentation_reviews.presentation_id " . "AND ciniki_conferences_presentation_reviews.business_id = '" . ciniki_core_dbQuote($ciniki, $args['business_id']) . "' " . ") " . "WHERE ciniki_conferences_presentations.business_id = '" . ciniki_core_dbQuote($ciniki, $args['business_id']) . "' " . "";
if (isset($args['presentation_status']) && $args['presentation_status'] > 0) {
$strsql .= "AND ciniki_conferences_presentations.status = '" . ciniki_core_dbQuote($ciniki, $args['presentation_status']) . "' ";
}
if (isset($args['presentation_type']) && $args['presentation_type'] > 0) {
$strsql .= "AND ciniki_conferences_presentations.presentation_type = '" . ciniki_core_dbQuote($ciniki, $args['presentation_type']) . "' ";
}
$strsql .= "GROUP BY ciniki_conferences_presentations.id, voted ";
if (isset($args['registration_status']) && $args['registration_status'] != '') {
$strsql .= "HAVING registration = '" . ciniki_core_dbQuote($ciniki, $args['registration_status']) . "' ";
}
$strsql .= "ORDER BY submission_date ";
$rc = ciniki_core_dbHashQueryArrayTree($ciniki, $strsql, 'ciniki.conferences', array(array('container' => 'presentations', 'fname' => 'id', 'fields' => array('id', 'conference_id', 'customer_id', 'presentation_type', 'presentation_number', 'status', 'status_text', 'registration', 'registration_text', 'submission_date', 'field', 'title', 'display_name', 'permalink'), 'utctotz' => array('submission_date' => array('format' => 'M j', 'timezone' => $intl_timezone)), 'maps' => array('status_text' => $maps['presentation']['status'], 'registration_text' => $maps['attendee']['status'], 'presentation_type_text' => $maps['presentation']['presentation_type'])), array('container' => 'voted', 'fname' => 'voted', 'fields' => array('voted', 'num_votes'))));
if ($rc['stat'] != 'ok') {
return $rc;
}
$customer_ids = array();
if (isset($rc['presentations'])) {
$conference['presentations'] = $rc['presentations'];
foreach ($conference['presentations'] as $pid => $presentation) {
$customer_ids[] = $presentation['customer_id'];
$conference['presentations'][$pid]['display_title'] = sprintf("#%03d: ", $presentation['presentation_number']) . $presentation['title'];
$conference['presentations'][$pid]['votes_received'] = 0;
$conference['presentations'][$pid]['total_reviews'] = 0;
if (isset($presentation['voted'])) {
foreach ($presentation['voted'] as $vote) {
$conference['presentations'][$pid]['total_reviews'] += $vote['num_votes'];
if ($vote['voted'] == 'yes') {
$conference['presentations'][$pid]['votes_received'] += $vote['num_votes'];
}
}
unset($conference['presentations'][$pid]['voted']);
}
}
} else {
$conference['presentations'] = array();
}
//
// Get the email list
//
if (isset($customer_ids) && count($customer_ids) > 0) {
ciniki_core_loadMethod($ciniki, 'ciniki', 'core', 'private', 'dbQuoteIDs');
$strsql = "SELECT ciniki_customers.display_name, " . "ciniki_customer_emails.email " . "FROM ciniki_customers " . "LEFT JOIN ciniki_customer_emails ON (" . "ciniki_customers.id = ciniki_customer_emails.customer_id " . "AND ciniki_customer_emails.business_id = '" . ciniki_core_dbQuote($ciniki, $args['business_id']) . "' " . ") " . "WHERE ciniki_customers.id IN (" . ciniki_core_dbQuoteIDs($ciniki, $customer_ids) . ") " . "AND ciniki_customers.business_id = '" . ciniki_core_dbQuote($ciniki, $args['business_id']) . "' " . "";
$rc = ciniki_core_dbHashQueryArrayTree($ciniki, $strsql, 'ciniki.conferences', array(array('container' => 'emails', 'fname' => 'email', 'fields' => array('display_name', 'email'))));
if ($rc['stat'] != 'ok') {
return $rc;
}
if (isset($rc['emails'])) {
foreach ($rc['emails'] as $email) {
$email_list .= ($email_list != '' ? ",\n" : '') . '"' . $email['display_name'] . '" <' . $email['email'] . '>';
}
}
}
}
//
// Get the reviewers for the conference
//
if (isset($args['reviewers']) && $args['reviewers'] == 'yes') {
$strsql = "SELECT ciniki_conferences_presentation_reviews.id, " . "ciniki_conferences_presentation_reviews.customer_id, " . "ciniki_customers.display_name, " . "IF(ciniki_conferences_presentation_reviews.vote > 0, 'yes', 'no') AS voted, " . "COUNT(ciniki_conferences_presentation_reviews.id) AS num_votes " . "FROM ciniki_conferences_presentation_reviews " . "LEFT JOIN ciniki_customers ON (" . "ciniki_conferences_presentation_reviews.customer_id = ciniki_customers.id " . "AND ciniki_customers.business_id = '" . ciniki_core_dbQuote($ciniki, $args['business_id']) . "' " . ") " . "WHERE ciniki_conferences_presentation_reviews.business_id = '" . ciniki_core_dbQuote($ciniki, $args['business_id']) . "' " . "AND ciniki_conferences_presentation_reviews.conference_id = '" . ciniki_core_dbQuote($ciniki, $args['conference_id']) . "' " . "GROUP BY ciniki_conferences_presentation_reviews.customer_id, voted " . "";
$rc = ciniki_core_dbHashQueryArrayTree($ciniki, $strsql, 'ciniki.conferences', array(array('container' => 'reviewers', 'fname' => 'customer_id', 'fields' => array('id', 'customer_id', 'display_name')), array('container' => 'voted', 'fname' => 'voted', 'fields' => array('voted', 'num_votes'))));
if ($rc['stat'] != 'ok') {
return $rc;
}
if (isset($rc['reviewers'])) {
$conference['reviewers'] = $rc['reviewers'];
foreach ($conference['reviewers'] as $rid => $review) {
$conference['reviewers'][$rid]['votes_received'] = 0;
$conference['reviewers'][$rid]['total_reviews'] = 0;
if (isset($review['voted'])) {
foreach ($review['voted'] as $vote) {
$conference['reviewers'][$rid]['total_reviews'] += $vote['num_votes'];
if ($vote['voted'] == 'yes') {
$conference['reviewers'][$rid]['votes_received'] += $vote['num_votes'];
}
}
unset($conference['reviewers'][$rid]['voted']);
}
}
} else {
$conference['reviewers'] = array();
}
}
//
// Get the attendees for the conference
//
if (isset($args['attendees']) && $args['attendees'] == 'yes') {
$strsql = "SELECT ciniki_conferences_attendees.id, " . "ciniki_conferences_attendees.customer_id, " . "ciniki_customers.display_name, " . "ciniki_customers.sort_name, " . "ciniki_customers.company, " . "ciniki_conferences_attendees.status, " . "ciniki_conferences_attendees.status AS status_text, " . "IFNULL(ciniki_customer_emails.email, '') AS emails, " . "IF(IFNULL(ciniki_conferences_presentations.id, 0) > 0, 'Yes', 'No') AS presenter " . "FROM ciniki_conferences_attendees " . "LEFT JOIN ciniki_conferences_presentations ON (" . "ciniki_conferences_attendees.customer_id = ciniki_conferences_presentations.customer_id " . "AND ciniki_conferences_attendees.conference_id = ciniki_conferences_presentations.conference_id " . "AND ciniki_conferences_presentations.business_id = '" . ciniki_core_dbQuote($ciniki, $args['business_id']) . "' " . ") " . "LEFT JOIN ciniki_customers ON (" . "ciniki_conferences_attendees.customer_id = ciniki_customers.id " . "AND ciniki_customers.business_id = '" . ciniki_core_dbQuote($ciniki, $args['business_id']) . "' " . ") " . "LEFT JOIN ciniki_customer_emails ON (" . "ciniki_customers.id = ciniki_customer_emails.customer_id " . "AND ciniki_customer_emails.business_id = '" . ciniki_core_dbQuote($ciniki, $args['business_id']) . "' " . ") " . "WHERE ciniki_conferences_attendees.business_id = '" . ciniki_core_dbQuote($ciniki, $args['business_id']) . "' " . "AND ciniki_conferences_attendees.conference_id = '" . ciniki_core_dbQuote($ciniki, $args['conference_id']) . "' " . "";
if (isset($args['attendee_status']) && $args['attendee_status'] != '') {
$strsql .= "AND ciniki_conferences_attendees.status = '" . ciniki_core_dbQuote($ciniki, $args['attendee_status']) . "' ";
}
$strsql .= "GROUP BY ciniki_customers.display_name, ciniki_customers.id ";
$strsql .= "ORDER BY ciniki_customers.sort_name ";
$rc = ciniki_core_dbHashQueryArrayTree($ciniki, $strsql, 'ciniki.conferences', array(array('container' => 'attendees', 'fname' => 'id', 'fields' => array('id', 'customer_id', 'display_name', 'sort_name', 'company', 'status', 'status_text', 'emails', 'presenter'), 'lists' => array('emails' => ','), 'maps' => array('status_text' => $maps['attendee']['status']))));
if ($rc['stat'] != 'ok') {
return $rc;
}
if (isset($rc['attendees'])) {
$conference['attendees'] = $rc['attendees'];
foreach ($conference['attendees'] as $attendee) {
$email_list .= ($email_list != '' ? ", \n" : '') . '"' . $attendee['display_name'] . '" <' . $attendee['emails'] . '>';
}
} else {
$conference['attendees'] = array();
$email_list = '';
}
}
//
// Get the presentations ordered by sessions, and then unassigned presentations
//
if (isset($args['sessionpresentations']) && $args['sessionpresentations'] == 'yes') {
$strsql = "SELECT ciniki_conferences_sessions.id, " . "CONCAT_WS('-', ciniki_conferences_sessions.id, ciniki_conferences_presentations.id) AS rowid, " . "ciniki_conferences_sessions.conference_id, " . "ciniki_conferences_sessions.room_id, " . "ciniki_conferences_rooms.name AS room, " . "ciniki_conferences_rooms.sequence, " . "ciniki_conferences_sessions.name, " . "ciniki_conferences_sessions.session_start AS start_time, " . "ciniki_conferences_sessions.session_start AS start_date, " . "ciniki_conferences_sessions.session_end AS end_time, " . "IFNULL(ciniki_conferences_presentations.id, 0) AS presentation_id, " . "IFNULL(ciniki_conferences_presentations.customer_id, 0) AS customer_id, " . "IFNULL(ciniki_conferences_presentations.presentation_number, '') AS presentation_number, " . "IFNULL(ciniki_conferences_presentations.title, '') AS presentation_title, " . "IFNULL(ciniki_customers.display_name, '') AS display_name, " . "IFNULL(ciniki_conferences_presentations.status, 0) AS status, " . "IFNULL(ciniki_conferences_presentations.status, '') AS status_text, " . "IFNULL(ciniki_conferences_attendees.status, 0) AS registration, " . "IFNULL(ciniki_conferences_attendees.status, 0) AS registration_text " . "FROM ciniki_conferences_sessions " . "INNER JOIN ciniki_conferences_rooms ON (" . "ciniki_conferences_sessions.room_id = ciniki_conferences_rooms.id " . "AND ciniki_conferences_rooms.business_id = '" . ciniki_core_dbQuote($ciniki, $args['business_id']) . "' " . ") " . "LEFT JOIN ciniki_conferences_presentations ON (" . "ciniki_conferences_sessions.id = ciniki_conferences_presentations.session_id " . "AND ciniki_conferences_presentations.business_id = '" . ciniki_core_dbQuote($ciniki, $args['business_id']) . "' " . ") " . "LEFT JOIN ciniki_conferences_attendees ON (" . "ciniki_conferences_presentations.customer_id = ciniki_conferences_attendees.customer_id " . "AND ciniki_conferences_presentations.conference_id = ciniki_conferences_attendees.conference_id " . "AND ciniki_conferences_attendees.business_id = '" . ciniki_core_dbQuote($ciniki, $args['business_id']) . "' " . ") " . "LEFT JOIN ciniki_customers ON (" . "ciniki_conferences_presentations.customer_id = ciniki_customers.id " . "AND ciniki_customers.business_id = '" . ciniki_core_dbQuote($ciniki, $args['business_id']) . "' " . ") " . "WHERE ciniki_conferences_sessions.business_id = '" . ciniki_core_dbQuote($ciniki, $args['business_id']) . "' " . "AND ciniki_conferences_sessions.conference_id = '" . ciniki_core_dbQuote($ciniki, $args['conference_id']) . "' " . "ORDER BY ciniki_conferences_sessions.session_start, " . "ciniki_conferences_rooms.sequence, " . "ciniki_conferences_rooms.name, " . "ciniki_conferences_presentations.title " . "";
ciniki_core_loadMethod($ciniki, 'ciniki', 'core', 'private', 'dbHashQueryArrayTree');
$rc = ciniki_core_dbHashQueryArrayTree($ciniki, $strsql, 'ciniki.conferences', array(array('container' => 'sessions', 'fname' => 'rowid', 'fields' => array('id', 'conference_id', 'room_id', 'room', 'sequence', 'name', 'start_time', 'start_date', 'end_time', 'presentation_id', 'customer_id', 'presentation_number', 'presentation_title', 'display_name', 'status', 'status_text', 'registration', 'registration_text'), 'utctotz' => array('start_time' => array('format' => $time_format, 'timezone' => $intl_timezone), 'start_date' => array('format' => $date_format, 'timezone' => $intl_timezone), 'end_time' => array('format' => $time_format, 'timezone' => $intl_timezone)), 'maps' => array('status_text' => $maps['presentation']['status'], 'registration_text' => $maps['attendee']['status']))));
if ($rc['stat'] != 'ok') {
return $rc;
}
if (isset($rc['sessions'])) {
$conference['assignedpresentations'] = $rc['sessions'];
foreach ($conference['assignedpresentations'] as $pid => $presentation) {
if ($presentation['presentation_id'] > 0) {
$conference['assignedpresentations'][$pid]['display_title'] = sprintf("#%03d: ", $presentation['presentation_number']) . $presentation['presentation_title'];
} else {
$conference['assignedpresentations'][$pid]['display_title'] = '';
}
}
} else {
$conference['assignedpresentations'] = array();
}
//
// Get the list of unassigned presentations
//
$strsql = "SELECT ciniki_conferences_presentations.id, " . "ciniki_conferences_presentations.conference_id, " . "ciniki_conferences_presentations.customer_id, " . "ciniki_customers.display_name, " . "ciniki_conferences_presentations.presentation_number, " . "ciniki_conferences_presentations.presentation_type, " . "ciniki_conferences_presentations.presentation_type AS presentation_type_text, " . "ciniki_conferences_presentations.status, " . "ciniki_conferences_presentations.status AS status_text, " . "IFNULL(ciniki_conferences_attendees.status, 0) AS registration, " . "IFNULL(ciniki_conferences_attendees.status, 0) AS registration_text, " . "ciniki_conferences_presentations.submission_date, " . "ciniki_conferences_presentations.field, " . "ciniki_conferences_presentations.title, " . "ciniki_conferences_presentations.permalink " . "FROM ciniki_conferences_presentations " . "LEFT JOIN ciniki_conferences_attendees ON (" . "ciniki_conferences_presentations.customer_id = ciniki_conferences_attendees.customer_id " . "AND ciniki_conferences_presentations.conference_id = ciniki_conferences_attendees.conference_id " . "AND ciniki_conferences_attendees.business_id = '" . ciniki_core_dbQuote($ciniki, $args['business_id']) . "' " . ") " . "LEFT JOIN ciniki_customers ON (" . "ciniki_conferences_presentations.customer_id = ciniki_customers.id " . "AND ciniki_customers.business_id = '" . ciniki_core_dbQuote($ciniki, $args['business_id']) . "' " . ") " . "WHERE ciniki_conferences_presentations.business_id = '" . ciniki_core_dbQuote($ciniki, $args['business_id']) . "' " . "AND ciniki_conferences_presentations.session_id = 0 " . "AND ciniki_conferences_presentations.status = 30 " . "HAVING registration = 30 " . "ORDER BY submission_date " . "";
$rc = ciniki_core_dbHashQueryArrayTree($ciniki, $strsql, 'ciniki.conferences', array(array('container' => 'presentations', 'fname' => 'id', 'fields' => array('id', 'conference_id', 'customer_id', 'presentation_type', 'presentation_number', 'status', 'status_text', 'registration', 'registration_text', 'submission_date', 'field', 'title', 'display_name', 'permalink'), 'maps' => array('status_text' => $maps['presentation']['status'], 'registration_text' => $maps['attendee']['status'], 'presentation_type_text' => $maps['presentation']['presentation_type']))));
if ($rc['stat'] != 'ok') {
return $rc;
}
if (isset($rc['presentations'])) {
$conference['unassignedpresentations'] = $rc['presentations'];
foreach ($conference['unassignedpresentations'] as $pid => $presentation) {
$conference['unassignedpresentations'][$pid]['display_title'] = sprintf("#%03d: ", $presentation['presentation_number']) . $presentation['title'];
}
} else {
$conference['unassignedpresentations'] = array();
}
}
//
// Get the list of sessions
//
if (isset($args['sessions']) && $args['sessions'] == 'yes') {
$strsql = "SELECT ciniki_conferences_sessions.id, " . "ciniki_conferences_sessions.conference_id, " . "ciniki_conferences_sessions.room_id, " . "ciniki_conferences_sessions.name, " . "ciniki_conferences_rooms.name AS room, " . "ciniki_conferences_rooms.sequence, " . "ciniki_conferences_sessions.session_start AS start_time, " . "ciniki_conferences_sessions.session_start AS start_date, " . "ciniki_conferences_sessions.session_end AS end_time " . "FROM ciniki_conferences_sessions " . "INNER JOIN ciniki_conferences_rooms ON (" . "ciniki_conferences_sessions.room_id = ciniki_conferences_rooms.id " . "AND ciniki_conferences_rooms.business_id = '" . ciniki_core_dbQuote($ciniki, $args['business_id']) . "' " . "AND ciniki_conferences_rooms.conference_id = '" . ciniki_core_dbQuote($ciniki, $args['conference_id']) . "' " . ") " . "WHERE ciniki_conferences_sessions.business_id = '" . ciniki_core_dbQuote($ciniki, $args['business_id']) . "' " . "AND ciniki_conferences_sessions.conference_id = '" . ciniki_core_dbQuote($ciniki, $args['conference_id']) . "' " . "ORDER BY ciniki_conferences_sessions.session_start, ciniki_conferences_rooms.sequence, ciniki_conferences_rooms.name " . "";
ciniki_core_loadMethod($ciniki, 'ciniki', 'core', 'private', 'dbHashQueryArrayTree');
$rc = ciniki_core_dbHashQueryArrayTree($ciniki, $strsql, 'ciniki.conferences', array(array('container' => 'sessions', 'fname' => 'id', 'fields' => array('id', 'conference_id', 'name', 'room_id', 'room', 'sequence', 'start_time', 'start_date', 'end_time'), 'utctotz' => array('start_time' => array('format' => $time_format, 'timezone' => $intl_timezone), 'start_date' => array('format' => $date_format, 'timezone' => $intl_timezone), 'end_time' => array('format' => $time_format, 'timezone' => $intl_timezone)))));
if ($rc['stat'] != 'ok') {
return $rc;
}
if (isset($rc['sessions'])) {
$conference['sessions'] = $rc['sessions'];
} else {
$conference['sessions'] = array();
}
}
//
// Get the list of rooms
//
if (isset($args['rooms']) && $args['rooms'] == 'yes') {
$strsql = "SELECT ciniki_conferences_rooms.id, " . "ciniki_conferences_rooms.conference_id, " . "ciniki_conferences_rooms.name, " . "ciniki_conferences_rooms.sequence " . "FROM ciniki_conferences_rooms " . "WHERE ciniki_conferences_rooms.business_id = '" . ciniki_core_dbQuote($ciniki, $args['business_id']) . "' " . "AND ciniki_conferences_rooms.conference_id = '" . ciniki_core_dbQuote($ciniki, $args['conference_id']) . "' " . "ORDER BY sequence, name " . "";
ciniki_core_loadMethod($ciniki, 'ciniki', 'core', 'private', 'dbHashQueryArrayTree');
$rc = ciniki_core_dbHashQueryArrayTree($ciniki, $strsql, 'ciniki.conferences', array(array('container' => 'rooms', 'fname' => 'id', 'fields' => array('id', 'conference_id', 'name', 'sequence'))));
if ($rc['stat'] != 'ok') {
return $rc;
}
if (isset($rc['rooms'])) {
$conference['rooms'] = $rc['rooms'];
} else {
$conference['rooms'] = array();
}
}
//
// Get the stats for the conference
//
if (isset($args['stats']) && $args['stats'] == 'yes') {
$strsql = "SELECT status, COUNT(status) AS num_presentations " . "FROM ciniki_conferences_presentations " . "WHERE ciniki_conferences_presentations.business_id = '" . ciniki_core_dbQuote($ciniki, $args['business_id']) . "' " . "AND ciniki_conferences_presentations.conference_id = '" . ciniki_core_dbQuote($ciniki, $args['conference_id']) . "' " . "GROUP BY status " . "";
$rc = ciniki_core_dbHashQueryIDTree($ciniki, $strsql, 'ciniki.conferences', array(array('container' => 'stats', 'fname' => 'status', 'fields' => array('status', 'num_presentations'))));
if ($rc['stat'] != 'ok') {
return $rc;
}
$conference['presentation_stats'] = array();
foreach ($maps['presentation']['status'] as $status => $status_text) {
$conference['presentation_stats'][$status] = array('name' => $status_text, 'count' => isset($rc['stats'][$status]['num_presentations']) ? $rc['stats'][$status]['num_presentations'] : 0);
}
//
// Get the attendee stats
//
$strsql = "SELECT status, COUNT(status) AS num_attendees " . "FROM ciniki_conferences_attendees " . "WHERE ciniki_conferences_attendees.business_id = '" . ciniki_core_dbQuote($ciniki, $args['business_id']) . "' " . "AND ciniki_conferences_attendees.conference_id = '" . ciniki_core_dbQuote($ciniki, $args['conference_id']) . "' " . "GROUP BY status " . "";
$rc = ciniki_core_dbHashQueryIDTree($ciniki, $strsql, 'ciniki.conferences', array(array('container' => 'stats', 'fname' => 'status', 'fields' => array('status', 'num_attendees'))));
if ($rc['stat'] != 'ok') {
return $rc;
}
$conference['attendee_stats'] = array();
foreach ($maps['attendee']['status'] as $status => $status_text) {
$conference['attendee_stats'][$status] = array('name' => $status_text, 'count' => isset($rc['stats'][$status]['num_attendees']) ? $rc['stats'][$status]['num_attendees'] : 0);
}
//
// Get the registration stats
//
$strsql = "SELECT IFNULL(ciniki_conferences_attendees.status, 0) AS status, COUNT(*) AS num_attendees " . "FROM ciniki_conferences_presentations " . "LEFT JOIN ciniki_conferences_attendees ON (" . "ciniki_conferences_presentations.customer_id = ciniki_conferences_attendees.customer_id " . "AND ciniki_conferences_attendees.business_id = '" . ciniki_core_dbQuote($ciniki, $args['business_id']) . "' " . "AND ciniki_conferences_attendees.conference_id = '" . ciniki_core_dbQuote($ciniki, $args['conference_id']) . "' " . ") " . "WHERE ciniki_conferences_presentations.business_id = '" . ciniki_core_dbQuote($ciniki, $args['business_id']) . "' " . "AND ciniki_conferences_presentations.conference_id = '" . ciniki_core_dbQuote($ciniki, $args['conference_id']) . "' " . "";
if (isset($args['presentation_status']) && $args['presentation_status'] > 0) {
$strsql .= "AND ciniki_conferences_presentations.status = '" . ciniki_core_dbQuote($ciniki, $args['presentation_status']) . "' ";
}
if (isset($args['presentation_type']) && $args['presentation_type'] > 0) {
$strsql .= "AND ciniki_conferences_presentations.presentation_type = '" . ciniki_core_dbQuote($ciniki, $args['presentation_type']) . "' ";
}
$strsql .= "GROUP BY status " . "";
$rc = ciniki_core_dbHashQueryIDTree($ciniki, $strsql, 'ciniki.conferences', array(array('container' => 'stats', 'fname' => 'status', 'fields' => array('status', 'num_attendees'))));
if ($rc['stat'] != 'ok') {
return $rc;
}
foreach ($maps['attendee']['status'] as $type => $type_text) {
$conference['registration_statuses'][$type] = array('name' => $type_text, 'count' => isset($rc['stats'][$type]['num_attendees']) ? $rc['stats'][$type]['num_attendees'] : 0);
}
//
// Get the types for the conference
//
$strsql = "SELECT presentation_type, COUNT(*) AS num_presentations " . "FROM ciniki_conferences_presentations " . "WHERE ciniki_conferences_presentations.business_id = '" . ciniki_core_dbQuote($ciniki, $args['business_id']) . "' " . "AND ciniki_conferences_presentations.conference_id = '" . ciniki_core_dbQuote($ciniki, $args['conference_id']) . "' " . "GROUP BY presentation_type " . "";
$rc = ciniki_core_dbHashQueryIDTree($ciniki, $strsql, 'ciniki.conferences', array(array('container' => 'stats', 'fname' => 'presentation_type', 'fields' => array('presentation_type', 'num_presentations'))));
if ($rc['stat'] != 'ok') {
return $rc;
}
$conference['presentation_types'] = array();
foreach ($maps['presentation']['presentation_type'] as $type => $type_text) {
$conference['presentation_types'][$type] = array('name' => $type_text, 'count' => isset($rc['stats'][$type]['num_presentations']) ? $rc['stats'][$type]['num_presentations'] : 0);
}
}
}
return array('stat' => 'ok', 'conference' => $conference, 'emails' => $email_list);
}
function ciniki_artistprofiles_artistGet($ciniki)
{
//
// Find all the required and optional arguments
//
ciniki_core_loadMethod($ciniki, 'ciniki', 'core', 'private', 'prepareArgs');
$rc = ciniki_core_prepareArgs($ciniki, 'no', array('business_id' => array('required' => 'yes', 'blank' => 'no', 'name' => 'Business'), 'artist_id' => array('required' => 'yes', 'blank' => 'no', 'name' => 'Artist'), 'images' => array('required' => 'no', 'blank' => 'yes', 'name' => 'Images'), 'links' => array('required' => 'no', 'blank' => 'yes', 'name' => 'Links'), 'videos' => array('required' => 'no', 'blank' => 'yes', 'name' => 'Videos'), 'audio' => array('required' => 'no', 'blank' => 'yes', 'name' => 'Audio'), 'categories' => array('required' => 'no', 'blank' => 'yes', 'name' => 'Categories')));
if ($rc['stat'] != 'ok') {
return $rc;
}
$args = $rc['args'];
//
// Make sure this module is activated, and
// check permission to run this function for this business
//
ciniki_core_loadMethod($ciniki, 'ciniki', 'artistprofiles', 'private', 'checkAccess');
$rc = ciniki_artistprofiles_checkAccess($ciniki, $args['business_id'], 'ciniki.artistprofiles.artistGet');
if ($rc['stat'] != 'ok') {
return $rc;
}
//
// Load business settings
//
ciniki_core_loadMethod($ciniki, 'ciniki', 'businesses', 'private', 'intlSettings');
$rc = ciniki_businesses_intlSettings($ciniki, $args['business_id']);
if ($rc['stat'] != 'ok') {
return $rc;
}
$intl_timezone = $rc['settings']['intl-default-timezone'];
$intl_currency_fmt = numfmt_create($rc['settings']['intl-default-locale'], NumberFormatter::CURRENCY);
$intl_currency = $rc['settings']['intl-default-currency'];
ciniki_core_loadMethod($ciniki, 'ciniki', 'users', 'private', 'datetimeFormat');
$datetime_format = ciniki_users_datetimeFormat($ciniki, 'php');
//
// Load artist profile maps
//
ciniki_core_loadMethod($ciniki, 'ciniki', 'artistprofiles', 'private', 'maps');
$rc = ciniki_artistprofiles_maps($ciniki);
if ($rc['stat'] != 'ok') {
return $rc;
}
$maps = $rc['maps'];
//
// Return default for new Artist
//
if ($args['artist_id'] == 0) {
$artist = array('id' => 0, 'name' => '', 'subname' => '', 'sort_name' => '', 'permalink' => '', 'status' => '', 'flags' => '', 'primary_image_id' => '0', 'primary_image_caption' => '', 'synopsis' => '', 'description' => '', 'setup_image_id' => '0', 'setup_image_caption' => '', 'setup_description' => '');
} else {
$strsql = "SELECT ciniki_artistprofiles.id, " . "ciniki_artistprofiles.name, " . "ciniki_artistprofiles.subname, " . "ciniki_artistprofiles.sort_name, " . "ciniki_artistprofiles.permalink, " . "ciniki_artistprofiles.status, " . "ciniki_artistprofiles.status AS status_text, " . "ciniki_artistprofiles.flags, " . "ciniki_artistprofiles.flags AS flags_text, " . "ciniki_artistprofiles.primary_image_id, " . "ciniki_artistprofiles.primary_image_caption, " . "ciniki_artistprofiles.synopsis, " . "ciniki_artistprofiles.description, " . "ciniki_artistprofiles.setup_image_id, " . "ciniki_artistprofiles.setup_image_caption, " . "ciniki_artistprofiles.setup_description " . "FROM ciniki_artistprofiles " . "WHERE ciniki_artistprofiles.business_id = '" . ciniki_core_dbQuote($ciniki, $args['business_id']) . "' " . "AND ciniki_artistprofiles.id = '" . ciniki_core_dbQuote($ciniki, $args['artist_id']) . "' " . "";
ciniki_core_loadMethod($ciniki, 'ciniki', 'core', 'private', 'dbHashQueryTree');
$rc = ciniki_core_dbHashQueryTree($ciniki, $strsql, 'ciniki.artistprofiles', array(array('container' => 'artists', 'fname' => 'id', 'name' => 'artist', 'fields' => array('id', 'name', 'subname', 'sort_name', 'permalink', 'status', 'status_text', 'flags', 'flags_text', 'primary_image_id', 'primary_image_caption', 'synopsis', 'description', 'setup_image_id', 'setup_image_caption', 'setup_description'), 'maps' => array('status_text' => $maps['artist']['status']), 'flags' => array('flags_text' => $maps['artist']['flags']))));
if ($rc['stat'] != 'ok') {
return array('stat' => 'fail', 'err' => array('pkg' => 'ciniki', 'code' => '2883', 'msg' => 'Artist not found', 'err' => $rc['err']));
}
if (!isset($rc['artists'][0]['artist'])) {
return array('stat' => 'fail', 'err' => array('pkg' => 'ciniki', 'code' => '2884', 'msg' => 'Unable to find Artist'));
}
$artist = $rc['artists'][0]['artist'];
ciniki_core_loadMethod($ciniki, 'ciniki', 'core', 'private', 'dbHashQueryArrayTree');
//
// Get the categories
//
$strsql = "SELECT tag_type, tag_name AS lists " . "FROM ciniki_artistprofiles_tags " . "WHERE artist_id = '" . ciniki_core_dbQuote($ciniki, $args['artist_id']) . "' " . "AND business_id = '" . ciniki_core_dbQuote($ciniki, $args['business_id']) . "' " . "ORDER BY tag_type, tag_name " . "";
$rc = ciniki_core_dbHashQueryTree($ciniki, $strsql, 'ciniki.artistprofiles', array(array('container' => 'tags', 'fname' => 'tag_type', 'name' => 'tags', 'fields' => array('tag_type', 'lists'), 'dlists' => array('lists' => '::'))));
if ($rc['stat'] != 'ok') {
return $rc;
}
if (isset($rc['tags'])) {
foreach ($rc['tags'] as $tags) {
if ($tags['tags']['tag_type'] == 10) {
$artist['categories'] = $tags['tags']['lists'];
}
}
}
//
// Get the images
//
if (isset($args['images']) && $args['images'] == 'yes') {
$strsql = "SELECT id, " . "name, " . "flags, " . "image_id, " . "description " . "FROM ciniki_artistprofiles_images " . "WHERE artist_id = '" . ciniki_core_dbQuote($ciniki, $args['artist_id']) . "' " . "AND business_id = '" . ciniki_core_dbQuote($ciniki, $args['business_id']) . "' " . "";
$rc = ciniki_core_dbHashQueryArrayTree($ciniki, $strsql, 'ciniki.artistprofiles', array(array('container' => 'images', 'fname' => 'id', 'fields' => array('id', 'name', 'flags', 'image_id', 'description'))));
if ($rc['stat'] != 'ok') {
return $rc;
}
if (isset($rc['images'])) {
ciniki_core_loadMethod($ciniki, 'ciniki', 'images', 'private', 'loadCacheThumbnail');
$artist['images'] = $rc['images'];
foreach ($artist['images'] as $img_id => $img) {
if (isset($img['image_id']) && $img['image_id'] > 0) {
$rc = ciniki_images_loadCacheThumbnail($ciniki, $args['business_id'], $img['image_id'], 75);
if ($rc['stat'] != 'ok') {
return $rc;
}
$artist['images'][$img_id]['image_data'] = 'data:image/jpg;base64,' . base64_encode($rc['image']);
}
}
} else {
$artist['images'] = array();
}
}
//
// Get the links for the profile
//
if (isset($args['links']) && $args['links'] == 'yes') {
$strsql = "SELECT id, name, link_type, url, description " . "FROM ciniki_artistprofiles_links " . "WHERE business_id = '" . ciniki_core_dbQuote($ciniki, $args['business_id']) . "' " . "AND ciniki_artistprofiles_links.artist_id = '" . ciniki_core_dbQuote($ciniki, $args['artist_id']) . "' " . "AND link_type >= 1000 AND link_type < 2000 " . "";
$rc = ciniki_core_dbHashQueryArrayTree($ciniki, $strsql, 'ciniki.blog', array(array('container' => 'links', 'fname' => 'id', 'fields' => array('id', 'name', 'url', 'description'))));
if ($rc['stat'] != 'ok') {
return $rc;
}
if (isset($rc['links'])) {
$artist['links'] = $rc['links'];
} else {
$artist['links'] = array();
}
}
//
// Get the video links for the profile
//
if (isset($args['videos']) && $args['videos'] == 'yes') {
$strsql = "SELECT id, name, link_type, url, description " . "FROM ciniki_artistprofiles_links " . "WHERE business_id = '" . ciniki_core_dbQuote($ciniki, $args['business_id']) . "' " . "AND artist_id = '" . ciniki_core_dbQuote($ciniki, $args['artist_id']) . "' " . "AND link_type >= 2000 AND link_type < 3000 " . "";
$rc = ciniki_core_dbHashQueryArrayTree($ciniki, $strsql, 'ciniki.blog', array(array('container' => 'links', 'fname' => 'id', 'fields' => array('id', 'name', 'url', 'description'))));
if ($rc['stat'] != 'ok') {
return $rc;
}
if (isset($rc['links'])) {
$artist['videos'] = $rc['links'];
} else {
$artist['videos'] = array();
}
}
}
$rsp = array('stat' => 'ok', 'artist' => $artist);
//
// Check if all tags should be returned
//
$rsp['categories'] = array();
if (($ciniki['business']['modules']['ciniki.artistprofiles']['flags'] & 0x100) > 0 && isset($args['categories']) && $args['categories'] == 'yes') {
//
// Get the available tags
//
ciniki_core_loadMethod($ciniki, 'ciniki', 'core', 'private', 'tagsList');
$rc = ciniki_core_tagsList($ciniki, 'ciniki.artistprofiles', $args['business_id'], 'ciniki_artistprofiles_tags', 10);
if ($rc['stat'] != 'ok') {
return array('stat' => 'fail', 'err' => array('pkg' => 'ciniki', 'code' => '2668', 'msg' => 'Unable to get list of categories', 'err' => $rc['err']));
}
if (isset($rc['tags'])) {
$rsp['categories'] = $rc['tags'];
}
}
return $rsp;
}
function ciniki_conferences_reviewerGet($ciniki)
{
//
// Find all the required and optional arguments
//
ciniki_core_loadMethod($ciniki, 'ciniki', 'core', 'private', 'prepareArgs');
$rc = ciniki_core_prepareArgs($ciniki, 'no', array('business_id' => array('required' => 'yes', 'blank' => 'no', 'name' => 'Business'), 'conference_id' => array('required' => 'yes', 'blank' => 'no', 'name' => 'Conference'), 'reviewer_id' => array('required' => 'yes', 'blank' => 'no', 'name' => 'Reviewer')));
if ($rc['stat'] != 'ok') {
return $rc;
}
$args = $rc['args'];
//
// Make sure this module is activated, and
// check permission to run this function for this business
//
ciniki_core_loadMethod($ciniki, 'ciniki', 'conferences', 'private', 'checkAccess');
$rc = ciniki_conferences_checkAccess($ciniki, $args['business_id'], 'ciniki.conferences.reviewerGet');
if ($rc['stat'] != 'ok') {
return $rc;
}
//
// Load business settings
//
ciniki_core_loadMethod($ciniki, 'ciniki', 'businesses', 'private', 'intlSettings');
$rc = ciniki_businesses_intlSettings($ciniki, $args['business_id']);
if ($rc['stat'] != 'ok') {
return $rc;
}
$intl_timezone = $rc['settings']['intl-default-timezone'];
ciniki_core_loadMethod($ciniki, 'ciniki', 'users', 'private', 'datetimeFormat');
$datetime_format = ciniki_users_datetimeFormat($ciniki, 'php');
//
// Load conference maps
//
ciniki_core_loadMethod($ciniki, 'ciniki', 'conferences', 'private', 'maps');
$rc = ciniki_conferences_maps($ciniki);
if ($rc['stat'] != 'ok') {
return $rc;
}
$maps = $rc['maps'];
$reviewer = array();
//
// Get the customer details
//
ciniki_core_loadMethod($ciniki, 'ciniki', 'customers', 'hooks', 'customerDetails');
$rc = ciniki_customers_hooks_customerDetails($ciniki, $args['business_id'], array('customer_id' => $args['reviewer_id'], 'phones' => 'yes', 'emails' => 'yes', 'addresses' => 'no', 'subscriptions' => 'no'));
if ($rc['stat'] != 'ok') {
return $rc;
}
$reviewer['customer_details'] = $rc['details'];
//
// Lookup reviews
//
$strsql = "SELECT ciniki_conferences_presentation_reviews.id, " . "ciniki_conferences_presentation_reviews.conference_id, " . "ciniki_conferences_presentation_reviews.customer_id, " . "ciniki_conferences_presentations.title, " . "ciniki_conferences_presentations.presentation_number, " . "ciniki_customers.display_name, " . "ciniki_conferences_presentation_reviews.vote, " . "ciniki_conferences_presentation_reviews.vote AS vote_text " . "FROM ciniki_conferences_presentation_reviews " . "INNER JOIN ciniki_conferences_presentations ON (" . "ciniki_conferences_presentation_reviews.presentation_id = ciniki_conferences_presentations.id " . "AND ciniki_conferences_presentations.conference_id = '" . ciniki_core_dbQuote($ciniki, $args['conference_id']) . "' " . "AND ciniki_conferences_presentations.business_id = '" . ciniki_core_dbQuote($ciniki, $args['business_id']) . "' " . ") " . "LEFT JOIN ciniki_customers ON (" . "ciniki_conferences_presentations.customer_id = ciniki_customers.id " . "AND ciniki_customers.business_id = '" . ciniki_core_dbQuote($ciniki, $args['business_id']) . "' " . ") " . "WHERE ciniki_conferences_presentation_reviews.customer_id = '" . ciniki_core_dbQuote($ciniki, $args['reviewer_id']) . "' " . "AND ciniki_conferences_presentation_reviews.business_id = '" . ciniki_core_dbQuote($ciniki, $args['business_id']) . "' " . "";
ciniki_core_loadMethod($ciniki, 'ciniki', 'core', 'private', 'dbHashQueryArrayTree');
$rc = ciniki_core_dbHashQueryArrayTree($ciniki, $strsql, 'ciniki.conferences', array(array('container' => 'reviews', 'fname' => 'id', 'fields' => array('id', 'conference_id', 'customer_id', 'presentation_number', 'title', 'display_name', 'vote', 'vote_text'), 'maps' => array('vote_text' => $maps['presentationreview']['vote']))));
if ($rc['stat'] != 'ok') {
return array('stat' => 'fail', 'err' => array('pkg' => 'ciniki', 'code' => '3251', 'msg' => 'Unable to get list of reviews', 'err' => $rc['err']));
}
if (isset($rc['reviews'])) {
$reviewer['reviews'] = $rc['reviews'];
foreach ($reviewer['reviews'] as $rid => $presentation) {
$reviewer['reviews'][$rid]['display_title'] = sprintf("#%03d: ", $presentation['presentation_number']) . $presentation['title'];
}
} else {
$reviewer['reviews'] = array();
}
//
// Check for any messages sent
//
if (isset($ciniki['business']['modules']['ciniki.mail'])) {
ciniki_core_loadMethod($ciniki, 'ciniki', 'mail', 'hooks', 'objectMessages');
$rc = ciniki_mail_hooks_objectMessages($ciniki, $args['business_id'], array('object' => 'ciniki.conferences.conferencereviewer', 'object_id' => $args['conference_id'] . '-' . $args['reviewer_id']));
if ($rc['stat'] != 'ok') {
return $rc;
}
if (isset($rc['messages'])) {
$reviewer['messages'] = $rc['messages'];
}
}
return array('stat' => 'ok', 'reviewer' => $reviewer);
}
function ciniki_conferences_templates_reviewerPresentationsPDF(&$ciniki, $business_id, $reviewer_id, $conference_id)
{
//
// Load business settings
//
ciniki_core_loadMethod($ciniki, 'ciniki', 'businesses', 'private', 'intlSettings');
$rc = ciniki_businesses_intlSettings($ciniki, $business_id);
if ($rc['stat'] != 'ok') {
return $rc;
}
$intl_timezone = $rc['settings']['intl-default-timezone'];
$intl_currency_fmt = numfmt_create($rc['settings']['intl-default-locale'], NumberFormatter::CURRENCY);
$intl_currency = $rc['settings']['intl-default-currency'];
ciniki_core_loadMethod($ciniki, 'ciniki', 'users', 'private', 'datetimeFormat');
$datetime_format = ciniki_users_datetimeFormat($ciniki, 'php');
//
// Load conference maps
//
ciniki_core_loadMethod($ciniki, 'ciniki', 'conferences', 'private', 'maps');
$rc = ciniki_conferences_maps($ciniki);
if ($rc['stat'] != 'ok') {
return $rc;
}
$maps = $rc['maps'];
//
// Load the presentations to be reviewed
//
$strsql = "SELECT ciniki_conferences_presentations.id, " . "ciniki_conferences_presentations.conference_id, " . "ciniki_conferences_presentations.customer_id, " . "ciniki_conferences_presentations.presentation_number, " . "ciniki_conferences_presentations.presentation_type, " . "ciniki_conferences_presentations.presentation_type AS presentation_type_text, " . "ciniki_conferences_presentations.status, " . "ciniki_conferences_presentations.status AS status_text, " . "ciniki_conferences_presentations.field, " . "ciniki_conferences_presentations.title, " . "ciniki_conferences_presentations.permalink, " . "ciniki_conferences_presentations.description " . "FROM ciniki_conferences_presentation_reviews, ciniki_conferences_presentations " . "WHERE ciniki_conferences_presentation_reviews.business_id = '" . ciniki_core_dbQuote($ciniki, $business_id) . "' " . "AND ciniki_conferences_presentation_reviews.customer_id = '" . ciniki_core_dbQuote($ciniki, $reviewer_id) . "' " . "AND ciniki_conferences_presentation_reviews.presentation_id = ciniki_conferences_presentations.id " . "AND ciniki_conferences_presentations.business_id = '" . ciniki_core_dbQuote($ciniki, $business_id) . "' " . "AND ciniki_conferences_presentations.conference_id = '" . ciniki_core_dbQuote($ciniki, $conference_id) . "' " . "";
ciniki_core_loadMethod($ciniki, 'ciniki', 'core', 'private', 'dbHashQueryArrayTree');
$rc = ciniki_core_dbHashQueryArrayTree($ciniki, $strsql, 'ciniki.conferences', array(array('container' => 'presentations', 'fname' => 'id', 'fields' => array('id', 'conference_id', 'customer_id', 'presentation_number', 'presentation_type', 'presentation_type_text', 'status', 'status_text', 'field', 'title', 'permalink', 'description'), 'maps' => array('presentation_type_text' => $maps['presentation']['presentation_type'], 'status_text' => $maps['presentation']['status']))));
if ($rc['stat'] != 'ok') {
return array('stat' => 'fail', 'err' => array('pkg' => 'ciniki', 'code' => '3189', 'msg' => 'Presentations not found', 'err' => $rc['err']));
}
if (!isset($rc['presentations'])) {
return array('stat' => 'fail', 'err' => array('pkg' => 'ciniki', 'code' => '3247', 'msg' => 'Unable to find presentations'));
}
$presentations = $rc['presentations'];
foreach ($presentations as $pid => $presentation) {
$presentations[$pid]['display_title'] = sprintf("#%03d: ", $presentation['presentation_number']) . $presentation['title'];
}
//
// Load the business details
//
ciniki_core_loadMethod($ciniki, 'ciniki', 'businesses', 'private', 'businessDetails');
$rc = ciniki_businesses_businessDetails($ciniki, $business_id);
if ($rc['stat'] != 'ok') {
return $rc;
}
if (isset($rc['details']) && is_array($rc['details'])) {
$business_details = $rc['details'];
} else {
$business_details = array();
}
//
// Load the conference details
//
$strsql = "SELECT id, name " . "FROM ciniki_conferences " . "WHERE id = '" . ciniki_core_dbQuote($ciniki, $conference_id) . "' " . "AND business_id = '" . ciniki_core_dbQuote($ciniki, $business_id) . "' " . "";
$rc = ciniki_core_dbHashQuery($ciniki, $strsql, 'ciniki.conferences', 'conference');
if ($rc['stat'] != 'ok') {
return $rc;
}
if (!isset($rc['conference'])) {
return array('stat' => 'fail', 'err' => array('pkg' => 'ciniki', 'code' => '3248', 'msg' => 'Unable to find conference'));
}
$conference = $rc['conference'];
//
// Load TCPDF library
//
$rsp = array('stat' => 'ok');
require_once $ciniki['config']['ciniki.core']['lib_dir'] . '/tcpdf/tcpdf.php';
class MYPDF extends TCPDF
{
public $left_margin = 18;
public $right_margin = 18;
public $top_margin = 18;
//Page header
public $header_image = null;
public $header_name = '';
public $header_addr = array();
public $header_details = array();
public $header_height = 25;
// The height of the image and address
public $business_details = array();
public $courses_settings = array();
public $conference_name = '';
public function Header()
{
$this->SetFont('helvetica', 'I', 14);
$this->Cell(0, 10, $this->conference_name, 0, false, 'C', 0, '', 0, false, 'T', 'M');
}
// Page footer
public function Footer()
{
$this->SetY(-15);
$this->SetFont('helvetica', 'I', 8);
$this->Cell(0, 10, 'Page ' . $this->pageNo() . '/' . $this->getAliasNbPages(), 0, false, 'C', 0, '', 0, false, 'T', 'M');
}
}
//
// Start a new document
//
$pdf = new MYPDF('P', PDF_UNIT, 'LETTER', true, 'UTF-8', false);
$pdf->business_details = $business_details;
$pdf->conference_name = $conference['name'];
//
// Setup the PDF basics
//
$pdf->SetCreator('Ciniki');
$pdf->SetAuthor($business_details['name']);
$pdf->SetTitle($conference['name']);
$pdf->SetSubject('');
$pdf->SetKeywords('');
// set margins
$pdf->SetMargins($pdf->left_margin, $pdf->top_margin + $pdf->header_height, $pdf->right_margin);
$pdf->SetHeaderMargin($pdf->top_margin);
// set font
$pdf->SetFont('times', 'BI', 10);
$pdf->SetCellPadding(2);
$pdf->SetFillColor(255);
$pdf->SetTextColor(0);
$pdf->SetDrawColor(51);
$pdf->SetLineWidth(0.15);
foreach ($presentations as $presentation) {
// add a page
$pdf->AddPage();
$pdf->SetFont('', 'B', 12);
$pdf->MultiCell(180, 1, $presentation['display_title'], 0, 'L');
$pdf->SetFont('', '', 11);
$pdf->MultiCell(180, 1, $presentation['field'], 0, 'L');
$pdf->SetFont('', '', 10);
$pdf->Ln();
$pdf->MultiCell(180, 8, $presentation['description'], 0, 'L');
}
return array('stat' => 'ok', 'presentations' => $presentations, 'conference' => $conference, 'pdf' => $pdf);
}
function ciniki_conferences_presentationReviewGet($ciniki)
{
//
// Find all the required and optional arguments
//
ciniki_core_loadMethod($ciniki, 'ciniki', 'core', 'private', 'prepareArgs');
$rc = ciniki_core_prepareArgs($ciniki, 'no', array('business_id' => array('required' => 'yes', 'blank' => 'no', 'name' => 'Business'), 'review_id' => array('required' => 'yes', 'blank' => 'no', 'name' => 'Presentation Review')));
if ($rc['stat'] != 'ok') {
return $rc;
}
$args = $rc['args'];
//
// Make sure this module is activated, and
// check permission to run this function for this business
//
ciniki_core_loadMethod($ciniki, 'ciniki', 'conferences', 'private', 'checkAccess');
$rc = ciniki_conferences_checkAccess($ciniki, $args['business_id'], 'ciniki.conferences.presentationReviewGet');
if ($rc['stat'] != 'ok') {
return $rc;
}
//
// Load business settings
//
ciniki_core_loadMethod($ciniki, 'ciniki', 'businesses', 'private', 'intlSettings');
$rc = ciniki_businesses_intlSettings($ciniki, $args['business_id']);
if ($rc['stat'] != 'ok') {
return $rc;
}
$intl_timezone = $rc['settings']['intl-default-timezone'];
$intl_currency_fmt = numfmt_create($rc['settings']['intl-default-locale'], NumberFormatter::CURRENCY);
$intl_currency = $rc['settings']['intl-default-currency'];
ciniki_core_loadMethod($ciniki, 'ciniki', 'users', 'private', 'datetimeFormat');
$datetime_format = ciniki_users_datetimeFormat($ciniki, 'php');
//
// Load conference maps
//
ciniki_core_loadMethod($ciniki, 'ciniki', 'conferences', 'private', 'maps');
$rc = ciniki_conferences_maps($ciniki);
if ($rc['stat'] != 'ok') {
return $rc;
}
$maps = $rc['maps'];
//
// Return default for new Presentation Review
//
if ($args['review_id'] == 0) {
$presentationreview = array('id' => 0, 'conference_id' => '', 'presentation_id' => '', 'customer_id' => '', 'vote' => '0', 'notes' => '');
} else {
$strsql = "SELECT ciniki_conferences_presentation_reviews.id, " . "ciniki_conferences_presentation_reviews.conference_id, " . "ciniki_conferences_presentation_reviews.presentation_id, " . "ciniki_conferences_presentation_reviews.customer_id, " . "ciniki_conferences_presentation_reviews.vote, " . "ciniki_conferences_presentation_reviews.notes " . "FROM ciniki_conferences_presentation_reviews " . "WHERE ciniki_conferences_presentation_reviews.business_id = '" . ciniki_core_dbQuote($ciniki, $args['business_id']) . "' " . "AND ciniki_conferences_presentation_reviews.id = '" . ciniki_core_dbQuote($ciniki, $args['review_id']) . "' " . "";
ciniki_core_loadMethod($ciniki, 'ciniki', 'core', 'private', 'dbHashQuery');
$rc = ciniki_core_dbHashQuery($ciniki, $strsql, 'ciniki.conferences', 'presentationreview');
if ($rc['stat'] != 'ok') {
return array('stat' => 'fail', 'err' => array('pkg' => 'ciniki', 'code' => '3247', 'msg' => 'Presentation Review not found', 'err' => $rc['err']));
}
if (!isset($rc['presentationreview'])) {
return array('stat' => 'fail', 'err' => array('pkg' => 'ciniki', 'code' => '3248', 'msg' => 'Unable to find Presentation Review'));
}
$presentationreview = $rc['presentationreview'];
//
// Get the customer details
//
ciniki_core_loadMethod($ciniki, 'ciniki', 'customers', 'hooks', 'customerDetails');
$rc = ciniki_customers_hooks_customerDetails($ciniki, $args['business_id'], array('customer_id' => $presentationreview['customer_id'], 'phones' => 'yes', 'emails' => 'yes', 'addresses' => 'no', 'subscriptions' => 'no'));
if ($rc['stat'] != 'ok') {
return $rc;
}
$presentationreview['customer_details'] = $rc['details'];
//
// Get the presentation details
//
$strsql = "SELECT ciniki_conferences_presentations.id, " . "ciniki_conferences_presentations.conference_id, " . "ciniki_conferences_presentations.customer_id, " . "ciniki_customers.display_name, " . "ciniki_conferences_presentations.presentation_number, " . "ciniki_conferences_presentations.presentation_type, " . "ciniki_conferences_presentations.presentation_type AS presentation_type_text, " . "ciniki_conferences_presentations.status, " . "ciniki_conferences_presentations.status AS status_text, " . "ciniki_conferences_presentations.title, " . "ciniki_conferences_presentations.field, " . "ciniki_conferences_presentations.submission_date " . "FROM ciniki_conferences_presentations " . "LEFT JOIN ciniki_customers ON (" . "ciniki_conferences_presentations.customer_id = ciniki_customers.id " . "AND ciniki_customers.business_id = '" . ciniki_core_dbQuote($ciniki, $args['business_id']) . "' " . ") " . "WHERE ciniki_conferences_presentations.business_id = '" . ciniki_core_dbQuote($ciniki, $args['business_id']) . "' " . "AND ciniki_conferences_presentations.id = '" . ciniki_core_dbQuote($ciniki, $presentationreview['presentation_id']) . "' " . "";
ciniki_core_loadMethod($ciniki, 'ciniki', 'core', 'private', 'dbHashQueryArrayTree');
$rc = ciniki_core_dbHashQueryArrayTree($ciniki, $strsql, 'ciniki.conferences', array(array('container' => 'presentations', 'fname' => 'id', 'fields' => array('id', 'conference_id', 'display_name', 'customer_id', 'presentation_number', 'presentation_type', 'presentation_type_text', 'status', 'status_text', 'submission_date', 'field', 'title'), 'maps' => array('presentation_type_text' => $maps['presentation']['presentation_type'], 'status_text' => $maps['presentation']['status']), 'utctotz' => array('submission_date' => array('format' => $datetime_format, 'timezone' => $intl_timezone)))));
if ($rc['stat'] != 'ok') {
return array('stat' => 'fail', 'err' => array('pkg' => 'ciniki', 'code' => '3249', 'msg' => 'Presentation not found', 'err' => $rc['err']));
}
if (!isset($rc['presentations'][0])) {
return array('stat' => 'fail', 'err' => array('pkg' => 'ciniki', 'code' => '3250', 'msg' => 'Unable to find Presentation'));
}
$presentation = $rc['presentations'][0];
$presentationreview['presentation_details'] = array(array('label' => 'Title', 'value' => sprintf("#%03d: ", $presentation['presentation_number']) . $presentation['title']), array('label' => 'Field', 'value' => $presentation['field']), array('label' => 'Presenter', 'value' => $presentation['display_name']));
}
return array('stat' => 'ok', 'review' => $presentationreview);
}
function ciniki_conferences_presentationGet($ciniki)
{
//
// Find all the required and optional arguments
//
ciniki_core_loadMethod($ciniki, 'ciniki', 'core', 'private', 'prepareArgs');
$rc = ciniki_core_prepareArgs($ciniki, 'no', array('business_id' => array('required' => 'yes', 'blank' => 'no', 'name' => 'Business'), 'presentation_id' => array('required' => 'yes', 'blank' => 'no', 'name' => 'Presentation')));
if ($rc['stat'] != 'ok') {
return $rc;
}
$args = $rc['args'];
//
// Make sure this module is activated, and
// check permission to run this function for this business
//
ciniki_core_loadMethod($ciniki, 'ciniki', 'conferences', 'private', 'checkAccess');
$rc = ciniki_conferences_checkAccess($ciniki, $args['business_id'], 'ciniki.conferences.presentationGet');
if ($rc['stat'] != 'ok') {
return $rc;
}
//
// Load business settings
//
ciniki_core_loadMethod($ciniki, 'ciniki', 'businesses', 'private', 'intlSettings');
$rc = ciniki_businesses_intlSettings($ciniki, $args['business_id']);
if ($rc['stat'] != 'ok') {
return $rc;
}
$intl_timezone = $rc['settings']['intl-default-timezone'];
$intl_currency_fmt = numfmt_create($rc['settings']['intl-default-locale'], NumberFormatter::CURRENCY);
$intl_currency = $rc['settings']['intl-default-currency'];
ciniki_core_loadMethod($ciniki, 'ciniki', 'users', 'private', 'datetimeFormat');
ciniki_core_loadMethod($ciniki, 'ciniki', 'users', 'private', 'dateFormat');
ciniki_core_loadMethod($ciniki, 'ciniki', 'users', 'private', 'timeFormat');
$datetime_format = ciniki_users_datetimeFormat($ciniki, 'php');
$date_format = ciniki_users_dateFormat($ciniki, 'php');
$time_format = ciniki_users_timeFormat($ciniki, 'php');
//
// Load conference maps
//
ciniki_core_loadMethod($ciniki, 'ciniki', 'conferences', 'private', 'maps');
$rc = ciniki_conferences_maps($ciniki);
if ($rc['stat'] != 'ok') {
return $rc;
}
$maps = $rc['maps'];
//
// Return default for new Presentation
//
if ($args['presentation_id'] == 0) {
$presentation = array('id' => 0, 'conference_id' => '', 'customer_id' => '', 'session_id' => 0, 'presentation_number' => '', 'presentation_type' => '', 'status' => '10', 'registration' => '0', 'submission_date' => '', 'field' => '', 'title' => '', 'permalink' => '', 'description' => '');
$sessions = array();
} else {
$strsql = "SELECT ciniki_conferences_presentations.id, " . "ciniki_conferences_presentations.conference_id, " . "ciniki_conferences_presentations.customer_id, " . "ciniki_conferences_presentations.session_id, " . "ciniki_customers.display_name, " . "ciniki_conferences_presentations.presentation_number, " . "ciniki_conferences_presentations.presentation_type, " . "ciniki_conferences_presentations.presentation_type AS presentation_type_text, " . "ciniki_conferences_presentations.status, " . "ciniki_conferences_presentations.status AS status_text, " . "IFNULL(ciniki_conferences_attendees.status, 0) AS registration, " . "IFNULL(ciniki_conferences_attendees.status, 0) AS registration_text, " . "ciniki_conferences_presentations.submission_date, " . "ciniki_conferences_presentations.field, " . "ciniki_conferences_presentations.title, " . "ciniki_conferences_presentations.permalink, " . "ciniki_conferences_presentations.description " . "FROM ciniki_conferences_presentations " . "LEFT JOIN ciniki_conferences_attendees ON (" . "ciniki_conferences_presentations.customer_id = ciniki_conferences_attendees.customer_id " . "AND ciniki_conferences_attendees.business_id = '" . ciniki_core_dbQuote($ciniki, $args['business_id']) . "' " . ") " . "LEFT JOIN ciniki_customers ON (" . "ciniki_conferences_presentations.customer_id = ciniki_customers.id " . "AND ciniki_customers.business_id = '" . ciniki_core_dbQuote($ciniki, $args['business_id']) . "' " . ") " . "WHERE ciniki_conferences_presentations.business_id = '" . ciniki_core_dbQuote($ciniki, $args['business_id']) . "' " . "AND ciniki_conferences_presentations.id = '" . ciniki_core_dbQuote($ciniki, $args['presentation_id']) . "' " . "";
ciniki_core_loadMethod($ciniki, 'ciniki', 'core', 'private', 'dbHashQueryArrayTree');
$rc = ciniki_core_dbHashQueryArrayTree($ciniki, $strsql, 'ciniki.conferences', array(array('container' => 'presentations', 'fname' => 'id', 'fields' => array('id', 'conference_id', 'customer_id', 'session_id', 'display_name', 'presentation_number', 'presentation_type', 'presentation_type_text', 'status', 'status_text', 'registration', 'registration_text', 'submission_date', 'field', 'title', 'permalink', 'description'), 'maps' => array('presentation_type_text' => $maps['presentation']['presentation_type'], 'status_text' => $maps['presentation']['status'], 'registration_text' => $maps['attendee']['status']), 'utctotz' => array('submission_date' => array('format' => $datetime_format, 'timezone' => $intl_timezone)))));
if ($rc['stat'] != 'ok') {
return array('stat' => 'fail', 'err' => array('pkg' => 'ciniki', 'code' => '3081', 'msg' => 'Presentation not found', 'err' => $rc['err']));
}
if (!isset($rc['presentations'][0])) {
return array('stat' => 'fail', 'err' => array('pkg' => 'ciniki', 'code' => '3082', 'msg' => 'Unable to find Presentation'));
}
$presentation = $rc['presentations'][0];
$presentation['display_title'] = sprintf("#%03d: ", $presentation['presentation_number']) . $presentation['title'];
//
// Get the customer details
//
ciniki_core_loadMethod($ciniki, 'ciniki', 'customers', 'hooks', 'customerDetails');
$rc = ciniki_customers_hooks_customerDetails($ciniki, $args['business_id'], array('customer_id' => $presentation['customer_id'], 'phones' => 'yes', 'emails' => 'yes', 'addresses' => 'no', 'subscriptions' => 'no', 'full_bio' => 'yes'));
if ($rc['stat'] != 'ok') {
return $rc;
}
$presentation['customer_details'] = $rc['details'];
if (isset($rc['customer']['full_bio'])) {
$presentation['full_bio'] = $rc['customer']['full_bio'];
} else {
$presentation['full_bio'] = '';
}
//
// Lookup reviews
//
$strsql = "SELECT ciniki_conferences_presentation_reviews.id, " . "ciniki_conferences_presentation_reviews.conference_id, " . "ciniki_conferences_presentation_reviews.customer_id, " . "ciniki_customers.display_name, " . "ciniki_conferences_presentation_reviews.vote, " . "ciniki_conferences_presentation_reviews.vote AS vote_text " . "FROM ciniki_conferences_presentation_reviews " . "LEFT JOIN ciniki_customers ON (" . "ciniki_conferences_presentation_reviews.customer_id = ciniki_customers.id " . "AND ciniki_customers.business_id = '" . ciniki_core_dbQuote($ciniki, $args['business_id']) . "' " . ") " . "WHERE ciniki_conferences_presentation_reviews.presentation_id = '" . ciniki_core_dbQuote($ciniki, $args['presentation_id']) . "' " . "AND ciniki_conferences_presentation_reviews.business_id = '" . ciniki_core_dbQuote($ciniki, $args['business_id']) . "' " . "";
$rc = ciniki_core_dbHashQueryArrayTree($ciniki, $strsql, 'ciniki.conferences', array(array('container' => 'reviews', 'fname' => 'id', 'fields' => array('id', 'conference_id', 'customer_id', 'display_name', 'vote', 'vote_text'), 'maps' => array('vote_text' => $maps['presentationreview']['vote']))));
if ($rc['stat'] != 'ok') {
return array('stat' => 'fail', 'err' => array('pkg' => 'ciniki', 'code' => '3188', 'msg' => 'Unable to get list of reviews', 'err' => $rc['err']));
}
if (isset($rc['reviews'])) {
$presentation['reviews'] = $rc['reviews'];
} else {
$presentation['reviews'] = array();
}
//
// Get the list of sessions
//
$strsql = "SELECT ciniki_conferences_sessions.id, " . "ciniki_conferences_sessions.conference_id, " . "ciniki_conferences_sessions.room_id, " . "ciniki_conferences_sessions.name, " . "ciniki_conferences_rooms.name AS room, " . "ciniki_conferences_rooms.sequence, " . "ciniki_conferences_sessions.session_start AS start_time, " . "ciniki_conferences_sessions.session_start AS start_date, " . "ciniki_conferences_sessions.session_end AS end_time " . "FROM ciniki_conferences_sessions " . "LEFT JOIN ciniki_conferences_rooms ON (" . "ciniki_conferences_sessions.room_id = ciniki_conferences_rooms.id " . "AND ciniki_conferences_rooms.business_id = '" . ciniki_core_dbQuote($ciniki, $args['business_id']) . "' " . ") " . "WHERE ciniki_conferences_sessions.business_id = '" . ciniki_core_dbQuote($ciniki, $args['business_id']) . "' " . "AND ciniki_conferences_sessions.conference_id = '" . ciniki_core_dbQuote($ciniki, $presentation['conference_id']) . "' " . "";
ciniki_core_loadMethod($ciniki, 'ciniki', 'core', 'private', 'dbHashQueryArrayTree');
$rc = ciniki_core_dbHashQueryArrayTree($ciniki, $strsql, 'ciniki.conferences', array(array('container' => 'sessions', 'fname' => 'id', 'fields' => array('id', 'conference_id', 'room', 'room_id', 'name', 'sequence', 'start_time', 'start_date', 'end_time'), 'utctotz' => array('start_time' => array('format' => $time_format, 'timezone' => $intl_timezone), 'start_date' => array('format' => $date_format, 'timezone' => $intl_timezone), 'end_time' => array('format' => $time_format, 'timezone' => $intl_timezone)))));
if ($rc['stat'] != 'ok') {
return $rc;
}
if (isset($rc['sessions'])) {
$sessions = $rc['sessions'];
foreach ($sessions as $sid => $session) {
$sessions[$sid]['display_name'] = $session['name'];
if ($session['room'] != '') {
$sessions[$sid]['display_name'] .= ($sessions[$sid]['display_name'] != '' ? ' - ' : '') . $session['room'];
}
$sessions[$sid]['display_name'] .= ($sessions[$sid]['display_name'] != '' ? ' - ' : '') . $session['start_time'] . ' - ' . $session['end_time'] . ', ' . $session['start_date'];
}
} else {
$sessions = array();
}
}
return array('stat' => 'ok', 'presentation' => $presentation, 'sessions' => $sessions);
}
function ciniki_artistprofiles_artistLoad($ciniki, $business_id, $artist_id, $args)
{
ciniki_core_loadMethod($ciniki, 'ciniki', 'core', 'private', 'dbHashQueryTree');
ciniki_core_loadMethod($ciniki, 'ciniki', 'core', 'private', 'dbHashQueryArrayTree');
ciniki_core_loadMethod($ciniki, 'ciniki', 'images', 'private', 'loadCacheThumbnail');
//
// Get the artist
//
$strsql = "SELECT ciniki_artistprofiles.id, " . "ciniki_artistprofiles.name, " . "ciniki_artistprofiles.subname, " . "ciniki_artistprofiles.sort_name, " . "ciniki_artistprofiles.permalink, " . "ciniki_artistprofiles.status, " . "ciniki_artistprofiles.flags, " . "ciniki_artistprofiles.primary_image_id, " . "ciniki_artistprofiles.primary_image_caption, " . "ciniki_artistprofiles.synopsis, " . "ciniki_artistprofiles.description, " . "ciniki_artistprofiles.setup_image_id, " . "ciniki_artistprofiles.setup_description " . "FROM ciniki_artistprofiles " . "WHERE ciniki_artistprofiles.business_id = '" . ciniki_core_dbQuote($ciniki, $business_id) . "' " . "";
if (is_numeric($artist_id)) {
$strsql .= "AND ciniki_artistprofiles.id = '" . ciniki_core_dbQuote($ciniki, $artist_id) . "' ";
} else {
$strsql .= "AND ciniki_artistprofiles.permalink = '" . ciniki_core_dbQuote($ciniki, $artist_id) . "' ";
}
$rc = ciniki_core_dbHashQueryTree($ciniki, $strsql, 'ciniki.artistprofiles', array(array('container' => 'artists', 'fname' => 'id', 'name' => 'artist', 'fields' => array('id', 'name', 'subname', 'sort_name', 'permalink', 'status', 'flags', 'primary_image_id', 'primary_image_caption', 'synopsis', 'description', 'setup_image_id', 'setup_description'))));
if ($rc['stat'] != 'ok') {
return $rc;
}
if (!isset($rc['artists'][0]['artist'])) {
return array('stat' => 'ok', 'err' => array('pkg' => 'ciniki', 'code' => '2859', 'msg' => 'Unable to find artist'));
}
$artist = $rc['artists'][0]['artist'];
$artist_id = $artist['id'];
// Incase this function was called with permalink
$artist['categories'] = array();
$artist['images'] = array();
$artist['setupimages'] = array();
$artist['links'] = array();
$artist['audio'] = array();
$artist['video'] = array();
//
// Get the categories
//
$strsql = "SELECT tag_type, tag_name " . "FROM ciniki_artistprofiles_tags " . "WHERE artist_id = '" . ciniki_core_dbQuote($ciniki, $artist_id) . "' " . "AND business_id = '" . ciniki_core_dbQuote($ciniki, $business_id) . "' " . "AND tag_type = 10 " . "ORDER BY tag_name " . "";
$rc = ciniki_core_dbHashQueryArrayTree($ciniki, $strsql, 'ciniki.artistprofiles', array(array('container' => 'tags', 'fname' => 'tag_type', 'fields' => array('tag_type', 'tag_name'))));
if ($rc['stat'] != 'ok') {
return $rc;
}
if (isset($rc['tags'])) {
foreach ($rc['tags'] as $tag) {
$artist['categories'][] = $tag['tag_name'];
}
}
//
// Get any images if requested
//
if (isset($args['images']) && ($args['images'] == 'yes' || $args['images'] == 'thumbs')) {
$strsql = "SELECT id, " . "(flags&0xF0) AS type, " . "permalink, name AS title, flags, image_id, description " . "FROM ciniki_artistprofiles_images " . "WHERE business_id = '" . ciniki_core_dbQuote($ciniki, $business_id) . "' " . "AND ciniki_artistprofiles_images.artist_id = '" . ciniki_core_dbQuote($ciniki, $artist_id) . "' " . "";
$rc = ciniki_core_dbHashQueryArrayTree($ciniki, $strsql, 'ciniki.artistprofiles', array(array('container' => 'types', 'fname' => 'type', 'fields' => array('type')), array('container' => 'images', 'fname' => 'id', 'fields' => array('id', 'permalink', 'title', 'flags', 'image_id', 'description'))));
if ($rc['stat'] != 'ok') {
return $rc;
}
if (isset($rc['types'])) {
foreach ($rc['types'] as $type) {
if (($type['type'] & 0xf0) == 0) {
$artist['images'] = $type['images'];
}
if (($type['type'] & 0x10) == 0x10) {
$artist['setupimages'] = $type['images'];
}
}
}
if ($args['images'] == 'thumbs') {
if (isset($artist['images'])) {
foreach ($artist['images'] as $img_id => $img) {
if (isset($img['image_id']) && $img['image_id'] > 0) {
$rc = ciniki_images_loadCacheThumbnail($ciniki, $business_id, $img['image_id'], 75);
if ($rc['stat'] != 'ok') {
return $rc;
}
$artist['images'][$img_id]['image_data'] = 'data:image/jpg;base64,' . base64_encode($rc['image']);
}
}
}
if (isset($artist['setupimages'])) {
foreach ($artist['setupimages'] as $img_id => $img) {
if (isset($img['image_id']) && $img['image_id'] > 0) {
$rc = ciniki_images_loadCacheThumbnail($ciniki, $business_id, $img['image_id'], 75);
if ($rc['stat'] != 'ok') {
return $rc;
}
$artist['setupimages'][$img_id]['image_data'] = 'data:image/jpg;base64,' . base64_encode($rc['image']);
}
}
}
}
}
//
// Get any audio if requested
//
if (isset($args['audio']) && $args['audio'] == 'yes') {
$strsql = "SELECT id, name, permalink, sequence, flags, " . "mp3_audio_id, wav_audio_id, ogg_audio_id, description " . "FROM ciniki_artistprofiles_audio " . "WHERE business_id = '" . ciniki_core_dbQuote($ciniki, $business_id) . "' " . "AND artist_id = '" . ciniki_core_dbQuote($ciniki, $artist_id) . "' " . "";
$rc = ciniki_core_dbHashQueryArrayTree($ciniki, $strsql, 'ciniki.artistprofiles', array(array('container' => 'audio', 'fname' => 'id', 'fields' => array('id', 'name', 'permalink', 'sequence', 'flags', 'mp3_audio_id', 'wav_audio_id', 'ogg_audio_id', 'description'))));
if ($rc['stat'] != 'ok') {
return $rc;
}
if (isset($rc['audio'])) {
$artist['audio'] = $rc['audio'];
}
}
//
// Get the video links for the profile
//
if (isset($args['videos']) && $args['videos'] == 'yes') {
$strsql = "SELECT id, name, link_type, url, description " . "FROM ciniki_artistprofiles_links " . "WHERE business_id = '" . ciniki_core_dbQuote($ciniki, $business_id) . "' " . "AND artist_id = '" . ciniki_core_dbQuote($ciniki, $artist_id) . "' " . "AND link_type >= 2000 AND link_type < 3000 " . "";
$rc = ciniki_core_dbHashQueryArrayTree($ciniki, $strsql, 'ciniki.blog', array(array('container' => 'links', 'fname' => 'id', 'fields' => array('id', 'name', 'link_type', 'url', 'description'))));
if ($rc['stat'] != 'ok') {
return $rc;
}
if (isset($rc['links'])) {
$artist['videos'] = $rc['links'];
} else {
$artist['videos'] = array();
}
}
//
// Get any links if requested
//
if (isset($args['links']) && $args['links'] == 'yes') {
$strsql = "SELECT id, name, link_type, url, description " . "FROM ciniki_artistprofiles_links " . "WHERE business_id = '" . ciniki_core_dbQuote($ciniki, $business_id) . "' " . "AND link_type < 2000 " . "AND artist_id = '" . ciniki_core_dbQuote($ciniki, $artist_id) . "' " . "";
$rc = ciniki_core_dbHashQueryArrayTree($ciniki, $strsql, 'ciniki.artistprofiles', array(array('container' => 'links', 'fname' => 'id', 'fields' => array('id', 'name', 'link_type', 'url', 'description'))));
if ($rc['stat'] != 'ok') {
return $rc;
}
if (isset($rc['links'])) {
$artist['links'] = $rc['links'];
}
}
return array('stat' => 'ok', 'artist' => $artist);
}
