customer.storage.factory.js 5.2 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128
  1. angular.module('odoo')
  2. /**
  3. * -----------------------------------------------------------------------------
  4. * Description: Local storage manager for customers data
  5. * -----------------------------------------------------------------------------
  6. */
  7. .factory('customersStorageFactory', function ($localStorage) {
  8. var configuration = $localStorage;
  9. /**
  10. *
  11. */
  12. var save = function (data, success, error) {
  13. var query = null;
  14. if (data.id) {
  15. query = squel.update()
  16. .table('partner')
  17. .set('remote_id', data.remote_id ? data.remote_id : 0)
  18. .set('modified', 1)
  19. .set('name', data.name)
  20. .set('city', data.city ? data.city : null)
  21. .set('mobile', data.mobile ? data.mobile : null)
  22. .set('phone', data.phone ? data.phone : null)
  23. .set('fax', data.fax ? data.fax : null)
  24. .set('email', data.email ? data.email : null)
  25. .set('street', data.street ? data.street : null)
  26. .set('street2', data.street2 ? data.street2 : null)
  27. .set('image_medium', data.image_medium ? data.image_medium : null)
  28. .set('image_small', data.image_small ? data.image_small : null)
  29. .set('comment', data.comment ? data.comment : null)
  30. .set('customer', 1)
  31. .set('employee', 0)
  32. .set('is_company', 0)
  33. .where('id = ?', data.id)
  34. .toParam();
  35. } else {
  36. query = squel.insert()
  37. .into('partner')
  38. .set('remote_id', data.remote_id ? data.remote_id : 0)
  39. .set('name', data.name)
  40. .set('city', data.city ? data.city : null)
  41. .set('mobile', data.mobile ? data.mobile : null)
  42. .set('phone', data.phone ? data.phone : null)
  43. .set('fax', data.fax ? data.fax : null)
  44. .set('email', data.email ? data.email : null)
  45. .set('street', data.street ? data.street : null)
  46. .set('street2', data.street2 ? data.street2 : null)
  47. .set('image_medium', data.image_medium ? data.image_medium : null)
  48. .set('image_small', data.image_small ? data.image_small : null)
  49. .set('comment', data.comment ? data.comment : null)
  50. .set('customer', 1)
  51. .set('employee', 0)
  52. .set('is_company', 0)
  53. .set('debit', data.debit)
  54. .set('debit_limit', data.debit_limit)
  55. .set('opportunity_count', data.opportunity_count)
  56. .set('contracts_count', data.contracts_count)
  57. .set('journal_item_count', data.journal_item_count)
  58. .set('meeting_count', data.meeting_count)
  59. .set('phonecall_count', data.phonecall_count)
  60. .set('sale_order_count', data.sale_order_count)
  61. .set('total_invoiced', data.total_invoiced)
  62. .set('type', data.type ? data.type : 'contact')
  63. .set('active', data.active ? data.active : 1)
  64. .set('company_id', angular.isArray(data.company_id) ? data.company_id[0] : configuration.company_id)
  65. .set('create_uid', angular.isArray(data.create_uid) ? data.create_uid[0] : configuration.id)
  66. .toParam();
  67. }
  68. db.executeSql(query.text, query.values, function (result) {
  69. success(query.text.startsWith('INSERT') ? result.insertId : data.id);
  70. }, function (err) {
  71. console.log(err);
  72. error(err);
  73. });
  74. };
  75. /**
  76. *
  77. */
  78. var remove = function (data, success, error) {
  79. var query = null;
  80. if (data.remote_id) {
  81. query = squel.update()
  82. .table('partner')
  83. .set('modified', 2)
  84. .where('id = ?', data.id)
  85. .toParam();
  86. } else {
  87. query = squel.delete()
  88. .from('partner')
  89. .where('id = ?', data.id)
  90. .toParam();
  91. }
  92. db.executeSql(query.text, query.values, function (result) {
  93. success(result.rowsAffected);
  94. }, function (err) {
  95. error(err);
  96. });
  97. };
  98. /**
  99. *
  100. */
  101. var removeAll = function (success, error) {
  102. var query = squel.delete()
  103. .from('partner')
  104. .where('customer = ?', 1)
  105. .toParam();
  106. db.executeSql(query.text, query.values, function (result) {
  107. success(result.rowsAffected);
  108. }, function (err) {
  109. error(err);
  110. });
  111. };
  112. return {
  113. save: save,
  114. remove: remove,
  115. removeAll: removeAll
  116. }
  117. });