customer.storage.factory.js 5.7 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134
  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. .set('partner_latitude', data.partner_latitude ? data.partner_latitude : 0)
  34. .set('partner_longitude', data.partner_longitude ? data.partner_longitude : 0)
  35. .set('date_localization', data.date_localization ? data.date_localization : null)
  36. .where('id = ?', data.id)
  37. .toParam();
  38. } else {
  39. query = squel.insert()
  40. .into('partner')
  41. .set('remote_id', data.remote_id ? data.remote_id : 0)
  42. .set('name', data.name)
  43. .set('city', data.city ? data.city : null)
  44. .set('mobile', data.mobile ? data.mobile : null)
  45. .set('phone', data.phone ? data.phone : null)
  46. .set('fax', data.fax ? data.fax : null)
  47. .set('email', data.email ? data.email : null)
  48. .set('street', data.street ? data.street : null)
  49. .set('street2', data.street2 ? data.street2 : null)
  50. .set('image_medium', data.image_medium ? data.image_medium : null)
  51. .set('image_small', data.image_small ? data.image_small : null)
  52. .set('comment', data.comment ? data.comment : null)
  53. .set('customer', 1)
  54. .set('employee', 0)
  55. .set('is_company', 0)
  56. .set('debit', data.debit)
  57. .set('debit_limit', data.debit_limit)
  58. .set('opportunity_count', data.opportunity_count)
  59. .set('contracts_count', data.contracts_count)
  60. .set('journal_item_count', data.journal_item_count)
  61. .set('meeting_count', data.meeting_count)
  62. .set('phonecall_count', data.phonecall_count)
  63. .set('sale_order_count', data.sale_order_count)
  64. .set('total_invoiced', data.total_invoiced)
  65. .set('type', data.type ? data.type : 'contact')
  66. .set('active', data.active ? data.active : 1)
  67. .set('partner_latitude', data.partner_latitude ? data.partner_latitude : 0)
  68. .set('partner_longitude', data.partner_longitude ? data.partner_longitude : 0)
  69. .set('date_localization', data.date_localization ? data.date_localization : null)
  70. .set('company_id', angular.isArray(data.company_id) ? data.company_id[0] : configuration.company_id)
  71. .set('create_uid', angular.isArray(data.create_uid) ? data.create_uid[0] : configuration.id)
  72. .toParam();
  73. }
  74. db.executeSql(query.text, query.values, function (result) {
  75. success(query.text.startsWith('INSERT') ? result.insertId : data.id);
  76. }, function (err) {
  77. console.log(err);
  78. error(err);
  79. });
  80. };
  81. /**
  82. *
  83. */
  84. var remove = function (data, success, error) {
  85. var query = null;
  86. if (data.remote_id) {
  87. query = squel.update()
  88. .table('partner')
  89. .set('modified', 2)
  90. .where('id = ?', data.id)
  91. .toParam();
  92. } else {
  93. query = squel.delete()
  94. .from('partner')
  95. .where('id = ?', data.id)
  96. .toParam();
  97. }
  98. db.executeSql(query.text, query.values, function (result) {
  99. success(result.rowsAffected);
  100. }, function (err) {
  101. error(err);
  102. });
  103. };
  104. /**
  105. *
  106. */
  107. var removeAll = function (success, error) {
  108. var query = squel.delete()
  109. .from('partner')
  110. .where('customer = ?', 1)
  111. .toParam();
  112. db.executeSql(query.text, query.values, function (result) {
  113. success(result.rowsAffected);
  114. }, function (err) {
  115. error(err);
  116. });
  117. };
  118. return {
  119. save: save,
  120. remove: remove,
  121. removeAll: removeAll
  122. }
  123. });