QOR is a set of libraries written in Go that abstracts common features needed for business applications, CMSs, and E-commerce systems.
Can you suggest some solution?
This is the first filter
userQueries.Filter(&admin.Filter{
Label: "Account Manager",
Config: &admin.SelectOneConfig{Collection: bulkupload.GetAccountManagers},
Handler: func(db gorm.DB, filter admin.FilterArgument) *gorm.DB {
db = configuration.GetDB(constants.READ)
metaValue := filter.Value.Get("Value")
var filterValue interface{}
if metaValue != nil {
filterValue = metaValue.Value
} else {
filterValue = nil
}
return db.Joins(" JOIN products ON products.id = user_queries.product_id JOIN users ON users.id = products.user_id AND users.deleted_at is null AND users.account_manager_id = ? ", filterValue)
},
})
Label: "Account Manager",
Config: &admin.SelectOneConfig{Collection: bulkupload.GetAccountManagers},
Handler: func(db gorm.DB, filter admin.FilterArgument) *gorm.DB {
db = configuration.GetDB(constants.READ)
metaValue := filter.Value.Get("Value")
var filterValue interface{}
if metaValue != nil {
filterValue = metaValue.Value
} else {
filterValue = nil
}
return db.Joins(" JOIN products ON products.id = user_queries.product_id JOIN users ON users.id = products.user_id AND users.deleted_at is null AND users.account_manager_id = ? ", filterValue)
},
})
and this is second one
userQueries.Filter(&admin.Filter{
Label: "Vendor User ID",
Config: &admin.SelectOneConfig{Collection: bulkupload.GetUsers},
Handler: func(db gorm.DB, filter admin.FilterArgument) gorm.DB {
//db1 := configuration.GetDB(constants.READ)
metaValue := filter.Value.Get("Value")
var filterValue interface{}
if metaValue != nil {
filterValue = metaValue.Value
} else {
filterValue = nil
}
//return db1.Exec("select from user_queries JOIN products ON products.id = user_queries.product_id where products.user_id is not null AND products.user_id = ? ", filterValue)
return db.Joins(" JOIN products ON products.id = user_queries.product_id and products.user_id is not null AND products.user_id = ? ", filterValue)
},
})
Label: "Vendor User ID",
Config: &admin.SelectOneConfig{Collection: bulkupload.GetUsers},
Handler: func(db gorm.DB, filter admin.FilterArgument) gorm.DB {
//db1 := configuration.GetDB(constants.READ)
metaValue := filter.Value.Get("Value")
var filterValue interface{}
if metaValue != nil {
filterValue = metaValue.Value
} else {
filterValue = nil
}
//return db1.Exec("select from user_queries JOIN products ON products.id = user_queries.product_id where products.user_id is not null AND products.user_id = ? ", filterValue)
return db.Joins(" JOIN products ON products.id = user_queries.product_id and products.user_id is not null AND products.user_id = ? ", filterValue)
},
})
How can I implement the second filter?
Hi guys, has anyone used github.com/qor/page_builder ? Looking for documentation to hook it to a request handler.
I have created a pull request qor/auth#39
Can some one please merge the pull
I fixed this by setting invisible to true on the resource and copying code from the AddResource:
Admin.AddMenu(&admin.Menu{Name: inflection.Plural(res.Config.Name), IconName: res.Config.IconName, Permissioner: res, Priority: res.Config.Priority, Ancestors: res.Config.Menu, RelativePath: res.ToParam()})
Admin.RegisterResourceRouters(res, "create", "update", "read")
For those who cannot login (see message "You have to confirm your account before continuing"), pls make a change on auth as this PR https://github.com/qor/auth/pull/39/files#diff-74d143ebc83607521c0db57e6225668d
can you see the image on the system? all the images on my local cannot be loaded, pls advice how to solve it?
Hello, how does qor's admin supports null.String by https://github.com/guregu/null ?
When creating admin simply, edit panel shows "String" and "Valid" section for nullable columns.
But values of the section are empty even when it have some text
When creating admin simply, edit panel shows "String" and "Valid" section for nullable columns.
But values of the section are empty even when it have some text
How can I access login page for a provider. Accessing http://localhost:9000/auth/login results in following page:
I do see the login file under password/views/auth/login/providers/password/tmpl, but cannot find the url which would send this page. Could not find anything in PasswordProvider .ServeHttp method which sends this page - was expecting a handle in this file
Im getting this
someone knows why?
neil@neil-Inspiron-7577:~$ go get -u github.com/qor/qor-example
# github.com/qor/auth
go1: internal compiler error: in methods, at go/gofrontend/types.cc:8611
Please submit a full bug report,
with preprocessed source if appropriate.
See <file:///usr/share/doc/gcc-8/README.Bugs> for instructions.
# github.com/qor/exchange/backends/csv
go/src/github.com/qor/exchange/backends/csv/xlsx2csv.go:28:27: error: reference to undefined field or method ‘Rows’
for _, row := range sheet.Rows {
^
go/src/github.com/qor/exchange/backends/csv/xlsx2csv.go:28:27: error: reference to undefined field or method ‘Rows’
go/src/github.com/qor/exchange/backends/csv/xlsx2csv.go:41:3: error: range clause must have array, slice, string, map, or channel type
for i, cell := range row.Cells {
^
go/src/github.com/qor/exchange/backends/csv/xlsx2csv.go:28:2: error: range clause must have array, slice, string, map, or channel type
for _, row := range sheet.Rows {
^
go/src/github.com/qor/exchange/backends/csv/xlsx2csv.go:28:6: error: invalid type for range clause
for _, row := range sheet.Rows {
^
neil@neil-Inspiron-7577:~$
# github.com/qor/auth
go1: internal compiler error: in methods, at go/gofrontend/types.cc:8611
Please submit a full bug report,
with preprocessed source if appropriate.
See <file:///usr/share/doc/gcc-8/README.Bugs> for instructions.
# github.com/qor/exchange/backends/csv
go/src/github.com/qor/exchange/backends/csv/xlsx2csv.go:28:27: error: reference to undefined field or method ‘Rows’
for _, row := range sheet.Rows {
^
go/src/github.com/qor/exchange/backends/csv/xlsx2csv.go:28:27: error: reference to undefined field or method ‘Rows’
go/src/github.com/qor/exchange/backends/csv/xlsx2csv.go:41:3: error: range clause must have array, slice, string, map, or channel type
for i, cell := range row.Cells {
^
go/src/github.com/qor/exchange/backends/csv/xlsx2csv.go:28:2: error: range clause must have array, slice, string, map, or channel type
for _, row := range sheet.Rows {
^
go/src/github.com/qor/exchange/backends/csv/xlsx2csv.go:28:6: error: invalid type for range clause
for _, row := range sheet.Rows {
^
neil@neil-Inspiron-7577:~$
how can i contact?
how do i get the dropdown to show something other than blank spaces?
@glenfordwilliams Look at the select one Dcoumentation for a dropdown example https://doc.getqor.com/admin/metas/select-one.html
put public before system
I'm looking for some help with the API. I can't the PUT (Update) call to work. The system always returns the old record.
curl --location --request PUT 'http://localhost:9090/api/task_types/1.json' \
--header 'Content-Type: application/javascript' \
--data-raw '{
"ID": 1,
"Icon": "foo",
"Title": "Text"
}'
Any help is much appreciated.
I cant find any example
Hi, everyone, can you help me?
I am gonna update age field value when select date on calendar.
How can I do?
I am gonna update age field value when select date on calendar.
How can I do?
Hello everyone. I'm trying the example program in the docu (Get Started). When I changed the struct name Product to Asset and tried adding new "Asset", handler for adding new "Asset" is not triggered. Is "Asset" an internal word that I should avoid using?
@danielsousaio
> I got the key error and "widget FullWidthBannerEditor not exists" error, when I was seeding it. Any idea how to fix it?
>
> $ go run config/db/seeds/main.go config/db/seeds/seeds.go
> Failed to create unique index for translations key & locale, got: Error 1170: BLOB/TEXT column 'key' used in key specification without a key length
>
> (/Users/jwong3/go/src/github.com/qor/i18n/backends/database/database.go:20)
> [2019-10-26 09:32:44] Error 1170: BLOB/TEXT column 'key' used in key specification without a key length
> WARNING: AssetFS is used before overwrite it!
> goroutine 1 [running, locked to thread]:
> runtime/debug.Stack(0x2e, 0x0, 0x0)
> /usr/local/go/src/runtime/debug/stack.go:24 +0x9d
> runtime/debug.PrintStack()
> /usr/local/go/src/runtime/debug/stack.go:16 +0x22
> github.com/qor/assetfs.SetAssetFS(0x6a57910, 0x24938e0)
> /Users/jwong3/go/src/github.com/qor/assetfs/assetfs.go:33 +0xc5
> github.com/qor/qor-example/config/bindatafs.init.0()
> /Users/jwong3/go/src/github.com/qor/qor-example/config/bindatafs/bindatafs.go:26 +0x5d
> Need to have gorm DB in the configuration in order to run migrations
> Start create sample data...
> --> Created setting.
> --> Created seo.
> --> Created admin users.
> --> Created users.
> --> Created addresses.
> --> Created categories.
> --> Created collections.
> --> Created colors.
> --> Created sizes.
> --> Created material.
> --> Created medialibraries.
> --> Created products.
> --> Created stores.
> --> Created orders.
> 2019/10/26 09:33:30 widget FullWidthBannerEditor not exists, make sure to register it
> 2019/10/26 09:33:30 widget FullWidthBannerEditor not exists, make sure to register it
> 2019/10/26 09:33:30 widget FullWidthBannerEditor not exists, make sure to register it
> 2019/10/26 09:33:30 widget FullWidthBannerEditor not exists, make sure to register it
> --> Created widgets.
> --> Created articles.
> --> Created helps.
> --> Done!
>
Did you ever fix this?
> I got the key error and "widget FullWidthBannerEditor not exists" error, when I was seeding it. Any idea how to fix it?
>
> $ go run config/db/seeds/main.go config/db/seeds/seeds.go
> Failed to create unique index for translations key & locale, got: Error 1170: BLOB/TEXT column 'key' used in key specification without a key length
>
> (/Users/jwong3/go/src/github.com/qor/i18n/backends/database/database.go:20)
> [2019-10-26 09:32:44] Error 1170: BLOB/TEXT column 'key' used in key specification without a key length
> WARNING: AssetFS is used before overwrite it!
> goroutine 1 [running, locked to thread]:
> runtime/debug.Stack(0x2e, 0x0, 0x0)
> /usr/local/go/src/runtime/debug/stack.go:24 +0x9d
> runtime/debug.PrintStack()
> /usr/local/go/src/runtime/debug/stack.go:16 +0x22
> github.com/qor/assetfs.SetAssetFS(0x6a57910, 0x24938e0)
> /Users/jwong3/go/src/github.com/qor/assetfs/assetfs.go:33 +0xc5
> github.com/qor/qor-example/config/bindatafs.init.0()
> /Users/jwong3/go/src/github.com/qor/qor-example/config/bindatafs/bindatafs.go:26 +0x5d
> Need to have gorm DB in the configuration in order to run migrations
> Start create sample data...
> --> Created setting.
> --> Created seo.
> --> Created admin users.
> --> Created users.
> --> Created addresses.
> --> Created categories.
> --> Created collections.
> --> Created colors.
> --> Created sizes.
> --> Created material.
> --> Created medialibraries.
> --> Created products.
> --> Created stores.
> --> Created orders.
> 2019/10/26 09:33:30 widget FullWidthBannerEditor not exists, make sure to register it
> 2019/10/26 09:33:30 widget FullWidthBannerEditor not exists, make sure to register it
> 2019/10/26 09:33:30 widget FullWidthBannerEditor not exists, make sure to register it
> 2019/10/26 09:33:30 widget FullWidthBannerEditor not exists, make sure to register it
> --> Created widgets.
> --> Created articles.
> --> Created helps.
> --> Done!
>
Did you ever fix this?