-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathXeroEmployee.php
64 lines (44 loc) · 1.22 KB
/
XeroEmployee.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
<?php
class XeroEmployee {
//ATTRIBUTES
public $_title = 'Employee';
public $_pk = 'xeroEmployeeID'; //our primary key title
protected $_table = 'xeroemployee'; //MySQL table name
//OUR FIELDS
public $xeroEmployeeID = ''; //Our primary Key
public $userID = 0;
//XERO Fields
public $EmployeeID; //Xero's primary key
public $FirstName;
public $LastName;
function __construct($dataarray,$userID)
{
// Intitlize all the variable
// print_r($dataarray);
foreach($dataarray->Employee as $row)
{
$this->EmployeeID=$row->EmployeeID;
$this->FirstName=$row->FirstName;
$this->LastName=$row->LastName;
$this->insert();
}
return true;
}
//CRUD
public function insert(){
$insert = sprintf("INSERT INTO ".$this->_table."
(userID, EmployeeID, FirstName, LastName )
VALUES
('%d', '%s', '%s', '%s');",
mysql_real_escape_string($this->userID),
mysql_real_escape_string($this->EmployeeID),
mysql_real_escape_string($this->FirstName),
mysql_real_escape_string($this->LastName)
);
$result = mysql_query($insert);
}
/*
Any other utilities you need here
*/
}
?>