function generate_project()
{
$project = new Project();
//if we don't manually set this variable, the parameters from the $_POST array will be imported. We don't want
//those parameters because then we would also be importing the Template id, which would effectively set this
//new project model = this template model. We will manually set the parameters from the template that we want to
//copy
$project->params_imported = true;
$project->set('client_id', Request::param('client_id'));
$project->set('name', Request::param('name'));
$project->set('start_date', Request::param('start_date'));
$project->set('due_date', Request::param('due_date'));
$project->save();
$this->project = $project;
}
public function init($configFile)
{
if (!file_exists($configFile) || !is_file($configFile)) {
die("Missing main configuration file");
}
//$x = setlocale(LC_TIME, 'ru_RU.CP1251', 'ru_RU.cp1251', 'Russian_Russia.1251');
$x = setlocale(LC_ALL, 'rus_RUS.65001', 'rus_RUS.65001', 'Russian_Russia.65001');
$xml = simplexml_load_file($configFile);
foreach ($xml->module as $module) {
$configuration = new ConfigParameter($module->asXML());
$class = $configuration->get('class');
if (!$class) {
die("Module has no class");
}
$module_id = $configuration->get('id');
if (!$module_id) {
die("Module has no ID");
}
if (Project::exists($module_id)) {
// TODO:: write to log file
//die("Module id already busy:".$module_id);
}
$module = new $class();
$module->initialize($configuration);
if ($module->setToRegistry() === true) {
Project::set($module_id, $module);
}
unset($module);
}
}
function testDestroyAssociatedRecords()
{
$c = new Company();
$c->set(array('name' => 'destroy_test'));
$c->save();
$p = new Project();
$p->set(array('company_id' => $c->id, 'name' => 'destroy_project_test'));
$p->save();
$e = new Estimate();
$e->set(array('project_id' => $p->id, 'name' => 'destroy_estimate_test'));
$e->save();
$h = new Hour();
$h->set(array('estimate_id' => $e->id, 'name' => 'destroy_hour_test'));
$h->save();
$ch = new Charge();
$ch->set(array('company_id' => $c->id, 'name' => 'destroy_charge_test'));
$ch->save();
$con = new SupportContract();
$con->set(array('company_id' => $c->id, 'name' => 'destroy_contract_test'));
$con->save();
$sup_hr = new Hour();
$sup_hr->set(array('support_contract_id' => $con->id, 'description' => 'destroy_support_hour_test'));
$sup_hr->save();
$pay = new Payment();
$pay->set(array('company_id' => $c->id, 'name' => 'destroy_payment_test'));
$pay->save();
$deleted_items = array('company' => $c->id, 'project' => $p->id, 'estimate' => $e->id, 'hour' => $h->id, 'support_hour' => $sup_hr->id, 'charge' => $ch->id, 'support_contract' => $con->id, 'payment' => $pay->id);
$c->destroyAssociatedRecords();
$c->delete();
$dbcon = AMP::getDb();
foreach ($deleted_items as $table => $id) {
if ($table == 'support_hour') {
$table = 'hour';
}
$sql = 'SELECT * FROM ' . $table . ' WHERE id = ' . $id;
if ($records = $dbcon->Execute($sql)) {
$this->assertEqual($records->RecordCount(), 0, "{$table} not deleted correctly: %s");
} else {
trigger_error($dbcon->ErrorMsg());
}
}
}
function show($params)
{
if (empty($params['id'])) {
bail('No company selected.');
}
$this->data->company = new Company($params['id']);
$user_id = Session::getUserId();
$p = new Project();
$p->set(array('company_id' => $params['id'], 'staff_id' => $user_id));
$this->data->new_project = $p;
$this->data->new_note = new Note();
$this->data->new_note->set(array('date' => date('Y-m-d'), 'staff_id' => Session::getUserId(), 'company_id' => $params['id']));
$this->data->new_charge = new Charge();
$this->data->new_charge->set(array('date' => date('Y-m-d'), 'company_id' => $params['id']));
$this->data->new_payment = new Payment();
$this->data->new_payment->set(array('date' => date('Y-m-d'), 'company_id' => $params['id']));
$this->data->new_invoice = new Invoice();
$this->data->new_invoice->set(array('company_id' => $params['id']));
$this->data->new_contact = new Contact();
$this->data->new_contact->set(array('company_id' => $params['id']));
}
function testCalculateBalanceWithDateRange()
{
#Company
$cp = new Company();
$cp->set(array('name' => 'Test Company', 'status' => 'active'));
$cp->save();
$pb = new CompanyPreviousBalance();
$pb->set(array('company_id' => $cp->id, 'amount' => 600.25, 'date' => '2010-01-30'));
$pb->save();
$this->assertWithinMargin($pb->getAmount(), '600.25', '.01');
######### Support
$sc = new SupportContract();
$sc->set(array('company_id' => $cp->id, 'domain_name' => 'Test', 'start_date' => '2010-01-01', 'end_date' => '2010-04-30', 'hourly_rate' => '120', 'support_hours' => '.5', 'monthly_rate' => '50'));
$sc->save();
# add support hours
# before previous balance
$h = new Hour();
$h->set(array('description' => 'Test', 'support_contract_id' => $sc->id, 'date' => '2010-01-20', 'hours' => '2.5'));
$h->save();
# in range
$h = new Hour();
$h->set(array('description' => 'Test', 'support_contract_id' => $sc->id, 'date' => '2010-02-20', 'hours' => '2.5'));
$h->save();
# in range
$h = new Hour();
$h->set(array('description' => 'Test', 'support_contract_id' => $sc->id, 'date' => '2010-03-20', 'hours' => '2.5'));
$h->save();
# out of range
$h = new Hour();
$h->set(array('description' => 'Test', 'support_contract_id' => $sc->id, 'date' => '2010-05-20', 'hours' => '2'));
$h->save();
### Support Totals = in range is 2 months x 50 = 100, 4 @ 120 = 480 = 580
$date_range = array('start_date' => '2010-01-01', 'end_date' => '2010-03-31');
$total = $cp->calculateSupportTotal($date_range);
$this->assertEqual($total, 580);
###### Project
$pj = new Project();
$pj->set(array('name' => 'Test Project', 'company_id' => $cp->id, 'hourly_rate' => '120'));
$pj->save();
# Add an Estimate item #1
$es1 = new Estimate();
$es1->set(array('project_id' => $pj->id, 'name' => 'Test Estimate 1', 'high_hours' => '10', 'low_hours' => '5'));
$es1->save();
# Add an Estimate item #2
$es2 = new Estimate();
$es2->set(array('project_id' => $pj->id, 'name' => 'Test Estimate 2', 'high_hours' => '10', 'low_hours' => '5'));
$es2->save();
# Add some before previous balance hours for #1 - 5 hours at 120 = 600
$hr = new Hour();
$hr->set(array('estimate_id' => $es1->id, 'description' => 'Test Hours for Estimate 1', 'date' => '2010-01-15', 'hours' => '5'));
$hr->save();
# Add some in range hours for #1 - 5 hours at 120 = 600
$hr = new Hour();
$hr->set(array('estimate_id' => $es1->id, 'description' => 'Test Hours for Estimate 1', 'date' => '2010-02-15', 'hours' => '5'));
$hr->save();
# Add some in range hours for #2 - 5 hours at 120 = 600
$hr = new Hour();
$hr->set(array('estimate_id' => $es2->id, 'description' => 'Test Hours for Estimate 2', 'date' => '2010-02-15', 'hours' => '5'));
$hr->save();
# Add some out of range hours for #2 - 5 hours at 120 = 600
$hr = new Hour();
$hr->set(array('estimate_id' => $es2->id, 'description' => 'Test Hours for Estimate 2', 'date' => '2010-05-15', 'hours' => '5'));
$hr->save();
## Project Totals = In range 1200, out of range 1800
$date_range = array('start_date' => '2010-01-01', 'end_date' => '2010-03-31');
$total = $cp->calculateProjectsTotal($date_range);
$this->assertEqual($total, 1200);
#Charge
# before previous balance
$cr = new Charge();
$cr->set(array('name' => 'Test', 'company_id' => $cp->id, 'date' => '2010-01-10', 'amount' => '20.50'));
$cr->save();
# in date range
$cr = new Charge();
$cr->set(array('name' => 'Test', 'company_id' => $cp->id, 'date' => '2010-03-14', 'amount' => '50.25'));
$cr->save();
# in date range
$cr = new Charge();
$cr->set(array('name' => 'Test', 'company_id' => $cp->id, 'date' => '2010-03-20', 'amount' => '50'));
$cr->save();
# out of date range
$cr = new Charge();
$cr->set(array('name' => 'Test', 'company_id' => $cp->id, 'date' => '2010-05-15', 'amount' => '50'));
$cr->save();
# Total Charges = in range 100.25, out of range 150.25
$date_range = array('start_date' => '2010-01-01', 'end_date' => '2010-03-31');
$charge_total = $cp->calculateChargesTotal($date_range);
$this->assertEqual($charge_total, 100.25);
## Test Total Costs
# Charges 100.25 + project 1200 + support 580
$date_range = array('start_date' => '2010-01-01', 'end_date' => '2010-03-31');
$total = $cp->calculateCosts($date_range);
$this->assertEqual($total, 1880.25);
## Payments
# add payment before previous balance date
$py = new Payment();
$py->set(array('company_id' => $cp->id, 'date' => '2010-01-22', 'amount' => '20.50'));
$py->save();
# add payment in range
$py = new Payment();
$py->set(array('company_id' => $cp->id, 'date' => '2010-02-10', 'amount' => '20.00'));
$py->save();
# add payment in range
$py = new Payment();
$py->set(array('company_id' => $cp->id, 'date' => '2010-03-01', 'amount' => '120.00'));
$py->save();
# add payment out of range
$py = new Payment();
$py->set(array('company_id' => $cp->id, 'date' => '2010-04-01', 'amount' => '20.25'));
$py->save();
# Total Payments are 20 + 120 = 140 in range and after previous balance
$date_range = array('start_date' => '2010-01-01', 'end_date' => '2010-03-31');
$payment_total = $cp->calculatePaymentsTotal($date_range);
$this->assertEqual($payment_total, 140);
#### fails because the previous balance isn't getting included FIX ME!!
# Total Balance Costs 1880.25 - Payments 140 + Previous balance 600.25 = 2340.5
$date_range = array('start_date' => '2010-01-01', 'end_date' => '2010-03-31');
$balance = $cp->calculateBalance($date_range);
$this->assertWithinMargin($balance, 2340.5, 0.001);
## clean up
$cp->destroyAssociatedRecords();
$cp->delete();
}
<?php
//test
require_once 'boot/bootstrap.php';
$p = new Project();
$s = getOne('Staff', array('First_Name' => 'Ted'));
$p->set(array('id' => 20971, 'name' => 'SimpeTest Project', 'staff_id' => $s->id, 'company_id' => 20970));
$p->save() ? print 'saved' : (print 'didn\'t save');
