public function signup()
{
$this->exportJS("\$('#docNav').hide();");
$data = base::subHeader("Create an Account", "Add your Company to the Support System");
$data .= base::begin();
$data .= base::pageHeader("Before you Begin", "You are about to create an account. If your company is already in our system, please have your company administrator add your account. You will only be able to add your company once.");
$elements = [];
$elements[] = ['type' => 'input', 'var' => 'user_name', 'text' => 'Full Name:', 'comment' => 'Main contact for account'];
$elements[] = ['type' => 'input', 'var' => 'user_email', 'text' => 'E-mail Address:', 'comment' => 'Also your login to this system'];
$elements[] = ['type' => 'password', 'var' => 'user_password', 'text' => 'Password:'******'type' => 'input', 'var' => 'user_phone', 'text' => 'Phone Number (and Extension):', 'comment' => 'xxx.xxx.xxxx ext. xxx'];
$elements[] = ['type' => 'input', 'var' => 'user_title', 'text' => 'Your Title:', 'comment' => 'Leave blank if individual'];
$span = [];
$span[] = ['span' => 6, 'elements' => $elements];
$elements = [];
$elements[] = ['type' => 'input', 'var' => 'company_name', 'text' => 'Company Name:', 'comment' => 'If individual leave this blank'];
$elements[] = ['type' => 'input', 'var' => 'company_address', 'text' => 'Address:', 'comment' => 'Where to mail invoices if required?'];
$elements[] = ['type' => 'input', 'var' => 'company_address2', 'text' => 'Address Line 2:', 'comment' => 'Suite, etc.'];
$elements[] = ['type' => 'input', 'var' => 'company_city', 'text' => 'City:'];
$elements[] = ['type' => 'input', 'var' => 'company_state', 'text' => 'State:'];
$elements[] = ['type' => 'input', 'var' => 'company_zip', 'text' => 'Zip:'];
$span[] = ['span' => 6, 'elements' => $elements];
$form = form::init()->spanElements($span)->id('createAccount')->post('/login/')->render();
$button = button::init()->formid('createAccount')->text('Create My Account')->addStyle('post')->addStyle('btn-primary')->icon('fire')->message('Creating Account..')->postVar('createAccount')->render();
$save = "<div class='pull-right'>{$button}</div>";
$data .= widget::init()->icon('share-alt')->span(12)->header('Account Details')->content($form)->footer($save)->render();
$this->export($data);
}
private function getSubTickets(&$ticket)
{
$subs = $this->query("SELECT * from subtickets WHERE ticket_id='{$ticket['id']}'");
$addButton .= button::init()->isModalLauncher()->text('Add Task')->url('#addTask')->addStyle('btn-inverse')->addStyle('btn-block')->withGroup(false)->icon('plus')->render();
$data = "<div class='row-fluid'>\n\t\t\t\t<div class='span6'>";
$headers = ['Task', 'Assigned', 'Author', 'Last Updated'];
foreach ($subs as $sub) {
$color = $sub['subticket_isclosed'] ? "red" : "green";
$ss = $sub['subticket_isclosed'] ? "<s>" : null;
$se = $sub['subticket_isclosed'] ? "</s>" : null;
$rows[] = ["<a class='get' href='/ticket/{$ticket['id']}/{$sub['id']}/'>{$ss}{$sub['subticket_title']}{$se}</a>", $sub['subticket_assigned'] ? "<a class='get' href='/assign/sub/{$sub['id']}/'>" . $this->getUserById($sub['subticket_assigned']) . "</a>" : "<a class='get' href='/assign/sub/{$sub['id']}/'>Unassigned</a>", $this->getUserById($sub['subticket_creator']), $this->fbTime($sub['subticket_lastupdated']), $color];
}
if (!$subs) {
$data .= "<h4>No tasks found</h4>";
} else {
$data .= table::init()->id('tasks')->headers($headers)->rows($rows)->render();
}
$data .= "{$addButton}</div>";
// Start Viewer on the next 6 span.
$data .= "<div class='span6'>";
$data .= widget::init()->header("<span class='viewportTitle'>Task Viewport</span>")->content("<div id='viewport'></div>")->icon('tasks')->render();
$data .= "</div>";
// end span6
$data .= "</div>";
// end rowfluid
$save = button::init()->addStyle('mpost')->addStyle('btn-primary')->icon('ok')->text('Create Task')->formid('addTaskForm')->postVar('addTask')->id($ticket['id'])->render();
$this->exportModal(modal::init()->header('Add Task')->content($this->addTaskForm())->id('addTask')->footer($save)->render());
return $data;
}
private function customerMain()
{
// Show tabs for all queues the agent has access to based on access level.
$headers = ['#', 'Subject', 'Status', 'Last Updated', 'Assigned', 'Queue'];
$tickets = $this->query("SELECT * from tickets WHERE company_id='{$this->company->id}' and ticket_isclosed = false");
$rows = [];
foreach ($tickets as $ticket) {
$rows[] = [$ticket['id'], "<a href='/ticket/{$ticket['id']}/'>{$ticket['ticket_title']}</a>", $ticket['ticket_status'], $this->fbTime($ticket['ticket_lastupdated']), $ticket['ticket_assigned'] ? $this->getUserByID($ticket['ticket_assigned']) : "Awaiting Assignment", $this->returnFieldFromTable("queue_name", "queues", "id='{$ticket['queue_id']}'")];
}
$table = table::init()->headers($headers)->rows($rows)->render();
$createTicket = button::init()->isModalLauncher()->url('#newTicket')->text('Create New Ticket')->addStyle('btn-inverse')->icon('tasks')->render();
$widget = widget::init()->span(12)->header('Ticket List')->content($table)->isTable(true)->rightHeader($createTicket)->render();
$data = base::row($widget);
$save = button::init()->formid('newTicketForm')->addStyle('mpost')->postVar('createTicket')->text('Create Ticket')->addStyle('btn-success')->icon('ok')->render();
$this->exportModal(modal::init()->id('newTicket')->header('Create New Ticket')->content($this->createTicketForm())->footer($save)->render());
return $data;
}
public function showClient($content)
{
$id = $content['showClient'];
$company = $this->query("SELECT * from companies WHERE id='{$id}'")[0];
$user = $this->query("SELECT * from users WHERE company_id='{$company['id']}'")[0];
// Going to pretty much copy the end-user signup form. (and change our postvars)
$elements = [];
$elements[] = ['type' => 'input', 'var' => 'user_name', 'text' => 'Full Name:', 'comment' => 'Main contact for account', 'val' => $user['user_name']];
$elements[] = ['type' => 'input', 'var' => 'user_email', 'text' => 'E-mail Address:', 'comment' => 'Also your login to this system', 'val' => $user['user_email']];
$elements[] = ['type' => 'password', 'var' => 'user_password', 'text' => 'Password:'******'type' => 'input', 'var' => 'user_phone', 'text' => 'Phone Number (and Extension):', 'comment' => 'xxx.xxx.xxxx ext. xxx', 'val' => $user['user_phone']];
$elements[] = ['type' => 'input', 'var' => 'user_title', 'text' => 'Title:', 'comment' => 'Leave blank if individual', 'val' => $user['user_title']];
$span = [];
$span[] = ['span' => 6, 'elements' => $elements];
$elements = [];
$elements[] = ['type' => 'input', 'var' => 'company_name', 'text' => 'Company Name:', 'comment' => 'If individual leave this blank', 'val' => $company['company_name']];
$elements[] = ['type' => 'input', 'var' => 'company_address', 'text' => 'Address:', 'comment' => 'Where to mail invoices if required?', 'val' => $company['company_address']];
$elements[] = ['type' => 'input', 'var' => 'company_address2', 'text' => 'Address Line 2:', 'comment' => 'Suite, etc.', 'val' => $company['company_address2']];
$elements[] = ['type' => 'input', 'var' => 'company_city', 'text' => 'City:', 'val' => $company['company_city']];
$elements[] = ['type' => 'input', 'var' => 'company_state', 'text' => 'State:', 'class' => 'state', 'val' => $company['company_state']];
$elements[] = ['type' => 'input', 'var' => 'company_zip', 'text' => 'Zip:', 'val' => $company['company_zip']];
$span[] = ['span' => 6, 'elements' => $elements];
$form = form::init()->spanElements($span)->id('editAccount')->post('/clients/')->render();
$button = button::init()->formid('editAccount')->text('Edit Account')->addStyle('post')->addStyle('btn-primary')->icon('fire')->message('Modifying Account..')->postVar('editAccount')->id($company['id'])->render();
$save = "<div class='pull-right'>{$button}</div>";
$data .= widget::init()->icon('share-alt')->span(12)->header('Account Details')->content($form)->footer($save)->render();
$this->exportJS(js::maskInput('state', "**"));
$this->export($data);
}
public function showInvoices()
{
$nav = $this->billingNav('invoices');
// Default to Credit.
$data = base::span(4, $nav);
//Just a simple table with a download button for downloading the invoices.
$headers = ['Ticket', 'Date', 'Description', 'Type', 'Download'];
$rows = [];
$transactions = $this->query("SELECT * from transactions WHERE company_id='{$this->company->id}'");
foreach ($transactions as $transaction) {
switch ($transaction['transaction_source']) {
case 'stripe':
$source = "Credit Card";
break;
case 'dwolla':
$source = "Checking Draft";
break;
case 'check':
$source = "Posted Check";
break;
case 'cash':
$source = "Cash";
break;
}
$row = ["<a href='/ticket/{$transaction['ticket_id']}/'>{$transaction['ticket_id']}</a>", date("m/d/y", $transaction['transaction_ts']), $transaction['transaction_desc'], $source, button::init()->url("/billing/invoice/{$transaction['id']}/")->text("Download Invoice")->addStyle('btn-small')->addStyle('btn-info')->icon('arrow-down')->render()];
$rows[] = $row;
}
$table = table::init()->rows($rows)->headers($headers)->render();
$data .= widget::init()->span(8)->isTable()->header("Processed Transactions")->content($table)->render();
$data = base::row($data);
$this->export($data);
}
public function showTransactionLog()
{
$data = base::span(4, $this->adminNav('billing'));
$headers = ['Merchant ID', 'Date', 'Amount', 'Fee', 'Net', 'Merchant', 'Description', 'Ticket', 'Company'];
$transactions = $this->query("SELECT * from transactions ORDER by transaction_ts DESC");
$rows = [];
foreach ($transactions as $transaction) {
$rows[] = [$transaction['transaction_merchant_id'], date("m/d/y h:ia", $transaction['transaction_ts']), number_format($transaction['transaction_amount'], 2), number_format($transaction['transaction_fee'], 2), number_format($transaction['transaction_net'], 2), $transaction['transaction_source'], $transaction['transaction_desc'], "<a href='/ticket/{$transaction['ticket_id']}/'>{$transaction['ticket_id']}</a>", $this->getCompanyById($transaction['company_id'])];
}
$table = table::init()->id('tlog')->headers($headers)->rows($rows)->render();
$data .= widget::init()->span(6)->header('Transaction Log')->content($table)->icon('credit-card')->istable(true)->render();
$this->exportjs(js::datatable('tlog', 50));
$headers = ['Payout Schedule', 'Amount'];
$rows = [];
$now = time();
$transfers = $this->query("SELECT * from transfers WHERE transfer_ts > {$now} ORDER by transfer_ts DESC");
foreach ($transfers as $transfer) {
$rows[] = [$this->fbTime($transfer['transfer_ts']), number_format($transfer['transfer_amt'] / 100, 2)];
}
$table = table::init()->headers($headers)->rows($rows)->render();
$data .= widget::init()->span(2)->header('Payout Schedule')->icon('truck')->content($table)->istable(true)->render();
$this->export(base::row($data, true));
}
