function testGenerateInvoiceReferenceOK()
{
$invoice_reference = WebfinanceCompany::GenerateInvoiceReference();
$this->assertEquals(date('Ymd') . 0, $invoice_reference);
CybPHP_MySQL::Query('INSERT INTO webfinance_invoices SET ' . "num_facture = '{$invoice_reference}'");
$invoice_reference = WebfinanceCompany::GenerateInvoiceReference();
$this->assertEquals(date('Ymd') . 01, $invoice_reference);
CybPHP_MySQL::Query('INSERT INTO webfinance_invoices SET ' . "num_facture = '{$invoice_reference}'");
$invoice_reference = WebfinanceCompany::GenerateInvoiceReference();
$this->assertEquals(date('Ymd') . 02, $invoice_reference);
}
function GetInfo()
{
CybPHP_Validate::ValidateInt($this->_company_id);
$result = CybPHP_MySQL::Query('SELECT nom AS name ' . 'FROM webfinance_clients ' . "WHERE id_client = {$this->_company_id}");
return mysql_fetch_assoc($result);
}
/**
* Get user ID from email address
*
* @param email string. The email address
*
* @return user_id int. The user ID.
*
*/
static function GetIdFromEmail($email = '')
{
CybPHP_Validate::ValidateEmail($email);
$email = mysql_escape_string($email);
$result = CybPHP_MySQL::Query('SELECT id_user ' . 'FROM webfinance_users ' . "WHERE email = '{$email}'");
$user = mysql_fetch_assoc($result);
return $user['id_user'];
}
