BK
I don't know what I have to do. i worked so hard
Size: a a a
2019 August 31
A
which version you use?
BK
BK
my model
BK
module.exports = (sequelize, DataTypes) => {
return sequelize.define(
'sirket',
{
id: {
type: DataTypes.INTEGER,
allowNull: false,
primaryKey: true},
companyId: {
field: 'sirket_id',
type: DataTypes.STRING,
allowNull: false,
},
categoryId: {
field: 'kat_id',
type: DataTypes.INTEGER,
allowNull: false,
},
userId: {
field: 'kul_id',
type: DataTypes.INTEGER,
},
cityId: {
field: 'il_id',
type: DataTypes.INTEGER,
},
countyId: {
field: 'ilce_id',
type: DataTypes.INTEGER,
},
name: {
field: 'sirket_ad',
type: DataTypes.STRING,
allowNull: false,
},
lat: {
field: 'koor_x',
type: DataTypes.FLOAT,
allowNull: false},
long: {
field: 'koor_y',
type: DataTypes.FLOAT,
allowNull: false},
adress: {
field: 'sirket_adres',
type: DataTypes.STRING,
},
dealer: {
field: 'bayi',
type: DataTypes.INTEGER,
},
distance: {
type: DataTypes.VIRTUAL,
get: function (key, options) {
// const lat = this.getDataValue('lat');
//console.log("LONGITUDE, ", longitude)
//console.log(sequelize.getContext()),
console.log(this);
return ""
}
}
},
{
timestamps: false,
freezeTableName: true}
)
};BK
models.sirket.get({plain:true,apiVersion:2});
return models.sirket.findAll({
limit: parseInt(args.limit),
order: [["name", "desc"]],
})BK
where am i doing wrong
BK
I would like to return lat with long values in km. but I should request lat long values
A
are you tried to request a
koor_x instead of lat in const lat = this.getDataValue('lat'); ?BK
yes, I'm getting that value. But to calculate the externally you should also take the lat value
BK
I can't get value from the outside
BK
return
models.sirket.findAll({
limit: parseInt(args.limit),
order: [["name", "desc"]],
})BK
sorry, wrong
BK
for example, I need to calculate and value.
return models.company.findAll ({
limit: parseInt (args.limit),
order: [["name", "desc"]],
LAT: 40.1231,
long: 23.12321
})
return models.company.findAll ({
limit: parseInt (args.limit),
order: [["name", "desc"]],
LAT: 40.1231,
long: 23.12321
})
YZ
module.exports = (sequelize, DataTypes) => {
return sequelize.define(
'sirket',
{
id: {
type: DataTypes.INTEGER,
allowNull: false,
primaryKey: true},
companyId: {
field: 'sirket_id',
type: DataTypes.STRING,
allowNull: false,
},
categoryId: {
field: 'kat_id',
type: DataTypes.INTEGER,
allowNull: false,
},
userId: {
field: 'kul_id',
type: DataTypes.INTEGER,
},
cityId: {
field: 'il_id',
type: DataTypes.INTEGER,
},
countyId: {
field: 'ilce_id',
type: DataTypes.INTEGER,
},
name: {
field: 'sirket_ad',
type: DataTypes.STRING,
allowNull: false,
},
lat: {
field: 'koor_x',
type: DataTypes.FLOAT,
allowNull: false},
long: {
field: 'koor_y',
type: DataTypes.FLOAT,
allowNull: false},
adress: {
field: 'sirket_adres',
type: DataTypes.STRING,
},
dealer: {
field: 'bayi',
type: DataTypes.INTEGER,
},
distance: {
type: DataTypes.VIRTUAL,
get: function (key, options) {
// const lat = this.getDataValue('lat');
//console.log("LONGITUDE, ", longitude)
//console.log(sequelize.getContext()),
console.log(this);
return ""
}
}
},
{
timestamps: false,
freezeTableName: true}
)
};Try this syntax: https://stackoverflow.com/a/21989178
BK
unfortunately not
BK
please share the sample code
YZ
Doesn't work?
BK
don't get value from settermethod menu
YZ