52.66.85.121 select user.pincode as cpfl_pincode, user_current_address.pincode as crnt_pincode, user_resource_data.category_id as rs_cid, user.name from user INNER JOIN user_resource_data on user.auth_key=user_resource_data.auth_key INNER JOIN user_current_address ON user_resource_data.auth_key=user_current_address.auth_key AND user_resource_data.auth_key='37160f2feb0a7129b11553b27b74cd3d' cpfl_pincode crnt_pincode rs_cid name 110092 110020 150 Srinivas SELECT DISTINCT(user.auth_key) from user inner join user_subscribe ON user.auth_key=user_subscribe.auth_key INNER JOIN user_current_address ON user.auth_key =user_current_address.auth_key WHERE user_subscribe.ctid='$ctid' AND (user.pincode='$crntPincode' OR user.pincode='$pflPincode' OR user_current_address.pincode='$crntPincode' OR user_current_address.pincode='$pflPincode') auth_key device_id 55401e02240c9fa2a581af2c6e3358cd d3tYrEyHdqw:APA91bHrYs_vglhbs26BAVvQY9aSVvGOZT1Go5... HOST = mail.hellosaarthi.com USERNAME="" PASSWORD ="" SMTPSECURE='tls' PORT = 587 7939-7759 588410110008759 userSchema userController productController PId : 1754 authKey : 92ba50f9b4ac1d19c4f96d7b2c6f1a44 resourceAuth : 68fe70e69376ddd6c2904b6fab0eae84 Previous LAT-LONG =>28.549516,77.267777 Current LAT-LONG => 28.711397,77.117617 resourceLatLong : 28.5495133,77.2677921 Resource Lat 28.5495233 Resource Lang 77.2677705 Problem Lat 28.711397 Problem Longtitude 77.117617 visiting & charge both true "{"name":"Srinivas","img_url":"http:\/\/selfemploy-dev.in\/selfemploy\/main\/profileimage\/1563185478_hhep21zcvo_cropped1280166730.jpg","offerid":"15","target_profile":"PROFILE_USER","target_screen":"PROFILE_USER_NEWS_FEED","n_type":"resource_place_offer","title":"Chage and visiting charge offer available","message":"Srinivas has published visiting offer with 20% off and charge offer with 20% off"}" visiting true "{"name":"Srinivas","img_url":"http:\/\/selfemploy-dev.in\/selfemploy\/main\/profileimage\/1563185478_hhep21zcvo_cropped1280166730.jpg","offerid":"20","target_profile":"PROFILE_USER","target_screen":"PROFILE_USER_NEWS_FEED","n_type":"resource_place_offer","title":"Visiting charge offer available","message":"Srinivas has published visiting charge offer with 20% off"}" } charge true "{"name":"Srinivas","img_url":"http:\/\/selfemploy-dev.in\/selfemploy\/main\/profileimage\/1563185478_hhep21zcvo_cropped1280166730.jpg","offerid":"19","target_profile":"PROFILE_USER","target_screen":"PROFILE_USER_NEWS_FEED","n_type":"resource_place_offer","title":"Chage offer available","message":"Srinivas has published charge offer with 20% off"}" data['auth']=$tUser['auth_key']; $data['nt_type']=24; $data['ref_id']=$pid; $data['profile']='2'; $this->prepareNotification($data); get_visit_offer_detail get_charge_offer_detail {"auth_key":"64abf134346aaf924433fe38e425a7c5","ctid":"150"} database : semantis user : se2 password : se2@321 CREATE USER 'se2'@'localhost' IDENTIFIED BY 'se@321'@'localhost'; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '@'localhost'' at line 1 mysql> use semantis; Database changed mysql> CREATE USER 'se2'@'localhost' IDENTIFIED BY 'se2@321'; ERROR 1396 (HY000): Operation CREATE USER failed for 'se2'@'localhost' mysql> CREATE USER 'se'@'localhost' IDENTIFIED BY 'se@321'; Query OK, 0 rows affected (0.00 sec) mysql> GRANT ALL PRIVILEGES ON semantis TO 'se'@'localhost' IDENTIFIED BY 'se@321' WITH GRANT OPTION; Query OK, 0 rows affected, 1 warning (0.00 sec) mysql> FLUSH PRIVILEGES; Query OK, 0 rows affected (0.00 sec) admin : admin passw: 7809e71rb admin : se passw: se@321 rajesh: 28.5497778 77.2672749 srinivas 28.5495066 77.2678021 array(3) { [0]=> string(152) "dWBIhpx8c4Y:APA91bGmHCvA6LHKALAeX3xVdjCKLlTGhNa6uc6I7wDioGqZ0lDH-J_7F5TSQHta1F1YF27E283Rid_4VV3SnFGuQbobX9Dh9A1tzmZxW9u9TUacdD5YsNjPxki_tj0hpxzvHVkPmJJY" [1]=> string(152) "dtsnvsC8Ij0:APA91bF8d7KqVyMMkVTaz2mBaoZFr3gTHMnXWUpb9MO-IhSdt1IQZFgxv5Xy6-kI50-SQaPdyfyZ1XguWnSjFhRokaepWbe3a2Kq2xCzkR9QGp9sWH3tCv_RZSvsZ7r0h7mdBX82cgGR" [2]=> string(152) "dum-9Bn-8cQ:APA91bFgfFzH_b06SLDp6Xt8avZKONKP2qFB9FDDqf8rBxUyVEXyLzD6gTJbJXR7o9D5pz21NDKCkLBq_X5_UEsYAWscZJanZp0HsPJZ6yJoZ9QVsFOWuHr_Ca49wSz31rLgQTj-3myd" } array(4) { ["auth"]=> string(32) "d46fd46bb194ce1eb32694c17ac6c145" ["nt_type"]=> int(25) ["ref_id"]=> string(2) "34" ["profile"]=> string(1) "1" } array(4) { ["auth"]=> string(32) "92ba50f9b4ac1d19c4f96d7b2c6f1a44" ["nt_type"]=> int(25) ["ref_id"]=> string(2) "34" ["profile"]=> string(1) "1" } array(4) { ["auth"]=> string(32) "68fe70e69376ddd6c2904b6fab0eae84" ["nt_type"]=> int(25) ["ref_id"]=> string(2) "34" ["profile"]=> string(1) "1" } {"response":200,"offer_status":{"vst_charge_status":{"response":200,"message":"Visiting charge updated"},"charge_status":null,"offerid":"34"}} Only sending Visiting Offer . Same resource not getting Offer select name,auth_key from user where device_id IN ('dWBIhpx8c4Y:APA91bGmHCvA6LHKALAeX3xVdjCKLlTGhNa6uc6I7wDioGqZ0lDH-J_7F5TSQHta1F1YF27E283Rid_4VV3SnFGuQbobX9Dh9A1tzmZxW9u9TUacdD5YsNjPxki_tj0hpxzvHVkPmJJY','dtsnvsC8Ij0:APA91bF8d7KqVyMMkVTaz2mBaoZFr3gTHMnXWUpb9MO-IhSdt1IQZFgxv5Xy6-kI50-SQaPdyfyZ1XguWnSjFhRokaepWbe3a2Kq2xCzkR9QGp9sWH3tCv_RZSvsZ7r0h7mdBX82cgGR','dum-9Bn-8cQ:APA91bFgfFzH_b06SLDp6Xt8avZKONKP2qFB9FDDqf8rBxUyVEXyLzD6gTJbJXR7o9D5pz21NDKCkLBq_X5_UEsYAWscZJanZp0HsPJZ6yJoZ9QVsFOWuHr_Ca49wSz31rLgQTj-3myd') Rajesh Prasad Yadav 68fe70e69376ddd6c2904b6fab0eae84 Hellouser 92ba50f9b4ac1d19c4f96d7b2c6f1a44 Balam Singh d46fd46bb194ce1eb32694c17ac6c145 ( [body] => {"name":"Srinivas","img_url":"http:\/\/localhost\/selfemploy\/main\/profileimage\/1563185478_hhep21zcvo_cropped1280166730.jpg","offerid":"36","target_profile":"PROFILE_USER","target_screen":"PROFILE_USER_NEWS_FEED","n_type":"resource_place_offer","title":"Visiting charge offer available","message":"Srinivas has published visiting charge offer with 20% off"} ) charge_id : 30 offer_id : 35 vst_id : 34 68fe70e69376ddd6c2904b6fab0eae84 storage: dbPath: /var/lib/mongodb #dbPath: /data/db/ journal: enabled: true # engine: # mmapv1: # wiredTiger: # where to write logging data. systemLog: destination: file logAppend: true path: /var/log/mongodb/mongod.log # network interfaces net: port: 27017 bindIp: 127.0.0.1 sudo apt-get purge mongodb mongodb-clients mongodb-server mongodb-dev Salary revision Hi, This mail regarding confirmation Salary revision. Please let me know whether my Salary has revised from this month or not ? If not please let me know why I was not considered for salary revision. Thanks db.productCategory.find().pretty(); { "_id" : ObjectId("5d4bc1b940194927abfbe402"), "productCategoryName" : "Animal", "productSubCategory" : [ { "productSubCategoryId" : ObjectId("5d4bc20e40194927abfbe403"), "productSubCategoryName" : "Tiger" }, { "productSubCategoryId" : ObjectId("5d4bc26040194927abfbe404"), "productSubCategoryName" : "Fox" } ] } db.productCategory.insertMany([{"productCategory":"Animal","productSubCategory":[{productSubCategoryId:new ObjectId(),"productSubCategory":"Tiger"},{productSubCategoryId:new ObjectId(),"productSubCategory":"Fox"},{productSubCategoryId:new ObjectId(),"productSubCategory":"Zebra"},{productSubCategoryId:new ObjectId(),"productSubCategory":"Elephant"},{productSubCategoryId:new ObjectId(),"productSubCategory":"Horse"}]},{"productCategory":"Flower","productSubCategory":[{productSubCategoryId:new ObjectId(),"productSubCategory":"Rose"},{productSubCategoryId:new ObjectId(),"productSubCategory":"Lotus"},{productSubCategoryId:new ObjectId(),"productSubCategory":"Lily"},{productSubCategoryId:new ObjectId(),"productSubCategory":"Sunflower"}]},{"productCategory":"Fruits","productSubCategory":[{productSubCategoryId:new ObjectId(),"productSubCategory":"Apple"},{productSubCategoryId:new ObjectId(),"productSubCategory":"Guava"},{productSubCategoryId:new ObjectId(),"productSubCategory":"Banana"},{productSubCategoryId:new ObjectId(),"productSubCategory":"Coconut"},{productSubCategoryId:new ObjectId(),"productSubCategory":"Kiwi"}]}]); const mongoose = require('mongoose'); const mongoose = require('mongoose'); const Schema = mongoose.Schema; let productCategory = new Schema({ productCategory:{type:String}, productSubCategory:[new Schema( { productSubCategoryId:{type:Schema.Types.ObjectId}, productSubCategory:{type:String} } ) ] }); module.exports = mongoose.model('productCategory',productCategory); producttags ({ _id: ObjectId("5d511822eb5bf01f287b50a4") }, { '$set': { productName: 'apple-33d', productFileFormat: 'pxtn', productFileVersion: '1.0.0', productDescription: 'compleate apple-3d model data width pxtn fidle format!!!', productCategory: '1', productSubCategory: '100', productGeometrytype: 'sspn', productPolyCount: 2000, productVerticesCount: 59, prodctPrice: Decimal128 { _bsontype: 'Decimal128', bytes: }, productDiscount: 0, productIsRoalityFree: true, productStatus: 0, productVerboseStatus: 'draft-commited', proudctSpecification: [ 'ast', 'gst', 'txt', 'zsh' ], productTags: [ 'ss', 'tip', 'txt' ] } }, {}) (node:7976) DeprecationWarning: collection.update is deprecated. Use updateOne, updateMany, or bulkWrite instead. Mongoose: users.update({ _id: ObjectId("5d511859eb5bf01f287b50a5"), 'products.productId': ObjectId("5d511822eb5bf01f287b50a4") }, { '$set': { 'products.$.productName': 'apple-33d', 'products.$.productFileFormat': 'pxtn', 'products.$.productFileVersion': '1.0.0', 'products.$.productDescription': 'compleate apple-3d model data width pxtn fidle format!!!', 'products.$.productCategory': '1', 'products.$.productSubCategory': '100', 'products.$.productGeometrytype': 'sspn', 'products.$.productPolyCount': '2000', 'products.$.productVerticesCount': '59', 'products.$.prodctPrice': '150.88', 'products.$.productDiscount': '0', 'products.$.productIsRoalityFree': '1', 'products.$.productStatus': 0, 'products.$.productVerboseStatus': 'draft-commited' } }, {} db.createCollection("productplugins"); db.productplugins.insertMany([{'_id':new ObjectId(),'value':'Unreal'},{'_id':new ObjectId(),'value':'Vray'},{'_id':new ObjectId(),'value':'Red shift'},{'_id':new ObjectId(),'value':'Arnon'},{'_id':new ObjectId(),'value':'Smoke'}]); Database creations collections productcategories.json productgeometrytypes.json productplugins.json productspecifications.json producttags.json API : 1. updating api "uploadProduct" and returning set of input required in "uploadProductDetails" returning array : productSpecifications productTags productGeometry productPlugins 2. Added extra fields for uploading products details : productSpecification productPlugins productTags 3. Created API for publishing Products "publishProduct" 4. Created API for listing drafts Products "draftProducts" 5. Created product for previewProduct "previewProduct" Migrated All API to Production * prepared documentation user product listing : productFilter:all productSort:none = > (Mongoose: products.find({ productUploader: ObjectId("5d525b3e423ce02f75d7af2d") }, { projection: {} })) productSort:published => Mongoose: products.find({ productUploader: ObjectId("5d525b3e423ce02f75d7af2d"), productStatus: 1 }, { projection: {} }) productSort : draft => Mongoose: products.find({ productUploader: ObjectId("5d525b3e423ce02f75d7af2d"), productStatus: 0 }, { projection: {} }) ProductFilter : most_recent productSort:none => Mongoose: products.find({ productUploader: ObjectId("5d525b3e423ce02f75d7af2d") }, { sort: { productUploadSnapTime: -1 }, projection: {} }) productSort:published => Mongoose: products.find({ productUploader: ObjectId("5d525b3e423ce02f75d7af2d"), productStatus: 1 }, { sort: { productUploadSnapTime: -1 }, projection: {} }) productSort:draft Mongoose: products.find({ productUploader: ObjectId("5d525b3e423ce02f75d7af2d"), productStatus: 0 }, { sort: { productUploadSnapTime: -1 }, projection: {} }) ProducFilter: most_viewd productSort:none Mongoose: products.find({ productUploader: ObjectId("5d525b3e423ce02f75d7af2d") }, { sort: { productViewCount: -1 }, projection: {} }) productSort : published Mongoose: products.find({ productUploader: ObjectId("5d525b3e423ce02f75d7af2d"), productStatus: 1 }, { sort: { productViewCount: -1 }, projection: {} }) productSort: draft Mongoose: products.find({ productUploader: ObjectId("5d525b3e423ce02f75d7af2d"), productStatus: 0 }, { sort: { productViewCount: -1 }, projection: {} }) productFilter:most_liked productSort:none Mongoose: products.find({ productUploader: ObjectId("5d525b3e423ce02f75d7af2d") }, { sort: { productLikeCount: -1 }, projection: {} }) productSort : published Mongoose: products.find({ productUploader: ObjectId("5d525b3e423ce02f75d7af2d"), productStatus: 1 }, { sort: { productLikeCount: -1 }, projection: {} }) productSort : draft Mongoose: products.find({ productUploader: ObjectId("5d525b3e423ce02f75d7af2d"), productStatus: 0 }, { sort: { productLikeCount: -1 }, projection: {} })