function ciniki_conferences_hooks_checkObjectUsed($ciniki, $business_id, $args)
{
ciniki_core_loadMethod($ciniki, 'ciniki', 'core', 'private', 'dbCount');
// Set the default to not used
$used = 'no';
$count = 0;
$msg = '';
if ($args['object'] == 'ciniki.customers.customer') {
//
// Check the invoice presentation submissions
//
$strsql = "SELECT 'items', COUNT(*) " . "FROM ciniki_conferences_presentations " . "WHERE customer_id = '" . ciniki_core_dbQuote($ciniki, $args['object_id']) . "' " . "AND business_id = '" . ciniki_core_dbQuote($ciniki, $business_id) . "' " . "";
$rc = ciniki_core_dbCount($ciniki, $strsql, 'ciniki.sapos', 'num');
if ($rc['stat'] != 'ok') {
return $rc;
}
if (isset($rc['num']['items']) && $rc['num']['items'] > 0) {
$used = 'yes';
$count = $rc['num']['items'];
$msg .= ($msg != '' ? ' ' : '') . "There " . ($count == 1 ? 'is' : 'are') . " {$count} conference presentation" . ($count == 1 ? '' : 's') . " for this customer.";
}
//
// Check the reviewer presentations
//
$strsql = "SELECT 'items', COUNT(*) " . "FROM ciniki_conferences_presentation_reviewers " . "WHERE customer_id = '" . ciniki_core_dbQuote($ciniki, $args['object_id']) . "' " . "AND business_id = '" . ciniki_core_dbQuote($ciniki, $business_id) . "' " . "";
$rc = ciniki_core_dbCount($ciniki, $strsql, 'ciniki.sapos', 'num');
if ($rc['stat'] != 'ok') {
return $rc;
}
if (isset($rc['num']['items']) && $rc['num']['items'] > 0) {
$used = 'yes';
$count = $rc['num']['items'];
$msg .= ($msg != '' ? ' ' : '') . "There " . ($count == 1 ? 'is' : 'are') . " {$count} conference review" . ($count == 1 ? '' : 's') . " for this customer.";
}
}
return array('stat' => 'ok', 'used' => $used, 'count' => $count, 'msg' => $msg);
}
function ciniki_merchandise_hooks_checkObjectUsed($ciniki, $business_id, $args)
{
ciniki_core_loadMethod($ciniki, 'ciniki', 'core', 'private', 'dbCount');
// Set the default to not used
$used = 'no';
$count = 0;
$msg = '';
if ($args['object'] == 'ciniki.artcatalog.item') {
//
// Check for artcatalog items that have merchandise linked to them
//
$strsql = "SELECT 'items', COUNT(*) " . "FROM ciniki_merchandise_objrefs " . "WHERE business_id = '" . ciniki_core_dbQuote($ciniki, $business_id) . "' " . "AND object = '" . ciniki_core_dbQuote($ciniki, $args['object']) . "' " . "AND object_id = '" . ciniki_core_dbQuote($ciniki, $args['object_id']) . "' " . "";
$rc = ciniki_core_dbCount($ciniki, $strsql, 'ciniki.merchandise', 'num');
if ($rc['stat'] != 'ok') {
return $rc;
}
if (isset($rc['num']['items']) && $rc['num']['items'] > 0) {
$used = 'yes';
$count = $rc['num']['items'];
$msg = "There " . ($count == 1 ? 'is' : 'are') . " {$count} merchandise product" . ($count == 1 ? '' : 's') . " still linked to this item.";
}
}
return array('stat' => 'ok', 'used' => $used, 'count' => $count, 'msg' => $msg);
}
