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); }