Adding custom file for db functions

1 files changed, 3 insertions, 66 deletions

diff --git a/muamba.business.inc b/muamba.business.inc
index d48efcb..db89305 100644
--- a/muamba.business.inc
+++ b/muamba.business.inc
@@ -5,6 +5,9 @@
  * Business logic for Muamba.
  */
 
+// Database functions.
+include_once('muamba.db.inc');
+
 /**
  * Request an item.
  *
@@ -56,72 +59,6 @@ function muamba_request($nid) {
 }
 
 /**
- * Check if user already requested an item.
- *
- * @param $nid
- *   Item nid.
- *
- * @param $uid
- *   Requester user nid.
- *
- * @return
- *   TRUE if user already requested an item, FALSE otherwise.
- */
-function muamba_check_user_request($nid, $uid) {
-  $nid = (int) $nid;
-  $uid = (int) $uid;
-
-  $query = db_select('muamba', 'm');
-
-  $query
-    ->condition('m.nid', $nid, '=')
-    ->condition('m.uid', $uid, '=')
-    ->condition('m.status', MUAMBA_REQUESTED, '=');
-
-  $result = $query->countQuery()->execute()->fetchField();
-
-  if ($result > 0) {
-    return TRUE;
-  }
-
-  return FALSE;
-}
-
-/**
- * Get the requests sent or received.
- *
- * @param $uid
- *   Requester user uid.
- */
-function muamba_get_transactions($uid, $type = 'sent', $status = MUAMBA_REQUESTED) {
-  $uid   = (int) $uid;
-  $query = db_select('muamba', 'm');
-
-  if ($type == 'sent') {
-    $query
-      ->condition('m.uid', $uid, '=')
-      ->condition('m.status', $status, '=')
-      ->fields('m', array('mid', 'uid', 'owner', 'thread_id'));
-  }
-  else {
-    $query
-      ->condition('m.owner', $uid, '=')
-      ->condition('m.status', $status, '=')
-      ->fields('m', array('mid', 'uid', 'owner', 'thread_id'));
-  }
-
-  $rows    = array();
-  $results = $query->execute()->fetchAll();
-
-  // Sanitize the data before handing it off to the theme layer.
-  foreach ($results as $entry) {
-    $rows[] = array_map('check_plain', (array) $entry);
-  }
-
-  return $rows;
-}
-
-/**
  * Transaction management page.
  */
 function muamba() {