| 1 |
<?php // $Id: qb_data.module,v 1.1 2009/02/04 00:08:12 vauxia Exp $ |
<?php // $Id: qb_data.module,v 1.2 2009/02/08 03:53:49 vauxia Exp $ |
| 2 |
|
|
| 3 |
/** |
/** |
| 4 |
* Implementation of hook_menu(). |
* Implementation of hook_menu(). |
| 6 |
function qb_data_menu() { |
function qb_data_menu() { |
| 7 |
return array( |
return array( |
| 8 |
'admin/settings/qb/data' => array( |
'admin/settings/qb/data' => array( |
| 9 |
'title' => t('Data integration'), |
'title' => t('Data'), |
| 10 |
'page callback' => 'qb_data_admin_overview', |
'page callback' => 'qb_data_admin_overview', |
| 11 |
'access arguments' => array('administer quickbooks'), |
'access arguments' => array('administer quickbooks'), |
| 12 |
'type' => MENU_LOCAL_TASK, |
'type' => MENU_LOCAL_TASK, |
| 94 |
$value->status = 0; |
$value->status = 0; |
| 95 |
qb_data_value($save); |
qb_data_value($save); |
| 96 |
} |
} |
| 97 |
|
|
| 98 |
|
/** |
| 99 |
|
* List all values we have created and/or imported from Quickbooks. |
| 100 |
|
*/ |
| 101 |
|
function qb_data_values($qdid, $active_only = TRUE, $pending_only = FALSE) { |
| 102 |
|
$values = array(); |
| 103 |
|
$where = array(); |
| 104 |
|
|
| 105 |
|
$sql = "SELECT * FROM {qb_data_value} WHERE qdid = %d"; |
| 106 |
|
if ($active_only) $sql .= " AND status = 1"; |
| 107 |
|
if ($pending_only) $sql .= " AND pending = 1"; |
| 108 |
|
$sql .= " ORDER by qb_name"; |
| 109 |
|
|
| 110 |
|
$res = db_query($sql, $qdid); |
| 111 |
|
while ($row = db_fetch_object($res)) $values[$row->qdvid] = $row; |
| 112 |
|
return $values; |
| 113 |
|
} |
| 114 |
|
|
| 115 |
|
/** |
| 116 |
|
* List all values from Quickbooks in a handy name/value array format. |
| 117 |
|
*/ |
| 118 |
|
function qb_data_values_array($qdid) { |
| 119 |
|
static $values = array(); |
| 120 |
|
if (!isset($values[$qdid])) { |
| 121 |
|
$values[$qdid] = array(); |
| 122 |
|
foreach (qb_data_values($qdid) as $qdvid => $info) { |
| 123 |
|
$values[$qdid][$qdvid] = $info->qb_full_name; |
| 124 |
|
} |
| 125 |
|
} |
| 126 |
|
return $values[$qdid]; |
| 127 |
|
} |
| 128 |
|
|
| 129 |
|
/** |
| 130 |
|
* Return the value of an individual record. |
| 131 |
|
*/ |
| 132 |
|
function qb_data_value($qdid, $name) { |
| 133 |
|
|
| 134 |
|
// Accept our unique id. |
| 135 |
|
if (is_numeric($name)) return(db_fetch_object(db_query("SELECT * |
| 136 |
|
FROM {qb_data_value} |
| 137 |
|
WHERE qdid = %d AND qdid = %d", $qdid, $name))); |
| 138 |
|
|
| 139 |
|
// Use the FullName value instead, as it's unique for each list type. |
| 140 |
|
return(db_fetch_object(db_query("SELECT * |
| 141 |
|
FROM {qb_data_value} |
| 142 |
|
WHERE qdid = %d AND qb_name = %d", $qdid, $name))); |
| 143 |
|
} |
| 144 |
|
|
Parent Directory
| 
Revision Log
| 
Revision Graph
| 
Patch