* You should have received a copy of the GNU General Public License along * with this program; if not, write to the Free Software Foundation, Inc., * 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA. * http://www.gnu.org/copyleft/gpl.html * */ require_once('includes/common.php'); require_once('includes/SI_Check.php'); require_once('includes/SI_User.php'); require_once('includes/SI_UserTransaction.php'); require_once('includes/SI_TaskActivity.php'); checkLogin(); $activity = new SI_TaskActivity(); $check = new SI_Check(); $user = new SI_User(); if($user->get($_REQUEST['user_id']) === FALSE){ $error_msg .= "Could not retrieve information for User ID ".$_REQUEST['user_id']."!\n"; debug_message($user->getLastError()); } $activities = $user->getActivities($user->id); if($activities === FALSE){ $error_msg .= "Could not retrieve Activity List for User ID ".$user->id."!\n"; debug_message($user->getLastError()); } $commissions = $user->getCommissions($user->id); if($commissions === FALSE){
$invoice_result = $si_db->query($invoice_insert_sql, TRUE); assert_die($invoice_result, "Could not add invoice!\n" . $si_db->getLastError()); // Add activities $invoice->get($number); // debug("Adding line items to invoice ".$invoice->id); assert_die($invoice->addTaskActivities($data['ids']), "Error adding task activities to invoice: " . $invoice->getLastError()); // Add the company transaction $ct = new SI_CompanyTransaction(); $ct->amount = $invoice->getTotal(); $ct->company_id = $invoice->company_id; $ct->description = "Invoice #" . $invoice->id; $ct->timestamp = $invoice->timestamp; assert_die($ct->add(), "Error adding company transaction: " . $ct->getLastError()); } // Create checks $check = new SI_Check(); foreach ($checks as $number => $data) { if ($number == 0) { continue; } // debug("Going to create check $number for amount ".$data['amount']." with ids ".join(', ', $data['ids'])); $check->user_id = $data['user_id']; $check->number = $number; $check->timestamp = $data['timestamp']; $check->amount = $data['amount']; $check->type = 'CHECK'; $check->name = $users[$data['user_id']]['first_name'] . ' ' . $users[$data['user_id']]['last_name']; $check->address1 = $users[$data['user_id']]['address1']; $check->address2 = $users[$data['user_id']]['address2']; $check->city = $users[$data['user_id']]['city']; $check->state = $users[$data['user_id']]['state'];
function getByNumber($number){ $Check = SI_Check::retrieveSet("WHERE number = '$number'", TRUE); if($Check === FALSE){ return FALSE; } if(isset($Check[0])){ $this->_populateData($Check[0]); if($this->_populateCommTransactions() === FALSE) return FALSE; if($this->_populateCostTransactions() === FALSE) return FALSE; $this->stripSlashes(); }else{ $this->error = "SI_Check::getByNumber() : No data retrieved from query\n"; return FALSE; } return TRUE; }
function getChecks($id = NULL, $limit = 0, $offset = 0){ global $db_conn; if($id === NULL){ $id = intval($this->id); }else{ $id = intval($id); } $limit_sql = ''; if($limit > 0 || $offset > 0){ $limit_sql = " LIMIT $offset, $limit "; } $check = new SI_Check(); $result = $check->retrieveSet("WHERE user_id = $id $limit_sql"); if($result === FALSE){ $this->error = "SI_User::getChecks(): Error getting checks: ".$check->getLastError(); return FALSE; } return $result; }
$user = new SI_User(); $users = $user->getUnpaidUsers(); if($users === FALSE){ $error_msg .= "Could not retrieve Unpaid Users's list!\n"; debug_message($user->getLastError()); } $invoice = new SI_Invoice(); $invoices = $invoice->getOutstanding(); if($invoices === FALSE){ $error_msg .= "Could not retrieve Outstanding Invoice list!\n"; debug_message($invoice->getLastError()); } $check = new SI_Check(); $checks = $check->retrieveSet("ORDER BY timestamp DESC LIMIT 5"); if($checks === FALSE){ $error_msg .= "Could not retrieve Check list!\n"; debug_message($check->getLastError()); } $ps = new SI_PaymentSchedule(); $time = time() + 30 * (24 * (60 * 60)); $ps_items = $ps->getUpcoming($time); if($ps_items === FALSE){ $error_msg .= "Could not retreive upcoming scheduled billings!\n"; debug_message($ps->getLastError()); } $expense = new SI_Expense();
if($loggedin_user->company_id != $invoice->company_id){ fatal_error('You do not have access to view this invoice!'); } } $activities = $activity->getActivitiesForCompany(0, TRUE, $_REQUEST['invoice']); if($activities === FALSE){ $error_msg .= "Could not retrieve Activity List for Invoice ".$_REQUEST['invoice']."!\n"; debug_message($activity->getLastError()); } }else if($_REQUEST['check']){ $title = "for Check Number ".$_REQUEST['check']; $field_header = 'Paid'; $field = 'check'; $url = $_SERVER['PHP_SELF']."?check=".$_REQUEST['check']."&"; $check = new SI_Check(); if($check->getByNumber($_REQUEST['check']) === FALSE){ $error_msg .= "Could not retrieve Activity List for Check ".$_REQUEST['check']."!\n"; debug_message($check->getLastError()); } if(!$loggedin_user->hasRight('admin') && !$loggedin_user->hasRight('accounting')){ if($loggedin_user->id != $check->user_id){ fatal_error('You do not have access to view this check!'); } } $activities = $check->getActivities(); if($activities === FALSE){ $error_msg .= "Could not retrieve Activity List for Check ID ".$_REQUEST['check']."!\n"; debug_message($check->getLastError()); }
function _getLinked(){ $id = intval($this->id); if($id <= 0) return TRUE; if($this->_ta == FALSE){ $ta = new SI_TaskActivity(); $tas = $ta->retrieveSet("WHERE a.cost_trans_id = $id OR a.com_trans_id = $id"); if($tas === FALSE){ $this->error = "Error getting linked task: ".$ta->getLastError(); return FALSE; } if(count($tas) == 1){ $this->_ta = &$tas[0]; } } if($this->_check == FALSE){ $check = new SI_Check(); $checks = $check->retrieveSet("WHERE trans_id = $id"); if($checks === FALSE){ $this->error = "Error getting linked task: ".$check->getLastError(); return FALSE; } if(count($checks) == 1){ $this->_check = &$checks[0]; } } return TRUE; }