lead.storage.factory.js 5.0 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120
  1. angular.module('odoo')
  2. /**
  3. *
  4. */
  5. .factory('leadsStorageFactory', function ($localStorage) {
  6. var configuration = $localStorage;
  7. /**
  8. *
  9. */
  10. var save = function (data, success, error) {
  11. var query = null;
  12. if (data.id) {
  13. query = squel.update()
  14. .table('crm_lead')
  15. .set('remote_id', data.remote_id ? data.remote_id : 0)
  16. .set('modified', 1)
  17. .set('name', data.name)
  18. .set('description', data.description ? data.description : null)
  19. .set('contact_name', data.contact_name ? data.contact_name : null)
  20. .set('phone', data.phone ? data.phone : null)
  21. .set('mobile', data.mobile ? data.mobile : null)
  22. .set('fax', data.fax ? data.fax : null)
  23. .set('street', data.street ? data.street : null)
  24. .set('street2', data.street2 ? data.street2 : null)
  25. .set('priority', data.priority ? data.priority : 2)
  26. .set('probability', data.probability ? data.probability : 10)
  27. .set('type', data.type ? data.type : 'lead')
  28. .set('stage_id', angular.isArray(data.stage_id) ? data.stage_id[0] : (data.stage_id ? data.stage_id : 1))
  29. .set('partner_id', data.partner_id ? data.partner_id : 0)
  30. .where('id = ?', data.id)
  31. .toParam();
  32. } else {
  33. query = squel.insert()
  34. .into('crm_lead')
  35. .set('remote_id', data.remote_id ? data.remote_id : 0)
  36. .set('name', data.name)
  37. .set('description', data.description ? data.description : null)
  38. .set('contact_name', data.contact_name ? data.contact_name : null)
  39. .set('phone', data.phone ? data.phone : null)
  40. .set('mobile', data.mobile ? data.mobile : null)
  41. .set('fax', data.fax ? data.fax : null)
  42. .set('street', data.street ? data.street : null)
  43. .set('street2', data.street2 ? data.street2 : null)
  44. .set('meeting_count', data.meeting_count)
  45. .set('message_bounce', data.message_bounce)
  46. .set('planned_cost', data.planned_cost)
  47. .set('planned_revenue', data.planned_revenue)
  48. .set('priority', data.priority ? data.priority : '2')
  49. .set('probability', data.probability ? data.probability : 0)
  50. .set('type', data.type ? data.type : 'lead')
  51. .set('active', data.active ? data.active : 1)
  52. .set('company_currency', angular.isArray(data.company_currency) ? data.company_currency[0] : 0)
  53. .set('company_id', angular.isArray(data.company_id) ? data.company_id[0] : configuration.company_id)
  54. .set('create_uid', angular.isArray(data.create_uid) ? data.create_uid[0] : configuration.id)
  55. .set('stage_id', angular.isArray(data.stage_id) ? data.stage_id[0] : (data.stage_id ? data.stage_id : 1))
  56. .set('user_id', angular.isArray(data.user_id) ? data.user_id[0] : configuration.id)
  57. .set('user_login', data.user_login ? data.user_login : configuration.user)
  58. .set('partner_id', data.partner_id ? data.partner_id : 0)
  59. .toParam();
  60. }
  61. db.executeSql(query.text, query.values, function (result) {
  62. success(query.text.startsWith('INSERT') ? result.insertId : data.id);
  63. }, function (err) {
  64. error(err);
  65. });
  66. }
  67. /**
  68. *
  69. */
  70. var remove = function (data, success, error) {
  71. var query = null;
  72. if (data.remote_id) {
  73. query = squel.update()
  74. .table('crm_lead')
  75. .set('modified', 2)
  76. .set('id = ?', data.id)
  77. .toParam();
  78. } else {
  79. query = squel.delete()
  80. .from('crm_lead')
  81. .where('id = ?', data.id)
  82. .toParam();
  83. }
  84. db.executeSql(query.text, query.values, function (result) {
  85. success(result.rowsAffected);
  86. }, function (err) {
  87. error(err);
  88. });
  89. }
  90. /**
  91. *
  92. */
  93. var removeAll = function (success, error) {
  94. var query = squel.delete()
  95. .from('crm_lead')
  96. .where('type = ?', 'lead')
  97. .toParam();
  98. db.executeSql(query.text, query.values, function (result) {
  99. success(result.rowsAffected)
  100. }, function (err) {
  101. error(err);
  102. });
  103. }
  104. return {
  105. save: save,
  106. remove: remove,
  107. removeAll: removeAll
  108. }
  109. });